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 Distributions
Built Distribution
Hashes for comapsmarthome_postgres_client-0.1.2-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | ca9c118466b8964644723aad6333093e6dcb6225b6937c83d878f973de0b5c51 |
|
MD5 | 04937408a4385da959b7463a75a2c17f |
|
BLAKE2b-256 | eaa565b463294d078a8480c7bf797dab67cf3ca8314c71e700f735d0a976029d |