Initial commitHEADmaster

1 files changed, 46 insertions, 0 deletions

diff --git a/src/sql_stmt.c b/src/sql_stmt.c
new file mode 100644
index 0000000..fa4a293
--- /dev/null
+++ b/src/sql_stmt.c
@@ -0,0 +1,46 @@
+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 = ?;" ;