Tutorials References Exercises Videos Menu
Create Website Get Certified Upgrade

AppML Models


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"}
}

What Can an AppML Model Do?

With an AppML model you can:

  • 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.

Examples

To allow users to filter data (search ,sort), you can add filter information to the model:

Example

"filteritems" : [
    {"item" : "CustomerName", "label" : "Customer"},
    {"item" : "City"},
    {"item" : "Country"}
]

To allow users to update data, you can add update information to the model: 

Example

"updateItems" : [
    {"item" : "CustomerName"},
    {"item" : "Address"},
    {"item" : "PostalCode"},
    {"item" : "City"},
    {"item" : "Country"}
]

Without a Model

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.