wy_qcos.db.models package

Submodules

wy_qcos.db.models.base module

class wy_qcos.db.models.base.MyEncoder(*, skipkeys=False, ensure_ascii=True, check_circular=True, allow_nan=True, sort_keys=False, indent=None, separators=None, default=None)

基类：JSONEncoder

default(obj)

class wy_qcos.db.models.base.Base(**kwargs)

基类：DeclarativeBase

Base model.

参数:

kwargs (Any)

asdict()

asjson()

metadata: ClassVar[MetaData] = MetaData()

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

参见

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 wy_qcos.db.models.base.BaseTable(**kwargs)

基类：Base

Base table.

参数:

kwargs (Any)

created_at = Column(None, DateTime(), table=None, server_default=DefaultClause(<sqlalchemy.sql.functions.current_timestamp at 0x7333ccb2ea50; current_timestamp>, for_update=False))

updated_at = Column(None, DateTime(), table=None, onupdate=ColumnElementColumnDefault(<sqlalchemy.sql.functions.current_timestamp at 0x7333ccb2eed0; current_timestamp>), server_default=DefaultClause(<sqlalchemy.sql.functions.current_timestamp at 0x7333cd781650; current_timestamp>, for_update=False))

class wy_qcos.db.models.base.ArrayType(*args, **kwargs)

基类：TypeDecorator

Platform-independent Array type.

参数:

• args (Any)

• kwargs (Any)

impl

JSON 的别名

cache_ok: bool | None = True

Using cache.

load_dialect_impl(dialect)

Load dialect impl.

process_bind_param(value, dialect)

Process bind param.

process_result_value(value, dialect)

Process result value.

class wy_qcos.db.models.base.GUID(*args, **kwargs)

基类：TypeDecorator

Platform-independent GUID type.

参数:

• args (Any)

• kwargs (Any)

impl

CHAR 的别名

cache_ok: bool | None = True

Using cache.

load_dialect_impl(dialect)

Load dialect impl.

process_bind_param(value, dialect)

Process bind param.

wy_qcos.db.models.project module

class wy_qcos.db.models.project.Project(**kwargs)

基类：Base

Project database model.

id

name

created_at

updated_at

users

login_logs

wy_qcos.db.models.user module

class wy_qcos.db.models.user.User(**kwargs)

基类：Base

User database model.

id

project_id

user_name

hashed_password

is_enabled

is_locked

last_login

password_changed_at

locked_until

password_expiry_days

failed_login_attempts

description

created_at

updated_at

user_roles

project

property roles: list[str]

Get list of role names for this user (convenience property).

返回:

List of role names from user_roles association

get_role_names()

Get list of role names for this user.

返回:

List of role names from user_roles association

返回类型:

list[str]

class wy_qcos.db.models.user.Role(**kwargs)

基类：Base

Role database model.

id

role_name

permissions

description

created_at

updated_at

user_roles

class wy_qcos.db.models.user.UserRole(**kwargs)

基类：Base

User-Role many-to-many relationship model.

id

user_id

role_id

created_at

user

role

class wy_qcos.db.models.user.LoginLog(**kwargs)

基类：Base

Login log database model.

id

project_id

user_name

ip_address

login_time

login_status

failure_reason

user_agent

project

class wy_qcos.db.models.user.TokenBlacklist(**kwargs)

基类：Base

Token blacklist database model for tracking revoked JWT tokens.

id

token_jti

expires_at

created_at

Module contents