#ifndef _fbtest1_fbtest1_h_
#define _fbtest1_fbtest1_h_
#include <CtrlLib/CtrlLib.h>

#include <SqlCtrl/SqlCtrl.h>

 

using namespace Upp;

 

#define LAYOUTFILE <fbtest1/fb.lay>

#include <CtrlCore/lay.h>

 

#include <Firebird/Firebird.h>

#define SCHEMADIALECT <Firebird/FirebirdSchema.h>

#define MODEL <fbtest1/database.sch>

#include "Sql/sch_header.h"

 

// debian: sudo apt-get install libpq-dev

 

class FirebirdTest : public WithFirebirdTestLayout<TopWindow> {

public:

    typedef FirebirdTest CLASSNAME;

    FirebirdTest();

    bool OpenDB();

    //bool InsertTestData();

    void ShowTestData();

protected:

    FBSession m_session;

};
#endif

#include "Firebird/Firebird.h"
#include "fbtest1.h"
 

#include <Sql/sch_schema.h>

#include <Sql/sch_source.h>

 

using namespace Upp;

bool FirebirdTest::OpenDB()

{

    
	
	m_session.Connect(
	"C:/Program Files/Firebird/Firebird_3_0/examples/empbuild/employee.fdb",
	"localhost",
	"SYSDBA",
	"MASTERKEY"
	);
	
	m_array.SetSession(m_session);
	
	SQL = m_session;

    SqlSchema sch(m_session);
    All_Tables(sch);
    SqlPerformScript(sch.Upgrade());
    SqlPerformScript(sch.Attributes())
    SQL.ClearError();
    
    return true;
	
}

FirebirdTest::FirebirdTest()

{

    CtrlLayout(*this, "Firebird Test");
    m_refresh <<= THISBACK(ShowTestData);
    m_array.SetTable(COUNTRY);
    m_array.AddColumn(COUNTRY_COUNTRY, "Country");
    m_array.AddColumn(COUNTRY_COUNTRY, "Currency");

}


void FirebirdTest::ShowTestData()

{

    // m_array.SetOrderBy(TESTPARTNER_NAME);

    m_array.Query();

}
GUI_APP_MAIN
{
	
	FirebirdTest dlg;

    if(dlg.OpenDB() )

    {

        dlg.ShowTestData();

        dlg.Run();

    }
    
    
    
}