Commit Graph

100 Commits

Author SHA1 Message Date
f84f357056 sqlExport: Use FROM DUAL in insertDistinct to fix older mariadb 2020-04-01 19:21:41 -04:00
bdf3b84c74 sqlExport: Simplify insert functions with f strings 2020-04-01 17:46:41 -04:00
d5ecf50943 sqlExport: WIP: Even worse fix for missing transactions 2020-04-01 17:38:49 -04:00
925e1abe80 Revert "sqlExport: Fix missing transactions by making whole row unique"
This reverts commit 6c862b9fb41f863cfc5d0ef4ffc863c4fe43d9fd.

Turns out that doesn't work, and mariadb was just silently failing.
Reopens #2.
2020-03-29 00:32:32 -04:00
74827ac9ad sqlExport: Fix missing transactions by making whole row unique
This is probably not a good way to fix this, but it does work.
Fixes #2
2020-03-29 00:32:32 -04:00
ae0cf430b5 sqlExport: Add some more fields to members table 2020-03-29 00:32:32 -04:00
17c9da6f9b sqlExport: Add 'Audit Date' to members table 2020-03-29 00:32:32 -04:00
44e560cd34 sqlExport: Remove name from transactions assertion
because apparently basic data consistency is too much to ask for
2020-03-29 00:32:32 -04:00
721000ce43 sqlExport: Change transaction start date to 2010 2020-03-29 00:32:32 -04:00
b417821703 sqlExport: Use both CSV and json transaction sources to get more data 2020-03-29 00:32:32 -04:00
65b79cad99 sqlExport: Set db character set to utf8 2020-03-29 00:32:32 -04:00
6ab2b7bd9c sqlExport: Add some informational prints 2020-03-29 00:32:32 -04:00
a6e596cfd4 sqlExport: Read membershipworks database info from passwords.py file 2020-03-29 00:32:32 -04:00
516813b895 sqlExport: Switch from REPLACE to INSERT...ON DUPLICATE KEY UPDATE
REPLACE DELETES the row even when there was no change, creating a
history entry even when none was needed or useful
2020-03-29 00:32:32 -04:00
01e08e1007 sqlExport: Delete labels that are no longer valid 2020-03-29 00:32:32 -04:00
b82da10073 Add sqlExport.py to README 2020-03-29 00:32:32 -04:00
8edaaf0df9 sqlExport: Migrate to mariadb, improve types 2020-03-29 00:32:32 -04:00
8b54dc7fe3 sqlExport: Merge the logic of members and transactions tables, w/ mappings defined in yaml 2020-03-29 00:32:32 -04:00
38ba551f1e sqlExport: WIP: sort of working export to SQL 2020-03-29 00:31:10 -04:00
cf84086446 doorUpdater: Retrieve former members and remove their schedules 2020-03-29 00:28:58 -04:00
952852badb doorUpdater: Reuse more code/flow between new and existing members 2020-03-29 00:28:58 -04:00
e832851fc4 Add README.md 2020-03-29 00:28:58 -04:00
a201b9f09c lib/MembershipWorks: Allow getting both CSV and json transactions data 2020-03-29 00:28:58 -04:00
06516ad0cd lib/membershipworks: Rework to be more generic, add more methods
parse out folder, label, and attribute information from the json
returned on login, allowing less hardcoded values

Add get_transaction and get_all_members methods
2020-03-29 00:28:37 -04:00
f95493e3a6 doorUpdater: Add temporary check for access during Limited Operations 2020-03-29 00:28:37 -04:00
641b9a2779 lib/hid: Work around HID bug in returned XML records
Includes:
- lib/hid: Don't send recordCount as -1, fixes #4
2020-03-29 00:28:09 -04:00
9d743344ab Move hid/*.py and MembershipWorks.py to lib folder 2020-02-14 18:32:34 -05:00
c52b76534c Refactor MembershipWorks handling into separate class/file 2020-02-06 17:48:47 -05:00
25532bf21b Refactor doorUpdater to add support for door specific schedules 2019-12-20 18:42:57 -05:00
d5be64c37d Switch config file from JSON to YAML 2019-12-20 18:42:06 -05:00
d248e41fdb Allow DoorController to handle paginated records requests 2019-12-20 17:38:10 -05:00
82a54b8f41 Re-arrange import ordering 2019-11-22 16:39:31 -05:00
659459ddd3 Add systemd config for running as a service 2019-11-09 15:09:54 -05:00
2b894d3cc9 Make executable, clean up style, and rename new door updater 2019-11-08 16:08:53 -05:00
21a9aa5b5c Properly add, remove, and reassign credentials for existing members 2019-11-08 16:08:53 -05:00
8367c8bbc1 Properly handle parity bits in codeToHex 2019-11-08 14:54:46 -05:00
667260831c Refactor new XML updater, move methods into correct classes 2019-11-07 15:22:50 -05:00
bb18f34b2e Remove deprecated door update scripts 2019-11-07 13:33:34 -05:00
df92332c69 Revert "Don't use format strings, for compatability with Python 3.5 :("
This reverts commit 96c34c95f3.
2019-11-07 13:33:34 -05:00
d867cacfef Switch to XML messages instead of CSV import for updating controllers 2019-11-07 13:33:22 -05:00
96c34c95f3 Don't use format strings, for compatability with Python 3.5 :( 2018-10-18 20:24:28 -04:00
067555376b DoorController: Fix schedule getting/sending 2018-10-18 20:15:27 -04:00
ee4898eaf3 DoorController: Use an exception instead of sys.exit 2018-10-18 20:14:58 -04:00
3e474f1b79 Move some variables around to saner places 2018-10-18 20:13:34 -04:00
f813c8d49e Add Storage Closet door to config 2018-10-18 20:10:59 -04:00
a84ef646f1 doorUpdater: Use ROOT for VertXMessage tag for clarity 2018-10-18 20:10:22 -04:00
9d376a87b1 Move door controller code into a class 2018-09-18 14:05:06 -04:00
3787021ffe Add function to get lock/unlock status of a door 2018-09-18 14:05:06 -04:00
7ae175baf0 Convert to lxml instead of xml.etree 2018-09-18 14:05:06 -04:00
48333d1e6d viewer: add basic buttons to lock/unlock front door 2018-09-18 14:05:06 -04:00