repositories

const (
	FORMS_FIND_BY_ID_SQL      = `select * from forms where id = $1`
	FORMS_FIND_BY_UUID_SQL    = `select * from forms where uuid = $1`
	FORMS_FIND_BY_USER_ID_SQL = `select * from forms where user_id = $1`
	FORMS_INSERT_SQL          = `insert into forms (user_id, name, description, recaptcha_secret_key) values ($1, $2, $3, $4) returning *`
	FORMS_UPDATE_SQL          = `update forms set name = $2, description = $3, recaptcha_secret_key = $4, updated_at = now() where id = $1 returning *`
	FORMS_DELETE_SQL          = `delete from forms where id = $1`
)

const (
	SUBMISSIONS_FIND_BY_FORM_ID_SQL = `select * from submissions where form_id = $1`
	SUBMISSIONS_INSERT_SQL          = `insert into submissions (form_id, body) values ($1, $2) returning *`
	SUBMISSIONS_DELETE_SQL          = `delete from submissions where id = $1`
)

const (
	USERS_FIND_BY_ID_SQL                       = `select * from users where id = $1`
	USERS_FIND_BY_EMAIL_SQL                    = `select * from users where email = lower($1)`
	USERS_FIND_BY_EMAIL_AND_PASSWORD_SQL       = `select * from users where email = lower($1) and password_digest = crypt($2, password_digest)`
	USERS_FIND_BY_EMAIL_CONFIRMATION_TOKEN_SQL = `select * from users where email_confirmation_token = $1`

	USERS_INSERT_SQL = `` /* 143-byte string literal not displayed */
	USERS_UPDATE_SQL = `` /* 162-byte string literal not displayed */
)