Improve session handling #9

Created a session-factory bound to connexion's underlying sqlalchemy engine and instanciated 2 separate sessions - each for api and sync.

Tests for setting/getting active source succeeded, so assuming that there is no need of calling commit() before the query. Since each session is created in the according context / thread, this approach should also be thread-safe but couldnt verify yet.

Need to retest, thus marking this mr to draft.

changed milestone to %1.0-alpha3 — Playful Platypus

assigned to @chrizz

mentioned in issue #9 (closed)

added 3 commits

• 59ae30cf - fix: config for SyncJob
• 764b7ecc - fix: config set sync_host to optional
• 706cafdf - refactor: db session factory and scope

Compare with previous version

added 2 commits

• 26328451 - fix: use same session for add and commit
• b7138b3a - fix: use single session for one sync cycle

Compare with previous version

added 1 commit

• fe00e706 - fix: bind engine to static model

Compare with previous version

added 1 commit

• 449e4345 - fix: bind engine to static model

Compare with previous version

added 1 commit

• 6e68fe1e - fix: bind engine to static model

Compare with previous version

added 1 commit

• ee2b7098 - fix: bind engine to static model

Compare with previous version

added 1 commit

• 27c53f54 - temp fix: set trackStart in camelCase to avoid null

Compare with previous version

added 1 commit

• bfbd1a1e - fix: convert to camelCase manually (temp fix)

Compare with previous version

marked this merge request as ready

mentioned in commit ea67094d

merged