AppML ma’lumotlar bazalari
"database" xususiyati
"database" xususiyati ma’lumotlar bazasini ma’lumot manbai sifatida belgilaydi. U quyidagi ichki xususiyatlarga ega:
| Element | Tavsif |
|---|---|
| "connection" | Ma’lumotlar bazasi ulanishining nomi |
| "execute" | Ma’lumotlarni olishdan oldin bajariladigan SQL operatorlari massivi (ixtiyoriy) |
| "keyfield" | Asosiy jadval uchun kalit maydon (ixtiyoriy) |
| "maintable" | Ushbu ilova uchun asosiy jadval (ixtiyoriy) |
| "orderby" | Ilova uchun qat’iy belgilangan SQL orderby bandi (ixtiyoriy) |
| "sql" | Ma’lumotlarni olish uchun SQL operatori (so‘rovi) |
Ma’lumotlar bazasidan ma’lumotlar
Ushbu model SQL ma’lumotlar bazasidagi Customer jadvalidan Customer, City va Country maydonlarini o‘z ichiga olgan yozuvlarni oladi:
Misol
{
"database": {
"connection": "mysql",
"sql" : "SELECT CustomerName, City, Country FROM Customers",
"orderby" : "CustomerName"
}
}
Filtrlash cheklovlari
Foydalanuvchilarga ma’lumotlarni filtrlash imkonini berish uchun modelga filtr ma’lumotlarini qo‘shishingiz mumkin:
"filteritems" : [
{"item" : "CustomerName", "label" : "Customer"},
{"item" : "City"},
{"item" : "Country"}]
Saralash cheklovlari
Foydalanuvchilarga ma’lumotlarni saralash imkonini berish uchun modelga saralash ma’lumotlarini qo‘shishingiz mumkin:
"sortitems" : [
{"item" : "CustomerName", "label" : "Customer"},
{"item" : "City"},
{"item" : "Country"}]
Yangilash cheklovlari
Foydalanuvchilarga ma’lumotlarni yangilash imkonini berish uchun modelga yangilash ma’lumotlarini kiritishingiz mumkin:
Misol
"updateItems" : [
{"item" : "CustomerName"},
{"item" : "Address"},
{"item" : "PostalCode"},
{"item" : "City"},
{"item" : "Country"}]
Standart holatda AppML ma’lumotlarni filtrlash, saralash yoki yangilashga faqat bu modelda ko‘rsatilgan bo‘lsagina ruxsat beradi.
Ma’lumotlar bazasi ulanishlari
Ma’lumotlar bazasi ulanishlari appml_config.php faylida belgilanadi:
appml_config.php
<?php echo("Access Forbidden");exit();?>
{
"dateformat" : "yyyy-mm-dd",
"databases": [
{
"connection" : "mysql",
"host" : "127.0.0.1:3306",
"dbname" : "Northwind",
"username" : "myUserId",
"password" : "myPassword"
},
{
"connection" : "googleDB",
"host" : "192.168.1.1:3306",
"dbname" : "Northwind",
"username" : "myUserId",
"password" : "myPassword"
},
{
"connection" : "amazonDB",
"host" : "mydbinstance.amazon.com:3306",
"dbname" : "Northwind",
"username" : "myUserId",
"password" : "myPassword"
},
{
"connection" : "azureDB",
"host" : "azure.cloudapp.net",
"dbname" : "Northwind",
"username" : "myUserId",
"password" : "myPassword"
}
]
}
Konfiguratsiya fayli ko‘plab ma’lumotlar bazasi ulanishlarini o‘z ichiga olishi mumkin.
Ma’lumotlar bazalarini yaratish
AppML ilova ishga tushirilishidan oldin SQL operatorlarini bajarish imkonini bergani uchun, zarur bo‘lsa, bundan ma’lumotlar bazasini yaratishda foydalanishingiz mumkin:
Model
{
"database" : {
"connection" : "myCDs",
"execute" : [
"DROP TABLE IF EXISTS CD_Catalog",
"CREATE TABLE IF NOT EXISTS CD_Catalog (CDID INT NOT NULL AUTO_INCREMENT,PRIMARY KEY (CDID),Title NVARCHAR(255),Artist NVARCHAR(255),Country NVARCHAR(255),Price NUMBER)"
]
}}
Tez prototiplash uchun ayni muddao!
W3Schools Pathfinder
Yutuqlaringizni kuzating – bu bepul!