Commit Graph

35 Commits (master)

Author SHA1 Message Date
Chris Veilleux 977f43ed7e add a database table for STT transcription metrics and logic to populate it. 2022-08-25 17:34:20 -05:00
Chris Veilleux 9298be41b6 upgraded db python environment to 3.9 and changed how city table is loaded due to new version of psycopg 2022-07-18 15:31:46 -05:00
Chris Veilleux 66f5bf4af3 updated database python environment to 3.9 2022-07-15 12:03:55 -05:00
Chris Veilleux 26ed641b48 applied the "Black" formatter to all files and added pre-commit hook to check 2022-03-11 13:22:33 -06:00
Ryan Voots 1341fc1555
Fix client encoding for PG connection
Set the encoding to utf8 so that it will correctly handle accented characters in the geography data.
2022-02-28 09:54:43 -05:00
Chris Veilleux c49de30f20 Add the pantacor_config table to the database. 2021-02-01 12:20:44 -06:00
Chris Veilleux 1713c423d0 Re-apply original merge from test to master 2020-12-28 12:29:19 -06:00
Kris Gesling b95b598ff5 prevent KeyError from missing timezone 2020-12-18 21:10:51 +09:30
Kris Gesling 12749da3af Revert "Merge remote-tracking branch 'origin/test'"
This reverts commit 9d3dd24601, reversing
changes made to 7ec565c4d8.
2020-12-18 21:04:48 +09:30
Chris Veilleux 2e1c67efd2 New tables to support tagging of wake word files. 2020-10-19 14:55:16 -05:00
Chris Veilleux 333d19efea added tagging schema 2020-09-02 13:55:06 -05:00
Chris Veilleux 2b074ef10d Moved wake_word and wake_word_settings tables to a new wake_word schema. 2020-08-27 13:16:28 -05:00
Chris Veilleux 54a71b284d Added account_activity table and fixed issue with agreement dates. 2020-06-24 14:12:11 -05:00
Chris Veilleux 979d4c2980 Refactored to be more modular. Changed location of agreements to devops repository. Download geography files directly. Other minor changes to make it runnable in new Docker image. 2020-06-22 18:52:57 -05:00
Chris Veilleux b326067f2e Merge remote-tracking branch 'remotes/origin/dev' into feature/publish_repo 2019-08-16 19:00:49 -05:00
Chris Veilleux 3e76eafe89 Fixed a couple of bugs and refactored to improve ease of use for someone installing on a VM from scratch 2019-08-12 13:14:22 -05:00
Steve Penrod 9dc4d62490 Adding the basics to prepare for publishing this repo
Changes include:

* Adding AGPL 3.0 license template (TODO: Apply to all 200+ *.py files)
* Adding AGPL license files
* Add generic public repo files (CONTRIBUTING, etc)
* Simple README updates
* Adding other generic files, e.g. .github templates
2019-07-27 18:44:23 -05:00
Chris Veilleux abf3556b36 renamed metrics schema to metric, because I am one anal MF 2019-06-28 22:38:38 -05:00
Chris Veilleux e68621ac04 add new api_history table to bootstrap 2019-06-27 12:17:15 -05:00
Chris Veilleux 12dc2175d2 updated the skill settings endpoint in the public API handle more use cases 2019-06-25 18:12:34 -05:00
Chris Veilleux 695d8a1838 add the core table to the bootstrap 2019-06-10 14:40:12 -05:00
Chris Veilleux fe2e8bc7e7 moved population of account.agreement table and geography tables from python notebooks into the bootstrap script 2019-05-21 14:18:36 -05:00
Matheus Lima 174bae440b Putting the url from the request in the global context in the before request hook 2019-04-24 16:28:06 -03:00
Chris Veilleux 1f38a1ee83 added metrics schema to script 2019-04-23 18:04:57 -05:00
Chris Veilleux 2ee471a6e1 add api metrics table and collection. in the process, changed the database connection mechanism to only get a connection from the pool once per request. 2019-04-22 16:58:28 -05:00
Matheus Lima a3167019af Removing refresh token from query 2019-04-16 18:35:26 -03:00
Chris Veilleux dd94d69269 schema changes to split the defaults out from the preferences 2019-03-20 10:50:35 -05:00
Chris Veilleux e5838736ab changed device.geography table and device.preferences table to have references to geography schema tables 2019-03-19 16:46:15 -05:00
Matheus Lima 7d87531e26 Fixed an created test for the membership updating 2019-03-14 14:31:55 -03:00
Chris Veilleux 8257b8fc41 changed location table to be the geography table and changed its structure due to new design 2019-03-13 16:52:12 -05:00
Chris Veilleux b1b990f1b2 added new geography schema and changes to skill schema 2019-03-13 16:36:06 -05:00
Chris Veilleux 5d16ede767 changed to build a template database first, then the mycroft database is created from the template. this will allow for testing databases to be created form the blank template as well 2019-02-24 23:50:43 -06:00
Matheus Lima 23e056ca96 Created test to validate device pairing workflow 2019-02-20 20:25:21 -03:00
Chris Veilleux 918f24ccf3 added an enum to define the types of agreements allowed and changed "content" column to "content_id" 2019-02-11 16:42:59 -06:00
Chris Veilleux a3f9c73d94 moved all mycroft database DDL and scripts from the devops repository to this one. 2019-02-08 13:14:33 -06:00