import os
import platform
import mysql.connector
 
def connect_db():
    return mysql.connector.connect(host="localhost", user="root", password="root", database='parking')
 
def Add_Record(mycursor):
    L = []
    id1 = int(input("Enter the parking number : "))
    L.append(id1)
    pname1 = input("Enter the Parking Name: ")
    L.append(pname1)
    level1 = input("Enter level of parking : ")
    L.append(level1)
    freespace1 = input("Is there any freespace or not : YES/NO ")
    L.append(freespace1)
    vehicleno1 = input("Enter the Vehicle Number : ")
    L.append(vehicleno1)
    nod1 = int(input("Enter total number of days for parking: "))
    L.append(nod1)
 
    # Payment calculation
    Payment1 = 20 * nod1 if nod1 <= 5 else 6969
    L.append(Payment1)
 
    stud = tuple(L)
    sql = 'INSERT INTO parkmaster12(pid, pnm, level, freespace, vehicleno, nod, payment) VALUES(%s, %s, %s, %s, %s, %s, %s)'
    mycursor.execute(sql, stud)
 
def Rec_View(mycursor):
    print("Select the search criteria : ")
    print("1. Parking Number")
    print("2. Parking Name")
    print("3. Level No")
    print("4. All")
    ch = int(input("Enter the choice : "))
 
    if ch == 1:
        s = int(input("Enter Parking no : "))
        sql = "SELECT * FROM parkmaster12 WHERE pid=%s"
        mycursor.execute(sql, (s,))
    elif ch == 2:
        s = input("Enter Parking Name : ")
        sql = "SELECT * FROM parkmaster12 WHERE pnm=%s"
        mycursor.execute(sql, (s,))
    elif ch == 3:
        s = input("Enter Level of Parking : ")
        sql = "SELECT * FROM parkmaster12 WHERE level=%s"
        mycursor.execute(sql, (s,))
    elif ch == 4:
        sql = "SELECT * FROM parkmaster12"
        mycursor.execute(sql)
 
    res = mycursor.fetchall()
    print("Details about Parking are as follows : ")
    print("(Parking Id, Parking Name, Level, FreeSpace(Y/N), Vehicle No, No of days for parking, Payment)")
    for x in res:
        print(x)
 
def Vehicle_Detail(mycursor):
    L = []
    vid1 = int(input("Enter Vehicle No : "))
    L.append(vid1)
    vnm1 = input("Enter Vehicle Name/Model Name : ")
    L.append(vnm1)
    dateofpur1 = input("Enter Year-Month-Date of purchase : ")
    L.append(dateofpur1)
    vdt = tuple(L)
    sql = "INSERT INTO vehicle(vid, vnm, dateofpur) VALUES(%s, %s, %s)"
    mycursor.execute(sql, vdt)
 
def Vehicle_View(mycursor):
    vid1 = int(input("Enter the vehicle number of the vehicle whose details is to be viewed : "))
    sql = 'SELECT parkmaster12.pid, parkmaster12.pnm, parkmaster12.vehicleno, vehicle.vid, vehicle.vnm FROM parkmaster12 INNER JOIN vehicle ON parkmaster12.pid=vehicle.vid WHERE vehicle.vid=%s'
    mycursor.execute(sql, (vid1,))
    res = mycursor.fetchall()
    print('The following are the details you wanted:')
    for x in res:
        print(x)
 
def remove(mycursor):
    vid1 = int(input("Enter the vehicle number of the vehicle to be deleted : "))
    sql = "DELETE FROM vehicle WHERE vid=%s"
    mycursor.execute(sql, (vid1,))
    print('Removed as per the command')
 
def Menu(mycursor):
    print("Enter 1 : To Add Parking Detail")
    print("Enter 2 : To View Parking Detail ")
    print("Enter 3 : To Add Vehicle Detail ")
    print("Enter 4 : To Remove Vehicle Record")
    print("Enter 5 : To see the details of Vehicle")
    input_dt = int(input("Please Select An Above Option: "))
 
    if input_dt == 1:
        Add_Record(mycursor)
    elif input_dt == 2:
        Rec_View(mycursor)
    elif input_dt == 3:
        Vehicle_Detail(mycursor)
    elif input_dt == 4:
        remove(mycursor)
    elif input_dt == 5:
        Vehicle_View(mycursor)
    else:
        print("Enter correct choice....")
 
def run():
    mydb = connect_db()
    mycursor = mydb.cursor()
    while True:
        Menu(mycursor)
        runAgn = input('\nWant to run Again Y/n: ')
        if runAgn.lower() != 'y':
            break
    mydb.close()
 
run()
 

aW1wb3J0IG9zCmltcG9ydCBwbGF0Zm9ybQppbXBvcnQgbXlzcWwuY29ubmVjdG9yCgpkZWYgY29ubmVjdF9kYigpOgogICAgcmV0dXJuIG15c3FsLmNvbm5lY3Rvci5jb25uZWN0KGhvc3Q9ImxvY2FsaG9zdCIsIHVzZXI9InJvb3QiLCBwYXNzd29yZD0icm9vdCIsIGRhdGFiYXNlPSdwYXJraW5nJykKCmRlZiBBZGRfUmVjb3JkKG15Y3Vyc29yKToKICAgIEwgPSBbXQogICAgaWQxID0gaW50KGlucHV0KCJFbnRlciB0aGUgcGFya2luZyBudW1iZXIgOiAiKSkKICAgIEwuYXBwZW5kKGlkMSkKICAgIHBuYW1lMSA9IGlucHV0KCJFbnRlciB0aGUgUGFya2luZyBOYW1lOiAiKQogICAgTC5hcHBlbmQocG5hbWUxKQogICAgbGV2ZWwxID0gaW5wdXQoIkVudGVyIGxldmVsIG9mIHBhcmtpbmcgOiAiKQogICAgTC5hcHBlbmQobGV2ZWwxKQogICAgZnJlZXNwYWNlMSA9IGlucHV0KCJJcyB0aGVyZSBhbnkgZnJlZXNwYWNlIG9yIG5vdCA6IFlFUy9OTyAiKQogICAgTC5hcHBlbmQoZnJlZXNwYWNlMSkKICAgIHZlaGljbGVubzEgPSBpbnB1dCgiRW50ZXIgdGhlIFZlaGljbGUgTnVtYmVyIDogIikKICAgIEwuYXBwZW5kKHZlaGljbGVubzEpCiAgICBub2QxID0gaW50KGlucHV0KCJFbnRlciB0b3RhbCBudW1iZXIgb2YgZGF5cyBmb3IgcGFya2luZzogIikpCiAgICBMLmFwcGVuZChub2QxKQoKICAgICMgUGF5bWVudCBjYWxjdWxhdGlvbgogICAgUGF5bWVudDEgPSAyMCAqIG5vZDEgaWYgbm9kMSA8PSA1IGVsc2UgNjk2OQogICAgTC5hcHBlbmQoUGF5bWVudDEpCgogICAgc3R1ZCA9IHR1cGxlKEwpCiAgICBzcWwgPSAnSU5TRVJUIElOVE8gcGFya21hc3RlcjEyKHBpZCwgcG5tLCBsZXZlbCwgZnJlZXNwYWNlLCB2ZWhpY2xlbm8sIG5vZCwgcGF5bWVudCkgVkFMVUVTKCVzLCAlcywgJXMsICVzLCAlcywgJXMsICVzKScKICAgIG15Y3Vyc29yLmV4ZWN1dGUoc3FsLCBzdHVkKQoKZGVmIFJlY19WaWV3KG15Y3Vyc29yKToKICAgIHByaW50KCJTZWxlY3QgdGhlIHNlYXJjaCBjcml0ZXJpYSA6ICIpCiAgICBwcmludCgiMS4gUGFya2luZyBOdW1iZXIiKQogICAgcHJpbnQoIjIuIFBhcmtpbmcgTmFtZSIpCiAgICBwcmludCgiMy4gTGV2ZWwgTm8iKQogICAgcHJpbnQoIjQuIEFsbCIpCiAgICBjaCA9IGludChpbnB1dCgiRW50ZXIgdGhlIGNob2ljZSA6ICIpKQogICAgCiAgICBpZiBjaCA9PSAxOgogICAgICAgIHMgPSBpbnQoaW5wdXQoIkVudGVyIFBhcmtpbmcgbm8gOiAiKSkKICAgICAgICBzcWwgPSAiU0VMRUNUICogRlJPTSBwYXJrbWFzdGVyMTIgV0hFUkUgcGlkPSVzIgogICAgICAgIG15Y3Vyc29yLmV4ZWN1dGUoc3FsLCAocywpKQogICAgZWxpZiBjaCA9PSAyOgogICAgICAgIHMgPSBpbnB1dCgiRW50ZXIgUGFya2luZyBOYW1lIDogIikKICAgICAgICBzcWwgPSAiU0VMRUNUICogRlJPTSBwYXJrbWFzdGVyMTIgV0hFUkUgcG5tPSVzIgogICAgICAgIG15Y3Vyc29yLmV4ZWN1dGUoc3FsLCAocywpKQogICAgZWxpZiBjaCA9PSAzOgogICAgICAgIHMgPSBpbnB1dCgiRW50ZXIgTGV2ZWwgb2YgUGFya2luZyA6ICIpCiAgICAgICAgc3FsID0gIlNFTEVDVCAqIEZST00gcGFya21hc3RlcjEyIFdIRVJFIGxldmVsPSVzIgogICAgICAgIG15Y3Vyc29yLmV4ZWN1dGUoc3FsLCAocywpKQogICAgZWxpZiBjaCA9PSA0OgogICAgICAgIHNxbCA9ICJTRUxFQ1QgKiBGUk9NIHBhcmttYXN0ZXIxMiIKICAgICAgICBteWN1cnNvci5leGVjdXRlKHNxbCkKCiAgICByZXMgPSBteWN1cnNvci5mZXRjaGFsbCgpCiAgICBwcmludCgiRGV0YWlscyBhYm91dCBQYXJraW5nIGFyZSBhcyBmb2xsb3dzIDogIikKICAgIHByaW50KCIoUGFya2luZyBJZCwgUGFya2luZyBOYW1lLCBMZXZlbCwgRnJlZVNwYWNlKFkvTiksIFZlaGljbGUgTm8sIE5vIG9mIGRheXMgZm9yIHBhcmtpbmcsIFBheW1lbnQpIikKICAgIGZvciB4IGluIHJlczoKICAgICAgICBwcmludCh4KQoKZGVmIFZlaGljbGVfRGV0YWlsKG15Y3Vyc29yKToKICAgIEwgPSBbXQogICAgdmlkMSA9IGludChpbnB1dCgiRW50ZXIgVmVoaWNsZSBObyA6ICIpKQogICAgTC5hcHBlbmQodmlkMSkKICAgIHZubTEgPSBpbnB1dCgiRW50ZXIgVmVoaWNsZSBOYW1lL01vZGVsIE5hbWUgOiAiKQogICAgTC5hcHBlbmQodm5tMSkKICAgIGRhdGVvZnB1cjEgPSBpbnB1dCgiRW50ZXIgWWVhci1Nb250aC1EYXRlIG9mIHB1cmNoYXNlIDogIikKICAgIEwuYXBwZW5kKGRhdGVvZnB1cjEpCiAgICB2ZHQgPSB0dXBsZShMKQogICAgc3FsID0gIklOU0VSVCBJTlRPIHZlaGljbGUodmlkLCB2bm0sIGRhdGVvZnB1cikgVkFMVUVTKCVzLCAlcywgJXMpIgogICAgbXljdXJzb3IuZXhlY3V0ZShzcWwsIHZkdCkKCmRlZiBWZWhpY2xlX1ZpZXcobXljdXJzb3IpOgogICAgdmlkMSA9IGludChpbnB1dCgiRW50ZXIgdGhlIHZlaGljbGUgbnVtYmVyIG9mIHRoZSB2ZWhpY2xlIHdob3NlIGRldGFpbHMgaXMgdG8gYmUgdmlld2VkIDogIikpCiAgICBzcWwgPSAnU0VMRUNUIHBhcmttYXN0ZXIxMi5waWQsIHBhcmttYXN0ZXIxMi5wbm0sIHBhcmttYXN0ZXIxMi52ZWhpY2xlbm8sIHZlaGljbGUudmlkLCB2ZWhpY2xlLnZubSBGUk9NIHBhcmttYXN0ZXIxMiBJTk5FUiBKT0lOIHZlaGljbGUgT04gcGFya21hc3RlcjEyLnBpZD12ZWhpY2xlLnZpZCBXSEVSRSB2ZWhpY2xlLnZpZD0lcycKICAgIG15Y3Vyc29yLmV4ZWN1dGUoc3FsLCAodmlkMSwpKQogICAgcmVzID0gbXljdXJzb3IuZmV0Y2hhbGwoKQogICAgcHJpbnQoJ1RoZSBmb2xsb3dpbmcgYXJlIHRoZSBkZXRhaWxzIHlvdSB3YW50ZWQ6JykKICAgIGZvciB4IGluIHJlczoKICAgICAgICBwcmludCh4KQoKZGVmIHJlbW92ZShteWN1cnNvcik6CiAgICB2aWQxID0gaW50KGlucHV0KCJFbnRlciB0aGUgdmVoaWNsZSBudW1iZXIgb2YgdGhlIHZlaGljbGUgdG8gYmUgZGVsZXRlZCA6ICIpKQogICAgc3FsID0gIkRFTEVURSBGUk9NIHZlaGljbGUgV0hFUkUgdmlkPSVzIgogICAgbXljdXJzb3IuZXhlY3V0ZShzcWwsICh2aWQxLCkpCiAgICBwcmludCgnUmVtb3ZlZCBhcyBwZXIgdGhlIGNvbW1hbmQnKQoKZGVmIE1lbnUobXljdXJzb3IpOgogICAgcHJpbnQoIkVudGVyIDEgOiBUbyBBZGQgUGFya2luZyBEZXRhaWwiKQogICAgcHJpbnQoIkVudGVyIDIgOiBUbyBWaWV3IFBhcmtpbmcgRGV0YWlsICIpCiAgICBwcmludCgiRW50ZXIgMyA6IFRvIEFkZCBWZWhpY2xlIERldGFpbCAiKQogICAgcHJpbnQoIkVudGVyIDQgOiBUbyBSZW1vdmUgVmVoaWNsZSBSZWNvcmQiKQogICAgcHJpbnQoIkVudGVyIDUgOiBUbyBzZWUgdGhlIGRldGFpbHMgb2YgVmVoaWNsZSIpCiAgICBpbnB1dF9kdCA9IGludChpbnB1dCgiUGxlYXNlIFNlbGVjdCBBbiBBYm92ZSBPcHRpb246ICIpKQogICAgCiAgICBpZiBpbnB1dF9kdCA9PSAxOgogICAgICAgIEFkZF9SZWNvcmQobXljdXJzb3IpCiAgICBlbGlmIGlucHV0X2R0ID09IDI6CiAgICAgICAgUmVjX1ZpZXcobXljdXJzb3IpCiAgICBlbGlmIGlucHV0X2R0ID09IDM6CiAgICAgICAgVmVoaWNsZV9EZXRhaWwobXljdXJzb3IpCiAgICBlbGlmIGlucHV0X2R0ID09IDQ6CiAgICAgICAgcmVtb3ZlKG15Y3Vyc29yKQogICAgZWxpZiBpbnB1dF9kdCA9PSA1OgogICAgICAgIFZlaGljbGVfVmlldyhteWN1cnNvcikKICAgIGVsc2U6CiAgICAgICAgcHJpbnQoIkVudGVyIGNvcnJlY3QgY2hvaWNlLi4uLiIpCgpkZWYgcnVuKCk6CiAgICBteWRiID0gY29ubmVjdF9kYigpCiAgICBteWN1cnNvciA9IG15ZGIuY3Vyc29yKCkKICAgIHdoaWxlIFRydWU6CiAgICAgICAgTWVudShteWN1cnNvcikKICAgICAgICBydW5BZ24gPSBpbnB1dCgnXG5XYW50IHRvIHJ1biBBZ2FpbiBZL246ICcpCiAgICAgICAgaWYgcnVuQWduLmxvd2VyKCkgIT0gJ3knOgogICAgICAgICAgICBicmVhawogICAgbXlkYi5jbG9zZSgpCgpydW4oKQo=