sys.path.append('../') from SOL4Py.ZMain import * import base64 from SOL4Py.mysql.ZMySQLDB import * from SOL4Py.crypto.ZAESIVEmbeddedCipher import * from SOL4Py.generator.ZTokenGenerator import * from SOL4Py.generator.ZEmailAddressGenerator import * from SOL4Py.generator.ZPasswordGenerator import * if main(__name__): # user password database # foo password test db = ZMySQLDB(argv=sys.argv) try: for i in range(1000): token_generator = ZTokenGenerator() email_generator = ZEmailAddressGenerator() password_generator = ZPasswordGenerator() atoken = token_generator.generate(20) email = email_generator.generate() password = password_generator.generate() key = email cipher = ZAESIVEmbeddedCipher(ZCipher.AS_HEX) hex_iv_password = cipher.encrypt(password, key)
sys.path.append('../') from SOL4Py.ZMain import * import base64 from SOL4Py.mysql.ZMySQLDB import * from SOL4Py.crypto.ZAESIVEmbeddedCipher import * from SOL4Py.generator.ZTokenGenerator import * from SOL4Py.generator.ZEmailAddressGenerator import * if main(__name__): # user password database # foo password test try: db = ZMySQLDB(argv=sys.argv) MAGIC = '&=~|%asZpo()/?moon' email = '*****@*****.**' password = "******" print("Email {}".format(email)) print("Password {}".format(password)) try: print("Select ...") select = "SELECT auth_token, email, password FROM test.User WHERE email=%s LIMIT 1" values = (email, ) row = db.execute_fetchone(select, values) if row == None: print(
print("New Auth_token {}".format(new_atoken)) print("New Password {}".format(new_password)) update = "UPDATE test.User SET auth_token=%s, password =%s WHERE id =%s" values = (new_atoken, new_hex_iv_password, id) self.cursor.execute(update, values) self.commit() except: traceback.print_exc() self.rollback() if main(__name__): # user password database db = ZMySQLDB(argv=sys.argv) try: update_thread = UpdateTableThread(db.connection) update_thread.start() update_thread.join() except: traceback.print_exc() finally: db.connection.close()
self.cursor.execute( "INSERT INTO test.User (auth_token, email, password) VALUES(%s, %s, %s)", (atoken, email, hex_iv_password)) except: traceback.print_exc() self.commit() except: traceback.print_exc() self.rollback() if main(__name__): # user password database # foo password test db = ZMySQLDB(argv=sys.argv) try: insertion_thread = InsertIntoTableThread(db.connection) insertion_thread.start() insertion_thread.join() except: traceback.print_exc() db.rollback() finally: db.connection.close()
sys.path.append('../') from SOL4Py.ZMain import * import base64 from SOL4Py.mysql.ZMySQLDB import * from SOL4Py.crypto.ZAESIVEmbeddedCipher import * from SOL4Py.generator.ZTokenGenerator import * from SOL4Py.generator.ZEmailAddressGenerator import * from SOL4Py.generator.ZPasswordGenerator import * if main(__name__): # user password database # foo password test db = ZMySQLDB(argv=sys.argv) try: delete = "DELETE FROM test.User WHERE email LIKE %s" values = ('%.biz', ) db.execute(delete, values) db.commit() select = "SELECT * FROM test.User WHERE email LIKE %s" values = ('%.biz', ) rows = db.execute_fetchall(select, values) if rows != None: print("Rows len {}".format(len(rows)))
from SOL4Py.mysql.ZMySQLDB import * """ create table test.User ( id bigint unsigned not null primary key auto_increment, auth_token varchar(40) default NULL, email varchar(255) unique default NULL, password varchar(512) default NULL, #AES ENCRUPTED Password validated bool default False, last_modified datetime default NOW() ); """ if main(__name__): # Commandline parameters user password dabase db = ZMySQLDB(argv=sys.argv) try: #Create test database. create_db = "CREATE DATABASE IF NOT EXISTS test" db.execute(create_db) #Create test.User table create_tbl = "CREATE TABLE IF NOT EXISTS test.User ( "\ + " id bigint unsigned not null primary key auto_increment, "\ + " auth_token varchar(40) default NULL, "\ + " email varchar(255) unique default NULL, "\ + " password varchar(512) default NULL, "\ + " last_modified datetime default NOW() "\ + " ); "