projectmoon
  • Joined on 2020-11-05
projectmoon pushed to master at projectmoon/tenebrous-dicebot 2021-05-20 15:41:03 +00:00
a33367fada Update dependencies to fix matrix SDK list users bug.
projectmoon merged pull request projectmoon/tenebrous-dicebot#64 2021-05-20 15:34:54 +00:00
Convert to SQLx and SQLite
projectmoon pushed to master at projectmoon/tenebrous-dicebot 2021-05-20 15:34:52 +00:00
5630b4ed20 Add sled migration utility.
6b6be06c89 Update sqlx offline json.
a3b39ee42c Use ON CONFLICT and transactions where appropriate.
7eee16961e Add tests for dbstate.
43d8f9574f Allow 'upserts' in insert_room_info. Add a few more room db tests.
Compare 17 commits »
projectmoon merged pull request projectmoon/tenebrous-dicebot#64 2021-05-20 15:34:52 +00:00
Convert to SQLx and SQLite
projectmoon commented on pull request projectmoon/tenebrous-dicebot#64 2021-05-20 15:34:15 +00:00
Convert to SQLx and SQLite

This PR is complete as-is, and the main database has been migrated to sqlite. The next step after the dicebot is running properly on sqlite will be to do some final cleanup bits:

  • Remove Sled and…
projectmoon pushed to sqlite at projectmoon/tenebrous-dicebot 2021-05-20 15:31:13 +00:00
5630b4ed20 Add sled migration utility.
projectmoon pushed to sqlite at projectmoon/tenebrous-dicebot 2021-05-19 21:36:24 +00:00
6b6be06c89 Update sqlx offline json.
projectmoon pushed to sqlite at projectmoon/tenebrous-dicebot 2021-05-19 21:34:18 +00:00
a3b39ee42c Use ON CONFLICT and transactions where appropriate.
projectmoon pushed to sqlite at projectmoon/tenebrous-dicebot 2021-05-19 21:16:45 +00:00
7eee16961e Add tests for dbstate.
43d8f9574f Allow 'upserts' in insert_room_info. Add a few more room db tests.
Compare 2 commits »
projectmoon pushed to sqlite at projectmoon/tenebrous-dicebot 2021-05-18 22:15:15 +00:00
1c4cd3d139 Add tests for rooms db API
projectmoon pushed to sqlite at projectmoon/tenebrous-dicebot 2021-05-18 21:39:56 +00:00
d1c04b8817 Tests for all of the variables DB api.
projectmoon pushed to sqlite at projectmoon/tenebrous-dicebot 2021-05-18 15:37:24 +00:00
5e899cd962 Return key not found error if value not found for user.
projectmoon pushed to sqlite at projectmoon/tenebrous-dicebot 2021-05-18 15:17:37 +00:00
257f3a066c Some user variable tests.
projectmoon pushed to sqlite at projectmoon/tenebrous-dicebot 2021-05-18 14:51:41 +00:00
e539dcac1f Move migrations to sqlite directory. Remove in-memory temp db until refinery supports sqlx.
projectmoon pushed to sqlite at projectmoon/tenebrous-dicebot 2021-05-18 14:27:22 +00:00
9f97a6cb43 Implement variable count; fix listing all variables returning values for all users.
projectmoon pushed to sqlite at projectmoon/tenebrous-dicebot 2021-05-17 23:15:11 +00:00
a665293268 Fix recording of room users, better logging.
projectmoon pushed to sqlite at projectmoon/tenebrous-dicebot 2021-05-16 22:24:57 +00:00
66fb6e7cf8 Fix various issues with room events and related logic.
projectmoon pushed to sqlite at projectmoon/tenebrous-dicebot 2021-05-16 21:39:30 +00:00
bfc5609ab6 Add proper constraints to db tables. Report errors when listing users.
projectmoon pushed to sqlite at projectmoon/tenebrous-dicebot 2021-05-16 14:30:02 +00:00
9798821b7b Implement room and dbstate for sqlite.
projectmoon pushed to sqlite at projectmoon/tenebrous-dicebot 2021-05-15 23:46:07 +00:00
cf9ce63892 Replace application-level database connectivity.