This is a test of the database that will generate Jamstack content.

• It is a database of vehicles. Some are Automobiles, some are Airplanes.
• The Jamstack framework will generate static HTML or static JSON from the database the first time a query with the appropriate slug is requested (ie: "type=auto&color=black").
• From then on, the static content will be delivered without even invoking PHP.
• This is done by the HTACCESS file.
• This file will continue to be delivered until it is flushed by the Jamstack operator.

Test Slug Count Increment (ASSERT: TRUE, CONDITION: category=car~color=red.html)

• This inspects the database record of "slug counts", which is will reveal the data record of how many times each "slug" was requested.
• Keeping track of the slug count will guides the devops as to which slugs are the most popular.
• Devops can use this information to choose which static files to generate offline prior to each deployment of new data.
• Those static files can be deployed to forward edge caches (CDN/Cloudflare).
• If this step is skipped, the first time each slug is requested (for each CDN server), it will generate a load on the server, but thereafter be cached on forward edge servers.

TRUE

Test Slug Count Read (ASSERT: >0, CONDITION: category=car~color=red.html)

867

Test Slug Count Read (ASSERT: 0, CONDITION: category=cardfadfafd~color=redadadfadfs.html)

0

Get Products (ASSERT: >1 Result, CONDITION: all products)

mResult = [ ]
[0]	0 = [ ]   [product_id]   "veh_jag_xjs" [qty_on_hand]   "2" [description]   "Top of the line English Roadster" [category]   "car" [make]   "Jaguar" [model]   "XJ-S" [year]   "1995" [color]   "white" [price]   "38000" [photo]   "jag-1.png"
[1]	1 = [ ]   [product_id]   "veh_jag_xjs" [qty_on_hand]   "1" [description]   "Top of the line English Roadster" [category]   "car" [make]   "Jaguar" [model]   "XJ-S" [year]   "1995" [color]   "red" [price]   "33000" [photo]   "jag-2.png"
[2]	2 = [ ]   [product_id]   "veh_jag_xjs" [qty_on_hand]   "1" [description]   "Top of the line English Roadster" [category]   "car" [make]   "Jaguar" [model]   "XJ-S" [year]   "1995" [color]   "black" [price]   "41000" [photo]   "jag-3.png"
[3]	3 = [ ]   [product_id]   "veh_bmw_320i" [qty_on_hand]   "1" [description]   "Amazing German Car" [category]   "car" [make]   "BMW" [model]   "320i" [year]   "1997" [color]   "black" [price]   "36000" [photo]   "bmw-1.png"
[4]	4 = [ ]   [product_id]   "veh_bmw_320i" [qty_on_hand]   "3" [description]   "Amazing German Car" [category]   "car" [make]   "BMW" [model]   "320i" [year]   "1998" [color]   "grey" [price]   "38000" [photo]   "bmw-2.png"
[5]	5 = [ ]   [product_id]   "veh_bmw_320i" [qty_on_hand]   "5" [description]   "Amazing German Car" [category]   "car" [make]   "BMW" [model]   "320i" [year]   "1997" [color]   "white" [price]   "34999" [photo]   "bmw-3.png"
[6]	6 = [ ]   [product_id]   "veh_mg_bgt" [qty_on_hand]   "1" [description]   "Rare Classic Sports Car" [category]   "car" [make]   "MG" [model]   "B-GT" [year]   "1971" [color]   "white" [price]   "25000" [photo]   "mg-1.png "
[7]	7 = [ ]   [product_id]   "veh_cessna_172" [qty_on_hand]   "2" [description]   "Workhorse of the Cessna Fleet" [category]   "airplane" [make]   "Cessna" [model]   "172" [year]   "1958" [color]   "yellow" [price]   "30000" [photo]   "cessna-1.png"

Get Products (ASSERT: 1 Result, CONDITION: 'make'=>'Jaguar', 'color'=>'black')

mResult = [ ]
[0]	0 = [ ]   [product_id]   "veh_jag_xjs" [qty_on_hand]   "1" [description]   "Top of the line English Roadster" [category]   "car" [make]   "Jaguar" [model]   "XJ-S" [year]   "1995" [color]   "black" [price]   "41000" [photo]   "jag-3.png"