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