search

ledger123 / runmyaccounts

SQL-Ledger Customizations by Run My Accounts
GNU General Public License v2.0
16 stars 9 forks source link

Update databases for Revolut #389

Closed sweitmann closed 1 year ago

sweitmann commented 1 year ago

Hi Armaghan,

We need to create a script that updates databases to solve the Revolut connection issues we discussed on Nextcloud.

a.) CREATE TABLE revolut_accounts ( id text, curr character varying(3), name text, balance numeric(12,2) );

b.) ALTER TABLE revolut_accounts OWNER to "sql-ledger";

c.) ALTER TABLE gl ADD COLUMN transjson json;

d.) ALTER TABLE gl ALTER COLUMN transjson SET STORAGE EXTENDED;

And then we also need to add the transjson column to gl_log and gl_log_deleted.

We should also add some kind of "flush" to clear memory, so that databases/ bank accounts don't get mixed up if you use the same browser.

Regards

ledger123 commented 1 year ago

Hi Sebastian,

I have made changes so that a new database will automatically get these database changes when first accessed from revolut interface. You can pull the rmac branch and test.

Regards

sweitmann commented 1 year ago

Hi Armaghan,

Tested and it looks great, thank you!

Closing this ticket now.

Regards