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() "\
+ " ); "