newsbot-api/database
James Tombleson 75b66dd625
Feature/sql (#8)
* Using sqlc to generate queries and goose for migrations. The intial tests look good.

* moving the old calls away for now.  Might use this in a package later on.

* Added postgres driver

* Updated the dockerfile to support sql migrations

* added sqlc config file

* updated schema and starting a seed script

* updated models to use the database ones

* updated reddit cron to talk to the db

* added env for sql connection string

* got the reddit source working with the db and posting articles

* added sql packages

* added rule to ignore dev sql file

* added migration down statement for rolling back

* updated cron for reddit and youtube

* Updated reddit to follow a new standard pattern

* updated youtube to follow new patterns

* updated tests and brought them to the standard

* updated the seed migration

* all cron tasks should feed the db now

* updated app init

* bumped docker to 1.18.3

* disabled remote tests given secrets and lack of interfaces currently to run tests
2022-06-08 21:17:08 -07:00
..
migrations Feature/sql (#8) 2022-06-08 21:17:08 -07:00
schema Feature/sql (#8) 2022-06-08 21:17:08 -07:00
db.go Feature/sql (#8) 2022-06-08 21:17:08 -07:00
models.go Feature/sql (#8) 2022-06-08 21:17:08 -07:00
query.sql.go Feature/sql (#8) 2022-06-08 21:17:08 -07:00