/
deleterequest.py
37 lines (36 loc) · 1.46 KB
/
deleterequest.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
from mysql.connector import cursor
def deleterequest(cnx, cursor, id, placeid, which, results):
if which == 0:
while 1:
featid = input("Please input the feature id from the above list you would like to update:\n")
isafeat = 0
for result in results:
if result[4] == featid:
isafeat = 1
if isafeat:
break
else:
print("Not a valid feature id from the results. Try again")
delete = ("INSERT INTO change_requests "
"(userid, featureid, changetype, streetid) "
"VALUES (%s, %s, %s, %s)")
cursor.execute(delete, (id, featid, "delete", placeid))
cnx.commit()
print("Change request submitted")
elif which == 1:
while 1:
featid = "Please input the feature id from the above list you would like to update:"
isafeat = 0
for result in results:
if result[2] == featid:
isafeat = 1
if isafeat:
break
else:
print("Not a valid feature id from the results. Try again")
delete = ("INSERT INTO change_requests "
"(userid, featureid, changetype, intersectionid) "
"VALUES (%s, %s, %s, %s)")
cursor.execute(delete, (id, featid, "delete", placeid))
cnx.commit()
print("Change request submitted")