this package is use for sql CRUD operations on sql database.
Project description
sql_operation
Under construction! Not ready for use yet! Currently experimenting and planning!
Developed by Sachin Indoriya (c) 2022
Examples of How To Use (Buggy Alpha Version)
from sql_operations import SqlDB
# mysql connection credentials
USERNAME = 'username'
PASSWORD = 'password'
DATABASE = 'database_name'
HOST = 'host'
# create SqlDB object
sql_db = SqlDB(dummy_data)
# check sql server is connected or not
if sql_db.is_conneted():
print("Hurrey!!!, sql server connected.")
else:
print("sql server not connected.")
# create a table
table_name = "new_table"
columns = ['col_1','col_2','col_3']
sql_db.create_table(table_name,columns)
# check table created or not
if sql_db.check_table_exist():
print("table exist")
else:
print("table not exist")
# insert row into table
table_name = "new_table"
row = ['val_1','val_2','val_3']
if sql_db.insert_into_table() == 1:
print("row inserted")
# read row from the table
table_name = "new_table"
item_id = "item_id"
rows = sql_db.read_rows(table_name,item_id)
print(rows)
# delete row from table
table_name = "new_table"
item_id = "item_id"
if sql_db.delete_rows(table_name,item_id) == 1:
print("row deleted")
# close database connection
sql_db.close_conn()
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
sql_oprations-0.0.3.tar.gz
(5.3 kB
view hashes)
Built Distribution
Close
Hashes for sql_oprations-0.0.3-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 0c8c39e5470c035259303d5eea3ebe9219d7cf9962f431f5e71df6f8a7aea7ba |
|
MD5 | cff171d3369f99dd744cedd6e1a225ea |
|
BLAKE2b-256 | de7af4b1b4c771bb8b686174266ac6ca4e5fbfc355454e096927dfa962f0368b |