Start » 2. Generating CRUD application

WAK CRUD generation tool Introduction

WAK gen tool is a very useful and productive tool for creating folder ( file .dic) by framework WAK when you already have DB.

Download

Download CRUD Genaration Tool package Here.

Database Preparation

In this step, you'd have to input SQL queries to create your Project Database in WAK.
In "Tiện ích CSDL" tab, choose "Thực hiện nhiều câu lệnh SQL" button, then input your SQL queries or use example queries below in box and submit. Next go to "Danh sách bảng dữ liệu" to check your Database.

Example SQL Queries

Hide

create sequence SEQ_CATEGORY;

create sequence SEQ_COMPOSER;

create sequence SEQ_SINGER;

create sequence SEQ_SONG;

/*==============================================================*/
/* Table: CATEGORY                                              */
/*==============================================================*/
create table CATEGORY (
   CATEGORY_ID          NUMBER(10)            not null,
   CODE                 VARCHAR2(50 CHAR)     not null,
   NAME                 VARCHAR2(1024 CHAR),
   DESCRIPTION          VARCHAR2(1024 CHAR),
   CREATED              TIMESTAMP            default SYSDATE  not null,
   CREATOR              VARCHAR2(50 CHAR)     not null,
   MODIFIED             TIMESTAMP,
   MODIFIER             VARCHAR2(50 CHAR),
   constraint PK_CATEGORY primary key (CATEGORY_ID)
);

comment on table CATEGORY is
'Thể loại ';

comment on column CATEGORY.CATEGORY_ID is
'ID';

comment on column CATEGORY.CODE is
'Mã';

comment on column CATEGORY.NAME is
'Tên ';

comment on column CATEGORY.DESCRIPTION is
'Mô tả';

comment on column CATEGORY.CREATED is
'Giờ tạo ';

comment on column CATEGORY.CREATOR is
'Người tạo ';

comment on column CATEGORY.MODIFIED is
'Giờ cập nhật';

comment on column CATEGORY.MODIFIER is
'Người cập nhật';

/*==============================================================*/
/* Table: COMPOSER                                              */
/*==============================================================*/
create table COMPOSER (
   COMPOSER_ID          NUMBER(10)            not null,
   NAME                 VARCHAR2(1024 CHAR),
   DESCRIPTION          VARCHAR2(1024 CHAR),
   CREATED              TIMESTAMP            default SYSDATE  not null,
   CREATOR              VARCHAR2(50 CHAR)     not null,
   MODIFIED             TIMESTAMP,
   MODIFIER             VARCHAR2(50 CHAR),
   constraint PK_COMPOSER primary key (COMPOSER_ID)
);

comment on table COMPOSER is
'Nhạc sĩ';

comment on column COMPOSER.COMPOSER_ID is
'ID';

comment on column COMPOSER.NAME is
'Tên ';

comment on column COMPOSER.DESCRIPTION is
'Tiểu sử';

comment on column COMPOSER.CREATED is
'Giờ tạo ';

comment on column COMPOSER.CREATOR is
'Người tạo ';

comment on column COMPOSER.MODIFIED is
'Giờ cập nhật';

comment on column COMPOSER.MODIFIER is
'Người cập nhật ';

/*==============================================================*/
/* Table: SINGER                                                */
/*==============================================================*/
create table SINGER (
   SINGER_ID            NUMBER(10)            not null,
   NAME                 VARCHAR2(1024 CHAR),
   DESCRIPTION          VARCHAR2(1024 CHAR),
   CREATED              TIMESTAMP            default SYSDATE  not null,
   CREATOR              VARCHAR2(50 CHAR)     not null,
   MODIFIED             TIMESTAMP,
   MODIFIER             VARCHAR2(50 CHAR),
   constraint PK_SINGER primary key (SINGER_ID)
);

comment on table SINGER is
'Ca sĩ ';

comment on column SINGER.SINGER_ID is
'ID';

comment on column SINGER.NAME is
'Tên ca sỹ ';

comment on column SINGER.DESCRIPTION is
'Tiểu sử';

comment on column SINGER.CREATED is
'Giờ tạo';

comment on column SINGER.CREATOR is
'Người tạo ';

comment on column SINGER.MODIFIED is
'Giờ cập nhật';

comment on column SINGER.MODIFIER is
'Người cập nhật ';

/*==============================================================*/
/* Table: SONG                                                  */
/*==============================================================*/
create table SONG (
   NAME                 VARCHAR2(128 CHAR),
   SONG_ID              NUMBER(10)            not null,
   SINGER_ID            NUMBER(10),
   COMPOSER_ID          NUMBER(10),
   CATEGORY_ID          NUMBER(10),
   LYRIC                CLOB,
   constraint PK_SONG primary key (SONG_ID)
);

comment on table SONG is
'Bài hát ';

comment on column SONG.NAME is
'Tên bài hát ';

comment on column SONG.SONG_ID is
'ID';

comment on column SONG.SINGER_ID is
'Ca sĩ';

comment on column SONG.COMPOSER_ID is
'Nhạc sĩ';

comment on column SONG.CATEGORY_ID is
'Thể loại';

comment on column SONG.LYRIC is
'Lời bài hát';

alter table SONG
   add constraint FK_S_CP foreign key (COMPOSER_ID)
      references COMPOSER (COMPOSER_ID);

alter table SONG
   add constraint FK_S_CT foreign key (CATEGORY_ID)
      references CATEGORY (CATEGORY_ID);

alter table SONG
   add constraint FK_S_SG foreign key (SINGER_ID)
      references SINGER (SINGER_ID);

Click in "Kết suất cấu trúc bảng" button in "Tiện ích CSDL" tab. In this step, choose your tables and submit to combine there tables in to file export.schema.

Intallation

Extract package, we have a folder like this

Copy file export.schema into this folder then run gen_adm_wak.bat to generate your menus.
Next, copy folder [com] in [wak-out] into your folder Project/app/web.

Now, your CRUD are created.