search

tchx84 / linka

An open source service to record air quality data from community sensors
GNU Affero General Public License v3.0
21 stars 11 forks source link

Postgres compatible test cases #92

Closed sanchezmarco closed 1 year ago

sanchezmarco commented 1 year ago

This isn't intented to be merge yet, is just to show how I got stucked in the process I wanted to start the migration from SQLite to PostgreSQL, using alembic and migrations is only a matter of change DATABASE_URL and it will create automaticly the schema with the (4)Postgresql server connected. The next process is to update test cases to verify all features are working properly I want to discuss a couple of issues here:

  1. The current implementation of test cases for sqlite doesn't work with postgres, I think because some connections concurrency
  2. Client as a pytest fixture
  3. Create the Token as async process
  4. Docker compose (web + postgres at least for testing)
tchx84 commented 1 year ago

This is now being done on https://github.com/tchx84/linka/pull/97