py-scopes/scopes/storage
2025-04-30 18:08:45 +02:00
..
db allow additional db parameters when setting up storage 2025-02-11 11:31:56 +01:00
__init__.py initial import 2024-02-14 18:15:48 +01:00
common.py storage.message: definitions, start with tests 2025-04-30 18:08:45 +02:00
concept.py more on children() and parents() 2024-03-16 23:38:58 +01:00
folder.py work in progress: oidc authentication: start login processing 2025-03-24 22:26:17 +01:00
message.py storage.message: definitions, start with tests 2025-04-30 18:08:45 +02:00
proxy.py initial import 2024-02-14 18:15:48 +01:00
README.rst initial import 2024-02-14 18:15:48 +01:00
topic.py work in progress: topics (as example for concepts) 2024-03-15 21:16:45 +01:00
tracking.py work in progress: oidc authentication: start login processing 2025-03-24 22:26:17 +01:00

========================================================
SQL-based Storage for Records (Tracks) and Other Objects
========================================================

Test Prerequisite: PostgreSQL database ccotest (user ccotest with password cco).

  >>> from cco.storage.common import getEngine, sessionFactory
  >>> from cco.storage.tracking import record

  >>> record.engine = getEngine('postgresql+psycopg', 'ccotest', 'ccotest', 'cco')
  >>> record.Session = sessionFactory(record.engine)


Tracking Storage
================

  >>> storage = record.Storage(doCommit=True)

  >>> tr01 = record.Track('t01', 'john')
  >>> tr01.head
  {'taskId': 't01', 'userName': 'john'}

  >>> storage.getTable()
  Table(...)

  >>> trackId = storage.save(tr01)
  >>> trackId > 0
  True

  >>> tr01a = storage.get(trackId)
  >>> tr01a.head

 Fin
 ===

  >>> storage.conn.close()