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)