this library allow to simplify the basic operation in postgres databases like select, insert, update, delete and upsert
Project description
Provides basic postgres functions for databases request.
select:
def get_my_data():
def _(cursor):
cursor.execute(f"select data from database")
return cursor.fetchone()
result = select(_)
return result.get('data') if result else None
insert:
def insert_my_data():
data = {
'data_1': data_1,
'data_2': data_2
}
insert(TABLE_NAME, data)
update: the primary key can be a string for array who have only one primary key but if it's a tuple, you can put a table of string : ['first_primay_key', 'second_primay_key']
def update_my_data():
data = {
'data_1': data_1,
'data_2': data_2
}
update(TABLE_NAME, 'my_primary_key', data)
upsert: Upsert is a function who insert if the data doesn't exist. And update if the data can be updated. the primary key can be a string for array who have only one primary key but if it's a tuple, you can put a table of string : ['first_primay_key', 'second_primay_key']
def upsert_my_data():
data = {
'data_1': data_1,
'data_2': data_2
}
upsert(TABLE_NAME, 'my_primary_key', data)
delete:
def delete_my_data():
delete(TABLE_NAME, primary_key, data_id)
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Hashes for comapsmarthome-postgres-client-0.1.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | c911422a0f9a8817ebbeb89bce5247105ee7be8e1ef8e5f9518ed382332cf056 |
|
MD5 | adc38a1c8df720e8f73915edb3a005bb |
|
BLAKE2b-256 | 6387c117bac076eefddeca3741b3562488a54e2acea79e00e98a9d3d25542b3b |