def get_airdrop_details(cur, airdrop_id):
    """
    Return all the details about an airdrop from the database
    :param airdrop_id:
    :return: a disctionary with all the airdrop details
    """
    airdrop_details = {}
    airdrop_transactions = []
    cur.execute("SELECT hash, status, date, id FROM airdrops WHERE id = ?", (airdrop_id, ))
    airdrop = cur.fetchone()
    airdrop_details['airdrop_id'] = airdrop[0]
    airdrop_details['status'] = airdrop[1]
    airdrop_details['date'] = airdrop[2]
    cur.execute("SELECT hash, name, status, date FROM transactions WHERE airdrop_id = ?", (airdrop[3], ))
    transactions = cur.fetchall()
    for trans in transactions:
        airdrop_transaction = {}
        airdrop_transaction['transaction_hash'] = trans[0]
        airdrop_transaction['transaction_name'] = trans[1]
        airdrop_transaction['transaction_status'] = trans[2]
        airdrop_transaction['transaction_data'] = trans[3]
        airdrop_transactions.append(airdrop_transaction)
    airdrop_details['transactions'] = airdrop_transactions
    return airdrop_details