From 8b4440f7236b0972c1a804eea4c8305b958ad03c Mon Sep 17 00:00:00 2001 From: Ilion Beyst Date: Mon, 13 Dec 2021 15:43:47 +0100 Subject: setup basic rocket+diesel app --- backend/migrations/.gitkeep | 0 .../00000000000000_diesel_initial_setup/down.sql | 6 ++++ .../00000000000000_diesel_initial_setup/up.sql | 36 ++++++++++++++++++++++ 3 files changed, 42 insertions(+) create mode 100644 backend/migrations/.gitkeep create mode 100644 backend/migrations/00000000000000_diesel_initial_setup/down.sql create mode 100644 backend/migrations/00000000000000_diesel_initial_setup/up.sql (limited to 'backend/migrations') diff --git a/backend/migrations/.gitkeep b/backend/migrations/.gitkeep new file mode 100644 index 0000000..e69de29 diff --git a/backend/migrations/00000000000000_diesel_initial_setup/down.sql b/backend/migrations/00000000000000_diesel_initial_setup/down.sql new file mode 100644 index 0000000..a9f5260 --- /dev/null +++ b/backend/migrations/00000000000000_diesel_initial_setup/down.sql @@ -0,0 +1,6 @@ +-- This file was automatically created by Diesel to setup helper functions +-- and other internal bookkeeping. This file is safe to edit, any future +-- changes will be added to existing projects as new migrations. + +DROP FUNCTION IF EXISTS diesel_manage_updated_at(_tbl regclass); +DROP FUNCTION IF EXISTS diesel_set_updated_at(); diff --git a/backend/migrations/00000000000000_diesel_initial_setup/up.sql b/backend/migrations/00000000000000_diesel_initial_setup/up.sql new file mode 100644 index 0000000..d68895b --- /dev/null +++ b/backend/migrations/00000000000000_diesel_initial_setup/up.sql @@ -0,0 +1,36 @@ +-- This file was automatically created by Diesel to setup helper functions +-- and other internal bookkeeping. This file is safe to edit, any future +-- changes will be added to existing projects as new migrations. + + + + +-- Sets up a trigger for the given table to automatically set a column called +-- `updated_at` whenever the row is modified (unless `updated_at` was included +-- in the modified columns) +-- +-- # Example +-- +-- ```sql +-- CREATE TABLE users (id SERIAL PRIMARY KEY, updated_at TIMESTAMP NOT NULL DEFAULT NOW()); +-- +-- SELECT diesel_manage_updated_at('users'); +-- ``` +CREATE OR REPLACE FUNCTION diesel_manage_updated_at(_tbl regclass) RETURNS VOID AS $$ +BEGIN + EXECUTE format('CREATE TRIGGER set_updated_at BEFORE UPDATE ON %s + FOR EACH ROW EXECUTE PROCEDURE diesel_set_updated_at()', _tbl); +END; +$$ LANGUAGE plpgsql; + +CREATE OR REPLACE FUNCTION diesel_set_updated_at() RETURNS trigger AS $$ +BEGIN + IF ( + NEW IS DISTINCT FROM OLD AND + NEW.updated_at IS NOT DISTINCT FROM OLD.updated_at + ) THEN + NEW.updated_at := current_timestamp; + END IF; + RETURN NEW; +END; +$$ LANGUAGE plpgsql; -- cgit v1.2.3 From eabeb7ed7b641dea0b8e71ab33ab97b4ed7a4cda Mon Sep 17 00:00:00 2001 From: Ilion Beyst Date: Mon, 13 Dec 2021 22:41:20 +0100 Subject: start implementing basic login functionality --- backend/migrations/2021-12-13-145111_users/down.sql | 1 + backend/migrations/2021-12-13-145111_users/up.sql | 6 ++++++ backend/migrations/2021-12-13-151129_sessions/down.sql | 1 + backend/migrations/2021-12-13-151129_sessions/up.sql | 5 +++++ 4 files changed, 13 insertions(+) create mode 100644 backend/migrations/2021-12-13-145111_users/down.sql create mode 100644 backend/migrations/2021-12-13-145111_users/up.sql create mode 100644 backend/migrations/2021-12-13-151129_sessions/down.sql create mode 100644 backend/migrations/2021-12-13-151129_sessions/up.sql (limited to 'backend/migrations') diff --git a/backend/migrations/2021-12-13-145111_users/down.sql b/backend/migrations/2021-12-13-145111_users/down.sql new file mode 100644 index 0000000..441087a --- /dev/null +++ b/backend/migrations/2021-12-13-145111_users/down.sql @@ -0,0 +1 @@ +DROP TABLE users; \ No newline at end of file diff --git a/backend/migrations/2021-12-13-145111_users/up.sql b/backend/migrations/2021-12-13-145111_users/up.sql new file mode 100644 index 0000000..6ec7e01 --- /dev/null +++ b/backend/migrations/2021-12-13-145111_users/up.sql @@ -0,0 +1,6 @@ +CREATE TABLE users( + id SERIAL PRIMARY KEY, + username VARCHAR(52) NOT NULL, + password_salt BYTEA NOT NULL, + password_hash BYTEA NOT NULL +); \ No newline at end of file diff --git a/backend/migrations/2021-12-13-151129_sessions/down.sql b/backend/migrations/2021-12-13-151129_sessions/down.sql new file mode 100644 index 0000000..54d1e93 --- /dev/null +++ b/backend/migrations/2021-12-13-151129_sessions/down.sql @@ -0,0 +1 @@ +DROP TABLE sessions; \ No newline at end of file diff --git a/backend/migrations/2021-12-13-151129_sessions/up.sql b/backend/migrations/2021-12-13-151129_sessions/up.sql new file mode 100644 index 0000000..f8ec21b --- /dev/null +++ b/backend/migrations/2021-12-13-151129_sessions/up.sql @@ -0,0 +1,5 @@ +CREATE TABLE sessions ( + id serial PRIMARY KEY, + user_id integer REFERENCES users(id) NOT NULL, + token VARCHAR(255) NOT NULL UNIQUE +) \ No newline at end of file -- cgit v1.2.3 From 13cdbc7ff760ae91ee3f62b2a2f62c7559ccaa3c Mon Sep 17 00:00:00 2001 From: Ilion Beyst Date: Tue, 14 Dec 2021 20:23:07 +0100 Subject: test registration & login --- backend/migrations/2021-12-13-145111_users/down.sql | 1 + backend/migrations/2021-12-13-145111_users/up.sql | 4 +++- 2 files changed, 4 insertions(+), 1 deletion(-) (limited to 'backend/migrations') diff --git a/backend/migrations/2021-12-13-145111_users/down.sql b/backend/migrations/2021-12-13-145111_users/down.sql index 441087a..49285a1 100644 --- a/backend/migrations/2021-12-13-145111_users/down.sql +++ b/backend/migrations/2021-12-13-145111_users/down.sql @@ -1 +1,2 @@ +DROP INDEX users_username_index DROP TABLE users; \ No newline at end of file diff --git a/backend/migrations/2021-12-13-145111_users/up.sql b/backend/migrations/2021-12-13-145111_users/up.sql index 6ec7e01..f35e718 100644 --- a/backend/migrations/2021-12-13-145111_users/up.sql +++ b/backend/migrations/2021-12-13-145111_users/up.sql @@ -3,4 +3,6 @@ CREATE TABLE users( username VARCHAR(52) NOT NULL, password_salt BYTEA NOT NULL, password_hash BYTEA NOT NULL -); \ No newline at end of file +); + +CREATE UNIQUE INDEX users_username_index ON users(username); \ No newline at end of file -- cgit v1.2.3 From 52242b03f1af7f73e73592c2e5ee2bc54813a64d Mon Sep 17 00:00:00 2001 From: Ilion Beyst Date: Sun, 19 Dec 2021 00:16:46 +0100 Subject: simple bot uploads --- backend/migrations/2021-12-18-130837_bots/down.sql | 3 +++ backend/migrations/2021-12-18-130837_bots/up.sql | 14 ++++++++++++++ 2 files changed, 17 insertions(+) create mode 100644 backend/migrations/2021-12-18-130837_bots/down.sql create mode 100644 backend/migrations/2021-12-18-130837_bots/up.sql (limited to 'backend/migrations') diff --git a/backend/migrations/2021-12-18-130837_bots/down.sql b/backend/migrations/2021-12-18-130837_bots/down.sql new file mode 100644 index 0000000..3d14604 --- /dev/null +++ b/backend/migrations/2021-12-18-130837_bots/down.sql @@ -0,0 +1,3 @@ +DROP TABLE code_bundles; +DROP INDEX bots_index; +DROP TABLE bots; \ No newline at end of file diff --git a/backend/migrations/2021-12-18-130837_bots/up.sql b/backend/migrations/2021-12-18-130837_bots/up.sql new file mode 100644 index 0000000..27f3582 --- /dev/null +++ b/backend/migrations/2021-12-18-130837_bots/up.sql @@ -0,0 +1,14 @@ +CREATE TABLE bots ( + id serial PRIMARY KEY, + owner_id integer REFERENCES users(id) NOT NULL, + name text NOT NULL +); + +CREATE UNIQUE INDEX bots_index ON bots(owner_id, name); + +CREATE TABLE code_bundles ( + id serial PRIMARY KEY, + bot_id integer REFERENCES bots(id) NOT NULL, + path text NOT NULL, + created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP +); \ No newline at end of file -- cgit v1.2.3