AppML Моделі
An AppML model describes an application.
What Is an AppML Model?
An AppML model is a JavaScript object (JSON) describing an application.
This small model describes a full application for retrieving data from a database:
{
"database" : {
"connection" : "localmysql",
"sql" : "SELECT * FROM Customers"}
}
Що може робити AppML модель?
За допомогою AppML моделі ви можете:
- Define connections to databases like MySQL, SQL Server, Access, and Oracle.
- Define connections to data files like JSON, XML, and other text files.
- Define SQL statements for retrieving data.
- Define filter and sorting restrictions.
- Define data types, data formats, and update restrictions.
- Define application security, users, and user groups.
Приклади
To allow users to filter data (search ,sort), you can add filter information to the model:
Приклад
"filteritems" : [
{"item" : "CustomerName", "label" : "Customer"},
{"item" : "City"},
{"item" : "Country"}
]
To allow users to update data, you can add update information to the model:
Приклад
"updateItems" : [
{"item" : "CustomerName"},
{"item" : "Address"},
{"item" : "PostalCode"},
{"item" : "City"},
{"item" : "Country"}
]
Без моделі
The applications you have seen earlier in this tutorial, did not use any models.
In later chapters, we will connect to databases, read, filter, and update data, as specified in a model.
