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]

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, fields: list, 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(table_name: str, fields: list, db_columns: dict, *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(table_name: str, fields: list, 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(table_name: str, fields: list, db_columns: dict, *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_field_type_map() → dict[source]
get_foreign_key_constraint(field_name: str, related_table: str, on_delete: str) → str[source]
get_placeholder() → str[source]
get_sql_type(python_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]
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, fields: list, 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(table_name: str, fields: list, db_columns: dict, *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(table_name: str, fields: list, 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(table_name: str, fields: list, db_columns: dict, *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_field_type_map() → dict[source]
get_foreign_key_constraint(field_name: str, related_table: str, on_delete: str) → str[source]
get_placeholder() → str[source]
get_sql_type(python_type) → str[source]
get_sql_types_map() → dict[source]