Database Module

This module handles database operations and synchronization for the PySide Demo application.

Submodules

database

class pyside_demo.db.database.Base(**kwargs: Any)[source]

Bases: DeclarativeBase

Base class for declarative SQLAlchemy models.

This class serves as the base for all database models in the application. It inherits from SQLAlchemy’s DeclarativeBase, providing the necessary functionality for declarative model definitions.

metadata: ClassVar[MetaData] = MetaData()

Refers to the _schema.MetaData collection that will be used for new _schema.Table objects.

See also

orm_declarative_metadata

registry: ClassVar[_RegistryType] = <sqlalchemy.orm.decl_api.registry object>

Refers to the _orm.registry in use where new _orm.Mapper objects will be associated.

class pyside_demo.db.database.Database[source]

Bases: object

add_item(name, description)[source]
delete_item(item_id)[source]
get_items()[source]
is_online()[source]
resolve_conflict(item_id, resolution_choice)[source]
set_conflict(item_id)[source]
sync_with_postgresql()[source]
update_item(item_id, name, description)[source]
class pyside_demo.db.database.Item(**kwargs)[source]

Bases: Base

created_at: Any
description: Any
id: Any
name: Any
sync_status: Any
updated_at: Any
version: Any
class pyside_demo.db.database.SyncStatus(value)[source]

Bases: str, Enum

An enumeration.

CONFLICT = 'conflict'
DELETED = 'deleted'
MODIFIED = 'modified'
SYNCED = 'synced'

sql