From 7734472faa9e0ecb18bab286055aceaa13c9c947 Mon Sep 17 00:00:00 2001
From: iximeow <git@iximeow.net>
Date: Sun, 4 Dec 2022 21:07:57 +0000
Subject: add ci driver, webserver. they work.

"work" is a strong word.
---
 src/sql.rs | 55 +++++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 55 insertions(+)
 create mode 100644 src/sql.rs

(limited to 'src/sql.rs')

diff --git a/src/sql.rs b/src/sql.rs
new file mode 100644
index 0000000..ee334c1
--- /dev/null
+++ b/src/sql.rs
@@ -0,0 +1,55 @@
+#![allow(dead_code)]
+
+pub enum JobState {
+    Pending = 0,
+    Started = 1,
+    Complete = 2,
+    Error = 3,
+}
+
+// remote_id is the remote from which we were notified. this is necessary so we know which remote
+// to pull from to actually run the job.
+pub const CREATE_JOBS_TABLE: &'static str = "\
+    CREATE TABLE IF NOT EXISTS jobs (id INTEGER PRIMARY KEY AUTOINCREMENT,
+        artifacts_path TEXT,
+        state INTEGER NOT NULL,
+        run_host TEXT,
+        remote_id INTEGER,
+        commit_id INTEGER,
+        created_time INTEGER,
+        started_time INTEGER,
+        complete_time INTEGER);";
+
+pub const CREATE_COMMITS_TABLE: &'static str = "\
+    CREATE TABLE IF NOT EXISTS commits (id INTEGER PRIMARY KEY AUTOINCREMENT, sha TEXT UNIQUE);";
+
+pub const CREATE_REPOS_TABLE: &'static str = "\
+    CREATE TABLE IF NOT EXISTS repos (id INTEGER PRIMARY KEY AUTOINCREMENT,
+        repo_name TEXT);";
+
+// remote_api is `github` or NULL for now. hopefully a future cgit-style notifier one day.
+// remote_path is some unique identifier for the relevant remote.
+// * for `github` remotes, this will be `owner/repo`.
+// * for others.. who knows.
+// remote_url is a url for human interaction with the remote (think https://git.iximeow.net/zvm)
+// remote_git_url is a url that can be `git clone`'d to fetch sources
+pub const CREATE_REMOTES_TABLE: &'static str = "\
+    CREATE TABLE IF NOT EXISTS remotes (id INTEGER PRIMARY KEY AUTOINCREMENT,
+        repo_id INTEGER,
+        remote_path TEXT,
+        remote_api TEXT,
+        remote_url TEXT,
+        remote_git_url TEXT,
+        notifier_config_path TEXT);";
+
+pub const CREATE_REMOTES_INDEX: &'static str = "\
+    CREATE INDEX IF NOT EXISTS 'repo_to_remote' ON remotes(repo_id);";
+
+pub const PENDING_JOBS: &'static str = "\
+    select * from jobs where state=0;";
+
+pub const COMMIT_TO_ID: &'static str = "\
+    select id from commits where sha=?1;";
+
+pub const REMOTES_FOR_REPO: &'static str = "\
+    select * from remotes where repo_id=?1;";
-- 
cgit v1.1