AppML case introduction



This case study demonstrates how to build a complete <AppML> Internet application with capabilities for listing, editing, and searching information against several tables in a database.


What we will create

We will use an existing database called Demo.

For each table in the database, we will:

  • Create a prototype model

  • Create a prototype HTML page

  • Create application model

  • Create HTML template

  • Create complete application


Demo Database

For the case study, we use a subset of the Northwind database that comes pre-installed with MS Office.

This database is well known and easy to test whether using PHP, classic ASP or ASP.NET.

The Demo database contains several tables with data, as shown below:

Customers

##Blondel père et fils 24, place KléberStrasbourgFranceBólido Comidas preparadasC/ Araquil, 67 MadridSpainBottom-Dollar Markets23 Tsawassen Blvd.TsawassenCanada
Customer AddressCityCountry
Around the Horn120 Hanover Sq.London UK
Berglunds snabbkjøpBerguvsvägen 8LuleåSweden
Blauer See DelikatessenForsterstr. 57MannheimGermany

Suppliers

SupplierAddressCityCountryExotic Liquid49 Gilbert St.LondonUKNew Orleans Cajun DelightsP.O. Box 78934New OrleansUSAGrandma Kelly's Homestead707 Oxford Rd.Ann ArborUSATokyo Traders9-8 SekimaiMusashino-shiTokyoJapanCooperativa de Quesos 'Las Cabras'Calle del Rosal 4OviedoSpainMayumi's92 Setsuko Chuo-kuOsakaJapanPavlova, Ltd.74 Rose St. Moonie PondsMelbourneAustralia##Specialty Biscuits, Ltd.##PB Kn ckebr d ABKaloadagatan 13 G teborgSwedenAv. das Americanas 12.890
29 King's WayManchesterUK
##Refrescos Americanas LTDA
S ​​o Paulo Brazil

Products

ProducQuantityPerUnitUnitPriceUnitsInStock
Chai10 boxes x 20 bags1839
Chang24 - 12 oz bottles1917
Aniseed Syrup12 - 550 ml bottles1013
Chai10 boxes x 20 bags1839
Chef Anton's Gumbo Mix36 boxes210
Grandma's Boysenberry Spread12 - 8 oz jars25120
Uncle Bob's Organic Dried Pears12 - 1 lb pkgs.3015
Northwoods Cranberry Sauce12 - 12 oz jars406
Mishi Kobe Niku18 - 500 g pkgs.9729
Ikura12 - 200 ml jars3131