Model

The model is the core asset, the model is used as a data source, which passed to template to generate code.
How the model is designed and useing the init shceme is important. The model of this project is come from the database. The model is directly related to set task and write template.

Related knowledge:

Model

• Transform
  • Database
• Model Structure
  • Entity(database、java class)
• Init Scheme
  • Init
  • Mapping And Convert

Tag

• entity

Model Design

We have created a new book table in the database. How to transfrom to a model?

The book table has 4 fields(MySql):

• id: Primary key, type int, auto increment.
• name: book name, type varchar, size is 50.
• type: book type, type int.
• regist_time: The registration time of the book, type timestamp.

After we have configured the database connection, find this table and click the Default transform.

The model structure as follows: the default simply transform the original structure model of the database.

According to the business logic, the model is missing some information.

Required properties:

• Class: Head uppercase part, the value is "Book".
• class: Lowercase part, the value is "book".
• menu: The left menu.

Required columns:

• name: field name, which come from id(Consistent with table field name), convert to the mapping name, such as regist_time convert to registTime.
• type: field type, convert from jdbcType.
• fullType: field full type, convert from jdbcType.
• controlType: field control type in ui page, include text, select and date.
• isEdit: wheather the field need to be edited, such as id is primary key no need to be edited, isEdit is false, others is true.
• isQuery: wheather the field need to be queried.

Init Scheme

We can manually add and modify these required properties and fields:

• add property
• add column
• mapping and convert

Of course, there are more easily way to set it up directly when you transfrom model with init scheme.

More about init scheme, please read:

• Init Scheme

Select the custom init scheme.

The required properties and fields are available, and we make a little modification to get the final model.

• controlType: id is null，name is text，type is select，registTime is date。
• isEdit: id is false, name, type and registTime is true。
• isQuery: id is false, name, type and registTime is true。

Summary

The model can add or modify some information according to the requirements of the project, and most of the work can be done in the init scheme. Please read the follow-up content.