actualbudget queries integration tests

1 files changed, 16 insertions, 9 deletions

diff --git a/rust/actualbudget_models/src/actualbudget_schema.rs b/rust/actualbudget_models/src/actualbudget_schema.rs
index a872231..02907c0 100644
--- a/rust/actualbudget_models/src/actualbudget_schema.rs
+++ b/rust/actualbudget_models/src/actualbudget_schema.rs
@@ -13,22 +13,29 @@ diesel::table! {
 }
 
 diesel::table! {
-    transactions (id) {
+    v_transactions (id) {
         id -> Text,
-        #[sql_name = "isParent"]
         is_parent -> Bool,
-        #[sql_name = "isChild"]
         is_child -> Bool,
-        #[sql_name = "acct"]
+        parent_id -> Nullable<Text>,
+        #[sql_name = "account"]
         account_id -> Text,
         #[sql_name = "category"]
-        category_id -> Text,
+        category_id -> Nullable<Text>,
         amount -> Integer,
-        #[sql_name = "description"]
-        payee -> Text,
-        notes -> Text,
+        payee -> Nullable<Text>,
+        notes -> Nullable<Text>,
         date -> Integer,
-        parent_id -> Nullable<Text>,
+        // imported_id -> Text,
+        // error -> Text,
+        // imported_payee -> Text,
+        // starting_balance_flag -> Integer,
+        // transfer_id -> Text,
+        // sort_order -> Real,
+        // cleared -> Integer,
+        // reconciled -> Integer,
+        // tombstone -> Integer,
+        // schedule -> Text,
     }
 }