gws.ext.db.provider.postgres.driver¶

class gws.ext.db.provider.postgres.driver.Connection(params)[source]¶

server_select(sql, params=None)[source]¶

select(sql, params=None)[source]¶

select_one(sql, params=None)[source]¶

select_list(sql, params=None)[source]¶

select_value(sql, params=None)[source]¶

count(table_name)[source]¶

exec(sql, params=None)[source]¶

execute(sql, params=None)[source]¶

execute_many(*pairs)[source]¶

transaction()[source]¶

table_names(schema)[source]¶

columns(table_name)[source]¶

insert_one(table_name, key_column, rec: dict, with_id=False)[source]¶

update(table_name, key_column, rec: dict)[source]¶

delete_many(table_name, key_column, uids)[source]¶

insert_many(table_name: str, recs: List[dict], on_conflict=None, page_size=100)[source]¶

schema_and_table(table_name)[source]¶

user_can(privilege, table_name)[source]¶

quote_table(table_name, schema=None)[source]¶

quote_ident(s)[source]¶