Quicken for Mac sqlite schema has changed - any plans to update these queries?

[42Network]

Quicken for Mac sqlite schema has changed - any plans to update these queries? I am using Quicken Premier 6.3.3

Also, what about a Python3 version?

I may make an attempt at these enhancements myself. I am still able to open my Quicken db with a SQLite utility and browse the tables.

For example, these queries still work:

select z_pk, zname, ztypename from zaccount;
select z_pk, zname, zuserdescription from ztag;
select count(*) from ZTRANSACTION;

Thanks

[HarryDolan]

Yeah, I realized that a while ago, but I haven’t used the module for some time. Maybe now I will.

Harry

On Sep 24, 2021, at 7:53 PM, Nathan Ellsworth @.***> wrote:

Quicken for Mac sqlite schema has changed - any plans to update these queries? I am using Quicken Premier 6.3.3

Also, what about a Python3 version?

I may make an attempt at these enhancements myself. I am still able to open my Quicken db with a SQLite utility and browse the tables.

For example, these queries still work:

select z_pk, zname, ztypename from zaccount; select z_pk, zname, zuserdescription from ztag; select count(*) from ZTRANSACTION; Thanks

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/HarryDolan/qquery/issues/1, or unsubscribe https://github.com/notifications/unsubscribe-auth/AEEWH2BO3UFUA6AR4OAVB7TUDUMR7ANCNFSM5EW7W7HA. Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.

[42Network]

I got it working on my system here. I just sent you a PR for the 3 line fix. I am a GitHub newbie, so let me know if I did something wrong with the PR.

Nathan

On Fri, Sep 24, 2021 at 7:56 PM Harry Dolan @.***> wrote:

Yeah, I realized that a while ago, but I haven’t used the module for some time. Maybe now I will.

Harry

On Sep 24, 2021, at 7:53 PM, Nathan Ellsworth @.***> wrote:

Quicken for Mac sqlite schema has changed - any plans to update these queries? I am using Quicken Premier 6.3.3

Also, what about a Python3 version?

I may make an attempt at these enhancements myself. I am still able to open my Quicken db with a SQLite utility and browse the tables.

For example, these queries still work:

select z_pk, zname, ztypename from zaccount; select z_pk, zname, zuserdescription from ztag; select count(*) from ZTRANSACTION; Thanks

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub < https://github.com/HarryDolan/qquery/issues/1>, or unsubscribe < https://github.com/notifications/unsubscribe-auth/AEEWH2BO3UFUA6AR4OAVB7TUDUMR7ANCNFSM5EW7W7HA . Triage notifications on the go with GitHub Mobile for iOS < https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675> or Android < https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub>.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/HarryDolan/qquery/issues/1#issuecomment-926985274, or unsubscribe https://github.com/notifications/unsubscribe-auth/AILLRKCQEDNQNTOPFPOFE53UDUM33ANCNFSM5EW7W7HA .

[HarryDolan]

Thanks for the code, Nathan. I accepted your pull request.

I also made a bunch of changes so that it works with python3 (long overdue). I have them on my local system, but I too am a GitHub newbie and it will take a while to merge it in to GitHub. I hope you’re not waiting for it.

Harry

On Sep 24, 2021, at 9:52 PM, Nathan Ellsworth @.***> wrote:

I got it working on my system here. I just sent you a PR for the 3 line fix. I am a GitHub newbie, so let me know if I did something wrong with the PR.

Nathan Ellsworth @.*** 512-450-8404 cell/text

On Fri, Sep 24, 2021 at 7:56 PM Harry Dolan @.***> wrote:

Yeah, I realized that a while ago, but I haven’t used the module for some time. Maybe now I will.

Harry

On Sep 24, 2021, at 7:53 PM, Nathan Ellsworth @.***> wrote:

Quicken for Mac sqlite schema has changed - any plans to update these queries? I am using Quicken Premier 6.3.3

Also, what about a Python3 version?

I may make an attempt at these enhancements myself. I am still able to open my Quicken db with a SQLite utility and browse the tables.

For example, these queries still work:

select z_pk, zname, ztypename from zaccount; select z_pk, zname, zuserdescription from ztag; select count(*) from ZTRANSACTION; Thanks

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub < https://github.com/HarryDolan/qquery/issues/1 https://github.com/HarryDolan/qquery/issues/1>, or unsubscribe < https://github.com/notifications/unsubscribe-auth/AEEWH2BO3UFUA6AR4OAVB7TUDUMR7ANCNFSM5EW7W7HA https://github.com/notifications/unsubscribe-auth/AEEWH2BO3UFUA6AR4OAVB7TUDUMR7ANCNFSM5EW7W7HA . Triage notifications on the go with GitHub Mobile for iOS < https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675> or Android < https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub>.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <https://github.com/HarryDolan/qquery/issues/1#issuecomment-926985274 https://github.com/HarryDolan/qquery/issues/1#issuecomment-926985274>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AILLRKCQEDNQNTOPFPOFE53UDUM33ANCNFSM5EW7W7HA https://github.com/notifications/unsubscribe-auth/AILLRKCQEDNQNTOPFPOFE53UDUM33ANCNFSM5EW7W7HA> .

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/HarryDolan/qquery/issues/1#issuecomment-926999565, or unsubscribe https://github.com/notifications/unsubscribe-auth/AEEWH2B2DBUZXSX4QRCKWGTUDU2QTANCNFSM5EW7W7HA. Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.

[42Network]

No rush. Works fine in Python 2 for me for now.

I think the sequence is git commit and git push. At least that's what I did after making a clone of your git. Then I used gh to create a PR.

PS: Have you ever tried writing to the Quicken DB via Python?

[HarryDolan]

I got it all onto GitHub. And, no, I never tried writing to the Quicken DB. I don’t dare! :-)

Harry

On Sep 28, 2021, at 10:37 PM, Nathan Ellsworth @.***> wrote:

No rush. Works fine in Python 2 for me for now.

I think the sequence is git commit and git push. At least that's what I did after making a clone of your git. Then I used gh to create a PR.

PS: Have you ever tried writing to the Quicken DB via Python?

— You are receiving this because you modified the open/close state. Reply to this email directly, view it on GitHub https://github.com/HarryDolan/qquery/issues/1#issuecomment-929801736, or unsubscribe https://github.com/notifications/unsubscribe-auth/AEEWH2ADVRG2OULEOFHWJDDUEKCWLANCNFSM5EW7W7HA. Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.