com.gdxsoft.easyweb:emp-script

Release 1.1.8

Web系统快速成型系统

Homepage Maven Java Download

License
MIT

Documentation

Easy Web Application

For the development of a Web application system, such as CRM, OA, SCM, etc., during the system development process, a lot of time is applied to the page composition. Although there are some MVC middleware applications, it still feels low-tech coding And testing accounts for 60%-80% of the entire development process. These include such as HTML code synthesis, page unit testing, data verification and page display effects, browser compatibility, and endless user needs changes Wait. At the same time, this part of the work is the devil of development engineers, but also the devil of project management.

In a typical application system, the business logic is only about 10%-20% of the overall part of the project, and most of the work is relatively simple data entry, modification, deletion and query (including multiple tables and summaries). The design of complex business logic must be done in a hard-coded manner to ensure the integrity of the business logic. But if the corresponding simple parts are still hard-coded (even with a code generator) and synthesized into HTML, such low-tech work will greatly extend the development time.

The goal of the development system is to reduce the development cycle by 80%, deploy a large amount of low-tech work through XML configuration files, free up engineers’ time, and focus on database architecture design and core business logic. At the same time reduce development time and development costs.

针对一个Web应用系统开发，如CRM，OA，SCM等，在系统开发过程中，大量的时间被应用于页面合成上面，虽然有一些MVC的中间件的应用，但是还是感觉到低技术水准的编码和测试占了整个开发过程中的60%-80%的时间，这些包括如HTML代码的合成，页面单元的测试，数据验证和页面显示效果，浏览器的兼容性，用户没完没了的需求变更等。同时该部分工作又是开发工程师的恶魔，同时也是项目管理中的恶魔。

在典型的应用系统中，业务逻辑复杂的部分只占项目整体部分的10%-20%左右，大部分的工作是较为简单的数据录入、修改、删除和查询（包括多表和汇总）。对于复杂的业务逻辑部分的设计必须采用硬编码的方式进行，从而保证业务逻辑的完整性。但对应简单的部分如果还是采用硬编码（即使使用代码生成器）并合成为HTML，这样低技术水准的工作会大大延长开发的时间。

该开发系统的目标是降低80%部分的开发周期，将大量的低技术含量的工作通过XML配置文件进行部署，解放工程师的时间，使其将主要精力放到数据库架构设计和核心业务逻辑上，同时减少开发时间和开发成本。

转换文件配置到数据库配置

// ewa 是在ewa_conf.xml的 <scriptPath name="ewa" path="jdbc:ewa" />
FileConf2JdbcConf f2j = new FileConf2JdbcConf("ewa");
String root = "/Users/guolei/project/user.config.xml";
f2j.startConvert(root);

英式日期格式定义

<!-- 全局变量定义 -->
<globals>
		<!-- 覆盖EwaGlobal.xml的定义 -->
		<!-- 日期格式 -->
		<global lang="enus" date="dd/MM/yyyy"></global>
</globals>

<addedResources>
		<addedResource name="ukdateformat" resourceType="js" defaultConf="true" last="false">
<![CDATA[
_EWA_G_SETTINGS.DATE_old = _EWA_G_SETTINGS.DATE;	
_EWA_G_SETTINGS.DATE = 'dd/MM/yyyy'; //英国
]]>
		</addedResource>
</addedResources>

Create a EWA tables （MYSQL）

CREATE TABLE ewa_cfg (
  XMLNAME varchar(200) NOT NULL,
  ITEMNAME varchar(100) NOT NULL,
  XMLDATA longtext NOT NULL,
  HASH_CODE int NOT NULL,
  ADM_LID varchar(50) DEFAULT NULL,
  CREATE_DATE datetime DEFAULT NULL,
  UPDATE_DATE datetime DEFAULT NULL,
  MD5 varchar(32) DEFAULT NULL,
  DATASOURCE varchar(123) DEFAULT NULL,
  CLASS_ACL varchar(333) DEFAULT NULL,
  CLASS_LOG varchar(333) DEFAULT NULL,
  DESCRIPTION varchar(500) DEFAULT NULL,
  PRIMARY KEY (XMLNAME,ITEMNAME)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE ewa_cfg_his (
  HIS_ID int NOT NULL AUTO_INCREMENT,
  HIS_DATE datetime NOT NULL,
  XMLNAME varchar(200) NOT NULL,
  ITEMNAME varchar(100) NOT NULL,
  XMLDATA longtext NOT NULL,
  HASH_CODE int NOT NULL,
  ADM_LID varchar(50) DEFAULT NULL,
  CREATE_DATE datetime DEFAULT NULL,
  UPDATE_DATE datetime DEFAULT NULL,
  MD5 varchar(32) DEFAULT NULL,
  DATASOURCE varchar(123) DEFAULT NULL,
  CLASS_ACL varchar(333) DEFAULT NULL,
  CLASS_LOG varchar(333) DEFAULT NULL,
  DESCRIPTION varchar(500) DEFAULT NULL,
  PRIMARY KEY (HIS_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE ewa_cfg_oth (
  OTH_TAG varchar(50) NOT NULL,
  OTH_TXT longtext,
  OTH_CDATE datetime DEFAULT NULL,
  OTH_MDATE datetime DEFAULT NULL,
  ADM_LID varchar(50) DEFAULT NULL,
  PRIMARY KEY (OTH_TAG)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE ewa_cfg_rm (
  RM_ID int NOT NULL AUTO_INCREMENT,
  RM_DATE datetime NOT NULL,
  XMLNAME varchar(200) NOT NULL,
  ITEMNAME varchar(100) NOT NULL,
  XMLDATA longtext NOT NULL,
  HASH_CODE int NOT NULL,
  ADM_LID varchar(50) DEFAULT NULL,
  CREATE_DATE datetime DEFAULT NULL,
  UPDATE_DATE datetime DEFAULT NULL,
  MD5 varchar(32) DEFAULT NULL,
  DATASOURCE varchar(123) DEFAULT NULL,
  CLASS_ACL varchar(333) DEFAULT NULL,
  CLASS_LOG varchar(333) DEFAULT NULL,
  DESCRIPTION varchar(500) DEFAULT NULL,
  PRIMARY KEY (RM_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;


CREATE TABLE ewa_cfg_tree (
  XMLNAME varchar(200) NOT NULL COMMENT '配置文件',
  EDIT_STATUS varchar(10) DEFAULT NULL COMMENT '编辑状态',
  PRIMARY KEY (XMLNAME)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

RESTful tables （MYSQL）

CREATE TABLE ewa_restful (
  rs_uid varchar(36) CHARACTER SET latin1 NOT NULL COMMENT '请求编号',
  cat_uid varchar(36) CHARACTER SET latin1 NOT NULL COMMENT '目录编号',
  rs_method varchar(10) NOT NULL COMMENT '请求方式',
  rs_name varchar(200) NOT NULL COMMENT '名称',
  rs_name_en varchar(200) NOT NULL COMMENT '名称英文',
  rs_xmlname varchar(200) NOT NULL COMMENT '配置文件',
  rs_itemname varchar(100) NOT NULL COMMENT '配置项',
  rs_parameters varchar(1000) NOT NULL COMMENT '参数',
  rs_memo longtext COMMENT '说明',
  rs_memo_en longtext COMMENT '英文说明',
  rs_status varchar(20) DEFAULT NULL COMMENT '状态',
  rs_ctime datetime DEFAULT NULL COMMENT '创建时间',
  rs_mtime datetime DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (rs_uid),
  UNIQUE KEY ewa_restful_un (cat_uid,rs_method)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE ewa_restful_catalog (
  cat_uid varchar(36) CHARACTER SET latin1 NOT NULL COMMENT '目录编号',
  cat_puid varchar(36) CHARACTER SET latin1 NOT NULL COMMENT '上级目录',
  cat_path varchar(200) CHARACTER SET latin1 NOT NULL COMMENT '接口地址',
  cat_path_full varchar(1000) CHARACTER SET latin1 DEFAULT NULL COMMENT '完整接口地址',
  cat_name varchar(50) NOT NULL COMMENT '名称',
  cat_name_en varchar(100) DEFAULT NULL COMMENT '英文名称',
  cat_memo longtext COMMENT '说明',
  cat_memo_en longtext COMMENT '英文说明',
  cat_lvl int NOT NULL COMMENT '级别',
  cat_ord int NOT NULL COMMENT '排序',
  cat_status varchar(20) DEFAULT NULL COMMENT '状态',
  cat_ctime datetime DEFAULT NULL COMMENT '创建时间',
  cat_mtime datetime DEFAULT NULL COMMENT '修改时间',
  p0 varchar(150) CHARACTER SET latin1 DEFAULT NULL,
  p1 varchar(150) CHARACTER SET latin1 DEFAULT NULL,
  p2 varchar(150) CHARACTER SET latin1 DEFAULT NULL,
  p3 varchar(150) CHARACTER SET latin1 DEFAULT NULL,
  p4 varchar(150) CHARACTER SET latin1 DEFAULT NULL,
  p5 varchar(150) CHARACTER SET latin1 DEFAULT NULL,
  p6 varchar(150) CHARACTER SET latin1 DEFAULT NULL,
  p7 varchar(150) CHARACTER SET latin1 DEFAULT NULL,
  p8 varchar(150) CHARACTER SET latin1 DEFAULT NULL,
  p9 varchar(150) CHARACTER SET latin1 DEFAULT NULL,
  PRIMARY KEY (cat_uid),
  KEY idx_ewa_restful_catalog_cat_puid (cat_puid),
  KEY ewa_restful_catalog_p0_IDX (p0,p1,p2,p3,p4,p5,p6,p7,p8,p9) USING BTREE,
  KEY idx_ewa_restful_catalog (cat_status,p0,p1,p2,p3,p4,p5,p6,p7,p8,p9)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

RESTful tables （HSQLDB）

CREATE TABLE EWA_RESTFUL (
 RS_UID VARCHAR(36) NOT NULL,
 CAT_UID VARCHAR(36) NOT NULL,
 RS_METHOD VARCHAR(10) NOT NULL,
 RS_NAME VARCHAR(200) NOT NULL,
 RS_NAME_EN VARCHAR(200) NOT NULL,
 RS_XMLNAME VARCHAR(200) NOT NULL,
 RS_ITEMNAME VARCHAR(100) NOT NULL,
 RS_PARAMETERS VARCHAR(1000) NOT NULL,
 RS_MEMO VARCHAR(16777216),
 RS_MEMO_EN VARCHAR(16777216),
 RS_STATUS VARCHAR(20) DEFAULT NULL,
 RS_CTIME TIMESTAMP DEFAULT NULL,
 RS_MTIME TIMESTAMP DEFAULT NULL,
 CONSTRAINT PK_EWA_RESTFUL PRIMARY KEY (RS_UID)
);
CREATE UNIQUE INDEX UN_EWA_RESTFUL ON EWA_RESTFUL (CAT_UID,RS_METHOD);

CREATE TABLE EWA_RESTFUL_CATALOG (
 CAT_UID VARCHAR(36) NOT NULL,
 CAT_PUID VARCHAR(36) NOT NULL,
 CAT_PATH VARCHAR(200) NOT NULL,
 CAT_PATH_FULL VARCHAR(1000) DEFAULT NULL,
 CAT_NAME VARCHAR(50) NOT NULL,
 CAT_NAME_EN VARCHAR(100) DEFAULT NULL,
 CAT_MEMO VARCHAR(16777216),
 CAT_MEMO_EN VARCHAR(16777216),
 CAT_LVL INTEGER NOT NULL,
 CAT_ORD INTEGER NOT NULL,
 CAT_STATUS VARCHAR(20) DEFAULT NULL,
 CAT_CTIME TIMESTAMP DEFAULT NULL,
 CAT_MTIME TIMESTAMP DEFAULT NULL,
 P0 VARCHAR(150) DEFAULT NULL,
 P1 VARCHAR(150) DEFAULT NULL,
 P2 VARCHAR(150) DEFAULT NULL,
 P3 VARCHAR(150) DEFAULT NULL,
 P4 VARCHAR(150) DEFAULT NULL,
 P5 VARCHAR(150) DEFAULT NULL,
 P6 VARCHAR(150) DEFAULT NULL,
 P7 VARCHAR(150) DEFAULT NULL,
 P8 VARCHAR(150) DEFAULT NULL,
 P9 VARCHAR(150) DEFAULT NULL,
 CONSTRAINT PK_EWA_RESTFUL_CATALOG PRIMARY KEY (CAT_UID)
);
CREATE INDEX IDX_EWA_RESTFUL_CATALOG ON EWA_RESTFUL_CATALOG (CAT_STATUS,P0,P1,P2,P3,P4,P5,P6,P7,P8,P9);
CREATE INDEX IDX_EWA_RESTFUL_CATALOG_CAT_PUID ON EWA_RESTFUL_CATALOG (CAT_PUID);
CREATE INDEX IDX_EWA_RESTFUL_CATALOG_P0 ON EWA_RESTFUL_CATALOG (P0,P1,P2,P3,P4,P5,P6,P7,P8,P9);

Module 导入/导出 tables （MYSQL）

create table ewa_mod (
  mod_code varchar(100) not null comment '模块编码',
  mod_name varchar(100) not null comment '模块名称',
  mod_name_en varchar(100) not null comment '模块名称-英文',
  mod_open_source char(1) not null comment '是否开源-y/n',
  mod_company varchar(100) default null comment '公司',
  mod_contact varchar(100) default null comment '联系人',
  mod_web varchar(200) default null comment '网址',
  mod_email varchar(100) default null comment '地址邮件',
  mod_osp varchar(100) default null comment '开源协议',
  mod_memo longtext comment '模块说明',
  mod_memo_en longtext comment '模块说明英文',
  mod_cdate datetime not null comment '创建时间',
  mod_mdate datetime not null comment '修改时间',
  mod_status varchar(10) not null comment '模块状态- new,dlv,undlv,del',
  mod_adm_id int not null comment '用户',
  mod_sup_id int not null comment '商户',
  mod_meta_db_name varchar(64) default null comment '元数据库名称',
  mod_work_db_name varchar(64) default null comment '工作数据库名称',
  mod_ewa_conn varchar(67) not null default '' comment 'ewa数据库连接池',
  primary key (mod_code)
) engine=innodb default charset=utf8mb4 comment='模块列表';

create table ewa_mod_cfgs (
  mod_ver_id bigint not null comment '版本编号',
  xmlname varchar(200) not null comment '配置文件',
  itemname varchar(100) not null comment '配置项',
  description varchar(500) not null comment '描述',
  emc_cdate datetime not null comment '创建数据',
  emc_mdate datetime not null comment '修改时间',
  emc_adm_id int not null comment '用户',
  emc_sup_id int not null comment '商户',
  emc_def_xmlname varchar(200) not null comment '默认文件',
  emc_def_itemname varchar(100) not null comment '默认配置项名称',
  primary key (mod_ver_id,xmlname,itemname)
) engine=innodb default charset=utf8mb4 comment='模块版本对应的配置项';

create table ewa_mod_data (
  mod_ver_id bigint not null comment '版本编号',
  table_catalog varchar(64) not null comment '数据库目录',
  table_schema varchar(64) not null comment '数据库',
  table_name varchar(64) not null comment '表名称',
  data_index int not null comment '记录行',
  data_row longtext not null comment '行记录'
) engine=innodb default charset=utf8mb4 comment='表的数据';

create table ewa_mod_ddl (
  emd_id bigint not null auto_increment comment '编号',
  mod_ver_id bigint not null comment '版本编号',
  emd_ewa_conn varchar(40) not null comment '数据库链接名称',
  table_name varchar(64) not null comment '表名称',
  table_catalog varchar(64) not null comment '数据库目录',
  table_schema varchar(64) not null comment '数据库',
  emd_database_type varchar(20) not null comment '表类型',
  emd_type varchar(20) not null comment '表类型',
  emd_ddl_sql longtext comment '创建用的 sql',
  emd_export varchar(10) not null comment '是否导出数据',
  emd_export_where varchar(2500) not null comment '导出数据条件',
  emd_cdate datetime not null comment '创建时间',
  emd_mdate datetime not null comment '修改时间',
  emd_adm_id int not null comment '用户',
  emd_sup_id int not null comment '商户',
  emd_xml longtext comment '导出的xml格式',
  primary key (emd_id),
  unique key ewa_mod_ddl_emd_ewa_conn_idx (emd_ewa_conn,table_name) using btree
) engine=innodb default charset=utf8mb4 comment='数据库的 ddl';

create table ewa_mod_field (
  emd_id bigint not null comment '编号',
  column_name varchar(64) not null default '',
  mod_ver_id bigint not null comment '版本编号',
  table_catalog varchar(64) not null comment '数据库目录',
  table_schema varchar(64) not null comment '数据库',
  table_name varchar(64) not null default '',
  ordinal_position bigint unsigned not null default '0',
  column_default longtext,
  is_nullable varchar(3) not null default '',
  data_type varchar(64) not null default '',
  character_maximum_length bigint unsigned default null,
  character_octet_length bigint unsigned default null,
  numeric_precision bigint unsigned default null,
  numeric_scale bigint unsigned default null,
  datetime_precision bigint unsigned default null,
  character_set_name varchar(32) default null,
  collation_name varchar(32) default null,
  column_type longtext not null,
  column_key varchar(3) not null default '',
  extra varchar(30) not null default '',
  privileges varchar(80) not null default '',
  column_comment varchar(1024) not null default '',
  generation_expression longtext not null,
  primary key (emd_id,column_name)
) engine=innodb default charset=utf8mb4;

create table ewa_mod_index (
  emd_id bigint not null comment '编号',
  index_name varchar(64) not null comment '索引名称',
  mod_ver_id bigint not null comment '版本编号',
  table_catalog varchar(64) not null comment '数据库目录',
  table_schema varchar(64) not null comment '数据库',
  table_name varchar(64) not null comment '表名称',
  index_type varchar(20) not null comment '索引类型, primary, unique, index',
  index_ddl longtext comment '创建用的sql',
  primary key (emd_id,index_name)
) engine=innodb default charset=utf8mb4 comment='表索引';

create table ewa_mod_index_field (
  mod_ver_id bigint not null comment '版本编号',
  table_catalog varchar(64) not null comment '数据库目录',
  table_schema varchar(64) not null comment '数据库',
  table_name varchar(64) not null comment '表名称',
  index_name varchar(64) not null comment '索引名称',
  column_name varchar(64) not null comment '字段名称',
  index_asc char(1) not null comment '升序=y，降序=n',
  primary key (mod_ver_id,table_catalog,table_schema,table_name,index_name,column_name)
) engine=innodb default charset=utf8mb4 comment='表索引的字段';

create table ewa_mod_package (
  mod_ver_id bigint(20) not null comment '版本号',
  pkg_dlv_date datetime not null comment '发布时间',
  pkg_len int(11) not null comment '包长度',
  pkg_md5 varchar(32) not null comment '包md5',
  pkg_sup_id int(11) not null comment '商户',
  pkg_adm_id int(11) not null comment '员工',
  pkg_file longblob comment '包数据',
  pkg_publish_time datetime default null comment '发布时间',
  pkg_publish_url varchar(400) default null comment '发布网址',
  pkg_publish_result text comment '发布结果',
  pkg_publish_status varchar(10) default null comment '发布状态',
  primary key (mod_ver_id)
) engine=innodb default charset=utf8mb4 comment='模块包数据-zip';

create table ewa_mod_ver (
  mod_ver_id bigint not null comment '版本编号',
  mod_code varchar(100) not null comment '模块编码',
  mod_ver varchar(30) not null comment '模块版本',
  mod_ver_cdate datetime not null comment '创建时间',
  mod_ver_mdate datetime not null comment '修改时间',
  mod_ver_memo longtext comment '模块版本说明',
  mod_ver_memo_en longtext comment '模块版本说明英文',
  mod_ver_status varchar(10) not null comment '模块状态- used,del',
  mod_ver_adm_id int not null comment '用户',
  mod_ver_sup_id int not null comment '商户',
  primary key (mod_ver_id),
  unique key ewa_mod_ver_mod_code_idx (mod_code,mod_ver) using btree
) engine=innodb default charset=utf8mb4 comment='模块版本';

create table ewa_mod_download (
  mod_dl_id int not null auto_increment comment '下载序号',
  mod_code varchar(100) not null comment '模块编码',
  mod_ver varchar(30) not null comment '模块版本',
  mod_name varchar(100) not null comment '模块名称',
  mod_name_en varchar(100) default null comment '模块名称-英文',
  mod_open_source char(1) default null comment '是否开源-y/n',
  mod_company varchar(100) default null comment '公司',
  mod_contact varchar(100) default null comment '联系人',
  mod_web varchar(200) default null comment '网址',
  mod_email varchar(100) default null comment '地址邮件',
  mod_osp varchar(100) default null comment '开源协议',
  mod_memo longtext comment '模块说明',
  mod_memo_en longtext comment '模块说明英文',
  mod_cdate datetime default null comment '创建时间',
  mod_mdate datetime default null comment '修改时间',
  mod_sup_id int default null comment '商户',
  mod_ver_id bigint default null comment '版本编号',
  mod_ver_cdate datetime default null comment '创建时间',
  mod_ver_mdate datetime default null comment '修改时间',
  mod_ver_memo longtext comment '模块版本说明',
  mod_ver_memo_en longtext comment '模块版本说明英文',
  mod_ver_status varchar(10) default null comment '模块状态 ',
  pkg_len int not null comment '包大小',
  pkg_md5 varchar(32) not null comment '包md5',
  pkg_file longblob comment '包内容',
  mod_dl_cdate datetime not null comment '创建时间',
  mod_dl_mdate datetime not null comment '修改时间',
  mod_dl_status varchar(10) not null comment '模块状态- used,del',
  mod_dl_sup_id int not null comment '商户',
  mod_dl_url varchar(700) default null comment '下载网址',
  import_data_conn varchar(50) default null comment '导入数据的连接名称',
  replace_meta_databasename varchar(64) default null comment '替换元数据库名称',
  replace_work_databasename varchar(64) default null comment '替换工作据库名称',
  primary key (mod_dl_id)
) engine=innodb default charset=utf8mb4 comment '下载的模块包';


CREATE TABLE ewa_mod_import_log (
  log_id int NOT NULL AUTO_INCREMENT COMMENT '日志编号',
  mod_dl_id int DEFAULT NULL COMMENT '下载序号',
  mod_code varchar(100) DEFAULT NULL COMMENT '模块编码',
  mod_ver varchar(30) DEFAULT NULL COMMENT '模块版本',
  mod_name varchar(100) DEFAULT NULL COMMENT '模块名称',
  import_data_conn varchar(50) DEFAULT NULL COMMENT '导入数据的连接名称',
  replace_meta_databasename varchar(64) DEFAULT NULL COMMENT '替换元数据库名称',
  replace_work_databasename varchar(64) DEFAULT NULL COMMENT '替换工作据库名称',
  log_begin datetime DEFAULT NULL COMMENT '开始时间',
  log_end datetime DEFAULT NULL COMMENT '结束时间',
  log_content longtext COMMENT '日志内容',
  log_errors longtext COMMENT '日志错误',
  log_result longtext COMMENT '执行结果记录',
  log_ip varchar(40) DEFAULT NULL COMMENT 'ip地址',
  log_ua varchar(500) DEFAULT NULL COMMENT 'UA',
  log_ref varchar(1000) DEFAULT NULL COMMENT 'referer',
  log_status varchar(4) DEFAULT NULL COMMENT '状态',
  PRIMARY KEY (log_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='导入日志';

Create a EWA tables （HSQLDB）

CREATE TABLE EWA_MOD (
 MOD_CODE VARCHAR(100) NOT NULL,
 MOD_NAME VARCHAR(100) NOT NULL,
 MOD_NAME_EN VARCHAR(100) NOT NULL,
 MOD_OPEN_SOURCE CHARACTER(1) NOT NULL,
 MOD_COMPANY VARCHAR(100) DEFAULT NULL,
 MOD_CONTACT VARCHAR(100) DEFAULT NULL,
 MOD_WEB VARCHAR(200) DEFAULT NULL,
 MOD_EMAIL VARCHAR(100) DEFAULT NULL,
 MOD_OSP VARCHAR(100) DEFAULT NULL,
 MOD_MEMO VARCHAR(16777216),
 MOD_MEMO_EN VARCHAR(16777216),
 MOD_CDATE TIMESTAMP NOT NULL,
 MOD_MDATE TIMESTAMP NOT NULL,
 MOD_STATUS VARCHAR(10) NOT NULL,
 MOD_ADM_ID INTEGER NOT NULL,
 MOD_SUP_ID INTEGER NOT NULL,
 MOD_META_DB_NAME VARCHAR(64) DEFAULT NULL,
 MOD_WORK_DB_NAME VARCHAR(64) DEFAULT NULL,
 MOD_EWA_CONN VARCHAR(67) DEFAULT '' NOT NULL,
 CONSTRAINT PK_EWA_MOD PRIMARY KEY (MOD_CODE)
);

CREATE TABLE EWA_MOD_CFGS (
 MOD_VER_ID BIGINT NOT NULL,
 XMLNAME VARCHAR(200) NOT NULL,
 ITEMNAME VARCHAR(100) NOT NULL,
 DESCRIPTION VARCHAR(500) NOT NULL,
 EMC_CDATE TIMESTAMP NOT NULL,
 EMC_MDATE TIMESTAMP NOT NULL,
 EMC_ADM_ID INTEGER NOT NULL,
 EMC_SUP_ID INTEGER NOT NULL,
 EMC_DEF_XMLNAME VARCHAR(200) NOT NULL,
 EMC_DEF_ITEMNAME VARCHAR(100) NOT NULL,
 CONSTRAINT PK_EWA_MOD_CFGS PRIMARY KEY (MOD_VER_ID,XMLNAME,ITEMNAME)
);

CREATE TABLE EWA_MOD_DATA (
 MOD_VER_ID BIGINT NOT NULL,
 TABLE_CATALOG VARCHAR(64) NOT NULL,
 TABLE_SCHEMA VARCHAR(64) NOT NULL,
 TABLE_NAME VARCHAR(64) NOT NULL,
 DATA_INDEX INTEGER NOT NULL,
 DATA_ROW VARCHAR(16777216) NOT NULL
);

CREATE TABLE EWA_MOD_DDL (
 EMD_ID BIGINT NOT NULL IDENTITY,
 MOD_VER_ID BIGINT NOT NULL,
 EMD_EWA_CONN VARCHAR(40) NOT NULL,
 TABLE_NAME VARCHAR(64) NOT NULL,
 TABLE_CATALOG VARCHAR(64) NOT NULL,
 TABLE_SCHEMA VARCHAR(64) NOT NULL,
 EMD_DATABASE_TYPE VARCHAR(20) NOT NULL,
 EMD_TYPE VARCHAR(20) NOT NULL,
 EMD_DDL_SQL VARCHAR(16777216),
 EMD_EXPORT VARCHAR(10) NOT NULL,
 EMD_EXPORT_WHERE VARCHAR(2500) NOT NULL,
 EMD_CDATE TIMESTAMP NOT NULL,
 EMD_MDATE TIMESTAMP NOT NULL,
 EMD_ADM_ID INTEGER NOT NULL,
 EMD_SUP_ID INTEGER NOT NULL,
 EMD_XML VARCHAR(16777216),
 CONSTRAINT SYS_PK_10145 PRIMARY KEY (EMD_ID)
);
CREATE UNIQUE INDEX EWA_MOD_DDL_EMD_EWA_CONN_IDX ON EWA_MOD_DDL (EMD_EWA_CONN,TABLE_NAME);
CREATE UNIQUE INDEX SYS_IDX_SYS_PK_10145_10146 ON EWA_MOD_DDL (EMD_ID);


CREATE TABLE EWA_MOD_DOWNLOAD (
 MOD_DL_ID INTEGER NOT NULL IDENTITY,
 MOD_CODE VARCHAR(100) NOT NULL,
 MOD_VER VARCHAR(30) NOT NULL,
 MOD_NAME VARCHAR(100) NOT NULL,
 MOD_NAME_EN VARCHAR(100) DEFAULT NULL,
 MOD_OPEN_SOURCE CHARACTER(1) DEFAULT NULL,
 MOD_COMPANY VARCHAR(100) DEFAULT NULL,
 MOD_CONTACT VARCHAR(100) DEFAULT NULL,
 MOD_WEB VARCHAR(200) DEFAULT NULL,
 MOD_EMAIL VARCHAR(100) DEFAULT NULL,
 MOD_OSP VARCHAR(100) DEFAULT NULL,
 MOD_MEMO VARCHAR(16777216),
 MOD_MEMO_EN VARCHAR(16777216),
 MOD_CDATE TIMESTAMP DEFAULT NULL,
 MOD_MDATE TIMESTAMP DEFAULT NULL,
 MOD_SUP_ID INTEGER DEFAULT NULL,
 MOD_VER_ID BIGINT DEFAULT NULL,
 MOD_VER_CDATE TIMESTAMP DEFAULT NULL,
 MOD_VER_MDATE TIMESTAMP DEFAULT NULL,
 MOD_VER_MEMO VARCHAR(16777216),
 MOD_VER_MEMO_EN VARCHAR(16777216),
 MOD_VER_STATUS VARCHAR(10) DEFAULT NULL,
 PKG_LEN INTEGER NOT NULL,
 PKG_MD5 VARCHAR(32) NOT NULL,
 PKG_FILE VARBINARY(16777216),
 MOD_DL_CDATE TIMESTAMP NOT NULL,
 MOD_DL_MDATE TIMESTAMP NOT NULL,
 MOD_DL_STATUS VARCHAR(10) NOT NULL,
 MOD_DL_SUP_ID INTEGER NOT NULL,
 MOD_DL_URL VARCHAR(700) DEFAULT NULL,
 IMPORT_DATA_CONN VARCHAR(50) DEFAULT NULL,
 REPLACE_META_DATABASENAME VARCHAR(64) DEFAULT NULL,
 REPLACE_WORK_DATABASENAME VARCHAR(64) DEFAULT NULL,
 CONSTRAINT PK_EWA_MOD_DOWNLOAD PRIMARY KEY (MOD_DL_ID)
);

CREATE TABLE EWA_MOD_FIELD (
 EMD_ID BIGINT NOT NULL,
 COLUMN_NAME VARCHAR(64) DEFAULT '' NOT NULL,
 MOD_VER_ID BIGINT NOT NULL,
 TABLE_CATALOG VARCHAR(64) NOT NULL,
 TABLE_SCHEMA VARCHAR(64) NOT NULL,
 TABLE_NAME VARCHAR(64) DEFAULT '' NOT NULL,
 ORDINAL_POSITION BIGINT DEFAULT 0 NOT NULL,
 COLUMN_DEFAULT VARCHAR(16777216),
 IS_NULLABLE VARCHAR(3) DEFAULT '' NOT NULL,
 DATA_TYPE VARCHAR(64) DEFAULT '' NOT NULL,
 CHARACTER_MAXIMUM_LENGTH BIGINT DEFAULT NULL,
 CHARACTER_OCTET_LENGTH BIGINT DEFAULT NULL,
 NUMERIC_PRECISION BIGINT DEFAULT NULL,
 NUMERIC_SCALE BIGINT DEFAULT NULL,
 DATETIME_PRECISION BIGINT DEFAULT NULL,
 CHARACTER_SET_NAME VARCHAR(32) DEFAULT NULL,
 COLLATION_NAME VARCHAR(32) DEFAULT NULL,
 COLUMN_TYPE VARCHAR(16777216) NOT NULL,
 COLUMN_KEY VARCHAR(3) DEFAULT '' NOT NULL,
 EXTRA VARCHAR(30) DEFAULT '' NOT NULL,
 "PRIVILEGES" VARCHAR(80) DEFAULT '' NOT NULL,
 COLUMN_COMMENT VARCHAR(1024) DEFAULT '' NOT NULL,
 GENERATION_EXPRESSION VARCHAR(16777216) NOT NULL,
 CONSTRAINT PK_EWA_MOD_FIELD PRIMARY KEY (EMD_ID,COLUMN_NAME)
);

CREATE TABLE EWA_MOD_INDEX (
 EMD_ID BIGINT NOT NULL,
 INDEX_NAME VARCHAR(64) NOT NULL,
 MOD_VER_ID BIGINT NOT NULL,
 TABLE_CATALOG VARCHAR(64) NOT NULL,
 TABLE_SCHEMA VARCHAR(64) NOT NULL,
 TABLE_NAME VARCHAR(64) NOT NULL,
 INDEX_TYPE VARCHAR(20) NOT NULL,
 INDEX_DDL VARCHAR(16777216),
 CONSTRAINT SYS_PK_10153 PRIMARY KEY (EMD_ID,INDEX_NAME)
);
CREATE UNIQUE INDEX SYS_IDX_SYS_PK_10153_10154 ON EWA_MOD_INDEX (EMD_ID,INDEX_NAME);



CREATE TABLE EWA_MOD_INDEX_FIELD (
 MOD_VER_ID BIGINT NOT NULL,
 TABLE_CATALOG VARCHAR(64) NOT NULL,
 TABLE_SCHEMA VARCHAR(64) NOT NULL,
 TABLE_NAME VARCHAR(64) NOT NULL,
 INDEX_NAME VARCHAR(64) NOT NULL,
 COLUMN_NAME VARCHAR(64) NOT NULL,
 INDEX_ASC CHARACTER(1) NOT NULL,
 CONSTRAINT PK_EWA_MOD_INDEX_FIELD PRIMARY KEY (MOD_VER_ID,TABLE_CATALOG,TABLE_SCHEMA,TABLE_NAME,INDEX_NAME,COLUMN_NAME)
);

CREATE TABLE EWA_MOD_PACKAGE (
 MOD_VER_ID BIGINT NOT NULL,
 PKG_DLV_DATE TIMESTAMP NOT NULL,
 PKG_LEN INTEGER NOT NULL,
 PKG_MD5 VARCHAR(32) NOT NULL,
 PKG_SUP_ID INTEGER NOT NULL,
 PKG_ADM_ID INTEGER NOT NULL,
 PKG_FILE VARBINARY(16777216),
 PKG_PUBLISH_TIME TIMESTAMP DEFAULT NULL,
 PKG_PUBLISH_URL VARCHAR(400) DEFAULT NULL,
 PKG_PUBLISH_RESULT VARCHAR(16777216),
 PKG_PUBLISH_STATUS VARCHAR(10) DEFAULT NULL,
 CONSTRAINT PK_EWA_MOD_PACKAGE PRIMARY KEY (MOD_VER_ID)
);

CREATE TABLE EWA_MOD_VER (
 MOD_VER_ID BIGINT NOT NULL,
 MOD_CODE VARCHAR(100) NOT NULL,
 MOD_VER VARCHAR(30) NOT NULL,
 MOD_VER_CDATE TIMESTAMP NOT NULL,
 MOD_VER_MDATE TIMESTAMP NOT NULL,
 MOD_VER_MEMO VARCHAR(16777216),
 MOD_VER_MEMO_EN VARCHAR(16777216),
 MOD_VER_STATUS VARCHAR(10) NOT NULL,
 MOD_VER_ADM_ID INTEGER NOT NULL,
 MOD_VER_SUP_ID INTEGER NOT NULL,
 CONSTRAINT PK_EWA_MOD_VER PRIMARY KEY (MOD_VER_ID)
);

Create a EWA tables （SQLSERVER）

CREATE TABLE EWA_CFG (
 XMLNAME varchar(200) NOT NULL,
 ITEMNAME varchar(100) NOT NULL,
 XMLDATA ntext NOT NULL,
 HASH_CODE int NOT NULL,
 ADM_LID varchar(50) NULL,
 CREATE_DATE datetime NULL,
 UPDATE_DATE datetime NULL,
 MD5 varchar(32) NULL,
 DATASOURCE varchar(123) NULL,
 CLASS_ACL varchar(333) NULL,
 CLASS_LOG varchar(333) NULL,
 DESCRIPTION varchar(500) NULL,
 CONSTRAINT PK_EWA_CFG PRIMARY KEY (XMLNAME,ITEMNAME)
);



CREATE TABLE EWA_CFG_HIS (
 HIS_ID int IDENTITY(1,1) NOT NULL,
 HIS_DATE datetime NOT NULL,
 XMLNAME varchar(200) NOT NULL,
 ITEMNAME varchar(100) NOT NULL,
 XMLDATA ntext NOT NULL,
 HASH_CODE int NOT NULL,
 ADM_LID varchar(50) NULL,
 CREATE_DATE datetime NULL,
 UPDATE_DATE datetime NULL,
 MD5 varchar(32) NULL,
 DATASOURCE varchar(123) NULL,
 CLASS_ACL varchar(333) NULL,
 CLASS_LOG varchar(333) NULL,
 DESCRIPTION varchar(500) NULL,
 CONSTRAINT PK_EWA_CFG_HIS PRIMARY KEY (HIS_ID)
);

CREATE TABLE EWA_CFG_OTH (
 OTH_TAG varchar(50) NOT NULL,
 OTH_TXT ntext NULL,
 OTH_CDATE datetime NULL,
 OTH_MDATE datetime NULL,
 ADM_LID varchar(50) NULL,
 CONSTRAINT PK_EWA_CFG_OTH PRIMARY KEY (OTH_TAG)
);

CREATE TABLE EWA_CFG_RM (
 RM_ID int IDENTITY(1,1) NOT NULL,
 RM_DATE datetime NOT NULL,
 XMLNAME varchar(200) NOT NULL,
 ITEMNAME varchar(100) NOT NULL,
 XMLDATA ntext NOT NULL,
 HASH_CODE int NOT NULL,
 ADM_LID varchar(50) NULL,
 CREATE_DATE datetime NULL,
 UPDATE_DATE datetime NULL,
 MD5 varchar(32) NULL,
 DATASOURCE varchar(123) NULL,
 CLASS_ACL varchar(333) NULL,
 CLASS_LOG varchar(333) NULL,
 DESCRIPTION varchar(500) NULL,
 CONSTRAINT PK_EWA_CFG_RM PRIMARY KEY (RM_ID)
);

CREATE TABLE EWA_CFG_TREE (
 XMLNAME varchar(200) NOT NULL,
 EDIT_STATUS varchar(10) NULL,
 CONSTRAINT PK_EWA_CFG_TREE PRIMARY KEY (XMLNAME)
);

Official web

https://www.gdxsoft.com

Github

https://github.com/gdx1231/emp-script

Maven

<dependency>
    <groupId>com.gdxsoft.easyweb</groupId>
    <artifactId>emp-script</artifactId>
    <version>1.1.8</version>
</dependency>

Stats

Dependencies
14
Dependent packages
2
Dependent repositories
0
Total releases
11
Latest release
First release
Stars
2
Forks
0
Watchers
2
Contributors
2
Repository size
9.98 MB
SourceRank
8

Development practices

Source repo 2FA enabled
TEXT!
Package manager 2FA enabled
TEXT!
Is security responsive
TEXT!
Dependencies are managed
TEXT!
Issue-free release available
TEXT!
Succession plan available
TEXT!
Package manager 2FA enabled
TEXT!

The Tidelift Subscription provides access to a continuously curated stream of human-researched and maintainer-verified data on open source packages and their licenses, releases, vulnerabilities, and development practices.

Learn more →

Releases

1.1.8
1.1.7
1.1.6
1.1.5
1.1.4
1.1.3
1.1.2
1.1.1
1.0.5
1.0.4
See all 11 releases

Contributors

Code Guo jinzhaopeng


See all contributors

Something wrong with this page? Make a suggestion

Export .ABOUT file for this package

Last synced: 2023-12-31 18:50:05 UTC

Login to resync this project