AppML Model describes an application. It is a JSON based format and we can define following functionalities.
Syntax :
<table appml-data="local?model=model_students"></div>
Here
model_students.js is the AppML data model file.
model_students.js
{
"rowsperpage" : 10,
"database" : {
"connection" : "localsql",
"sql" : "SELECT studentName, class, section FROM Students",
"orderby" : "StudentName"
},
"filteritems" : [
{"item" : "studentName", "label" : "Student"},
{"item" : "class"},
{"item" : "section"}
],
"sortitems" : [
{"item" : "studentName", "label" : "Student"},
{"item" : "class"},
{"item" : "section"}
]
}
Following are the common uses of AppML models :* Define database connections to MySQL, Sql Server, MS Access and Oracle.
* Define connection to access files like JSON, XML, csv based text file.
* Define SQL statements for CRUD (Create, Read, Update, Delete) operations.
* Apply Filter/Sorting restrictions on table.
* Define data types, data formats and restrictions on them.
* Apply security on application users. Define user groups.
