from Database import MySQL


db =  MySQL("localhost",  "username",  "password",  "database", port = 3306)

from Database import PostgreSQL

db =  PostgreSQL("localhost", "username", "password", "database", port = 5432)

table =  "test"
data =  [4,"Arsalan","+989121234560"]
result = db.insert(table,list)
print(result)

table =  "test"
column_index = 1
row_index = 1
cell = db.read_cell_by_index(table,row_index,column_index)
print(cell)

>>>  "Arshia"

table =  "test"
column = db.read_column_by_index(table,1)
print(column)

>>>  ["Alireza","Arshia","Hossein","Arsalan"]

table =  "test"
column = db.read_column_by_name(table,"name")
print(column)

>>>  ["Alireza","Arshia","Hossein","Arsalan"]

table =  "test"
row = db.read_row_by_id(table,3)
print(row)

>>>  [3,"Hossein","+989121234569"]

table =  "test"
rows = db.read_rows_by_key(table,"name","Hossein")
print(rows)

>>> ((3,"Hossein","+989121234569"),)

table =  "test"
result = db.update_cells_by_id(table,id = 4,name="Hossein",phone="+989121234563")
print(result)

table =  "test"
key_column = "name"
key = "Hossein"
result = db.update_cells_by_key(table,key_column,key,name="Amir", phone="+989121234565")
print(result)

table =  "test"
result = db.delete_row_by_id(table,2)
print(result)

table =  "test"
result = db.delete_rows_by_key(table,"name","Amir")
print(result)