Refactors some backend stuff to core lib

1 files changed, 72 insertions, 0 deletions

diff --git a/backend/core/src/schema.rs b/backend/core/src/schema.rs
new file mode 100644
index 0000000..372f8f3
--- /dev/null
+++ b/backend/core/src/schema.rs
@@ -0,0 +1,72 @@
+// @generated automatically by Diesel CLI.
+
+diesel::table! {
+    accounts (id) {
+        id -> Integer,
+        name -> Text,
+        opening_balance -> Integer,
+        opening_date -> Text,
+    }
+}
+
+diesel::table! {
+    budget_updates (id) {
+        id -> Integer,
+        category_id -> Integer,
+        date -> Text,
+        new_budget -> Integer,
+        new_period -> Integer,
+    }
+}
+
+diesel::table! {
+    categories (id) {
+        id -> Integer,
+        name -> Text,
+    }
+}
+
+diesel::table! {
+    category_transfers (id) {
+        id -> Integer,
+        description -> Text,
+        quantity -> Integer,
+        from_category_id -> Integer,
+        to_category_id -> Integer,
+    }
+}
+
+diesel::table! {
+    transaction_categorisations (id) {
+        id -> Integer,
+        description -> Text,
+        quantity -> Integer,
+        transaction_id -> Integer,
+        category_id -> Integer,
+    }
+}
+
+diesel::table! {
+    transactions (id) {
+        id -> Integer,
+        description -> Text,
+        payee -> Text,
+        quantity -> Integer,
+        date -> Text,
+        account_id -> Integer,
+    }
+}
+
+diesel::joinable!(budget_updates -> categories (category_id));
+diesel::joinable!(transaction_categorisations -> categories (category_id));
+diesel::joinable!(transaction_categorisations -> transactions (transaction_id));
+diesel::joinable!(transactions -> accounts (account_id));
+
+diesel::allow_tables_to_appear_in_same_query!(
+    accounts,
+    budget_updates,
+    categories,
+    category_transfers,
+    transaction_categorisations,
+    transactions,
+);