int DB_Init_Model::Get_Payee_id(const wxString& name)
{
    int payee_id = -1;
    Model_Payee::Data* entry = Model_Payee::instance().get(name);
    if (entry)
    {
        payee_id = entry->id();
    }
    else ShowMessage("The ID not found for Payee: " + name);

    return payee_id;
}
void Test_Relocate_Payee::setUp()
{
    CpuTimer time("Startup");
    m_base_frame = new TestFrameBase(m_this_instance);
    m_base_frame->Show(true);

    m_test_db.Open(m_test_db_filename);
    m_dbmodel = new DB_Model();
    m_dbmodel->Init_Model_Tables(&m_test_db);
    m_dbmodel->Init_BaseCurrency();


    // Initialise some payees
    Model_Payee::instance().Savepoint();
    {
        Model_Payee::Data* payee = Model_Payee::instance().create();
        payee->PAYEENAME = "Workshop";
        payee->CATEGID = Model_Category::instance().get("Income")->id();
        payee->SUBCATEGID = Model_Subcategory::instance().get("Salary", payee->CATEGID)->id();
        Model_Payee::instance().save(payee);

        Model_Payee::Data* supermarket = Model_Payee::instance().clone(payee);
        supermarket->PAYEENAME = "Supermarket";
        supermarket->CATEGID = Model_Category::instance().get("Food")->id();
        supermarket->SUBCATEGID = Model_Subcategory::instance().get("Groceries", supermarket->CATEGID)->id();
        Model_Payee::instance().save(supermarket);

        payee = Model_Payee::instance().create();
        payee->PAYEENAME = "Aldi";
        Model_Payee::instance().save(payee);

        payee = Model_Payee::instance().create();
        payee->PAYEENAME = "Coles";
        Model_Payee::instance().save(payee);

        payee = Model_Payee::instance().create();
        payee->PAYEENAME = "Woolworths";
        Model_Payee::instance().save(payee);

        // Set up payees inthe other tables.
        Model_Checking::Data* checking_entry = Model_Checking::instance().create();
        checking_entry->PAYEEID = supermarket->id();
        Model_Checking::instance().save(checking_entry);

        Model_Billsdeposits::Data* bill_entry = Model_Billsdeposits::instance().create();
        bill_entry->PAYEEID = supermarket->id();
        Model_Billsdeposits::instance().save(bill_entry);
    }
    Model_Payee::instance().ReleaseSavepoint();
}