+ " set "
+ column
+ " = "
+ newvalue
+ " where "
+ where1
+ " = "
+ round
+ " and "
+ where2
+ " = "
+ dog
+ ";"
)
print build_select_query
rowselect = cwagsDBUpdate(build_select_query, 0, 0, 0)
else:
pass
changedruns = {50: [10, 1], 30: [7, 0], 56: [11, 1]}
for entry in changedruns.keys():
build_select_query_special = (
"update "
+ table
+ " set dog = "
+ str(changedruns[entry][0])
+ ", result = "
+ str(changedruns[entry][1])
+ " where id = "
+ str(entry)
+ ";"
syntax_for_select = "update TABLE set COLUMN = NEWVALUE where id = ID;"
# update dog set cwags ='15-1095-01' where id = 8;
csvfile = open(info_to_add, "rb")
csvreader = csv.reader(csvfile, delimiter=",", quotechar='"')
csvdict = csv.DictReader(csvfile)
table = "dog"
setcolumn = "cwags"
wherecolumn = "id"
for row in csvdict:
for key in row.keys():
if key == setcolumn:
column = key
newvalue = row[key]
elif key == wherecolumn:
where = key
id = row[key]
else:
print key, row[key]
if id:
print id
build_select_query = (
"update " + table + " set " + column + " = '" + newvalue + "' where " + where + " = " + id + ";"
)
print build_select_query
rowselect = cwagsDBUpdate(build_select_query, 0, 0, 0)
else:
pass
