probotic/src/stmt.c

/* stmt.c */

VARDECL sqlite3_stmt * remind_stmt;
VARDECL char const remind_stmt_template[] =
	"SELECT "
		"title,"
		"body,"
		"difficulty,"
		"repo_link,"
		"trigger_date,"
		"started DATE,"
		"span"
	" FROM assignment INNER JOIN project on assignment.project = project.rowid "
	"WHERE who = ?;";

VARDECL sqlite3_stmt * set_repo_stmt;
VARDECL char const set_repo_stmt_template[] =
	"UPDATE assignment "
		"SET "
		"repo_link = ? "
	"WHERE who = ?;";

VARDECL char const dump_stmt[] =
	"SELECT * FROM project;";

VARDECL sqlite3_stmt * get_nth_id_stmt;
VARDECL char const get_nth_id_stmt_template[] =
	"SELECT rowid "
	"FROM project "
	"LIMIT 1 "
	"OFFSET ?;";

VARDECL sqlite3_stmt * new_assignment_stmt;
VARDECL char const new_assignment_stmt_template[] =
	"INSERT INTO assignment "
		"(who, project)"
			" VALUES "
		"(?, ?);";

VARDECL sqlite3_stmt * purge_assignments_stmt;
VARDECL char const purge_assignments_stmt_template[] =
	"DELETE FROM assignment "
		"WHERE who = ?;";

VARDECL sqlite3_stmt* is_no_assignment_stmt;
VARDECL const char is_no_assignment_stmt_template[] =
	"SELECT * FROM assignment "
		"WHERE who = ?;" ;