repository

const (
	SQLCheckTeacherExist = `SELECT EXISTS(SELECT * FROM teacher_mst WHERE id=$1)`

	SQLInsertNewTeacher = `INSERT INTO teacher_mst (id, name, email, picture) 
							VALUES ($1, $2, $3, $4)`

	SQLGetTeacherProfile = `SELECT * FROM teacher_mst WHERE id=$1`

	SQLApproveStudent = `UPDATE participant_mst SET status=1 WHERE teacher_id=$1 AND webinar_id=$2 AND student_id=$3`

	SQLRejectStudent = `UPDATE participant_mst SET status=2 WHERE teacher_id=$1 AND webinar_id=$2 AND student_id=$3`
)

const (
	SQLGetAllWebinarByTeacherID = `SELECT * FROM webinar_mst WHERE teacher_id=$1`

	SQLInsertNewWebinar = `` /* 175-byte string literal not displayed */

	SQLUpdateWebinar = `` /* 150-byte string literal not displayed */

	SQLDeleteWebinar = `DELETE FROM webinar_mst WHERE teacher_id=$1 AND id=$2`

	SQLGetWebinarBySlug = `SELECT * FROM webinar_mst WHERE title ILIKE $1`

	SQLGetWebinarByID = `SELECT * FROM webinar_mst WHERE id=$1`

	SQLGetParticipants = `` /* 133-byte string literal not displayed */

)

const (
	SQLCheckStudentExist = `SELECT EXISTS(SELECT * FROM student_mst WHERE id=$1)`

	SQLInsertNewStudent = `INSERT INTO student_mst (id, name, email, picture) 
							VALUES ($1, $2, $3, $4)`

	SQLGetStudentProfile = `SELECT * FROM student_mst WHERE id=$1`

	SQLGetRegisteredWebinars = `SELECT w.* FROM webinar_mst as w INNER JOIN participant_mst as p 
								ON w.id=p.webinar_id WHERE p.student_id=$1`

	SQLEnrollWebinar = `INSERT INTO participant_mst (student_id, webinar_id, teacher_id, status) 
							VALUES ($1, $2, $3, 0)`

	SQLCancelEnrollWebinar = `DELETE FROM participant_mst WHERE student_id=$1 AND webinar_id=$2 AND teacher_id=$3`
)