def setUpClass(cls): super(TestSuperAdminViewsWithData, cls).setUpClass() # Init User cls.user_name = 'test_super_admin1' cls.password = '******' cls.address = 'test_address_111111111' cls.public_key = 'test_publickey' cls.enc_master_seed = 'test_enc_master_seed' cls.enc_master_key = 'test_enc_master_key' # Transaction cls.from_address = cls.address cls.to_address = cls.address cls.amount = 10000000 cls.sequence = 20 cls.ledger = 12345678 cls.created = datetime.datetime.now() cls.destination_tag = 11111111 cls.status = 'test_status' cls.txid = 'dcsac89dsachd98ahc98adh' cls.path = reverse('admin_panel:login_page') cls.client = Client() # Common DB cls.cm_db = util.get_db_connect() # Create User enc_password = util.encrypt_password(cls.password) cls.test_user = Login_Master.objects.create(user_name=cls.user_name, password=enc_password) # Sample data insert_sample_address(cls.user_name,cls.address,cls.public_key,cls.enc_master_seed,cls.enc_master_key) insert_sample_transaction(cls.from_address, cls.to_address, cls.amount, cls.txid, cls.sequence,cls.ledger,cls.destination_tag,cls.status)
def delete_sample_user(user_name): db_auxpay = util.get_db_connect() cur = db_auxpay.cursor() delete_user_query = "Delete from aux_ripp_user_master where user_name = '%s'" % (user_name) cur.execute(delete_user_query) db_auxpay.commit() cur.close() db_auxpay.close()
def delete_sample_transaction(address): # Delete Temp Data db_auxpay = util.get_db_connect() cur = db_auxpay.cursor() delete_tx_query = "Delete from aux_ripp_transaction_master where from_address = '%s' or to_address = '%s'" % (address,address) cur.execute(delete_tx_query) db_auxpay.commit() cur.close() db_auxpay.close()
def delete_sample_address(user_name): # Delete Temp Data db_auxpay = util.get_db_connect() cur = db_auxpay.cursor() delete_address_query = "Delete from aux_ripp_address_master where user_name = '%s'" % (user_name) cur.execute(delete_address_query) db_auxpay.commit() cur.close() db_auxpay.close()
def insert_sample_user(user_name,token,url,app_key,app_secret): # Auxpay Db Connection db_auxpay = util.get_db_connect() cur = db_auxpay.cursor() # Generate Address insert_address = "Insert into aux_ripp_user_master(user_name,token,notification_url,app_key,app_secret) values (%s,%s,%s,%s,%s)" cur.execute(insert_address, (user_name, token, url, app_key, app_secret)) db_auxpay.commit() cur.close() db_auxpay.close()
def insert_sample_address(user_name,address,public_key,enc_master_seed,enc_master_key): # Auxpay Db Connection db_auxpay = util.get_db_connect() cur = db_auxpay.cursor() # Generate Address insert_address = "Insert into aux_ripp_address_master(user_name,address,public_key,enc_master_seed,enc_master_key,is_active,is_multi_sig) values (%s,%s,%s,%s,%s,%s,%s)" cur.execute(insert_address, (user_name, address, public_key, enc_master_seed, enc_master_key, False, False)) db_auxpay.commit() cur.close() db_auxpay.close()
def insert_sample_transaction(from_address, to_address, amount, txid, sequence,ledger,destination_tag,status): # Auxpay Db Connection db_auxpay = util.get_db_connect() cur = db_auxpay.cursor() insert_transaction = 'Insert into aux_ripp_transaction_master' \ ' (from_address,to_address,amount,txid,sequence,ledger_index,created_at,bid_id,status)' \ ' values(%s,%s,%s,%s,%s,%s,%s,%s,%s)' cur.execute(insert_transaction, ( from_address, to_address, amount, txid, sequence, ledger, datetime.datetime.now(), destination_tag, status)) db_auxpay.commit() cur.close() db_auxpay.close()