def _update(sql, args):
val = (args[1], args[0])
mycursor.execute(sql, val)
mydb.commit()
print(mycursor.rowcount, "record updated")
mycursor.execute("SELECT * FROM client")
myresult = mycursor.fetchall()
for x in myresult:
print(x)
#!/usr/bin/python3
"""Deletes a client record in the database boli_assurance of SQL"""
import mysql.connector
import sys
from database_connect import mydb, mycursor
from tabulate import tabulate
sql = ("SELECT * FROM client WHERE id_client=%s")
args = sys.argv
val = (int(args[1]), )
mycursor.execute(sql, val)
myresult = mycursor.fetchall()
for x in myresult:
print(
tabulate(
myresult,
headers=['id_client', 'first_name', 'last_name', 'phone', 'email'],
tablefmt='psql'))
#!/usr/bin/python3
""" Creates a vehicle record in the database boli_assurance of SQL"""
import mysql.connector
import sys
from database_connect import mydb, mycursor
sql = (
"INSERT INTO vehicle (id_plate, value, date_assurance, time_asssurance, is_assured, id_employee, id_client) VALUES (%s, %s, %s, %s, %s, %s, %s, %s)"
)
args = sys.argv
val = (int(args[1]), int(args[2]), args[3], int(args[4]), (args[5]),
int(args[6]), int(args[7]))
mycursor.execute(sql, val)
mydb.commit()
print(mycursor.rowcount, "record inserted")
mycursor.execute("SELECT * FROM vehicle")
myresult = mycursor.fetchall()
for x in myresult:
print(x)
#!/usr/bin/python3
"""Deletes an employee record in the database boli_assurance of SQL"""
import mysql.connector
import sys
from database_connect import mydb, mycursor
from tabulate import tabulate
sql = "SELECT * FROM employee"
mycursor.execute(sql)
myresult = mycursor.fetchall()
for x in myresult:
print(
tabulate(
myresult,
headers=['id_employee', 'first_name', 'last_name', 'department'],
tablefmt='psql'))
#!/usr/bin/python3
"""Deletes a client record in the database boli_assurance of SQL"""
import mysql.connector
import sys
from database_connect import mydb, mycursor
sql = ("DELETE FROM client "
"WHERE id_client=%s")
args = sys.argv
val = (int(args[1]),)
mycursor.execute(sql, val)
mydb.commit()
print(mycursor.rowcount, "record deleted")
mycursor.execute("SELECT * FROM client")
myresult = mycursor.fetchall()
for x in myresult:
print(x)
#!/usr/bin/python3
""" Creates an employee record in the database boli_assurance of SQL"""
import mysql.connector
import sys
from database_connect import mydb, mycursor
sql = ("INSERT INTO employee (id_employee, first_name, last_name, department) "
"VALUES (%s, %s, %s, %s)")
args = sys.argv
val = (int(args[1]), args[2], args[3], args[4])
mycursor.execute(sql, val)
mydb.commit()
print(mycursor.rowcount, "record inserted.")
mycursor.execute("SELECT * FROM employee")
myresult = mycursor.fetchall()
for x in myresult:
print(x)