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 main():
conn = connect_to_database.connect()
cursor = conn.cursor()
form = cgi.FieldStorage()
if "playername" not in form:
print("Error")
else:
playername = str(form.getvalue('playername'))
player_id = get_id(cursor, playername)
print_results(cursor, player_id, playername)
def main():
conn = connect_to_database.connect()
cursor = conn.cursor()
form = cgi.FieldStorage()
if "playername" not in form:
print("Error: No username entered")
else:
playername = str(form.getvalue("playername"))
insert_player(cursor, conn, playername)
print_results(cursor)
def test_query():
try:
(cursor, connection) = connect()
print('connection is ok')
query = "SELECT * FROM movies"
cursor.execute(query)
print(cursor.fetchone())
close_connection(cursor, connection)
except Exception as error:
print(error)
def main():
conn = connect_to_database.connect()
cursor = conn.cursor()
form = cgi.FieldStorage()
if "playername" not in form or "new_name" not in form:
print("Error: Missing data.")
else:
playername = str(form.getvalue('playername'))
new_name = str(form.getvalue('new_name'))
update_user(cursor, conn, new_name, playername)
print_results(cursor)
def movie(name):
data = []
try:
(cursor, connection) = connect()
query = "SELECT * FROM movies WHERE name = %s;"
cursor.execute(query, (name, ))
data = cursor.fetchone()
close_connection(cursor, connection)
except Exception as error:
print(error)
finally:
return render_template('movie.html', title=name, data=data)
def home():
data = []
try:
(cursor, connection) = connect()
query = "SELECT name, pic_url, year, genre, rate FROM movies"
cursor.execute(query)
result = cursor.fetchmany(4)
for row in result:
data.append(row)
close_connection(cursor, connection)
except Exception as error:
print(error)
return render_template('home.html', title='Tom Hanks', data=data)
def movies():
data = []
try:
(cursor, connection) = connect()
query = "SELECT * FROM movies;"
cursor.execute(query)
result = cursor.fetchall()
for row in result:
data.append(row)
close_connection(cursor, connection)
except Exception as error:
print(error)
finally:
return render_template('movies.html', title='Movies', data=data)
def import_data():
try:
(cursor, connection) = connect()
print('connection is ok')
f = open('movies.csv')
file = csv.reader(f)
insert_data = "INSERT INTO movies (name, pic_url, year, genre, rate, story) VALUES (%s, %s, %s, %s, %s, %s)"
for name, pic_url, year, genre, rate, story in file:
cursor.execute(insert_data, (name, pic_url, year, genre, rate, story))
connection.commit()
close_connection(cursor, connection)
print('data is inserted to database')
except Exception as error:
print(error)
def insert_param_into_table(conn, table_name, rows):
conn = connect_to_database.connect()
#rows=fetch_a_b_c_from_table(conn,'data')
#rows=fetch_everything_from_table(conn,'data')
#for x in rows:
#print x[0],x[1],x[2],'\n'
table_name = str(table_name)
t_sql = "INSERT INTO %s (a, b, c) " % (table_name)
sql = t_sql + "VALUES (%s, %s, %s)"
curr = conn.cursor()
try:
curr.executemany(sql, rows)
conn.commit()
print("inserted_sucessfully")
except:
conn.rollback()
print("data not inserted")
def create_table():
try:
(cursor, connection) = connect()
print('connection is ok')
create_table = '''CREATE TABLE movies(
id SERIAL PRIMARY KEY,
name VARCHAR NOT NULL,
pic_url VARCHAR NOT NULL,
year VARCHAR NOT NULL,
genre VARCHAR NOT NULL,
rate VARCHAR NOT NULL,
story TEXT
);'''
cursor.execute(create_table)
connection.commit()
print("table is created")
close_connection(cursor, connection)
except Exception as error:
print(error)
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)
def compare_tables(src, dest):
conn = connect_to_database.connect()
list1 = model.fetch_a_b_c_from_table(conn, src)
list2 = model.fetch_a_b_c_from_table(conn, dest)
ans = count_similarity(list1, list2)
print(ans)
def main():
conn = connect_to_database.connect()
cursor = conn.cursor()
print_results(cursor)
