dbeasyorm.db.backends package

Submodules

dbeasyorm.db.backends.abstract module

class dbeasyorm.db.backends.abstract.DataBaseBackend[source]

Bases: ABC

abstract connect(*args, **kwargs) → object[source]

abstract execute(query: str, params=None)[source]

abstract generate_alter_field_sql(*args, **kwargs) → str[source]

abstract generate_create_table_sql(table_name: str, fields: BaseField) → str[source]

abstract generate_delete_sql(table_name: str, where_clause: tuple) → str[source]

abstract generate_drop_field_sql(*args, **kwargs) → str[source]

abstract generate_drop_table_sql(table_name: str) → str[source]

generate_insert_sql(table_name: str, columns: tuple) → str[source]

abstract generate_join_sql(table_name: str, on: str, join_type: str) → str[source]

abstract generate_select_sql(table_name: str, columns: tuple, where_clause: tuple, limit: int | None = None, offset: int | None = None) → str[source]

abstract generate_update_sql(table_name: str, set_clause: tuple, where_clause: tuple) → str[source]

abstract get_database_schemas() → dict[source]

abstract get_foreign_key_constraint(field_name, related_table, on_delete) → str[source]

abstract get_placeholder() → str[source]

abstract get_sql_type(type: type) → str[source]

abstract get_sql_types_map() → dict[source]

get_sql_val_repr(value)[source]

dbeasyorm.db.backends.postgres module

class dbeasyorm.db.backends.postgres.PostgreSQLBackend(host, database: str, user: str, password: str, port=5432, *args, **kwargs)[source]

Bases: DataBaseBackend

connect(**kwargs) → DataBaseBackend[source]

execute(query: str, params=None) → cursor[source]

generate_alter_field_sql(table_name: str, field: BaseField, *args, **kwargs) → str[source]

generate_create_table_sql(table_name: str, fields: BaseField)[source]

generate_delete_sql(table_name: str, where_clause: tuple)[source]

generate_drop_field_sql(table_name: str, field: BaseField, *args, **kwargs) → str[source]

generate_drop_table_sql(table_name: str) → str[source]

generate_insert_sql(table_name: str, columns: tuple) → str[source]

generate_join_sql(table_name: str, on: str, join_type: str) → str[source]

generate_select_sql(table_name: str, columns: tuple, where_clause: dict | None = None, limit: int | None = None, offset: int | None = None) → str[source]

generate_update_sql(table_name: str, set_clause: tuple, where_clause: tuple)[source]

get_database_schemas() → dict[source]

get_foreign_key_constraint(field_name: str, related_table: str, on_delete: str) → str[source]

get_placeholder() → str[source]

get_sql_type(type) → str[source]

get_sql_types_map() → dict[source]

dbeasyorm.db.backends.sqlite module

class dbeasyorm.db.backends.sqlite.SQLiteBackend(database_path: str, *args, **kwargs)[source]

Bases: DataBaseBackend

connect(**kwargs) → DataBaseBackend[source]

execute(query: str, params=None) → Cursor[source]

generate_alter_field_sql(model: BaseField, db_columns: dict, *args, **kwargs) → str[source]

generate_create_table_sql(table_name: str, fields: BaseField)[source]

generate_delete_sql(table_name: str, where_clause: tuple)[source]

generate_drop_field_sql(model: BaseField, *args, **kwargs) → str[source]

generate_drop_table_sql(table_name: str) → str[source]

generate_insert_sql(table_name: str, columns: tuple) → str[source]

generate_join_sql(table_name: str, on: str, join_type: str) → str[source]

generate_select_sql(table_name: str, columns: tuple, where_clause: dict | None = None, limit: int | None = None, offset: int | None = None) → str[source]

generate_update_sql(table_name: str, set_clause: tuple, where_clause: tuple)[source]

get_database_schemas() → dict[source]

get_foreign_key_constraint(field_name: str, related_table: str, on_delete: str) → str[source]

get_placeholder() → str[source]

get_sql_type(type) → str[source]

get_sql_types_map() → dict[source]

Module contents

class dbeasyorm.db.backends.DataBaseBackend[source]

Bases: ABC

abstract connect(*args, **kwargs) → object[source]

abstract execute(query: str, params=None)[source]

abstract generate_alter_field_sql(*args, **kwargs) → str[source]

abstract generate_create_table_sql(table_name: str, fields: BaseField) → str[source]

abstract generate_delete_sql(table_name: str, where_clause: tuple) → str[source]

abstract generate_drop_field_sql(*args, **kwargs) → str[source]

abstract generate_drop_table_sql(table_name: str) → str[source]

generate_insert_sql(table_name: str, columns: tuple) → str[source]

abstract generate_join_sql(table_name: str, on: str, join_type: str) → str[source]

abstract generate_select_sql(table_name: str, columns: tuple, where_clause: tuple, limit: int | None = None, offset: int | None = None) → str[source]

abstract generate_update_sql(table_name: str, set_clause: tuple, where_clause: tuple) → str[source]

abstract get_database_schemas() → dict[source]

abstract get_foreign_key_constraint(field_name, related_table, on_delete) → str[source]

abstract get_placeholder() → str[source]

abstract get_sql_type(type: type) → str[source]

abstract get_sql_types_map() → dict[source]

get_sql_val_repr(value)[source]

class dbeasyorm.db.backends.PostgreSQLBackend(host, database: str, user: str, password: str, port=5432, *args, **kwargs)[source]

Bases: DataBaseBackend

connect(**kwargs) → DataBaseBackend[source]

execute(query: str, params=None) → cursor[source]

generate_alter_field_sql(table_name: str, field: BaseField, *args, **kwargs) → str[source]

generate_create_table_sql(table_name: str, fields: BaseField)[source]

generate_delete_sql(table_name: str, where_clause: tuple)[source]

generate_drop_field_sql(table_name: str, field: BaseField, *args, **kwargs) → str[source]

generate_drop_table_sql(table_name: str) → str[source]

generate_insert_sql(table_name: str, columns: tuple) → str[source]

generate_join_sql(table_name: str, on: str, join_type: str) → str[source]

generate_select_sql(table_name: str, columns: tuple, where_clause: dict | None = None, limit: int | None = None, offset: int | None = None) → str[source]

generate_update_sql(table_name: str, set_clause: tuple, where_clause: tuple)[source]

get_database_schemas() → dict[source]

get_foreign_key_constraint(field_name: str, related_table: str, on_delete: str) → str[source]

get_placeholder() → str[source]

get_sql_type(type) → str[source]

get_sql_types_map() → dict[source]

class dbeasyorm.db.backends.SQLiteBackend(database_path: str, *args, **kwargs)[source]

Bases: DataBaseBackend

connect(**kwargs) → DataBaseBackend[source]

execute(query: str, params=None) → Cursor[source]

generate_alter_field_sql(model: BaseField, db_columns: dict, *args, **kwargs) → str[source]

generate_create_table_sql(table_name: str, fields: BaseField)[source]

generate_delete_sql(table_name: str, where_clause: tuple)[source]

generate_drop_field_sql(model: BaseField, *args, **kwargs) → str[source]

generate_drop_table_sql(table_name: str) → str[source]

generate_insert_sql(table_name: str, columns: tuple) → str[source]

generate_join_sql(table_name: str, on: str, join_type: str) → str[source]

generate_select_sql(table_name: str, columns: tuple, where_clause: dict | None = None, limit: int | None = None, offset: int | None = None) → str[source]

generate_update_sql(table_name: str, set_clause: tuple, where_clause: tuple)[source]

get_database_schemas() → dict[source]

get_foreign_key_constraint(field_name: str, related_table: str, on_delete: str) → str[source]

get_placeholder() → str[source]

get_sql_type(type) → str[source]

get_sql_types_map() → dict[source]