From b46012f212a4302b4d1325d8fdf9634e7083e76a Mon Sep 17 00:00:00 2001 From: René 'Necoro' Neumann Date: Fri, 11 Oct 2024 22:47:16 +0200 Subject: First draft of recurrent costs and categories --- sql/categories.sql | 4 ++++ sql/ddl/pgsql.sql | 4 ++-- sql/rexps.sql | 4 ++++ 3 files changed, 10 insertions(+), 2 deletions(-) create mode 100644 sql/categories.sql create mode 100644 sql/rexps.sql (limited to 'sql') diff --git a/sql/categories.sql b/sql/categories.sql new file mode 100644 index 0000000..2c8e5c7 --- /dev/null +++ b/sql/categories.sql @@ -0,0 +1,4 @@ +-- name: GetCategories :many +SELECT id, name + FROM categories + WHERE user_id = $1; \ No newline at end of file diff --git a/sql/ddl/pgsql.sql b/sql/ddl/pgsql.sql index 09c7133..18dc388 100644 --- a/sql/ddl/pgsql.sql +++ b/sql/ddl/pgsql.sql @@ -19,14 +19,14 @@ CREATE INDEX user_id ON categories (user_id); -CREATE TABLE const_expenses ( +CREATE TABLE recur_expenses ( id SERIAL PRIMARY KEY, description TEXT, expense NUMERIC(10, 2) NOT NULL, duration INTERVAL NOT NULL, start DATE NOT NULL, "end" DATE NOT NULL, - prev_id INTEGER REFERENCES const_expenses, + prev_id INTEGER REFERENCES recur_expenses, category_id INTEGER NOT NULL REFERENCES categories, user_id INTEGER NOT NULL REFERENCES users ); diff --git a/sql/rexps.sql b/sql/rexps.sql new file mode 100644 index 0000000..87dc23f --- /dev/null +++ b/sql/rexps.sql @@ -0,0 +1,4 @@ +-- name: GetRecurExpenses :many +SELECT id, description, expense, duration, start, "end" + FROM recur_expenses + WHERE user_id = $1; \ No newline at end of file -- cgit v1.2.3-70-g09d2