Hi Parvinder,
As an alternative to ORM , you can try out my project here:
git://proghelp.git.sourceforge.net/gitroot/proghelp/proghelp
It takes modified syntax of create table input statements and builds a
working Wt application, along with Makefiles and random test data. It generates
stored procedures for PostgreSQL. A sample input is below.
Kind Regards,
Neil
CREATE TABLE Project : UI_GROUP (Project_Admin) (
Project_Admin ->
Project_Code int: primary_key UI_VIEW UI_SELECT,
Project_Number varchar(20): unique UI_VIEW UI_SELECT,
Project_Name varchar(250): unique UI_VIEW UI_SELECT SEARCH_KEY
UI_DIALOG_SELECT_XFER
Project_Description ->
Project_Short_Description varchar(2000): not null
Project_Dates ->
Project_Entry_Date datetime: not null,
Project_Start_Date datetime: null,
Project_End_Date datetime: null,
Project_Commission_Date datetime: not null UI_VIEW UI_SELECT,
Project_Lost_Date datetime: not null
Project_Description ->
Project_Description varchar(5000): null
Project_Dates ->
Revenue_Start_Date datetime: not null
Project_Admin ->
Project_Status_Code int: references Project_Status(Project_Status_Code)
Project_People ->
Employee_Code int: references Employee(Employee_Code) ,
ClientContactPerson_Code int: references
ClientContactPerson(ClientContactPerson_Code)
Project_Admin ->
Exchange_Master_Code int: references
Exchange_Master(Exchange_Master_Code),
Project_Type_Code int: references Project_Type(Project_Type_Code)
);
CREATE TABLE ClientContactPerson: UI_GROUP (Client) (
ClientContactPerson_Code int: PRIMARY_KEY UI_VIEW UI_SELECT,
ClientContactPerson_Name varchar(250): NOT NULL SEARCH_KEY UI_VIEW
UI_SELECT UI_DIALOG_SELECT_XFER,
Client_Code int: REFERENCES Client(Client_Code) ,
Designation varchar(150): NULL,
Email1 varchar(250): not null,
Email2 varchar(250): null,
Phone varchar(50): NULL,
Extention varchar(50): NULL,
Mobile varchar(50): NULL
);
CREATE TABLE Client: UI_GROUP (Client) (
Client_Code int : PRIMARY_KEY UI_VIEW UI_SELECT,
Client_Name varchar(250): UNIQUE SEARCH_KEY UI_VIEW UI_SELECT
UI_DIALOG_SELECT_XFER,
ClientGroup_Code int: REFERENCES ClientGroup(ClientGroup_Code) ,
Address1 varchar(500) :NULL,
Address2 varchar(500) :NULL,
City varchar(250) : NOT NULL,
Pin varchar(150) : NULL,
POBOX varchar(50) : NULL,
Country_Code int: references Country(Country_Code),
Phone1 varchar(50): NULL,
Phone2 varchar(50): NULL,
Fax varchar(50): NULL,
Website varchar(250): NULL,
isInternal bit: NULL
);
create table Country :UI_GROUP (Client) (
Country_Code int: PRIMARY_KEY UI_VIEW UI_SELECT,
Country_Short_Name varchar(5): UNIQUE UI_VIEW UI_SELECT SEARCH_KEY
UI_DIALOG_SELECT_XFER,
Country_Name varchar(250): UNIQUE);
CREATE TABLE ClientGroup: UI_GROUP(Client) (
ClientGroup_Code int : PRIMARY_KEY UI_VIEW UI_SELECT,
ClientGroup_Name varchar(250) : UNIQUE UI_VIEW UI_SELECT SEARCH_KEY
);
CREATE TABLE Employee: UI_GROUP (Employee) SESSION_KEY_ROOT (
Employee_Code int: primary_key UI_VIEW UI_SELECT session_key_source,
ForeName varchar(250) : not null UI_VIEW UI_SELECT SEARCH_KEY
UI_DIALOG_SELECT_XFER,
MiddleName varchar(250) : not null UI_VIEW UI_SELECT,
LastName varchar(250) : not null UI_VIEW UI_SELECT SEARCH_KEY,
EmployeeStatus composite: references many
EmployeeStatus(Employee_Code),
Gender bit : not null,
Title varchar(150) : not null,
Prefered_Name varchar(150) : not null,
Date_of_Birth datetime : not null,
Previous_Employee_Code int : not null,
HireDate datetime : not null
);
CREATE TABLE EmployeeStatus: UI_GROUP(Employee) (
EmployeeStatus_Code int : primary_key UI_VIEW UI_SELECT,
Employee_Code int : not null references Employee(Employee_Code) UI_VIEW
UI_SELECT,
Designation_Code int : not null references Designation(Designation_Code)
UI_VIEW UI_SELECT,
Date_appointed_to_Position datetime : not null,
Division_Code int : not null references Division(Division_Code) UI_VIEW
UI_SELECT,
Is_head_of_Division bit : not null,
Comments varchar(200) : not null,
isCurrent bit : not null
);
CREATE TABLE Division: UI_GROUP(Employee) (
Division_Code int : primary_key UI_VIEW UI_SELECT,
Division_Name varchar(150) : not null UI_VIEW UI_SELECT SEARCH_KEY
UI_DIALOG_SELECT_XFER,
Division_Head int : not null,
Part_of_Division int : not null,
Lft int : not null invisible,
Rgt int : not null invisible,
Deleted bit: null invisible
);
CREATE TABLE Designation : UI_GROUP (Employee) (
Designation_Code int : primary_key UI_VIEW UI_SELECT,
Designation_Title varchar(150): not null UI_VIEW UI_SELECT SEARCH_KEY
UI_DIALOG_SELECT_XFER,
DesignationGroup_Code int: not null references
DesignationGroup(DesignationGroup_Code)
);
CREATE TABLE DesignationGroup : UI_GROUP (Employee) (
DesignationGroup_Code int : primary_key UI_VIEW UI_SELECT
session_key_source,
DesignationGroup_Title varchar(150): not null UI_VIEW UI_SELECT
UI_DIALOG_SELECT_XFER SEARCH_KEY
);
CREATE TABLE TimeCost : UI_GROUP (Timesheet_Admin) (
TimeCost_Code int: primary_key UI_VIEW UI_SELECT,
DesignationGroup_Code int: references
DesignationGroup(DesignationGroup_Code),
Hourly_Rate double: not null
);
CREATE TABLE Activity : UI_GROUP (Timesheet_Admin) (
Activity_Code int: primary_key UI_VIEW UI_SELECT,
Activity_Name varchar(150): not null UI_VIEW UI_SELECT SEARCH_KEY
UI_DIALOG_SELECT_XFER,
Activity_Description varchar(2000): not null
);
CREATE TABLE DesignationActivity : UI_GROUP (Timesheet_Admin) (
DesignationActivity_Code int: primary_key UI_VIEW UI_SELECT,
Activity_Code int: references Activity(Activity_Code) UI_VIEW UI_SELECT ,
DesignationGroup_Code int: references
DesignationGroup(DesignationGroup_Code)
);
create Table Currency : UI_GROUP (Exchange_Rates) (
Currency_Code int: primary_key UI_VIEW UI_SELECT,
Currency_Short_Name varchar(5): not null UI_VIEW UI_SELECT SEARCH_KEY
UI_DIALOG_SELECT_XFER,
Currency_Name varchar(200): null);
create Table Exchange_Master: UI_GROUP (Exchange_Rates) (
Exchange_Master_Code int: primary_key UI_VIEW UI_SELECT,
Currency_Code int: references Currency(Currency_Code) UI_VIEW UI_SELECT ,
Exchange_Details composite: references many
Exchange_Details(Exchange_Details_Code),
Exchange_Master_Date datetime: not null UI_VIEW UI_SELECT,
Exchange_Master_Comments varchar(250): not null
);
create table Exchange_Details: UI_GROUP (Exchange_Rates) (
Exchange_Details_Code int: primary_key UI_VIEW UI_SELECT,
Exchange_Master_Code int: references Exchange_Master(Exchange_Master_Code),
Exchange_Rate double: not null UI_VIEW UI_SELECT,
Exchange_Details_Date datetime: not null UI_VIEW UI_SELECT,
Comments varchar(250): not null);
create Table Project_Type : UI_GROUP (Project_Admin) (
Project_Type_Code int: primary_key UI_VIEW UI_SELECT,
Project_Type_Short_Description varchar(100): not null UI_VIEW UI_SELECT
SEARCH_KEY UI_DIALOG_SELECT_XFER,
Project_Type_Description varchar(1000): not null);
create Table Project_Status: UI_GROUP (Project_Admin) (
Project_Status_Code int: primary_key UI_VIEW UI_SELECT,
Project_Status_Description varchar(250): not null UI_VIEW UI_SELECT
UI_DIALOG_SELECT_XFER
);
create Table Timesheet: UI_GROUP (Project_Admin) (
Timesheet_Code int: primary_key,
Employee_Code int: session references Employee(Employee_Code),
Project_Code int: references Project(Project_Code) embedded,
Entry_Date datetime: embedded SEARCH_KEY,
TimeSpent double: not null
);
create table Timesheet_Tables: UI_GROUP(Admin) is_master_tables_list (
Timesheet_Tables_Code int: primary_key UI_VIEW UI_SELECT,
Table_Name varchar(250): UNIQUE UI_VIEW UI_SELECT UI_DIALOG_SELECT_XFER);
create table Role: UI_GROUP(Admin) IS_ROLE_TABLE (
Role_Code int: primary_key UI_VIEW UI_SELECT,
Role_Name varchar(250): UNIQUE UI_VIEW UI_SELECT UI_DIALOG_SELECT_XFER);
create table Table_Security: UI_GROUP(Admin) (
Table_Security_Code int: primary_key UI_VIEW UI_SELECT,
Timesheet_Tables_Code int: UI_VIEW UI_SELECT references
Timesheet_Tables(Timesheet_Tables_Code),
Role_Code int: UI_VIEW UI_SELECT references Role(Role_Code)
);
create table User_Login: UI_GROUP(Admin) IS_LOGIN_PAGE (
User_Login_Code int: primary_key UI_VIEW UI_SELECT,
User_Login_Name varchar(20): unique IS_LOGIN_USERNAME_FIELD UI_VIEW
UI_SELECT UI_DIALOG_SELECT_XFER,
User_Password varchar(250): password IS_LOGIN_PASSWORD_FIELD,
Employee_Code int: references Employee(Employee_Code)
);
create table User_Role : UI_GROUP(Admin) IS_USER_ROLES_TABLE (
User_Role_Code int: primary_key UI_VIEW UI_SELECT ,
User_Login_Code int : references User_Login(User_Login_Code) session,
Role_Code int: references Role(Role_Code)
);
>________________________________
>From: PARVINDER RAJPUT <m...@parvinder.co.in>
>To: witty-interest@lists.sourceforge.net
>Sent: Wednesday, November 2, 2011 10:14 AM
>Subject: Re: [Wt-interest] Search name from datatbase
>
>void WtApplication::find()
>{
> root()->addWidget(new WText("Search")); // show some text
> nameEdit_ = new WLineEdit(root());
> root()->addWidget(new WBreak());
>
> WPushButton *b = new WPushButton("Find", root()); // create a button
> b->setMargin(10, Left); // add 5 pixels
>margin
> // insert a line break
> greeting_ = new WText( root()); // empty text
> b->clicked().connect(this, &WtApplication::find);
>
>}
>
>
>
>void WtApplication::search() {
>
>
>try {
>
> greeting_->setText( nameEdit_->text()); //its
>value pass to query
>
> Transaction tt(session_);
>
>//colform collect = session_.find<form>("where dat like 'parvinder%'");
>
>//its working fine
>
>colform collect = session_.find<form>("where dat like
>'%?%'").bind(nameEdit_->text());
>//But this query is not fetch the value from database.
> for (colform::const_iterator i =
>collect.begin(); i != collect.end(); ++i)
>
>
>
>
>msg((*i)->store,(*i)->name,(*i)->contact,(*i)->intercom,(*i)->stream);
> tt.commit();
> } catch (...) {}
>
>}
>
>I think find function does not connect with search function. So that
>it does not find the value.
>
>but when we use simple query
>colform collect = session_.find<form>("where dat like 'parvinder%'");
>its working fine
>
>--
>Parvinder Rajput
>website:- www.parvinder.co.in
>
>------------------------------------------------------------------------------
>RSA® Conference 2012
>Save $700 by Nov 18
>Register now!
>http://p.sf.net/sfu/rsa-sfdev2dev1
>_______________________________________________
>witty-interest mailing list
>witty-interest@lists.sourceforge.net
>https://lists.sourceforge.net/lists/listinfo/witty-interest
>
>
>------------------------------------------------------------------------------
RSA® Conference 2012
Save $700 by Nov 18
Register now!
http://p.sf.net/sfu/rsa-sfdev2dev1
_______________________________________________
witty-interest mailing list
witty-interest@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/witty-interest
