MycroftAI
/
selene-backend
mirror of https://github.com/MycroftAI/selene-backend.git
1
0
Fork 0
Code Issues Projects Releases Wiki Activity
1,776 Commits
38 Branches
10 Tags
4.1 MiB
Commit Graph

117 Commits (refactor/python3.10)

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 0a02e28110 change package manager from pipenv to poetry 2022-08-24 13:22:05 -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 4eef250051 Add logic to script to handle duplicated cities that have devices assigned to them. 2021-03-12 14:02:20 -06:00
Chris Veilleux 47fb276b4f Add pylint to dependencies 2021-02-18 18:52:27 -06:00
Chris Veilleux 5146c9346f New script and SQL to remove the duplicated cities that are part of the geographical information we download. 2021-02-18 18:50:51 -06:00
Chris Veilleux 779d3e8fac Rename "release" column in pantacor_config table to "release_channel". 2021-02-04 13:57:48 -06:00
Chris Veilleux f7bb357b7e Added IP address to the pantacor_config table. 2021-02-04 12:27:35 -06: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 6e4177b5a5 Add a priority column to the tag table because some tags are prerequisites to others 2020-11-30 11:32:35 -06:00
Chris Veilleux b648ebe3ca update a tag value based on user feedback 2020-10-30 15:46:37 -05:00
Chris Veilleux 144cb0ed89 fix timestamp range issues with tagging.session table 2020-10-29 20:52:30 -05:00
Chris Veilleux e76faf714b added remainder of tagging tables 2020-10-24 00:51:56 -05:00
Chris Veilleux 2e1c67efd2 New tables to support tagging of wake word files. 2020-10-19 14:55:16 -05:00
Chris Veilleux 0106523772 make the file location on the tagging.file table not nullable 2020-10-06 00:33:29 -05:00
Chris Veilleux 492f5aa2e9 Merge branch 'dev' into feature/wake-word-file-removal 2020-10-02 13:47:41 -05:00
Chris Veilleux 69e04bce4e unique index does not propagate down from parent table. 2020-09-24 11:54:06 -05:00
Chris Veilleux 88943afe37 add status to wake word file table 2020-09-17 13:56:11 -05:00
Chris Veilleux 333d19efea added tagging schema 2020-09-02 13:55:06 -05:00
Chris Veilleux 628fa90e0d removed wake word engine enum type 2020-09-02 13:54:22 -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 03fb6447aa simplify to use only roles that are currently in use 2020-06-22 18:46:05 -05:00
Chris Veilleux 37e38764c3 add the population column 2020-06-22 18:45:37 -05:00
Chris Veilleux ec356eec12 added logic to populate the *_active columns in the account_activity metrics table. 2020-05-26 22:35:50 -05:00
Chris Veilleux 9a5ed1ddc4 add ability to track new and deleted accounts on the new account activity table. 
add ability to track new and deleted accounts on the new account activity table.
 2020-05-21 17:36:42 -05:00
Chris Veilleux a0c08ebbdc new table in metrics schema for account activity reporting 2020-05-21 15:54:18 -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 51072d2151 ensure pipfiles are up-to-date before publishing repo 2019-08-15 19:23:42 -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 8d9e697537 added new column to metric.core_interaction table to capture the user latency metric. 2019-07-09 19:43:12 -05:00
Chris Veilleux 63e6053966 new metric.core_interaction table to track skill latency and the code to populate it from the metric.core table. 2019-07-09 13:47:31 -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 1d80903939 changed duration column to be numeric 2019-06-28 22:06:22 -05:00
Chris Veilleux 63793dfc91 removed unique index and added an index on access_ts 2019-06-28 14:52:42 -05:00
Chris Veilleux 57bbf00baa removed unique constraint as they are not allowed on partitioned tables 2019-06-27 12:51:14 -05:00
Chris Veilleux e68621ac04 add new api_history table to bootstrap 2019-06-27 12:17:15 -05:00
Chris Veilleux de3030b11e new api_history partitioned table to help with query performance of millions of rows per day 2019-06-27 01:23:46 -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 fd2b46d0b2 Change the core metrics collection to happen within Selene. 2019-06-08 19:23:29 -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