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()