def watermark(table_name):
conn = connect_to_database.connect()
count = 0
params = []
#print "Watermarked Tuples"
for i in range(1, 10000):
if (check_id(i) == True):
row = model.fetch_only_a_b_c_from_table(conn, table_name, i)
# model.update_only_a_b_c_in_table(conn,table_name,i,1,1,1)
a_old, b_old, c_old = row[0], row[1], row[2]
a8_old, b8_old = a_old % 256, b_old % 256
a_mod, b_mod = a_old - a8_old, b_old - b8_old
lbefore = (a8_old + b8_old) / 2
hbefore = a8_old - b8_old
hdash = 2 * hbefore + 1
g = (hdash + 1) / 2
f = hdash / 2
anew8, bnew8 = lbefore + g, lbefore - f
if ((anew8 >= 0 and anew8 < 256) and (bnew8 >= 0 and bnew8 < 256)):
a_new = a_mod + anew8
b_new = b_mod + bnew8
c_new = c_old | 10
#print i,a_new,b_new,c_new
params.append((a_new, b_new, c_new, i))
count += 1
#print i
model.update_all_a_b_c_in_table(conn, table_name, params)
print("Total rows Updated %d" % count)
connect_to_database.close(conn)
def reverse_watermark(table_name):
conn = connect_to_database.connect()
count = 0
params = []
#print "Reverse Watermarked Tuples"
for i in range(1, 10000):
if check_id(i) == True:
row = model.fetch_only_a_b_c_from_table(conn, table_name, i)
#model.update_only_a_b_c_in_table(conn,table_name,i,1,1,1)
a_old, b_old, c_old = row[0], row[1], row[2]
a8_old, b8_old = a_old % 256, b_old % 256
a_mod, b_mod = a_old - a8_old, b_old - b8_old
lbefore = (a8_old + b8_old) / 2
hbefore = a8_old - b8_old
hdash = hbefore / 2
g = (hdash + 1) / 2
f = hdash / 2
anew8, bnew8 = lbefore + g, lbefore - f
if ((c_old & 10) == 10):
a_new = a_mod + anew8
b_new = b_mod + bnew8
temp = sys.maxsize
c_new = c_old & (temp ^ 10)
#print i,a_new,b_new,c_new
params.append((a_new, b_new, c_new, i))
count += 1
#print i
model.update_all_a_b_c_in_table(conn, table_name, params)
print("Total rows Updated %d" % count)
connect_to_database.close(conn)
try:
curr.execute("UPDATE %s SET a = %d,b = %d,c = %d WHERE ID = %d" %
(table_name, a, b, c, id))
conn.commit()
except:
conn.rollback()
def update_all_a_b_c_in_table(conn, table_name, params):
curr = conn.cursor()
table_name = str(table_name)
sql = "UPDATE %s SET " % (table_name)
sql = sql + "a = %s,b =%s,c = %s WHERE ID = %s"
curr.executemany(sql, params)
conn.commit()
print("Updated sucessfully")
if __name__ == '__main__':
x = int(
raw_input('''Enter 1 for deleting every row from table
Enter 2 for inserting rows\n'''))
y = str(raw_input("Insert table name\n"))
conn = connect_to_database.connect()
if x == 1:
delete_everything_table(conn, y)
else:
insert_into_table(conn, y)
connect_to_database.close(conn)
def list():
conn = connect_to_database.connect()
rows = model.fetch_everything_from_table(conn, 'data')
connect_to_database.close(conn)
return render_template('test.html', rows=rows)
def copy_data_from_src_to_dest(src, dest):
conn = connect_to_database.connect()
model.delete_everything_table(conn, dest)
param = model.fetch_a_b_c_from_table(conn, src)
model.insert_param_into_table(conn, dest, param)
connect_to_database.close(conn)
