@progress/kendo-schematics
Advanced tools
Comparing version 3.1.0 to 3.2.0-dev.202209131446
@@ -6,3 +6,3 @@ { | ||
"license": "SEE LICENSE in LICENSE.md", | ||
"version": "3.1.0", | ||
"version": "3.2.0-dev.202209131446", | ||
"scripts": { | ||
@@ -9,0 +9,0 @@ "build-package": "npm run build", |
@@ -17,7 +17,38 @@ { | ||
"grid": { | ||
"description": "Generates a component containing Kendo Angular Grid component.", | ||
"factory": "./collection/grid/index#grid", | ||
"schema": "./collection/grid/schema.json" | ||
} | ||
"progress:scaffold-category": "page", | ||
"description": "Generates a component containing Kendo Angular Grid component.", | ||
"factory": "./collection/grid/index#grid", | ||
"schema": "./collection/grid/schema.json" | ||
}, | ||
"scheduler": { | ||
"progress:scaffold-category": "page", | ||
"description": "Generates a component containing Kendo Angular Scheduler component.", | ||
"factory": "./collection/scheduler/index#scheduler", | ||
"schema": "./collection/scheduler/schema.json" | ||
}, | ||
"categorical-chart": { | ||
"progress:scaffold-category": "page", | ||
"description": "Generates a component containing Kendo Angular Chart component.", | ||
"factory": "./collection/charts/categorical/index#chart", | ||
"schema": "./collection/charts/categorical/schema.json" | ||
}, | ||
"circular-chart": { | ||
"progress:scaffold-category": "page", | ||
"description": "Generates a component containing Kendo Angular Pie or Donut Chart component.", | ||
"factory": "./collection/charts/circular/index#chart", | ||
"schema": "./collection/charts/circular/schema.json" | ||
}, | ||
"scatter-chart": { | ||
"progress:scaffold-category": "page", | ||
"description": "Generates a component containing Kendo Angular Scatter Chart component.", | ||
"factory": "./collection/charts/scatter/index#chart", | ||
"schema": "./collection/charts/scatter/schema.json" | ||
}, | ||
"stock-chart": { | ||
"progress:scaffold-category": "page", | ||
"description": "Generates a component containing Kendo Angular Stock Chart component.", | ||
"factory": "./collection/charts/stock/index#chart", | ||
"schema": "./collection/charts/stock/schema.json" | ||
} | ||
} | ||
} | ||
} |
@@ -1,1 +0,1 @@ | ||
export declare const products = "[{\n \"ProductID\": 1,\n \"ProductName\": \"Chai\",\n \"SupplierID\": 1,\n \"CategoryID\": 1,\n \"QuantityPerUnit\": \"10 boxes x 20 bags\",\n \"UnitPrice\": 18.0000,\n \"UnitsInStock\": 39,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 10,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 1,\n \"CategoryName\": \"Beverages\",\n \"Description\": \"Soft drinks, coffees, teas, beers, and ales\"\n }\n}, {\n \"ProductID\": 2,\n \"ProductName\": \"Chang\",\n \"SupplierID\": 1,\n \"CategoryID\": 1,\n \"QuantityPerUnit\": \"24 - 12 oz bottles\",\n \"UnitPrice\": 19.0000,\n \"UnitsInStock\": 17,\n \"UnitsOnOrder\": 40,\n \"ReorderLevel\": 25,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 1,\n \"CategoryName\": \"Beverages\",\n \"Description\": \"Soft drinks, coffees, teas, beers, and ales\"\n }\n}, {\n \"ProductID\": 3,\n \"ProductName\": \"Aniseed Syrup\",\n \"SupplierID\": 1,\n \"CategoryID\": 2,\n \"QuantityPerUnit\": \"12 - 550 ml bottles\",\n \"UnitPrice\": 10.0000,\n \"UnitsInStock\": 13,\n \"UnitsOnOrder\": 70,\n \"ReorderLevel\": 25,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 2,\n \"CategoryName\": \"Condiments\",\n \"Description\": \"Sweet and savory sauces, relishes, spreads, and seasonings\"\n }\n}, {\n \"ProductID\": 4,\n \"ProductName\": \"Chef Anton's Cajun Seasoning\",\n \"SupplierID\": 2,\n \"CategoryID\": 2,\n \"QuantityPerUnit\": \"48 - 6 oz jars\",\n \"UnitPrice\": 22.0000,\n \"UnitsInStock\": 53,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 0,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 2,\n \"CategoryName\": \"Condiments\",\n \"Description\": \"Sweet and savory sauces, relishes, spreads, and seasonings\"\n }\n}, {\n \"ProductID\": 5,\n \"ProductName\": \"Chef Anton's Gumbo Mix\",\n \"SupplierID\": 2,\n \"CategoryID\": 2,\n \"QuantityPerUnit\": \"36 boxes\",\n \"UnitPrice\": 21.3500,\n \"UnitsInStock\": 0,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 0,\n \"Discontinued\": true,\n \"Category\": {\n \"CategoryID\": 2,\n \"CategoryName\": \"Condiments\",\n \"Description\": \"Sweet and savory sauces, relishes, spreads, and seasonings\"\n }\n}, {\n \"ProductID\": 6,\n \"ProductName\": \"Grandma's Boysenberry Spread\",\n \"SupplierID\": 3,\n \"CategoryID\": 2,\n \"QuantityPerUnit\": \"12 - 8 oz jars\",\n \"UnitPrice\": 25.0000,\n \"UnitsInStock\": 120,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 25,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 2,\n \"CategoryName\": \"Condiments\",\n \"Description\": \"Sweet and savory sauces, relishes, spreads, and seasonings\"\n }\n}, {\n \"ProductID\": 7,\n \"ProductName\": \"Uncle Bob's Organic Dried Pears\",\n \"SupplierID\": 3,\n \"CategoryID\": 7,\n \"QuantityPerUnit\": \"12 - 1 lb pkgs.\",\n \"UnitPrice\": 30.0000,\n \"UnitsInStock\": 15,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 10,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 7,\n \"CategoryName\": \"Produce\",\n \"Description\": \"Dried fruit and bean curd\"\n }\n}, {\n \"ProductID\": 8,\n \"ProductName\": \"Northwoods Cranberry Sauce\",\n \"SupplierID\": 3,\n \"CategoryID\": 2,\n \"QuantityPerUnit\": \"12 - 12 oz jars\",\n \"UnitPrice\": 40.0000,\n \"UnitsInStock\": 6,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 0,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 2,\n \"CategoryName\": \"Condiments\",\n \"Description\": \"Sweet and savory sauces, relishes, spreads, and seasonings\"\n }\n}, {\n \"ProductID\": 9,\n \"ProductName\": \"Mishi Kobe Niku\",\n \"SupplierID\": 4,\n \"CategoryID\": 6,\n \"QuantityPerUnit\": \"18 - 500 g pkgs.\",\n \"UnitPrice\": 97.0000,\n \"UnitsInStock\": 29,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 0,\n \"Discontinued\": true,\n \"Category\": {\n \"CategoryID\": 6,\n \"CategoryName\": \"Meat/Poultry\",\n \"Description\": \"Prepared meats\"\n }\n}, {\n \"ProductID\": 10,\n \"ProductName\": \"Ikura\",\n \"SupplierID\": 4,\n \"CategoryID\": 8,\n \"QuantityPerUnit\": \"12 - 200 ml jars\",\n \"UnitPrice\": 31.0000,\n \"UnitsInStock\": 31,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 0,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 8,\n \"CategoryName\": \"Seafood\",\n \"Description\": \"Seaweed and fish\"\n }\n}, {\n \"ProductID\": 11,\n \"ProductName\": \"Queso Cabrales\",\n \"SupplierID\": 5,\n \"CategoryID\": 4,\n \"QuantityPerUnit\": \"1 kg pkg.\",\n \"UnitPrice\": 21.0000,\n \"UnitsInStock\": 22,\n \"UnitsOnOrder\": 30,\n \"ReorderLevel\": 30,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 4,\n \"CategoryName\": \"Dairy Products\",\n \"Description\": \"Cheeses\"\n }\n}, {\n \"ProductID\": 12,\n \"ProductName\": \"Queso Manchego La Pastora\",\n \"SupplierID\": 5,\n \"CategoryID\": 4,\n \"QuantityPerUnit\": \"10 - 500 g pkgs.\",\n \"UnitPrice\": 38.0000,\n \"UnitsInStock\": 86,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 0,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 4,\n \"CategoryName\": \"Dairy Products\",\n \"Description\": \"Cheeses\"\n }\n}, {\n \"ProductID\": 13,\n \"ProductName\": \"Konbu\",\n \"SupplierID\": 6,\n \"CategoryID\": 8,\n \"QuantityPerUnit\": \"2 kg box\",\n \"UnitPrice\": 6.0000,\n \"UnitsInStock\": 24,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 5,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 8,\n \"CategoryName\": \"Seafood\",\n \"Description\": \"Seaweed and fish\"\n }\n}, {\n \"ProductID\": 14,\n \"ProductName\": \"Tofu\",\n \"SupplierID\": 6,\n \"CategoryID\": 7,\n \"QuantityPerUnit\": \"40 - 100 g pkgs.\",\n \"UnitPrice\": 23.2500,\n \"UnitsInStock\": 35,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 0,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 7,\n \"CategoryName\": \"Produce\",\n \"Description\": \"Dried fruit and bean curd\"\n }\n}, {\n \"ProductID\": 15,\n \"ProductName\": \"Genen Shouyu\",\n \"SupplierID\": 6,\n \"CategoryID\": 2,\n \"QuantityPerUnit\": \"24 - 250 ml bottles\",\n \"UnitPrice\": 15.5000,\n \"UnitsInStock\": 39,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 5,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 2,\n \"CategoryName\": \"Condiments\",\n \"Description\": \"Sweet and savory sauces, relishes, spreads, and seasonings\"\n }\n}, {\n \"ProductID\": 16,\n \"ProductName\": \"Pavlova\",\n \"SupplierID\": 7,\n \"CategoryID\": 3,\n \"QuantityPerUnit\": \"32 - 500 g boxes\",\n \"UnitPrice\": 17.4500,\n \"UnitsInStock\": 29,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 10,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 3,\n \"CategoryName\": \"Confections\",\n \"Description\": \"Desserts, candies, and sweet breads\"\n }\n}, {\n \"ProductID\": 17,\n \"ProductName\": \"Alice Mutton\",\n \"SupplierID\": 7,\n \"CategoryID\": 6,\n \"QuantityPerUnit\": \"20 - 1 kg tins\",\n \"UnitPrice\": 39.0000,\n \"UnitsInStock\": 0,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 0,\n \"Discontinued\": true,\n \"Category\": {\n \"CategoryID\": 6,\n \"CategoryName\": \"Meat/Poultry\",\n \"Description\": \"Prepared meats\"\n }\n}, {\n \"ProductID\": 18,\n \"ProductName\": \"Carnarvon Tigers\",\n \"SupplierID\": 7,\n \"CategoryID\": 8,\n \"QuantityPerUnit\": \"16 kg pkg.\",\n \"UnitPrice\": 62.5000,\n \"UnitsInStock\": 42,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 0,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 8,\n \"CategoryName\": \"Seafood\",\n \"Description\": \"Seaweed and fish\"\n }\n}, {\n \"ProductID\": 19,\n \"ProductName\": \"Teatime Chocolate Biscuits\",\n \"SupplierID\": 8,\n \"CategoryID\": 3,\n \"QuantityPerUnit\": \"10 boxes x 12 pieces\",\n \"UnitPrice\": 9.2000,\n \"UnitsInStock\": 25,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 5,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 3,\n \"CategoryName\": \"Confections\",\n \"Description\": \"Desserts, candies, and sweet breads\"\n }\n}, {\n \"ProductID\": 20,\n \"ProductName\": \"Sir Rodney's Marmalade\",\n \"SupplierID\": 8,\n \"CategoryID\": 3,\n \"QuantityPerUnit\": \"30 gift boxes\",\n \"UnitPrice\": 81.0000,\n \"UnitsInStock\": 40,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 0,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 3,\n \"CategoryName\": \"Confections\",\n \"Description\": \"Desserts, candies, and sweet breads\"\n }\n}, {\n \"ProductID\": 21,\n \"ProductName\": \"Sir Rodney's Scones\",\n \"SupplierID\": 8,\n \"CategoryID\": 3,\n \"QuantityPerUnit\": \"24 pkgs. x 4 pieces\",\n \"UnitPrice\": 10.0000,\n \"UnitsInStock\": 3,\n \"UnitsOnOrder\": 40,\n \"ReorderLevel\": 5,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 3,\n \"CategoryName\": \"Confections\",\n \"Description\": \"Desserts, candies, and sweet breads\"\n }\n}, {\n \"ProductID\": 22,\n \"ProductName\": \"Gustaf's Kn\u00E4ckebr\u00F6d\",\n \"SupplierID\": 9,\n \"CategoryID\": 5,\n \"QuantityPerUnit\": \"24 - 500 g pkgs.\",\n \"UnitPrice\": 21.0000,\n \"UnitsInStock\": 104,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 25,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 5,\n \"CategoryName\": \"Grains/Cereals\",\n \"Description\": \"Breads, crackers, pasta, and cereal\"\n }\n}, {\n \"ProductID\": 23,\n \"ProductName\": \"Tunnbr\u00F6d\",\n \"SupplierID\": 9,\n \"CategoryID\": 5,\n \"QuantityPerUnit\": \"12 - 250 g pkgs.\",\n \"UnitPrice\": 9.0000,\n \"UnitsInStock\": 61,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 25,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 5,\n \"CategoryName\": \"Grains/Cereals\",\n \"Description\": \"Breads, crackers, pasta, and cereal\"\n }\n}, {\n \"ProductID\": 24,\n \"ProductName\": \"Guaran\u00E1 Fant\u00E1stica\",\n \"SupplierID\": 10,\n \"CategoryID\": 1,\n \"QuantityPerUnit\": \"12 - 355 ml cans\",\n \"UnitPrice\": 4.5000,\n \"UnitsInStock\": 20,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 0,\n \"Discontinued\": true,\n \"Category\": {\n \"CategoryID\": 1,\n \"CategoryName\": \"Beverages\",\n \"Description\": \"Soft drinks, coffees, teas, beers, and ales\"\n }\n}, {\n \"ProductID\": 25,\n \"ProductName\": \"NuNuCa Nu\u00DF-Nougat-Creme\",\n \"SupplierID\": 11,\n \"CategoryID\": 3,\n \"QuantityPerUnit\": \"20 - 450 g glasses\",\n \"UnitPrice\": 14.0000,\n \"UnitsInStock\": 76,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 30,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 3,\n \"CategoryName\": \"Confections\",\n \"Description\": \"Desserts, candies, and sweet breads\"\n }\n}, {\n \"ProductID\": 26,\n \"ProductName\": \"Gumb\u00E4r Gummib\u00E4rchen\",\n \"SupplierID\": 11,\n \"CategoryID\": 3,\n \"QuantityPerUnit\": \"100 - 250 g bags\",\n \"UnitPrice\": 31.2300,\n \"UnitsInStock\": 15,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 0,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 3,\n \"CategoryName\": \"Confections\",\n \"Description\": \"Desserts, candies, and sweet breads\"\n }\n}, {\n \"ProductID\": 27,\n \"ProductName\": \"Schoggi Schokolade\",\n \"SupplierID\": 11,\n \"CategoryID\": 3,\n \"QuantityPerUnit\": \"100 - 100 g pieces\",\n \"UnitPrice\": 43.9000,\n \"UnitsInStock\": 49,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 30,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 3,\n \"CategoryName\": \"Confections\",\n \"Description\": \"Desserts, candies, and sweet breads\"\n }\n}, {\n \"ProductID\": 28,\n \"ProductName\": \"R\u00F6ssle Sauerkraut\",\n \"SupplierID\": 12,\n \"CategoryID\": 7,\n \"QuantityPerUnit\": \"25 - 825 g cans\",\n \"UnitPrice\": 45.6000,\n \"UnitsInStock\": 26,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 0,\n \"Discontinued\": true,\n \"Category\": {\n \"CategoryID\": 7,\n \"CategoryName\": \"Produce\",\n \"Description\": \"Dried fruit and bean curd\"\n }\n}, {\n \"ProductID\": 29,\n \"ProductName\": \"Th\u00FCringer Rostbratwurst\",\n \"SupplierID\": 12,\n \"CategoryID\": 6,\n \"QuantityPerUnit\": \"50 bags x 30 sausgs.\",\n \"UnitPrice\": 123.7900,\n \"UnitsInStock\": 0,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 0,\n \"Discontinued\": true,\n \"Category\": {\n \"CategoryID\": 6,\n \"CategoryName\": \"Meat/Poultry\",\n \"Description\": \"Prepared meats\"\n }\n}, {\n \"ProductID\": 30,\n \"ProductName\": \"Nord-Ost Matjeshering\",\n \"SupplierID\": 13,\n \"CategoryID\": 8,\n \"QuantityPerUnit\": \"10 - 200 g glasses\",\n \"UnitPrice\": 25.8900,\n \"UnitsInStock\": 10,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 15,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 8,\n \"CategoryName\": \"Seafood\",\n \"Description\": \"Seaweed and fish\"\n }\n}, {\n \"ProductID\": 31,\n \"ProductName\": \"Gorgonzola Telino\",\n \"SupplierID\": 14,\n \"CategoryID\": 4,\n \"QuantityPerUnit\": \"12 - 100 g pkgs\",\n \"UnitPrice\": 12.5000,\n \"UnitsInStock\": 0,\n \"UnitsOnOrder\": 70,\n \"ReorderLevel\": 20,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 4,\n \"CategoryName\": \"Dairy Products\",\n \"Description\": \"Cheeses\"\n }\n}, {\n \"ProductID\": 32,\n \"ProductName\": \"Mascarpone Fabioli\",\n \"SupplierID\": 14,\n \"CategoryID\": 4,\n \"QuantityPerUnit\": \"24 - 200 g pkgs.\",\n \"UnitPrice\": 32.0000,\n \"UnitsInStock\": 9,\n \"UnitsOnOrder\": 40,\n \"ReorderLevel\": 25,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 4,\n \"CategoryName\": \"Dairy Products\",\n \"Description\": \"Cheeses\"\n }\n}, {\n \"ProductID\": 33,\n \"ProductName\": \"Geitost\",\n \"SupplierID\": 15,\n \"CategoryID\": 4,\n \"QuantityPerUnit\": \"500 g\",\n \"UnitPrice\": 2.5000,\n \"UnitsInStock\": 112,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 20,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 4,\n \"CategoryName\": \"Dairy Products\",\n \"Description\": \"Cheeses\"\n }\n}, {\n \"ProductID\": 34,\n \"ProductName\": \"Sasquatch Ale\",\n \"SupplierID\": 16,\n \"CategoryID\": 1,\n \"QuantityPerUnit\": \"24 - 12 oz bottles\",\n \"UnitPrice\": 14.0000,\n \"UnitsInStock\": 111,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 15,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 1,\n \"CategoryName\": \"Beverages\",\n \"Description\": \"Soft drinks, coffees, teas, beers, and ales\"\n }\n}, {\n \"ProductID\": 35,\n \"ProductName\": \"Steeleye Stout\",\n \"SupplierID\": 16,\n \"CategoryID\": 1,\n \"QuantityPerUnit\": \"24 - 12 oz bottles\",\n \"UnitPrice\": 18.0000,\n \"UnitsInStock\": 20,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 15,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 1,\n \"CategoryName\": \"Beverages\",\n \"Description\": \"Soft drinks, coffees, teas, beers, and ales\"\n }\n}, {\n \"ProductID\": 36,\n \"ProductName\": \"Inlagd Sill\",\n \"SupplierID\": 17,\n \"CategoryID\": 8,\n \"QuantityPerUnit\": \"24 - 250 g jars\",\n \"UnitPrice\": 19.0000,\n \"UnitsInStock\": 112,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 20,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 8,\n \"CategoryName\": \"Seafood\",\n \"Description\": \"Seaweed and fish\"\n }\n}, {\n \"ProductID\": 37,\n \"ProductName\": \"Gravad lax\",\n \"SupplierID\": 17,\n \"CategoryID\": 8,\n \"QuantityPerUnit\": \"12 - 500 g pkgs.\",\n \"UnitPrice\": 26.0000,\n \"UnitsInStock\": 11,\n \"UnitsOnOrder\": 50,\n \"ReorderLevel\": 25,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 8,\n \"CategoryName\": \"Seafood\",\n \"Description\": \"Seaweed and fish\"\n }\n}, {\n \"ProductID\": 38,\n \"ProductName\": \"C\u00F4te de Blaye\",\n \"SupplierID\": 18,\n \"CategoryID\": 1,\n \"QuantityPerUnit\": \"12 - 75 cl bottles\",\n \"UnitPrice\": 263.5000,\n \"UnitsInStock\": 17,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 15,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 1,\n \"CategoryName\": \"Beverages\",\n \"Description\": \"Soft drinks, coffees, teas, beers, and ales\"\n }\n}, {\n \"ProductID\": 39,\n \"ProductName\": \"Chartreuse verte\",\n \"SupplierID\": 18,\n \"CategoryID\": 1,\n \"QuantityPerUnit\": \"750 cc per bottle\",\n \"UnitPrice\": 18.0000,\n \"UnitsInStock\": 69,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 5,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 1,\n \"CategoryName\": \"Beverages\",\n \"Description\": \"Soft drinks, coffees, teas, beers, and ales\"\n }\n}, {\n \"ProductID\": 40,\n \"ProductName\": \"Boston Crab Meat\",\n \"SupplierID\": 19,\n \"CategoryID\": 8,\n \"QuantityPerUnit\": \"24 - 4 oz tins\",\n \"UnitPrice\": 18.4000,\n \"UnitsInStock\": 123,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 30,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 8,\n \"CategoryName\": \"Seafood\",\n \"Description\": \"Seaweed and fish\"\n }\n}, {\n \"ProductID\": 41,\n \"ProductName\": \"Jack's New England Clam Chowder\",\n \"SupplierID\": 19,\n \"CategoryID\": 8,\n \"QuantityPerUnit\": \"12 - 12 oz cans\",\n \"UnitPrice\": 9.6500,\n \"UnitsInStock\": 85,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 10,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 8,\n \"CategoryName\": \"Seafood\",\n \"Description\": \"Seaweed and fish\"\n }\n}, {\n \"ProductID\": 42,\n \"ProductName\": \"Singaporean Hokkien Fried Mee\",\n \"SupplierID\": 20,\n \"CategoryID\": 5,\n \"QuantityPerUnit\": \"32 - 1 kg pkgs.\",\n \"UnitPrice\": 14.0000,\n \"UnitsInStock\": 26,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 0,\n \"Discontinued\": true,\n \"Category\": {\n \"CategoryID\": 5,\n \"CategoryName\": \"Grains/Cereals\",\n \"Description\": \"Breads, crackers, pasta, and cereal\"\n }\n}, {\n \"ProductID\": 43,\n \"ProductName\": \"Ipoh Coffee\",\n \"SupplierID\": 20,\n \"CategoryID\": 1,\n \"QuantityPerUnit\": \"16 - 500 g tins\",\n \"UnitPrice\": 46.0000,\n \"UnitsInStock\": 17,\n \"UnitsOnOrder\": 10,\n \"ReorderLevel\": 25,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 1,\n \"CategoryName\": \"Beverages\",\n \"Description\": \"Soft drinks, coffees, teas, beers, and ales\"\n }\n}, {\n \"ProductID\": 44,\n \"ProductName\": \"Gula Malacca\",\n \"SupplierID\": 20,\n \"CategoryID\": 2,\n \"QuantityPerUnit\": \"20 - 2 kg bags\",\n \"UnitPrice\": 19.4500,\n \"UnitsInStock\": 27,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 15,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 2,\n \"CategoryName\": \"Condiments\",\n \"Description\": \"Sweet and savory sauces, relishes, spreads, and seasonings\"\n }\n}, {\n \"ProductID\": 45,\n \"ProductName\": \"Rogede sild\",\n \"SupplierID\": 21,\n \"CategoryID\": 8,\n \"QuantityPerUnit\": \"1k pkg.\",\n \"UnitPrice\": 9.5000,\n \"UnitsInStock\": 5,\n \"UnitsOnOrder\": 70,\n \"ReorderLevel\": 15,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 8,\n \"CategoryName\": \"Seafood\",\n \"Description\": \"Seaweed and fish\"\n }\n}, {\n \"ProductID\": 46,\n \"ProductName\": \"Spegesild\",\n \"SupplierID\": 21,\n \"CategoryID\": 8,\n \"QuantityPerUnit\": \"4 - 450 g glasses\",\n \"UnitPrice\": 12.0000,\n \"UnitsInStock\": 95,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 0,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 8,\n \"CategoryName\": \"Seafood\",\n \"Description\": \"Seaweed and fish\"\n }\n}, {\n \"ProductID\": 47,\n \"ProductName\": \"Zaanse koeken\",\n \"SupplierID\": 22,\n \"CategoryID\": 3,\n \"QuantityPerUnit\": \"10 - 4 oz boxes\",\n \"UnitPrice\": 9.5000,\n \"UnitsInStock\": 36,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 0,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 3,\n \"CategoryName\": \"Confections\",\n \"Description\": \"Desserts, candies, and sweet breads\"\n }\n}, {\n \"ProductID\": 48,\n \"ProductName\": \"Chocolade\",\n \"SupplierID\": 22,\n \"CategoryID\": 3,\n \"QuantityPerUnit\": \"10 pkgs.\",\n \"UnitPrice\": 12.7500,\n \"UnitsInStock\": 15,\n \"UnitsOnOrder\": 70,\n \"ReorderLevel\": 25,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 3,\n \"CategoryName\": \"Confections\",\n \"Description\": \"Desserts, candies, and sweet breads\"\n }\n}, {\n \"ProductID\": 49,\n \"ProductName\": \"Maxilaku\",\n \"SupplierID\": 23,\n \"CategoryID\": 3,\n \"QuantityPerUnit\": \"24 - 50 g pkgs.\",\n \"UnitPrice\": 20.0000,\n \"UnitsInStock\": 10,\n \"UnitsOnOrder\": 60,\n \"ReorderLevel\": 15,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 3,\n \"CategoryName\": \"Confections\",\n \"Description\": \"Desserts, candies, and sweet breads\"\n }\n}, {\n \"ProductID\": 50,\n \"ProductName\": \"Valkoinen suklaa\",\n \"SupplierID\": 23,\n \"CategoryID\": 3,\n \"QuantityPerUnit\": \"12 - 100 g bars\",\n \"UnitPrice\": 16.2500,\n \"UnitsInStock\": 65,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 30,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 3,\n \"CategoryName\": \"Confections\",\n \"Description\": \"Desserts, candies, and sweet breads\"\n }\n}, {\n \"ProductID\": 51,\n \"ProductName\": \"Manjimup Dried Apples\",\n \"SupplierID\": 24,\n \"CategoryID\": 7,\n \"QuantityPerUnit\": \"50 - 300 g pkgs.\",\n \"UnitPrice\": 53.0000,\n \"UnitsInStock\": 20,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 10,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 7,\n \"CategoryName\": \"Produce\",\n \"Description\": \"Dried fruit and bean curd\"\n }\n}, {\n \"ProductID\": 52,\n \"ProductName\": \"Filo Mix\",\n \"SupplierID\": 24,\n \"CategoryID\": 5,\n \"QuantityPerUnit\": \"16 - 2 kg boxes\",\n \"UnitPrice\": 7.0000,\n \"UnitsInStock\": 38,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 25,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 5,\n \"CategoryName\": \"Grains/Cereals\",\n \"Description\": \"Breads, crackers, pasta, and cereal\"\n }\n}, {\n \"ProductID\": 53,\n \"ProductName\": \"Perth Pasties\",\n \"SupplierID\": 24,\n \"CategoryID\": 6,\n \"QuantityPerUnit\": \"48 pieces\",\n \"UnitPrice\": 32.8000,\n \"UnitsInStock\": 0,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 0,\n \"Discontinued\": true,\n \"Category\": {\n \"CategoryID\": 6,\n \"CategoryName\": \"Meat/Poultry\",\n \"Description\": \"Prepared meats\"\n }\n}, {\n \"ProductID\": 54,\n \"ProductName\": \"Tourti\u00E8re\",\n \"SupplierID\": 25,\n \"CategoryID\": 6,\n \"QuantityPerUnit\": \"16 pies\",\n \"UnitPrice\": 7.4500,\n \"UnitsInStock\": 21,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 10,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 6,\n \"CategoryName\": \"Meat/Poultry\",\n \"Description\": \"Prepared meats\"\n }\n}, {\n \"ProductID\": 55,\n \"ProductName\": \"P\u00E2t\u00E9 chinois\",\n \"SupplierID\": 25,\n \"CategoryID\": 6,\n \"QuantityPerUnit\": \"24 boxes x 2 pies\",\n \"UnitPrice\": 24.0000,\n \"UnitsInStock\": 115,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 20,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 6,\n \"CategoryName\": \"Meat/Poultry\",\n \"Description\": \"Prepared meats\"\n }\n}, {\n \"ProductID\": 56,\n \"ProductName\": \"Gnocchi di nonna Alice\",\n \"SupplierID\": 26,\n \"CategoryID\": 5,\n \"QuantityPerUnit\": \"24 - 250 g pkgs.\",\n \"UnitPrice\": 38.0000,\n \"UnitsInStock\": 21,\n \"UnitsOnOrder\": 10,\n \"ReorderLevel\": 30,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 5,\n \"CategoryName\": \"Grains/Cereals\",\n \"Description\": \"Breads, crackers, pasta, and cereal\"\n }\n}, {\n \"ProductID\": 57,\n \"ProductName\": \"Ravioli Angelo\",\n \"SupplierID\": 26,\n \"CategoryID\": 5,\n \"QuantityPerUnit\": \"24 - 250 g pkgs.\",\n \"UnitPrice\": 19.5000,\n \"UnitsInStock\": 36,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 20,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 5,\n \"CategoryName\": \"Grains/Cereals\",\n \"Description\": \"Breads, crackers, pasta, and cereal\"\n }\n}, {\n \"ProductID\": 58,\n \"ProductName\": \"Escargots de Bourgogne\",\n \"SupplierID\": 27,\n \"CategoryID\": 8,\n \"QuantityPerUnit\": \"24 pieces\",\n \"UnitPrice\": 13.2500,\n \"UnitsInStock\": 62,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 20,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 8,\n \"CategoryName\": \"Seafood\",\n \"Description\": \"Seaweed and fish\"\n }\n}, {\n \"ProductID\": 59,\n \"ProductName\": \"Raclette Courdavault\",\n \"SupplierID\": 28,\n \"CategoryID\": 4,\n \"QuantityPerUnit\": \"5 kg pkg.\",\n \"UnitPrice\": 55.0000,\n \"UnitsInStock\": 79,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 0,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 4,\n \"CategoryName\": \"Dairy Products\",\n \"Description\": \"Cheeses\"\n }\n}, {\n \"ProductID\": 60,\n \"ProductName\": \"Camembert Pierrot\",\n \"SupplierID\": 28,\n \"CategoryID\": 4,\n \"QuantityPerUnit\": \"15 - 300 g rounds\",\n \"UnitPrice\": 34.0000,\n \"UnitsInStock\": 19,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 0,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 4,\n \"CategoryName\": \"Dairy Products\",\n \"Description\": \"Cheeses\"\n }\n}, {\n \"ProductID\": 61,\n \"ProductName\": \"Sirop d'\u00E9rable\",\n \"SupplierID\": 29,\n \"CategoryID\": 2,\n \"QuantityPerUnit\": \"24 - 500 ml bottles\",\n \"UnitPrice\": 28.5000,\n \"UnitsInStock\": 113,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 25,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 2,\n \"CategoryName\": \"Condiments\",\n \"Description\": \"Sweet and savory sauces, relishes, spreads, and seasonings\"\n }\n}, {\n \"ProductID\": 62,\n \"ProductName\": \"Tarte au sucre\",\n \"SupplierID\": 29,\n \"CategoryID\": 3,\n \"QuantityPerUnit\": \"48 pies\",\n \"UnitPrice\": 49.3000,\n \"UnitsInStock\": 17,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 0,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 3,\n \"CategoryName\": \"Confections\",\n \"Description\": \"Desserts, candies, and sweet breads\"\n }\n}, {\n \"ProductID\": 63,\n \"ProductName\": \"Vegie-spread\",\n \"SupplierID\": 7,\n \"CategoryID\": 2,\n \"QuantityPerUnit\": \"15 - 625 g jars\",\n \"UnitPrice\": 43.9000,\n \"UnitsInStock\": 24,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 5,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 2,\n \"CategoryName\": \"Condiments\",\n \"Description\": \"Sweet and savory sauces, relishes, spreads, and seasonings\"\n }\n}, {\n \"ProductID\": 64,\n \"ProductName\": \"Wimmers gute Semmelkn\u00F6del\",\n \"SupplierID\": 12,\n \"CategoryID\": 5,\n \"QuantityPerUnit\": \"20 bags x 4 pieces\",\n \"UnitPrice\": 33.2500,\n \"UnitsInStock\": 22,\n \"UnitsOnOrder\": 80,\n \"ReorderLevel\": 30,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 5,\n \"CategoryName\": \"Grains/Cereals\",\n \"Description\": \"Breads, crackers, pasta, and cereal\"\n }\n}, {\n \"ProductID\": 65,\n \"ProductName\": \"Louisiana Fiery Hot Pepper Sauce\",\n \"SupplierID\": 2,\n \"CategoryID\": 2,\n \"QuantityPerUnit\": \"32 - 8 oz bottles\",\n \"UnitPrice\": 21.0500,\n \"UnitsInStock\": 76,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 0,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 2,\n \"CategoryName\": \"Condiments\",\n \"Description\": \"Sweet and savory sauces, relishes, spreads, and seasonings\"\n }\n}, {\n \"ProductID\": 66,\n \"ProductName\": \"Louisiana Hot Spiced Okra\",\n \"SupplierID\": 2,\n \"CategoryID\": 2,\n \"QuantityPerUnit\": \"24 - 8 oz jars\",\n \"UnitPrice\": 17.0000,\n \"UnitsInStock\": 4,\n \"UnitsOnOrder\": 100,\n \"ReorderLevel\": 20,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 2,\n \"CategoryName\": \"Condiments\",\n \"Description\": \"Sweet and savory sauces, relishes, spreads, and seasonings\"\n }\n}, {\n \"ProductID\": 67,\n \"ProductName\": \"Laughing Lumberjack Lager\",\n \"SupplierID\": 16,\n \"CategoryID\": 1,\n \"QuantityPerUnit\": \"24 - 12 oz bottles\",\n \"UnitPrice\": 14.0000,\n \"UnitsInStock\": 52,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 10,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 1,\n \"CategoryName\": \"Beverages\",\n \"Description\": \"Soft drinks, coffees, teas, beers, and ales\"\n }\n}, {\n \"ProductID\": 68,\n \"ProductName\": \"Scottish Longbreads\",\n \"SupplierID\": 8,\n \"CategoryID\": 3,\n \"QuantityPerUnit\": \"10 boxes x 8 pieces\",\n \"UnitPrice\": 12.5000,\n \"UnitsInStock\": 6,\n \"UnitsOnOrder\": 10,\n \"ReorderLevel\": 15,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 3,\n \"CategoryName\": \"Confections\",\n \"Description\": \"Desserts, candies, and sweet breads\"\n }\n}, {\n \"ProductID\": 69,\n \"ProductName\": \"Gudbrandsdalsost\",\n \"SupplierID\": 15,\n \"CategoryID\": 4,\n \"QuantityPerUnit\": \"10 kg pkg.\",\n \"UnitPrice\": 36.0000,\n \"UnitsInStock\": 26,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 15,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 4,\n \"CategoryName\": \"Dairy Products\",\n \"Description\": \"Cheeses\"\n }\n}, {\n \"ProductID\": 70,\n \"ProductName\": \"Outback Lager\",\n \"SupplierID\": 7,\n \"CategoryID\": 1,\n \"QuantityPerUnit\": \"24 - 355 ml bottles\",\n \"UnitPrice\": 15.0000,\n \"UnitsInStock\": 15,\n \"UnitsOnOrder\": 10,\n \"ReorderLevel\": 30,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 1,\n \"CategoryName\": \"Beverages\",\n \"Description\": \"Soft drinks, coffees, teas, beers, and ales\"\n }\n}, {\n \"ProductID\": 71,\n \"ProductName\": \"Flotemysost\",\n \"SupplierID\": 15,\n \"CategoryID\": 4,\n \"QuantityPerUnit\": \"10 - 500 g pkgs.\",\n \"UnitPrice\": 21.5000,\n \"UnitsInStock\": 26,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 0,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 4,\n \"CategoryName\": \"Dairy Products\",\n \"Description\": \"Cheeses\"\n }\n}, {\n \"ProductID\": 72,\n \"ProductName\": \"Mozzarella di Giovanni\",\n \"SupplierID\": 14,\n \"CategoryID\": 4,\n \"QuantityPerUnit\": \"24 - 200 g pkgs.\",\n \"UnitPrice\": 34.8000,\n \"UnitsInStock\": 14,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 0,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 4,\n \"CategoryName\": \"Dairy Products\",\n \"Description\": \"Cheeses\"\n }\n}, {\n \"ProductID\": 73,\n \"ProductName\": \"R\u00F6d Kaviar\",\n \"SupplierID\": 17,\n \"CategoryID\": 8,\n \"QuantityPerUnit\": \"24 - 150 g jars\",\n \"UnitPrice\": 15.0000,\n \"UnitsInStock\": 101,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 5,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 8,\n \"CategoryName\": \"Seafood\",\n \"Description\": \"Seaweed and fish\"\n }\n}, {\n \"ProductID\": 74,\n \"ProductName\": \"Longlife Tofu\",\n \"SupplierID\": 4,\n \"CategoryID\": 7,\n \"QuantityPerUnit\": \"5 kg pkg.\",\n \"UnitPrice\": 10.0000,\n \"UnitsInStock\": 4,\n \"UnitsOnOrder\": 20,\n \"ReorderLevel\": 5,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 7,\n \"CategoryName\": \"Produce\",\n \"Description\": \"Dried fruit and bean curd\"\n }\n}, {\n \"ProductID\": 75,\n \"ProductName\": \"Rh\u00F6nbr\u00E4u Klosterbier\",\n \"SupplierID\": 12,\n \"CategoryID\": 1,\n \"QuantityPerUnit\": \"24 - 0.5 l bottles\",\n \"UnitPrice\": 7.7500,\n \"UnitsInStock\": 125,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 25,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 1,\n \"CategoryName\": \"Beverages\",\n \"Description\": \"Soft drinks, coffees, teas, beers, and ales\"\n }\n}, {\n \"ProductID\": 76,\n \"ProductName\": \"Lakkalik\u00F6\u00F6ri\",\n \"SupplierID\": 23,\n \"CategoryID\": 1,\n \"QuantityPerUnit\": \"500 ml\",\n \"UnitPrice\": 18.0000,\n \"UnitsInStock\": 57,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 20,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 1,\n \"CategoryName\": \"Beverages\",\n \"Description\": \"Soft drinks, coffees, teas, beers, and ales\"\n }\n}, {\n \"ProductID\": 77,\n \"ProductName\": \"Original Frankfurter gr\u00FCne So\u00DFe\",\n \"SupplierID\": 12,\n \"CategoryID\": 2,\n \"QuantityPerUnit\": \"12 boxes\",\n \"UnitPrice\": 13.0000,\n \"UnitsInStock\": 32,\n \"UnitsOnOrder\": 0,\n \"ReorderLevel\": 15,\n \"Discontinued\": false,\n \"Category\": {\n \"CategoryID\": 2,\n \"CategoryName\": \"Condiments\",\n \"Description\": \"Sweet and savory sauces, relishes, spreads, and seasonings\"\n }\n}];"; | ||
export declare const productsSourceCode = "export const products = [{\n ProductID: 1,\n ProductName: 'Chai',\n SupplierID: 1,\n CategoryID: 1,\n QuantityPerUnit: '10 boxes x 20 bags',\n UnitPrice: 18.0000,\n UnitsInStock: 39,\n UnitsOnOrder: 0,\n ReorderLevel: 10,\n Discontinued: false,\n Category: {\n CategoryID: 1,\n CategoryName: 'Beverages',\n Description: 'Soft drinks, coffees, teas, beers, and ales'\n }\n}, {\n ProductID: 2,\n ProductName: 'Chang',\n SupplierID: 1,\n CategoryID: 1,\n QuantityPerUnit: '24 - 12 oz bottles',\n UnitPrice: 19.0000,\n UnitsInStock: 17,\n UnitsOnOrder: 40,\n ReorderLevel: 25,\n Discontinued: false,\n Category: {\n CategoryID: 1,\n CategoryName: 'Beverages',\n Description: 'Soft drinks, coffees, teas, beers, and ales'\n }\n}, {\n ProductID: 3,\n ProductName: 'Aniseed Syrup',\n SupplierID: 1,\n CategoryID: 2,\n QuantityPerUnit: '12 - 550 ml bottles',\n UnitPrice: 10.0000,\n UnitsInStock: 13,\n UnitsOnOrder: 70,\n ReorderLevel: 25,\n Discontinued: false,\n Category: {\n CategoryID: 2,\n CategoryName: 'Condiments',\n Description: 'Sweet and savory sauces, relishes, spreads, and seasonings'\n }\n}, {\n ProductID: 4,\n ProductName: 'Chef Antons Cajun Seasoning',\n SupplierID: 2,\n CategoryID: 2,\n QuantityPerUnit: '48 - 6 oz jars',\n UnitPrice: 22.0000,\n UnitsInStock: 53,\n UnitsOnOrder: 0,\n ReorderLevel: 0,\n Discontinued: false,\n Category: {\n CategoryID: 2,\n CategoryName: 'Condiments',\n Description: 'Sweet and savory sauces, relishes, spreads, and seasonings'\n }\n}, {\n ProductID: 5,\n ProductName: 'Chef Antons Gumbo Mix',\n SupplierID: 2,\n CategoryID: 2,\n QuantityPerUnit: '36 boxes',\n UnitPrice: 21.3500,\n UnitsInStock: 0,\n UnitsOnOrder: 0,\n ReorderLevel: 0,\n Discontinued: true,\n Category: {\n CategoryID: 2,\n CategoryName: 'Condiments',\n Description: 'Sweet and savory sauces, relishes, spreads, and seasonings'\n }\n}, {\n ProductID: 6,\n ProductName: 'Grandmas Boysenberry Spread',\n SupplierID: 3,\n CategoryID: 2,\n QuantityPerUnit: '12 - 8 oz jars',\n UnitPrice: 25.0000,\n UnitsInStock: 120,\n UnitsOnOrder: 0,\n ReorderLevel: 25,\n Discontinued: false,\n Category: {\n CategoryID: 2,\n CategoryName: 'Condiments',\n Description: 'Sweet and savory sauces, relishes, spreads, and seasonings'\n }\n}, {\n ProductID: 7,\n ProductName: 'Uncle Bobs Organic Dried Pears',\n SupplierID: 3,\n CategoryID: 7,\n QuantityPerUnit: '12 - 1 lb pkgs.',\n UnitPrice: 30.0000,\n UnitsInStock: 15,\n UnitsOnOrder: 0,\n ReorderLevel: 10,\n Discontinued: false,\n Category: {\n CategoryID: 7,\n CategoryName: 'Produce',\n Description: 'Dried fruit and bean curd'\n }\n}, {\n ProductID: 8,\n ProductName: 'Northwoods Cranberry Sauce',\n SupplierID: 3,\n CategoryID: 2,\n QuantityPerUnit: '12 - 12 oz jars',\n UnitPrice: 40.0000,\n UnitsInStock: 6,\n UnitsOnOrder: 0,\n ReorderLevel: 0,\n Discontinued: false,\n Category: {\n CategoryID: 2,\n CategoryName: 'Condiments',\n Description: 'Sweet and savory sauces, relishes, spreads, and seasonings'\n }\n}, {\n ProductID: 9,\n ProductName: 'Mishi Kobe Niku',\n SupplierID: 4,\n CategoryID: 6,\n QuantityPerUnit: '18 - 500 g pkgs.',\n UnitPrice: 97.0000,\n UnitsInStock: 29,\n UnitsOnOrder: 0,\n ReorderLevel: 0,\n Discontinued: true,\n Category: {\n CategoryID: 6,\n CategoryName: 'Meat/Poultry',\n Description: 'Prepared meats'\n }\n}, {\n ProductID: 10,\n ProductName: 'Ikura',\n SupplierID: 4,\n CategoryID: 8,\n QuantityPerUnit: '12 - 200 ml jars',\n UnitPrice: 31.0000,\n UnitsInStock: 31,\n UnitsOnOrder: 0,\n ReorderLevel: 0,\n Discontinued: false,\n Category: {\n CategoryID: 8,\n CategoryName: 'Seafood',\n Description: 'Seaweed and fish'\n }\n}, {\n ProductID: 11,\n ProductName: 'Queso Cabrales',\n SupplierID: 5,\n CategoryID: 4,\n QuantityPerUnit: '1 kg pkg.',\n UnitPrice: 21.0000,\n UnitsInStock: 22,\n UnitsOnOrder: 30,\n ReorderLevel: 30,\n Discontinued: false,\n Category: {\n CategoryID: 4,\n CategoryName: 'Dairy Products',\n Description: 'Cheeses'\n }\n}, {\n ProductID: 12,\n ProductName: 'Queso Manchego La Pastora',\n SupplierID: 5,\n CategoryID: 4,\n QuantityPerUnit: '10 - 500 g pkgs.',\n UnitPrice: 38.0000,\n UnitsInStock: 86,\n UnitsOnOrder: 0,\n ReorderLevel: 0,\n Discontinued: false,\n Category: {\n CategoryID: 4,\n CategoryName: 'Dairy Products',\n Description: 'Cheeses'\n }\n}, {\n ProductID: 13,\n ProductName: 'Konbu',\n SupplierID: 6,\n CategoryID: 8,\n QuantityPerUnit: '2 kg box',\n UnitPrice: 6.0000,\n UnitsInStock: 24,\n UnitsOnOrder: 0,\n ReorderLevel: 5,\n Discontinued: false,\n Category: {\n CategoryID: 8,\n CategoryName: 'Seafood',\n Description: 'Seaweed and fish'\n }\n}, {\n ProductID: 14,\n ProductName: 'Tofu',\n SupplierID: 6,\n CategoryID: 7,\n QuantityPerUnit: '40 - 100 g pkgs.',\n UnitPrice: 23.2500,\n UnitsInStock: 35,\n UnitsOnOrder: 0,\n ReorderLevel: 0,\n Discontinued: false,\n Category: {\n CategoryID: 7,\n CategoryName: 'Produce',\n Description: 'Dried fruit and bean curd'\n }\n}, {\n ProductID: 15,\n ProductName: 'Genen Shouyu',\n SupplierID: 6,\n CategoryID: 2,\n QuantityPerUnit: '24 - 250 ml bottles',\n UnitPrice: 15.5000,\n UnitsInStock: 39,\n UnitsOnOrder: 0,\n ReorderLevel: 5,\n Discontinued: false,\n Category: {\n CategoryID: 2,\n CategoryName: 'Condiments',\n Description: 'Sweet and savory sauces, relishes, spreads, and seasonings'\n }\n}, {\n ProductID: 16,\n ProductName: 'Pavlova',\n SupplierID: 7,\n CategoryID: 3,\n QuantityPerUnit: '32 - 500 g boxes',\n UnitPrice: 17.4500,\n UnitsInStock: 29,\n UnitsOnOrder: 0,\n ReorderLevel: 10,\n Discontinued: false,\n Category: {\n CategoryID: 3,\n CategoryName: 'Confections',\n Description: 'Desserts, candies, and sweet breads'\n }\n}, {\n ProductID: 17,\n ProductName: 'Alice Mutton',\n SupplierID: 7,\n CategoryID: 6,\n QuantityPerUnit: '20 - 1 kg tins',\n UnitPrice: 39.0000,\n UnitsInStock: 0,\n UnitsOnOrder: 0,\n ReorderLevel: 0,\n Discontinued: true,\n Category: {\n CategoryID: 6,\n CategoryName: 'Meat/Poultry',\n Description: 'Prepared meats'\n }\n}, {\n ProductID: 18,\n ProductName: 'Carnarvon Tigers',\n SupplierID: 7,\n CategoryID: 8,\n QuantityPerUnit: '16 kg pkg.',\n UnitPrice: 62.5000,\n UnitsInStock: 42,\n UnitsOnOrder: 0,\n ReorderLevel: 0,\n Discontinued: false,\n Category: {\n CategoryID: 8,\n CategoryName: 'Seafood',\n Description: 'Seaweed and fish'\n }\n}, {\n ProductID: 19,\n ProductName: 'Teatime Chocolate Biscuits',\n SupplierID: 8,\n CategoryID: 3,\n QuantityPerUnit: '10 boxes x 12 pieces',\n UnitPrice: 9.2000,\n UnitsInStock: 25,\n UnitsOnOrder: 0,\n ReorderLevel: 5,\n Discontinued: false,\n Category: {\n CategoryID: 3,\n CategoryName: 'Confections',\n Description: 'Desserts, candies, and sweet breads'\n }\n}, {\n ProductID: 20,\n ProductName: 'Sir Rodneys Marmalade',\n SupplierID: 8,\n CategoryID: 3,\n QuantityPerUnit: '30 gift boxes',\n UnitPrice: 81.0000,\n UnitsInStock: 40,\n UnitsOnOrder: 0,\n ReorderLevel: 0,\n Discontinued: false,\n Category: {\n CategoryID: 3,\n CategoryName: 'Confections',\n Description: 'Desserts, candies, and sweet breads'\n }\n}, {\n ProductID: 21,\n ProductName: 'Sir Rodneys Scones',\n SupplierID: 8,\n CategoryID: 3,\n QuantityPerUnit: '24 pkgs. x 4 pieces',\n UnitPrice: 10.0000,\n UnitsInStock: 3,\n UnitsOnOrder: 40,\n ReorderLevel: 5,\n Discontinued: false,\n Category: {\n CategoryID: 3,\n CategoryName: 'Confections',\n Description: 'Desserts, candies, and sweet breads'\n }\n}, {\n ProductID: 22,\n ProductName: 'Gustafs Kn\u00E4ckebr\u00F6d',\n SupplierID: 9,\n CategoryID: 5,\n QuantityPerUnit: '24 - 500 g pkgs.',\n UnitPrice: 21.0000,\n UnitsInStock: 104,\n UnitsOnOrder: 0,\n ReorderLevel: 25,\n Discontinued: false,\n Category: {\n CategoryID: 5,\n CategoryName: 'Grains/Cereals',\n Description: 'Breads, crackers, pasta, and cereal'\n }\n}, {\n ProductID: 23,\n ProductName: 'Tunnbr\u00F6d',\n SupplierID: 9,\n CategoryID: 5,\n QuantityPerUnit: '12 - 250 g pkgs.',\n UnitPrice: 9.0000,\n UnitsInStock: 61,\n UnitsOnOrder: 0,\n ReorderLevel: 25,\n Discontinued: false,\n Category: {\n CategoryID: 5,\n CategoryName: 'Grains/Cereals',\n Description: 'Breads, crackers, pasta, and cereal'\n }\n}, {\n ProductID: 24,\n ProductName: 'Guaran\u00E1 Fant\u00E1stica',\n SupplierID: 10,\n CategoryID: 1,\n QuantityPerUnit: '12 - 355 ml cans',\n UnitPrice: 4.5000,\n UnitsInStock: 20,\n UnitsOnOrder: 0,\n ReorderLevel: 0,\n Discontinued: true,\n Category: {\n CategoryID: 1,\n CategoryName: 'Beverages',\n Description: 'Soft drinks, coffees, teas, beers, and ales'\n }\n}, {\n ProductID: 25,\n ProductName: 'NuNuCa Nu\u00DF-Nougat-Creme',\n SupplierID: 11,\n CategoryID: 3,\n QuantityPerUnit: '20 - 450 g glasses',\n UnitPrice: 14.0000,\n UnitsInStock: 76,\n UnitsOnOrder: 0,\n ReorderLevel: 30,\n Discontinued: false,\n Category: {\n CategoryID: 3,\n CategoryName: 'Confections',\n Description: 'Desserts, candies, and sweet breads'\n }\n}, {\n ProductID: 26,\n ProductName: 'Gumb\u00E4r Gummib\u00E4rchen',\n SupplierID: 11,\n CategoryID: 3,\n QuantityPerUnit: '100 - 250 g bags',\n UnitPrice: 31.2300,\n UnitsInStock: 15,\n UnitsOnOrder: 0,\n ReorderLevel: 0,\n Discontinued: false,\n Category: {\n CategoryID: 3,\n CategoryName: 'Confections',\n Description: 'Desserts, candies, and sweet breads'\n }\n}, {\n ProductID: 27,\n ProductName: 'Schoggi Schokolade',\n SupplierID: 11,\n CategoryID: 3,\n QuantityPerUnit: '100 - 100 g pieces',\n UnitPrice: 43.9000,\n UnitsInStock: 49,\n UnitsOnOrder: 0,\n ReorderLevel: 30,\n Discontinued: false,\n Category: {\n CategoryID: 3,\n CategoryName: 'Confections',\n Description: 'Desserts, candies, and sweet breads'\n }\n}, {\n ProductID: 28,\n ProductName: 'R\u00F6ssle Sauerkraut',\n SupplierID: 12,\n CategoryID: 7,\n QuantityPerUnit: '25 - 825 g cans',\n UnitPrice: 45.6000,\n UnitsInStock: 26,\n UnitsOnOrder: 0,\n ReorderLevel: 0,\n Discontinued: true,\n Category: {\n CategoryID: 7,\n CategoryName: 'Produce',\n Description: 'Dried fruit and bean curd'\n }\n}, {\n ProductID: 29,\n ProductName: 'Th\u00FCringer Rostbratwurst',\n SupplierID: 12,\n CategoryID: 6,\n QuantityPerUnit: '50 bags x 30 sausgs.',\n UnitPrice: 123.7900,\n UnitsInStock: 0,\n UnitsOnOrder: 0,\n ReorderLevel: 0,\n Discontinued: true,\n Category: {\n CategoryID: 6,\n CategoryName: 'Meat/Poultry',\n Description: 'Prepared meats'\n }\n}, {\n ProductID: 30,\n ProductName: 'Nord-Ost Matjeshering',\n SupplierID: 13,\n CategoryID: 8,\n QuantityPerUnit: '10 - 200 g glasses',\n UnitPrice: 25.8900,\n UnitsInStock: 10,\n UnitsOnOrder: 0,\n ReorderLevel: 15,\n Discontinued: false,\n Category: {\n CategoryID: 8,\n CategoryName: 'Seafood',\n Description: 'Seaweed and fish'\n }\n}, {\n ProductID: 31,\n ProductName: 'Gorgonzola Telino',\n SupplierID: 14,\n CategoryID: 4,\n QuantityPerUnit: '12 - 100 g pkgs',\n UnitPrice: 12.5000,\n UnitsInStock: 0,\n UnitsOnOrder: 70,\n ReorderLevel: 20,\n Discontinued: false,\n Category: {\n CategoryID: 4,\n CategoryName: 'Dairy Products',\n Description: 'Cheeses'\n }\n}, {\n ProductID: 32,\n ProductName: 'Mascarpone Fabioli',\n SupplierID: 14,\n CategoryID: 4,\n QuantityPerUnit: '24 - 200 g pkgs.',\n UnitPrice: 32.0000,\n UnitsInStock: 9,\n UnitsOnOrder: 40,\n ReorderLevel: 25,\n Discontinued: false,\n Category: {\n CategoryID: 4,\n CategoryName: 'Dairy Products',\n Description: 'Cheeses'\n }\n}, {\n ProductID: 33,\n ProductName: 'Geitost',\n SupplierID: 15,\n CategoryID: 4,\n QuantityPerUnit: '500 g',\n UnitPrice: 2.5000,\n UnitsInStock: 112,\n UnitsOnOrder: 0,\n ReorderLevel: 20,\n Discontinued: false,\n Category: {\n CategoryID: 4,\n CategoryName: 'Dairy Products',\n Description: 'Cheeses'\n }\n}, {\n ProductID: 34,\n ProductName: 'Sasquatch Ale',\n SupplierID: 16,\n CategoryID: 1,\n QuantityPerUnit: '24 - 12 oz bottles',\n UnitPrice: 14.0000,\n UnitsInStock: 111,\n UnitsOnOrder: 0,\n ReorderLevel: 15,\n Discontinued: false,\n Category: {\n CategoryID: 1,\n CategoryName: 'Beverages',\n Description: 'Soft drinks, coffees, teas, beers, and ales'\n }\n}, {\n ProductID: 35,\n ProductName: 'Steeleye Stout',\n SupplierID: 16,\n CategoryID: 1,\n QuantityPerUnit: '24 - 12 oz bottles',\n UnitPrice: 18.0000,\n UnitsInStock: 20,\n UnitsOnOrder: 0,\n ReorderLevel: 15,\n Discontinued: false,\n Category: {\n CategoryID: 1,\n CategoryName: 'Beverages',\n Description: 'Soft drinks, coffees, teas, beers, and ales'\n }\n}, {\n ProductID: 36,\n ProductName: 'Inlagd Sill',\n SupplierID: 17,\n CategoryID: 8,\n QuantityPerUnit: '24 - 250 g jars',\n UnitPrice: 19.0000,\n UnitsInStock: 112,\n UnitsOnOrder: 0,\n ReorderLevel: 20,\n Discontinued: false,\n Category: {\n CategoryID: 8,\n CategoryName: 'Seafood',\n Description: 'Seaweed and fish'\n }\n}, {\n ProductID: 37,\n ProductName: 'Gravad lax',\n SupplierID: 17,\n CategoryID: 8,\n QuantityPerUnit: '12 - 500 g pkgs.',\n UnitPrice: 26.0000,\n UnitsInStock: 11,\n UnitsOnOrder: 50,\n ReorderLevel: 25,\n Discontinued: false,\n Category: {\n CategoryID: 8,\n CategoryName: 'Seafood',\n Description: 'Seaweed and fish'\n }\n}, {\n ProductID: 38,\n ProductName: 'C\u00F4te de Blaye',\n SupplierID: 18,\n CategoryID: 1,\n QuantityPerUnit: '12 - 75 cl bottles',\n UnitPrice: 263.5000,\n UnitsInStock: 17,\n UnitsOnOrder: 0,\n ReorderLevel: 15,\n Discontinued: false,\n Category: {\n CategoryID: 1,\n CategoryName: 'Beverages',\n Description: 'Soft drinks, coffees, teas, beers, and ales'\n }\n}, {\n ProductID: 39,\n ProductName: 'Chartreuse verte',\n SupplierID: 18,\n CategoryID: 1,\n QuantityPerUnit: '750 cc per bottle',\n UnitPrice: 18.0000,\n UnitsInStock: 69,\n UnitsOnOrder: 0,\n ReorderLevel: 5,\n Discontinued: false,\n Category: {\n CategoryID: 1,\n CategoryName: 'Beverages',\n Description: 'Soft drinks, coffees, teas, beers, and ales'\n }\n}, {\n ProductID: 40,\n ProductName: 'Boston Crab Meat',\n SupplierID: 19,\n CategoryID: 8,\n QuantityPerUnit: '24 - 4 oz tins',\n UnitPrice: 18.4000,\n UnitsInStock: 123,\n UnitsOnOrder: 0,\n ReorderLevel: 30,\n Discontinued: false,\n Category: {\n CategoryID: 8,\n CategoryName: 'Seafood',\n Description: 'Seaweed and fish'\n }\n}, {\n ProductID: 41,\n ProductName: 'Jacks New England Clam Chowder',\n SupplierID: 19,\n CategoryID: 8,\n QuantityPerUnit: '12 - 12 oz cans',\n UnitPrice: 9.6500,\n UnitsInStock: 85,\n UnitsOnOrder: 0,\n ReorderLevel: 10,\n Discontinued: false,\n Category: {\n CategoryID: 8,\n CategoryName: 'Seafood',\n Description: 'Seaweed and fish'\n }\n}, {\n ProductID: 42,\n ProductName: 'Singaporean Hokkien Fried Mee',\n SupplierID: 20,\n CategoryID: 5,\n QuantityPerUnit: '32 - 1 kg pkgs.',\n UnitPrice: 14.0000,\n UnitsInStock: 26,\n UnitsOnOrder: 0,\n ReorderLevel: 0,\n Discontinued: true,\n Category: {\n CategoryID: 5,\n CategoryName: 'Grains/Cereals',\n Description: 'Breads, crackers, pasta, and cereal'\n }\n}, {\n ProductID: 43,\n ProductName: 'Ipoh Coffee',\n SupplierID: 20,\n CategoryID: 1,\n QuantityPerUnit: '16 - 500 g tins',\n UnitPrice: 46.0000,\n UnitsInStock: 17,\n UnitsOnOrder: 10,\n ReorderLevel: 25,\n Discontinued: false,\n Category: {\n CategoryID: 1,\n CategoryName: 'Beverages',\n Description: 'Soft drinks, coffees, teas, beers, and ales'\n }\n}, {\n ProductID: 44,\n ProductName: 'Gula Malacca',\n SupplierID: 20,\n CategoryID: 2,\n QuantityPerUnit: '20 - 2 kg bags',\n UnitPrice: 19.4500,\n UnitsInStock: 27,\n UnitsOnOrder: 0,\n ReorderLevel: 15,\n Discontinued: false,\n Category: {\n CategoryID: 2,\n CategoryName: 'Condiments',\n Description: 'Sweet and savory sauces, relishes, spreads, and seasonings'\n }\n}, {\n ProductID: 45,\n ProductName: 'Rogede sild',\n SupplierID: 21,\n CategoryID: 8,\n QuantityPerUnit: '1k pkg.',\n UnitPrice: 9.5000,\n UnitsInStock: 5,\n UnitsOnOrder: 70,\n ReorderLevel: 15,\n Discontinued: false,\n Category: {\n CategoryID: 8,\n CategoryName: 'Seafood',\n Description: 'Seaweed and fish'\n }\n}, {\n ProductID: 46,\n ProductName: 'Spegesild',\n SupplierID: 21,\n CategoryID: 8,\n QuantityPerUnit: '4 - 450 g glasses',\n UnitPrice: 12.0000,\n UnitsInStock: 95,\n UnitsOnOrder: 0,\n ReorderLevel: 0,\n Discontinued: false,\n Category: {\n CategoryID: 8,\n CategoryName: 'Seafood',\n Description: 'Seaweed and fish'\n }\n}, {\n ProductID: 47,\n ProductName: 'Zaanse koeken',\n SupplierID: 22,\n CategoryID: 3,\n QuantityPerUnit: '10 - 4 oz boxes',\n UnitPrice: 9.5000,\n UnitsInStock: 36,\n UnitsOnOrder: 0,\n ReorderLevel: 0,\n Discontinued: false,\n Category: {\n CategoryID: 3,\n CategoryName: 'Confections',\n Description: 'Desserts, candies, and sweet breads'\n }\n}, {\n ProductID: 48,\n ProductName: 'Chocolade',\n SupplierID: 22,\n CategoryID: 3,\n QuantityPerUnit: '10 pkgs.',\n UnitPrice: 12.7500,\n UnitsInStock: 15,\n UnitsOnOrder: 70,\n ReorderLevel: 25,\n Discontinued: false,\n Category: {\n CategoryID: 3,\n CategoryName: 'Confections',\n Description: 'Desserts, candies, and sweet breads'\n }\n}, {\n ProductID: 49,\n ProductName: 'Maxilaku',\n SupplierID: 23,\n CategoryID: 3,\n QuantityPerUnit: '24 - 50 g pkgs.',\n UnitPrice: 20.0000,\n UnitsInStock: 10,\n UnitsOnOrder: 60,\n ReorderLevel: 15,\n Discontinued: false,\n Category: {\n CategoryID: 3,\n CategoryName: 'Confections',\n Description: 'Desserts, candies, and sweet breads'\n }\n}, {\n ProductID: 50,\n ProductName: 'Valkoinen suklaa',\n SupplierID: 23,\n CategoryID: 3,\n QuantityPerUnit: '12 - 100 g bars',\n UnitPrice: 16.2500,\n UnitsInStock: 65,\n UnitsOnOrder: 0,\n ReorderLevel: 30,\n Discontinued: false,\n Category: {\n CategoryID: 3,\n CategoryName: 'Confections',\n Description: 'Desserts, candies, and sweet breads'\n }\n}, {\n ProductID: 51,\n ProductName: 'Manjimup Dried Apples',\n SupplierID: 24,\n CategoryID: 7,\n QuantityPerUnit: '50 - 300 g pkgs.',\n UnitPrice: 53.0000,\n UnitsInStock: 20,\n UnitsOnOrder: 0,\n ReorderLevel: 10,\n Discontinued: false,\n Category: {\n CategoryID: 7,\n CategoryName: 'Produce',\n Description: 'Dried fruit and bean curd'\n }\n}, {\n ProductID: 52,\n ProductName: 'Filo Mix',\n SupplierID: 24,\n CategoryID: 5,\n QuantityPerUnit: '16 - 2 kg boxes',\n UnitPrice: 7.0000,\n UnitsInStock: 38,\n UnitsOnOrder: 0,\n ReorderLevel: 25,\n Discontinued: false,\n Category: {\n CategoryID: 5,\n CategoryName: 'Grains/Cereals',\n Description: 'Breads, crackers, pasta, and cereal'\n }\n}, {\n ProductID: 53,\n ProductName: 'Perth Pasties',\n SupplierID: 24,\n CategoryID: 6,\n QuantityPerUnit: '48 pieces',\n UnitPrice: 32.8000,\n UnitsInStock: 0,\n UnitsOnOrder: 0,\n ReorderLevel: 0,\n Discontinued: true,\n Category: {\n CategoryID: 6,\n CategoryName: 'Meat/Poultry',\n Description: 'Prepared meats'\n }\n}, {\n ProductID: 54,\n ProductName: 'Tourti\u00E8re',\n SupplierID: 25,\n CategoryID: 6,\n QuantityPerUnit: '16 pies',\n UnitPrice: 7.4500,\n UnitsInStock: 21,\n UnitsOnOrder: 0,\n ReorderLevel: 10,\n Discontinued: false,\n Category: {\n CategoryID: 6,\n CategoryName: 'Meat/Poultry',\n Description: 'Prepared meats'\n }\n}, {\n ProductID: 55,\n ProductName: 'P\u00E2t\u00E9 chinois',\n SupplierID: 25,\n CategoryID: 6,\n QuantityPerUnit: '24 boxes x 2 pies',\n UnitPrice: 24.0000,\n UnitsInStock: 115,\n UnitsOnOrder: 0,\n ReorderLevel: 20,\n Discontinued: false,\n Category: {\n CategoryID: 6,\n CategoryName: 'Meat/Poultry',\n Description: 'Prepared meats'\n }\n}, {\n ProductID: 56,\n ProductName: 'Gnocchi di nonna Alice',\n SupplierID: 26,\n CategoryID: 5,\n QuantityPerUnit: '24 - 250 g pkgs.',\n UnitPrice: 38.0000,\n UnitsInStock: 21,\n UnitsOnOrder: 10,\n ReorderLevel: 30,\n Discontinued: false,\n Category: {\n CategoryID: 5,\n CategoryName: 'Grains/Cereals',\n Description: 'Breads, crackers, pasta, and cereal'\n }\n}, {\n ProductID: 57,\n ProductName: 'Ravioli Angelo',\n SupplierID: 26,\n CategoryID: 5,\n QuantityPerUnit: '24 - 250 g pkgs.',\n UnitPrice: 19.5000,\n UnitsInStock: 36,\n UnitsOnOrder: 0,\n ReorderLevel: 20,\n Discontinued: false,\n Category: {\n CategoryID: 5,\n CategoryName: 'Grains/Cereals',\n Description: 'Breads, crackers, pasta, and cereal'\n }\n}, {\n ProductID: 58,\n ProductName: 'Escargots de Bourgogne',\n SupplierID: 27,\n CategoryID: 8,\n QuantityPerUnit: '24 pieces',\n UnitPrice: 13.2500,\n UnitsInStock: 62,\n UnitsOnOrder: 0,\n ReorderLevel: 20,\n Discontinued: false,\n Category: {\n CategoryID: 8,\n CategoryName: 'Seafood',\n Description: 'Seaweed and fish'\n }\n}, {\n ProductID: 59,\n ProductName: 'Raclette Courdavault',\n SupplierID: 28,\n CategoryID: 4,\n QuantityPerUnit: '5 kg pkg.',\n UnitPrice: 55.0000,\n UnitsInStock: 79,\n UnitsOnOrder: 0,\n ReorderLevel: 0,\n Discontinued: false,\n Category: {\n CategoryID: 4,\n CategoryName: 'Dairy Products',\n Description: 'Cheeses'\n }\n}, {\n ProductID: 60,\n ProductName: 'Camembert Pierrot',\n SupplierID: 28,\n CategoryID: 4,\n QuantityPerUnit: '15 - 300 g rounds',\n UnitPrice: 34.0000,\n UnitsInStock: 19,\n UnitsOnOrder: 0,\n ReorderLevel: 0,\n Discontinued: false,\n Category: {\n CategoryID: 4,\n CategoryName: 'Dairy Products',\n Description: 'Cheeses'\n }\n}, {\n ProductID: 61,\n ProductName: 'Sirop d\u00E9rable',\n SupplierID: 29,\n CategoryID: 2,\n QuantityPerUnit: '24 - 500 ml bottles',\n UnitPrice: 28.5000,\n UnitsInStock: 113,\n UnitsOnOrder: 0,\n ReorderLevel: 25,\n Discontinued: false,\n Category: {\n CategoryID: 2,\n CategoryName: 'Condiments',\n Description: 'Sweet and savory sauces, relishes, spreads, and seasonings'\n }\n}, {\n ProductID: 62,\n ProductName: 'Tarte au sucre',\n SupplierID: 29,\n CategoryID: 3,\n QuantityPerUnit: '48 pies',\n UnitPrice: 49.3000,\n UnitsInStock: 17,\n UnitsOnOrder: 0,\n ReorderLevel: 0,\n Discontinued: false,\n Category: {\n CategoryID: 3,\n CategoryName: 'Confections',\n Description: 'Desserts, candies, and sweet breads'\n }\n}, {\n ProductID: 63,\n ProductName: 'Vegie-spread',\n SupplierID: 7,\n CategoryID: 2,\n QuantityPerUnit: '15 - 625 g jars',\n UnitPrice: 43.9000,\n UnitsInStock: 24,\n UnitsOnOrder: 0,\n ReorderLevel: 5,\n Discontinued: false,\n Category: {\n CategoryID: 2,\n CategoryName: 'Condiments',\n Description: 'Sweet and savory sauces, relishes, spreads, and seasonings'\n }\n}, {\n ProductID: 64,\n ProductName: 'Wimmers gute Semmelkn\u00F6del',\n SupplierID: 12,\n CategoryID: 5,\n QuantityPerUnit: '20 bags x 4 pieces',\n UnitPrice: 33.2500,\n UnitsInStock: 22,\n UnitsOnOrder: 80,\n ReorderLevel: 30,\n Discontinued: false,\n Category: {\n CategoryID: 5,\n CategoryName: 'Grains/Cereals',\n Description: 'Breads, crackers, pasta, and cereal'\n }\n}, {\n ProductID: 65,\n ProductName: 'Louisiana Fiery Hot Pepper Sauce',\n SupplierID: 2,\n CategoryID: 2,\n QuantityPerUnit: '32 - 8 oz bottles',\n UnitPrice: 21.0500,\n UnitsInStock: 76,\n UnitsOnOrder: 0,\n ReorderLevel: 0,\n Discontinued: false,\n Category: {\n CategoryID: 2,\n CategoryName: 'Condiments',\n Description: 'Sweet and savory sauces, relishes, spreads, and seasonings'\n }\n}, {\n ProductID: 66,\n ProductName: 'Louisiana Hot Spiced Okra',\n SupplierID: 2,\n CategoryID: 2,\n QuantityPerUnit: '24 - 8 oz jars',\n UnitPrice: 17.0000,\n UnitsInStock: 4,\n UnitsOnOrder: 100,\n ReorderLevel: 20,\n Discontinued: false,\n Category: {\n CategoryID: 2,\n CategoryName: 'Condiments',\n Description: 'Sweet and savory sauces, relishes, spreads, and seasonings'\n }\n}, {\n ProductID: 67,\n ProductName: 'Laughing Lumberjack Lager',\n SupplierID: 16,\n CategoryID: 1,\n QuantityPerUnit: '24 - 12 oz bottles',\n UnitPrice: 14.0000,\n UnitsInStock: 52,\n UnitsOnOrder: 0,\n ReorderLevel: 10,\n Discontinued: false,\n Category: {\n CategoryID: 1,\n CategoryName: 'Beverages',\n Description: 'Soft drinks, coffees, teas, beers, and ales'\n }\n}, {\n ProductID: 68,\n ProductName: 'Scottish Longbreads',\n SupplierID: 8,\n CategoryID: 3,\n QuantityPerUnit: '10 boxes x 8 pieces',\n UnitPrice: 12.5000,\n UnitsInStock: 6,\n UnitsOnOrder: 10,\n ReorderLevel: 15,\n Discontinued: false,\n Category: {\n CategoryID: 3,\n CategoryName: 'Confections',\n Description: 'Desserts, candies, and sweet breads'\n }\n}, {\n ProductID: 69,\n ProductName: 'Gudbrandsdalsost',\n SupplierID: 15,\n CategoryID: 4,\n QuantityPerUnit: '10 kg pkg.',\n UnitPrice: 36.0000,\n UnitsInStock: 26,\n UnitsOnOrder: 0,\n ReorderLevel: 15,\n Discontinued: false,\n Category: {\n CategoryID: 4,\n CategoryName: 'Dairy Products',\n Description: 'Cheeses'\n }\n}, {\n ProductID: 70,\n ProductName: 'Outback Lager',\n SupplierID: 7,\n CategoryID: 1,\n QuantityPerUnit: '24 - 355 ml bottles',\n UnitPrice: 15.0000,\n UnitsInStock: 15,\n UnitsOnOrder: 10,\n ReorderLevel: 30,\n Discontinued: false,\n Category: {\n CategoryID: 1,\n CategoryName: 'Beverages',\n Description: 'Soft drinks, coffees, teas, beers, and ales'\n }\n}, {\n ProductID: 71,\n ProductName: 'Flotemysost',\n SupplierID: 15,\n CategoryID: 4,\n QuantityPerUnit: '10 - 500 g pkgs.',\n UnitPrice: 21.5000,\n UnitsInStock: 26,\n UnitsOnOrder: 0,\n ReorderLevel: 0,\n Discontinued: false,\n Category: {\n CategoryID: 4,\n CategoryName: 'Dairy Products',\n Description: 'Cheeses'\n }\n}, {\n ProductID: 72,\n ProductName: 'Mozzarella di Giovanni',\n SupplierID: 14,\n CategoryID: 4,\n QuantityPerUnit: '24 - 200 g pkgs.',\n UnitPrice: 34.8000,\n UnitsInStock: 14,\n UnitsOnOrder: 0,\n ReorderLevel: 0,\n Discontinued: false,\n Category: {\n CategoryID: 4,\n CategoryName: 'Dairy Products',\n Description: 'Cheeses'\n }\n}, {\n ProductID: 73,\n ProductName: 'R\u00F6d Kaviar',\n SupplierID: 17,\n CategoryID: 8,\n QuantityPerUnit: '24 - 150 g jars',\n UnitPrice: 15.0000,\n UnitsInStock: 101,\n UnitsOnOrder: 0,\n ReorderLevel: 5,\n Discontinued: false,\n Category: {\n CategoryID: 8,\n CategoryName: 'Seafood',\n Description: 'Seaweed and fish'\n }\n}, {\n ProductID: 74,\n ProductName: 'Longlife Tofu',\n SupplierID: 4,\n CategoryID: 7,\n QuantityPerUnit: '5 kg pkg.',\n UnitPrice: 10.0000,\n UnitsInStock: 4,\n UnitsOnOrder: 20,\n ReorderLevel: 5,\n Discontinued: false,\n Category: {\n CategoryID: 7,\n CategoryName: 'Produce',\n Description: 'Dried fruit and bean curd'\n }\n}, {\n ProductID: 75,\n ProductName: 'Rh\u00F6nbr\u00E4u Klosterbier',\n SupplierID: 12,\n CategoryID: 1,\n QuantityPerUnit: '24 - 0.5 l bottles',\n UnitPrice: 7.7500,\n UnitsInStock: 125,\n UnitsOnOrder: 0,\n ReorderLevel: 25,\n Discontinued: false,\n Category: {\n CategoryID: 1,\n CategoryName: 'Beverages',\n Description: 'Soft drinks, coffees, teas, beers, and ales'\n }\n}, {\n ProductID: 76,\n ProductName: 'Lakkalik\u00F6\u00F6ri',\n SupplierID: 23,\n CategoryID: 1,\n QuantityPerUnit: '500 ml',\n UnitPrice: 18.0000,\n UnitsInStock: 57,\n UnitsOnOrder: 0,\n ReorderLevel: 20,\n Discontinued: false,\n Category: {\n CategoryID: 1,\n CategoryName: 'Beverages',\n Description: 'Soft drinks, coffees, teas, beers, and ales'\n }\n}, {\n ProductID: 77,\n ProductName: 'Original Frankfurter gr\u00FCne So\u00DFe',\n SupplierID: 12,\n CategoryID: 2,\n QuantityPerUnit: '12 boxes',\n UnitPrice: 13.0000,\n UnitsInStock: 32,\n UnitsOnOrder: 0,\n ReorderLevel: 15,\n Discontinued: false,\n Category: {\n CategoryID: 2,\n CategoryName: 'Condiments',\n Description: 'Sweet and savory sauces, relishes, spreads, and seasonings'\n }\n}];"; |
"use strict"; | ||
Object.defineProperty(exports, "__esModule", { value: true }); | ||
exports.products = void 0; | ||
exports.products = `[{ | ||
"ProductID": 1, | ||
"ProductName": "Chai", | ||
"SupplierID": 1, | ||
"CategoryID": 1, | ||
"QuantityPerUnit": "10 boxes x 20 bags", | ||
"UnitPrice": 18.0000, | ||
"UnitsInStock": 39, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 10, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 1, | ||
"CategoryName": "Beverages", | ||
"Description": "Soft drinks, coffees, teas, beers, and ales" | ||
exports.productsSourceCode = void 0; | ||
exports.productsSourceCode = `export const products = [{ | ||
ProductID: 1, | ||
ProductName: 'Chai', | ||
SupplierID: 1, | ||
CategoryID: 1, | ||
QuantityPerUnit: '10 boxes x 20 bags', | ||
UnitPrice: 18.0000, | ||
UnitsInStock: 39, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 10, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 1, | ||
CategoryName: 'Beverages', | ||
Description: 'Soft drinks, coffees, teas, beers, and ales' | ||
} | ||
}, { | ||
"ProductID": 2, | ||
"ProductName": "Chang", | ||
"SupplierID": 1, | ||
"CategoryID": 1, | ||
"QuantityPerUnit": "24 - 12 oz bottles", | ||
"UnitPrice": 19.0000, | ||
"UnitsInStock": 17, | ||
"UnitsOnOrder": 40, | ||
"ReorderLevel": 25, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 1, | ||
"CategoryName": "Beverages", | ||
"Description": "Soft drinks, coffees, teas, beers, and ales" | ||
ProductID: 2, | ||
ProductName: 'Chang', | ||
SupplierID: 1, | ||
CategoryID: 1, | ||
QuantityPerUnit: '24 - 12 oz bottles', | ||
UnitPrice: 19.0000, | ||
UnitsInStock: 17, | ||
UnitsOnOrder: 40, | ||
ReorderLevel: 25, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 1, | ||
CategoryName: 'Beverages', | ||
Description: 'Soft drinks, coffees, teas, beers, and ales' | ||
} | ||
}, { | ||
"ProductID": 3, | ||
"ProductName": "Aniseed Syrup", | ||
"SupplierID": 1, | ||
"CategoryID": 2, | ||
"QuantityPerUnit": "12 - 550 ml bottles", | ||
"UnitPrice": 10.0000, | ||
"UnitsInStock": 13, | ||
"UnitsOnOrder": 70, | ||
"ReorderLevel": 25, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 2, | ||
"CategoryName": "Condiments", | ||
"Description": "Sweet and savory sauces, relishes, spreads, and seasonings" | ||
ProductID: 3, | ||
ProductName: 'Aniseed Syrup', | ||
SupplierID: 1, | ||
CategoryID: 2, | ||
QuantityPerUnit: '12 - 550 ml bottles', | ||
UnitPrice: 10.0000, | ||
UnitsInStock: 13, | ||
UnitsOnOrder: 70, | ||
ReorderLevel: 25, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 2, | ||
CategoryName: 'Condiments', | ||
Description: 'Sweet and savory sauces, relishes, spreads, and seasonings' | ||
} | ||
}, { | ||
"ProductID": 4, | ||
"ProductName": "Chef Anton's Cajun Seasoning", | ||
"SupplierID": 2, | ||
"CategoryID": 2, | ||
"QuantityPerUnit": "48 - 6 oz jars", | ||
"UnitPrice": 22.0000, | ||
"UnitsInStock": 53, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 0, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 2, | ||
"CategoryName": "Condiments", | ||
"Description": "Sweet and savory sauces, relishes, spreads, and seasonings" | ||
ProductID: 4, | ||
ProductName: 'Chef Antons Cajun Seasoning', | ||
SupplierID: 2, | ||
CategoryID: 2, | ||
QuantityPerUnit: '48 - 6 oz jars', | ||
UnitPrice: 22.0000, | ||
UnitsInStock: 53, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 0, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 2, | ||
CategoryName: 'Condiments', | ||
Description: 'Sweet and savory sauces, relishes, spreads, and seasonings' | ||
} | ||
}, { | ||
"ProductID": 5, | ||
"ProductName": "Chef Anton's Gumbo Mix", | ||
"SupplierID": 2, | ||
"CategoryID": 2, | ||
"QuantityPerUnit": "36 boxes", | ||
"UnitPrice": 21.3500, | ||
"UnitsInStock": 0, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 0, | ||
"Discontinued": true, | ||
"Category": { | ||
"CategoryID": 2, | ||
"CategoryName": "Condiments", | ||
"Description": "Sweet and savory sauces, relishes, spreads, and seasonings" | ||
ProductID: 5, | ||
ProductName: 'Chef Antons Gumbo Mix', | ||
SupplierID: 2, | ||
CategoryID: 2, | ||
QuantityPerUnit: '36 boxes', | ||
UnitPrice: 21.3500, | ||
UnitsInStock: 0, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 0, | ||
Discontinued: true, | ||
Category: { | ||
CategoryID: 2, | ||
CategoryName: 'Condiments', | ||
Description: 'Sweet and savory sauces, relishes, spreads, and seasonings' | ||
} | ||
}, { | ||
"ProductID": 6, | ||
"ProductName": "Grandma's Boysenberry Spread", | ||
"SupplierID": 3, | ||
"CategoryID": 2, | ||
"QuantityPerUnit": "12 - 8 oz jars", | ||
"UnitPrice": 25.0000, | ||
"UnitsInStock": 120, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 25, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 2, | ||
"CategoryName": "Condiments", | ||
"Description": "Sweet and savory sauces, relishes, spreads, and seasonings" | ||
ProductID: 6, | ||
ProductName: 'Grandmas Boysenberry Spread', | ||
SupplierID: 3, | ||
CategoryID: 2, | ||
QuantityPerUnit: '12 - 8 oz jars', | ||
UnitPrice: 25.0000, | ||
UnitsInStock: 120, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 25, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 2, | ||
CategoryName: 'Condiments', | ||
Description: 'Sweet and savory sauces, relishes, spreads, and seasonings' | ||
} | ||
}, { | ||
"ProductID": 7, | ||
"ProductName": "Uncle Bob's Organic Dried Pears", | ||
"SupplierID": 3, | ||
"CategoryID": 7, | ||
"QuantityPerUnit": "12 - 1 lb pkgs.", | ||
"UnitPrice": 30.0000, | ||
"UnitsInStock": 15, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 10, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 7, | ||
"CategoryName": "Produce", | ||
"Description": "Dried fruit and bean curd" | ||
ProductID: 7, | ||
ProductName: 'Uncle Bobs Organic Dried Pears', | ||
SupplierID: 3, | ||
CategoryID: 7, | ||
QuantityPerUnit: '12 - 1 lb pkgs.', | ||
UnitPrice: 30.0000, | ||
UnitsInStock: 15, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 10, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 7, | ||
CategoryName: 'Produce', | ||
Description: 'Dried fruit and bean curd' | ||
} | ||
}, { | ||
"ProductID": 8, | ||
"ProductName": "Northwoods Cranberry Sauce", | ||
"SupplierID": 3, | ||
"CategoryID": 2, | ||
"QuantityPerUnit": "12 - 12 oz jars", | ||
"UnitPrice": 40.0000, | ||
"UnitsInStock": 6, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 0, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 2, | ||
"CategoryName": "Condiments", | ||
"Description": "Sweet and savory sauces, relishes, spreads, and seasonings" | ||
ProductID: 8, | ||
ProductName: 'Northwoods Cranberry Sauce', | ||
SupplierID: 3, | ||
CategoryID: 2, | ||
QuantityPerUnit: '12 - 12 oz jars', | ||
UnitPrice: 40.0000, | ||
UnitsInStock: 6, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 0, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 2, | ||
CategoryName: 'Condiments', | ||
Description: 'Sweet and savory sauces, relishes, spreads, and seasonings' | ||
} | ||
}, { | ||
"ProductID": 9, | ||
"ProductName": "Mishi Kobe Niku", | ||
"SupplierID": 4, | ||
"CategoryID": 6, | ||
"QuantityPerUnit": "18 - 500 g pkgs.", | ||
"UnitPrice": 97.0000, | ||
"UnitsInStock": 29, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 0, | ||
"Discontinued": true, | ||
"Category": { | ||
"CategoryID": 6, | ||
"CategoryName": "Meat/Poultry", | ||
"Description": "Prepared meats" | ||
ProductID: 9, | ||
ProductName: 'Mishi Kobe Niku', | ||
SupplierID: 4, | ||
CategoryID: 6, | ||
QuantityPerUnit: '18 - 500 g pkgs.', | ||
UnitPrice: 97.0000, | ||
UnitsInStock: 29, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 0, | ||
Discontinued: true, | ||
Category: { | ||
CategoryID: 6, | ||
CategoryName: 'Meat/Poultry', | ||
Description: 'Prepared meats' | ||
} | ||
}, { | ||
"ProductID": 10, | ||
"ProductName": "Ikura", | ||
"SupplierID": 4, | ||
"CategoryID": 8, | ||
"QuantityPerUnit": "12 - 200 ml jars", | ||
"UnitPrice": 31.0000, | ||
"UnitsInStock": 31, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 0, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 8, | ||
"CategoryName": "Seafood", | ||
"Description": "Seaweed and fish" | ||
ProductID: 10, | ||
ProductName: 'Ikura', | ||
SupplierID: 4, | ||
CategoryID: 8, | ||
QuantityPerUnit: '12 - 200 ml jars', | ||
UnitPrice: 31.0000, | ||
UnitsInStock: 31, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 0, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 8, | ||
CategoryName: 'Seafood', | ||
Description: 'Seaweed and fish' | ||
} | ||
}, { | ||
"ProductID": 11, | ||
"ProductName": "Queso Cabrales", | ||
"SupplierID": 5, | ||
"CategoryID": 4, | ||
"QuantityPerUnit": "1 kg pkg.", | ||
"UnitPrice": 21.0000, | ||
"UnitsInStock": 22, | ||
"UnitsOnOrder": 30, | ||
"ReorderLevel": 30, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 4, | ||
"CategoryName": "Dairy Products", | ||
"Description": "Cheeses" | ||
ProductID: 11, | ||
ProductName: 'Queso Cabrales', | ||
SupplierID: 5, | ||
CategoryID: 4, | ||
QuantityPerUnit: '1 kg pkg.', | ||
UnitPrice: 21.0000, | ||
UnitsInStock: 22, | ||
UnitsOnOrder: 30, | ||
ReorderLevel: 30, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 4, | ||
CategoryName: 'Dairy Products', | ||
Description: 'Cheeses' | ||
} | ||
}, { | ||
"ProductID": 12, | ||
"ProductName": "Queso Manchego La Pastora", | ||
"SupplierID": 5, | ||
"CategoryID": 4, | ||
"QuantityPerUnit": "10 - 500 g pkgs.", | ||
"UnitPrice": 38.0000, | ||
"UnitsInStock": 86, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 0, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 4, | ||
"CategoryName": "Dairy Products", | ||
"Description": "Cheeses" | ||
ProductID: 12, | ||
ProductName: 'Queso Manchego La Pastora', | ||
SupplierID: 5, | ||
CategoryID: 4, | ||
QuantityPerUnit: '10 - 500 g pkgs.', | ||
UnitPrice: 38.0000, | ||
UnitsInStock: 86, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 0, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 4, | ||
CategoryName: 'Dairy Products', | ||
Description: 'Cheeses' | ||
} | ||
}, { | ||
"ProductID": 13, | ||
"ProductName": "Konbu", | ||
"SupplierID": 6, | ||
"CategoryID": 8, | ||
"QuantityPerUnit": "2 kg box", | ||
"UnitPrice": 6.0000, | ||
"UnitsInStock": 24, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 5, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 8, | ||
"CategoryName": "Seafood", | ||
"Description": "Seaweed and fish" | ||
ProductID: 13, | ||
ProductName: 'Konbu', | ||
SupplierID: 6, | ||
CategoryID: 8, | ||
QuantityPerUnit: '2 kg box', | ||
UnitPrice: 6.0000, | ||
UnitsInStock: 24, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 5, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 8, | ||
CategoryName: 'Seafood', | ||
Description: 'Seaweed and fish' | ||
} | ||
}, { | ||
"ProductID": 14, | ||
"ProductName": "Tofu", | ||
"SupplierID": 6, | ||
"CategoryID": 7, | ||
"QuantityPerUnit": "40 - 100 g pkgs.", | ||
"UnitPrice": 23.2500, | ||
"UnitsInStock": 35, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 0, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 7, | ||
"CategoryName": "Produce", | ||
"Description": "Dried fruit and bean curd" | ||
ProductID: 14, | ||
ProductName: 'Tofu', | ||
SupplierID: 6, | ||
CategoryID: 7, | ||
QuantityPerUnit: '40 - 100 g pkgs.', | ||
UnitPrice: 23.2500, | ||
UnitsInStock: 35, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 0, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 7, | ||
CategoryName: 'Produce', | ||
Description: 'Dried fruit and bean curd' | ||
} | ||
}, { | ||
"ProductID": 15, | ||
"ProductName": "Genen Shouyu", | ||
"SupplierID": 6, | ||
"CategoryID": 2, | ||
"QuantityPerUnit": "24 - 250 ml bottles", | ||
"UnitPrice": 15.5000, | ||
"UnitsInStock": 39, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 5, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 2, | ||
"CategoryName": "Condiments", | ||
"Description": "Sweet and savory sauces, relishes, spreads, and seasonings" | ||
ProductID: 15, | ||
ProductName: 'Genen Shouyu', | ||
SupplierID: 6, | ||
CategoryID: 2, | ||
QuantityPerUnit: '24 - 250 ml bottles', | ||
UnitPrice: 15.5000, | ||
UnitsInStock: 39, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 5, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 2, | ||
CategoryName: 'Condiments', | ||
Description: 'Sweet and savory sauces, relishes, spreads, and seasonings' | ||
} | ||
}, { | ||
"ProductID": 16, | ||
"ProductName": "Pavlova", | ||
"SupplierID": 7, | ||
"CategoryID": 3, | ||
"QuantityPerUnit": "32 - 500 g boxes", | ||
"UnitPrice": 17.4500, | ||
"UnitsInStock": 29, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 10, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 3, | ||
"CategoryName": "Confections", | ||
"Description": "Desserts, candies, and sweet breads" | ||
ProductID: 16, | ||
ProductName: 'Pavlova', | ||
SupplierID: 7, | ||
CategoryID: 3, | ||
QuantityPerUnit: '32 - 500 g boxes', | ||
UnitPrice: 17.4500, | ||
UnitsInStock: 29, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 10, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 3, | ||
CategoryName: 'Confections', | ||
Description: 'Desserts, candies, and sweet breads' | ||
} | ||
}, { | ||
"ProductID": 17, | ||
"ProductName": "Alice Mutton", | ||
"SupplierID": 7, | ||
"CategoryID": 6, | ||
"QuantityPerUnit": "20 - 1 kg tins", | ||
"UnitPrice": 39.0000, | ||
"UnitsInStock": 0, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 0, | ||
"Discontinued": true, | ||
"Category": { | ||
"CategoryID": 6, | ||
"CategoryName": "Meat/Poultry", | ||
"Description": "Prepared meats" | ||
ProductID: 17, | ||
ProductName: 'Alice Mutton', | ||
SupplierID: 7, | ||
CategoryID: 6, | ||
QuantityPerUnit: '20 - 1 kg tins', | ||
UnitPrice: 39.0000, | ||
UnitsInStock: 0, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 0, | ||
Discontinued: true, | ||
Category: { | ||
CategoryID: 6, | ||
CategoryName: 'Meat/Poultry', | ||
Description: 'Prepared meats' | ||
} | ||
}, { | ||
"ProductID": 18, | ||
"ProductName": "Carnarvon Tigers", | ||
"SupplierID": 7, | ||
"CategoryID": 8, | ||
"QuantityPerUnit": "16 kg pkg.", | ||
"UnitPrice": 62.5000, | ||
"UnitsInStock": 42, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 0, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 8, | ||
"CategoryName": "Seafood", | ||
"Description": "Seaweed and fish" | ||
ProductID: 18, | ||
ProductName: 'Carnarvon Tigers', | ||
SupplierID: 7, | ||
CategoryID: 8, | ||
QuantityPerUnit: '16 kg pkg.', | ||
UnitPrice: 62.5000, | ||
UnitsInStock: 42, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 0, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 8, | ||
CategoryName: 'Seafood', | ||
Description: 'Seaweed and fish' | ||
} | ||
}, { | ||
"ProductID": 19, | ||
"ProductName": "Teatime Chocolate Biscuits", | ||
"SupplierID": 8, | ||
"CategoryID": 3, | ||
"QuantityPerUnit": "10 boxes x 12 pieces", | ||
"UnitPrice": 9.2000, | ||
"UnitsInStock": 25, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 5, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 3, | ||
"CategoryName": "Confections", | ||
"Description": "Desserts, candies, and sweet breads" | ||
ProductID: 19, | ||
ProductName: 'Teatime Chocolate Biscuits', | ||
SupplierID: 8, | ||
CategoryID: 3, | ||
QuantityPerUnit: '10 boxes x 12 pieces', | ||
UnitPrice: 9.2000, | ||
UnitsInStock: 25, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 5, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 3, | ||
CategoryName: 'Confections', | ||
Description: 'Desserts, candies, and sweet breads' | ||
} | ||
}, { | ||
"ProductID": 20, | ||
"ProductName": "Sir Rodney's Marmalade", | ||
"SupplierID": 8, | ||
"CategoryID": 3, | ||
"QuantityPerUnit": "30 gift boxes", | ||
"UnitPrice": 81.0000, | ||
"UnitsInStock": 40, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 0, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 3, | ||
"CategoryName": "Confections", | ||
"Description": "Desserts, candies, and sweet breads" | ||
ProductID: 20, | ||
ProductName: 'Sir Rodneys Marmalade', | ||
SupplierID: 8, | ||
CategoryID: 3, | ||
QuantityPerUnit: '30 gift boxes', | ||
UnitPrice: 81.0000, | ||
UnitsInStock: 40, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 0, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 3, | ||
CategoryName: 'Confections', | ||
Description: 'Desserts, candies, and sweet breads' | ||
} | ||
}, { | ||
"ProductID": 21, | ||
"ProductName": "Sir Rodney's Scones", | ||
"SupplierID": 8, | ||
"CategoryID": 3, | ||
"QuantityPerUnit": "24 pkgs. x 4 pieces", | ||
"UnitPrice": 10.0000, | ||
"UnitsInStock": 3, | ||
"UnitsOnOrder": 40, | ||
"ReorderLevel": 5, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 3, | ||
"CategoryName": "Confections", | ||
"Description": "Desserts, candies, and sweet breads" | ||
ProductID: 21, | ||
ProductName: 'Sir Rodneys Scones', | ||
SupplierID: 8, | ||
CategoryID: 3, | ||
QuantityPerUnit: '24 pkgs. x 4 pieces', | ||
UnitPrice: 10.0000, | ||
UnitsInStock: 3, | ||
UnitsOnOrder: 40, | ||
ReorderLevel: 5, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 3, | ||
CategoryName: 'Confections', | ||
Description: 'Desserts, candies, and sweet breads' | ||
} | ||
}, { | ||
"ProductID": 22, | ||
"ProductName": "Gustaf's Knäckebröd", | ||
"SupplierID": 9, | ||
"CategoryID": 5, | ||
"QuantityPerUnit": "24 - 500 g pkgs.", | ||
"UnitPrice": 21.0000, | ||
"UnitsInStock": 104, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 25, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 5, | ||
"CategoryName": "Grains/Cereals", | ||
"Description": "Breads, crackers, pasta, and cereal" | ||
ProductID: 22, | ||
ProductName: 'Gustafs Knäckebröd', | ||
SupplierID: 9, | ||
CategoryID: 5, | ||
QuantityPerUnit: '24 - 500 g pkgs.', | ||
UnitPrice: 21.0000, | ||
UnitsInStock: 104, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 25, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 5, | ||
CategoryName: 'Grains/Cereals', | ||
Description: 'Breads, crackers, pasta, and cereal' | ||
} | ||
}, { | ||
"ProductID": 23, | ||
"ProductName": "Tunnbröd", | ||
"SupplierID": 9, | ||
"CategoryID": 5, | ||
"QuantityPerUnit": "12 - 250 g pkgs.", | ||
"UnitPrice": 9.0000, | ||
"UnitsInStock": 61, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 25, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 5, | ||
"CategoryName": "Grains/Cereals", | ||
"Description": "Breads, crackers, pasta, and cereal" | ||
ProductID: 23, | ||
ProductName: 'Tunnbröd', | ||
SupplierID: 9, | ||
CategoryID: 5, | ||
QuantityPerUnit: '12 - 250 g pkgs.', | ||
UnitPrice: 9.0000, | ||
UnitsInStock: 61, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 25, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 5, | ||
CategoryName: 'Grains/Cereals', | ||
Description: 'Breads, crackers, pasta, and cereal' | ||
} | ||
}, { | ||
"ProductID": 24, | ||
"ProductName": "Guaraná Fantástica", | ||
"SupplierID": 10, | ||
"CategoryID": 1, | ||
"QuantityPerUnit": "12 - 355 ml cans", | ||
"UnitPrice": 4.5000, | ||
"UnitsInStock": 20, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 0, | ||
"Discontinued": true, | ||
"Category": { | ||
"CategoryID": 1, | ||
"CategoryName": "Beverages", | ||
"Description": "Soft drinks, coffees, teas, beers, and ales" | ||
ProductID: 24, | ||
ProductName: 'Guaraná Fantástica', | ||
SupplierID: 10, | ||
CategoryID: 1, | ||
QuantityPerUnit: '12 - 355 ml cans', | ||
UnitPrice: 4.5000, | ||
UnitsInStock: 20, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 0, | ||
Discontinued: true, | ||
Category: { | ||
CategoryID: 1, | ||
CategoryName: 'Beverages', | ||
Description: 'Soft drinks, coffees, teas, beers, and ales' | ||
} | ||
}, { | ||
"ProductID": 25, | ||
"ProductName": "NuNuCa Nuß-Nougat-Creme", | ||
"SupplierID": 11, | ||
"CategoryID": 3, | ||
"QuantityPerUnit": "20 - 450 g glasses", | ||
"UnitPrice": 14.0000, | ||
"UnitsInStock": 76, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 30, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 3, | ||
"CategoryName": "Confections", | ||
"Description": "Desserts, candies, and sweet breads" | ||
ProductID: 25, | ||
ProductName: 'NuNuCa Nuß-Nougat-Creme', | ||
SupplierID: 11, | ||
CategoryID: 3, | ||
QuantityPerUnit: '20 - 450 g glasses', | ||
UnitPrice: 14.0000, | ||
UnitsInStock: 76, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 30, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 3, | ||
CategoryName: 'Confections', | ||
Description: 'Desserts, candies, and sweet breads' | ||
} | ||
}, { | ||
"ProductID": 26, | ||
"ProductName": "Gumbär Gummibärchen", | ||
"SupplierID": 11, | ||
"CategoryID": 3, | ||
"QuantityPerUnit": "100 - 250 g bags", | ||
"UnitPrice": 31.2300, | ||
"UnitsInStock": 15, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 0, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 3, | ||
"CategoryName": "Confections", | ||
"Description": "Desserts, candies, and sweet breads" | ||
ProductID: 26, | ||
ProductName: 'Gumbär Gummibärchen', | ||
SupplierID: 11, | ||
CategoryID: 3, | ||
QuantityPerUnit: '100 - 250 g bags', | ||
UnitPrice: 31.2300, | ||
UnitsInStock: 15, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 0, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 3, | ||
CategoryName: 'Confections', | ||
Description: 'Desserts, candies, and sweet breads' | ||
} | ||
}, { | ||
"ProductID": 27, | ||
"ProductName": "Schoggi Schokolade", | ||
"SupplierID": 11, | ||
"CategoryID": 3, | ||
"QuantityPerUnit": "100 - 100 g pieces", | ||
"UnitPrice": 43.9000, | ||
"UnitsInStock": 49, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 30, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 3, | ||
"CategoryName": "Confections", | ||
"Description": "Desserts, candies, and sweet breads" | ||
ProductID: 27, | ||
ProductName: 'Schoggi Schokolade', | ||
SupplierID: 11, | ||
CategoryID: 3, | ||
QuantityPerUnit: '100 - 100 g pieces', | ||
UnitPrice: 43.9000, | ||
UnitsInStock: 49, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 30, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 3, | ||
CategoryName: 'Confections', | ||
Description: 'Desserts, candies, and sweet breads' | ||
} | ||
}, { | ||
"ProductID": 28, | ||
"ProductName": "Rössle Sauerkraut", | ||
"SupplierID": 12, | ||
"CategoryID": 7, | ||
"QuantityPerUnit": "25 - 825 g cans", | ||
"UnitPrice": 45.6000, | ||
"UnitsInStock": 26, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 0, | ||
"Discontinued": true, | ||
"Category": { | ||
"CategoryID": 7, | ||
"CategoryName": "Produce", | ||
"Description": "Dried fruit and bean curd" | ||
ProductID: 28, | ||
ProductName: 'Rössle Sauerkraut', | ||
SupplierID: 12, | ||
CategoryID: 7, | ||
QuantityPerUnit: '25 - 825 g cans', | ||
UnitPrice: 45.6000, | ||
UnitsInStock: 26, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 0, | ||
Discontinued: true, | ||
Category: { | ||
CategoryID: 7, | ||
CategoryName: 'Produce', | ||
Description: 'Dried fruit and bean curd' | ||
} | ||
}, { | ||
"ProductID": 29, | ||
"ProductName": "Thüringer Rostbratwurst", | ||
"SupplierID": 12, | ||
"CategoryID": 6, | ||
"QuantityPerUnit": "50 bags x 30 sausgs.", | ||
"UnitPrice": 123.7900, | ||
"UnitsInStock": 0, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 0, | ||
"Discontinued": true, | ||
"Category": { | ||
"CategoryID": 6, | ||
"CategoryName": "Meat/Poultry", | ||
"Description": "Prepared meats" | ||
ProductID: 29, | ||
ProductName: 'Thüringer Rostbratwurst', | ||
SupplierID: 12, | ||
CategoryID: 6, | ||
QuantityPerUnit: '50 bags x 30 sausgs.', | ||
UnitPrice: 123.7900, | ||
UnitsInStock: 0, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 0, | ||
Discontinued: true, | ||
Category: { | ||
CategoryID: 6, | ||
CategoryName: 'Meat/Poultry', | ||
Description: 'Prepared meats' | ||
} | ||
}, { | ||
"ProductID": 30, | ||
"ProductName": "Nord-Ost Matjeshering", | ||
"SupplierID": 13, | ||
"CategoryID": 8, | ||
"QuantityPerUnit": "10 - 200 g glasses", | ||
"UnitPrice": 25.8900, | ||
"UnitsInStock": 10, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 15, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 8, | ||
"CategoryName": "Seafood", | ||
"Description": "Seaweed and fish" | ||
ProductID: 30, | ||
ProductName: 'Nord-Ost Matjeshering', | ||
SupplierID: 13, | ||
CategoryID: 8, | ||
QuantityPerUnit: '10 - 200 g glasses', | ||
UnitPrice: 25.8900, | ||
UnitsInStock: 10, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 15, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 8, | ||
CategoryName: 'Seafood', | ||
Description: 'Seaweed and fish' | ||
} | ||
}, { | ||
"ProductID": 31, | ||
"ProductName": "Gorgonzola Telino", | ||
"SupplierID": 14, | ||
"CategoryID": 4, | ||
"QuantityPerUnit": "12 - 100 g pkgs", | ||
"UnitPrice": 12.5000, | ||
"UnitsInStock": 0, | ||
"UnitsOnOrder": 70, | ||
"ReorderLevel": 20, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 4, | ||
"CategoryName": "Dairy Products", | ||
"Description": "Cheeses" | ||
ProductID: 31, | ||
ProductName: 'Gorgonzola Telino', | ||
SupplierID: 14, | ||
CategoryID: 4, | ||
QuantityPerUnit: '12 - 100 g pkgs', | ||
UnitPrice: 12.5000, | ||
UnitsInStock: 0, | ||
UnitsOnOrder: 70, | ||
ReorderLevel: 20, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 4, | ||
CategoryName: 'Dairy Products', | ||
Description: 'Cheeses' | ||
} | ||
}, { | ||
"ProductID": 32, | ||
"ProductName": "Mascarpone Fabioli", | ||
"SupplierID": 14, | ||
"CategoryID": 4, | ||
"QuantityPerUnit": "24 - 200 g pkgs.", | ||
"UnitPrice": 32.0000, | ||
"UnitsInStock": 9, | ||
"UnitsOnOrder": 40, | ||
"ReorderLevel": 25, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 4, | ||
"CategoryName": "Dairy Products", | ||
"Description": "Cheeses" | ||
ProductID: 32, | ||
ProductName: 'Mascarpone Fabioli', | ||
SupplierID: 14, | ||
CategoryID: 4, | ||
QuantityPerUnit: '24 - 200 g pkgs.', | ||
UnitPrice: 32.0000, | ||
UnitsInStock: 9, | ||
UnitsOnOrder: 40, | ||
ReorderLevel: 25, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 4, | ||
CategoryName: 'Dairy Products', | ||
Description: 'Cheeses' | ||
} | ||
}, { | ||
"ProductID": 33, | ||
"ProductName": "Geitost", | ||
"SupplierID": 15, | ||
"CategoryID": 4, | ||
"QuantityPerUnit": "500 g", | ||
"UnitPrice": 2.5000, | ||
"UnitsInStock": 112, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 20, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 4, | ||
"CategoryName": "Dairy Products", | ||
"Description": "Cheeses" | ||
ProductID: 33, | ||
ProductName: 'Geitost', | ||
SupplierID: 15, | ||
CategoryID: 4, | ||
QuantityPerUnit: '500 g', | ||
UnitPrice: 2.5000, | ||
UnitsInStock: 112, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 20, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 4, | ||
CategoryName: 'Dairy Products', | ||
Description: 'Cheeses' | ||
} | ||
}, { | ||
"ProductID": 34, | ||
"ProductName": "Sasquatch Ale", | ||
"SupplierID": 16, | ||
"CategoryID": 1, | ||
"QuantityPerUnit": "24 - 12 oz bottles", | ||
"UnitPrice": 14.0000, | ||
"UnitsInStock": 111, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 15, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 1, | ||
"CategoryName": "Beverages", | ||
"Description": "Soft drinks, coffees, teas, beers, and ales" | ||
ProductID: 34, | ||
ProductName: 'Sasquatch Ale', | ||
SupplierID: 16, | ||
CategoryID: 1, | ||
QuantityPerUnit: '24 - 12 oz bottles', | ||
UnitPrice: 14.0000, | ||
UnitsInStock: 111, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 15, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 1, | ||
CategoryName: 'Beverages', | ||
Description: 'Soft drinks, coffees, teas, beers, and ales' | ||
} | ||
}, { | ||
"ProductID": 35, | ||
"ProductName": "Steeleye Stout", | ||
"SupplierID": 16, | ||
"CategoryID": 1, | ||
"QuantityPerUnit": "24 - 12 oz bottles", | ||
"UnitPrice": 18.0000, | ||
"UnitsInStock": 20, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 15, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 1, | ||
"CategoryName": "Beverages", | ||
"Description": "Soft drinks, coffees, teas, beers, and ales" | ||
ProductID: 35, | ||
ProductName: 'Steeleye Stout', | ||
SupplierID: 16, | ||
CategoryID: 1, | ||
QuantityPerUnit: '24 - 12 oz bottles', | ||
UnitPrice: 18.0000, | ||
UnitsInStock: 20, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 15, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 1, | ||
CategoryName: 'Beverages', | ||
Description: 'Soft drinks, coffees, teas, beers, and ales' | ||
} | ||
}, { | ||
"ProductID": 36, | ||
"ProductName": "Inlagd Sill", | ||
"SupplierID": 17, | ||
"CategoryID": 8, | ||
"QuantityPerUnit": "24 - 250 g jars", | ||
"UnitPrice": 19.0000, | ||
"UnitsInStock": 112, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 20, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 8, | ||
"CategoryName": "Seafood", | ||
"Description": "Seaweed and fish" | ||
ProductID: 36, | ||
ProductName: 'Inlagd Sill', | ||
SupplierID: 17, | ||
CategoryID: 8, | ||
QuantityPerUnit: '24 - 250 g jars', | ||
UnitPrice: 19.0000, | ||
UnitsInStock: 112, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 20, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 8, | ||
CategoryName: 'Seafood', | ||
Description: 'Seaweed and fish' | ||
} | ||
}, { | ||
"ProductID": 37, | ||
"ProductName": "Gravad lax", | ||
"SupplierID": 17, | ||
"CategoryID": 8, | ||
"QuantityPerUnit": "12 - 500 g pkgs.", | ||
"UnitPrice": 26.0000, | ||
"UnitsInStock": 11, | ||
"UnitsOnOrder": 50, | ||
"ReorderLevel": 25, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 8, | ||
"CategoryName": "Seafood", | ||
"Description": "Seaweed and fish" | ||
ProductID: 37, | ||
ProductName: 'Gravad lax', | ||
SupplierID: 17, | ||
CategoryID: 8, | ||
QuantityPerUnit: '12 - 500 g pkgs.', | ||
UnitPrice: 26.0000, | ||
UnitsInStock: 11, | ||
UnitsOnOrder: 50, | ||
ReorderLevel: 25, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 8, | ||
CategoryName: 'Seafood', | ||
Description: 'Seaweed and fish' | ||
} | ||
}, { | ||
"ProductID": 38, | ||
"ProductName": "Côte de Blaye", | ||
"SupplierID": 18, | ||
"CategoryID": 1, | ||
"QuantityPerUnit": "12 - 75 cl bottles", | ||
"UnitPrice": 263.5000, | ||
"UnitsInStock": 17, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 15, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 1, | ||
"CategoryName": "Beverages", | ||
"Description": "Soft drinks, coffees, teas, beers, and ales" | ||
ProductID: 38, | ||
ProductName: 'Côte de Blaye', | ||
SupplierID: 18, | ||
CategoryID: 1, | ||
QuantityPerUnit: '12 - 75 cl bottles', | ||
UnitPrice: 263.5000, | ||
UnitsInStock: 17, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 15, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 1, | ||
CategoryName: 'Beverages', | ||
Description: 'Soft drinks, coffees, teas, beers, and ales' | ||
} | ||
}, { | ||
"ProductID": 39, | ||
"ProductName": "Chartreuse verte", | ||
"SupplierID": 18, | ||
"CategoryID": 1, | ||
"QuantityPerUnit": "750 cc per bottle", | ||
"UnitPrice": 18.0000, | ||
"UnitsInStock": 69, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 5, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 1, | ||
"CategoryName": "Beverages", | ||
"Description": "Soft drinks, coffees, teas, beers, and ales" | ||
ProductID: 39, | ||
ProductName: 'Chartreuse verte', | ||
SupplierID: 18, | ||
CategoryID: 1, | ||
QuantityPerUnit: '750 cc per bottle', | ||
UnitPrice: 18.0000, | ||
UnitsInStock: 69, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 5, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 1, | ||
CategoryName: 'Beverages', | ||
Description: 'Soft drinks, coffees, teas, beers, and ales' | ||
} | ||
}, { | ||
"ProductID": 40, | ||
"ProductName": "Boston Crab Meat", | ||
"SupplierID": 19, | ||
"CategoryID": 8, | ||
"QuantityPerUnit": "24 - 4 oz tins", | ||
"UnitPrice": 18.4000, | ||
"UnitsInStock": 123, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 30, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 8, | ||
"CategoryName": "Seafood", | ||
"Description": "Seaweed and fish" | ||
ProductID: 40, | ||
ProductName: 'Boston Crab Meat', | ||
SupplierID: 19, | ||
CategoryID: 8, | ||
QuantityPerUnit: '24 - 4 oz tins', | ||
UnitPrice: 18.4000, | ||
UnitsInStock: 123, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 30, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 8, | ||
CategoryName: 'Seafood', | ||
Description: 'Seaweed and fish' | ||
} | ||
}, { | ||
"ProductID": 41, | ||
"ProductName": "Jack's New England Clam Chowder", | ||
"SupplierID": 19, | ||
"CategoryID": 8, | ||
"QuantityPerUnit": "12 - 12 oz cans", | ||
"UnitPrice": 9.6500, | ||
"UnitsInStock": 85, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 10, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 8, | ||
"CategoryName": "Seafood", | ||
"Description": "Seaweed and fish" | ||
ProductID: 41, | ||
ProductName: 'Jacks New England Clam Chowder', | ||
SupplierID: 19, | ||
CategoryID: 8, | ||
QuantityPerUnit: '12 - 12 oz cans', | ||
UnitPrice: 9.6500, | ||
UnitsInStock: 85, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 10, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 8, | ||
CategoryName: 'Seafood', | ||
Description: 'Seaweed and fish' | ||
} | ||
}, { | ||
"ProductID": 42, | ||
"ProductName": "Singaporean Hokkien Fried Mee", | ||
"SupplierID": 20, | ||
"CategoryID": 5, | ||
"QuantityPerUnit": "32 - 1 kg pkgs.", | ||
"UnitPrice": 14.0000, | ||
"UnitsInStock": 26, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 0, | ||
"Discontinued": true, | ||
"Category": { | ||
"CategoryID": 5, | ||
"CategoryName": "Grains/Cereals", | ||
"Description": "Breads, crackers, pasta, and cereal" | ||
ProductID: 42, | ||
ProductName: 'Singaporean Hokkien Fried Mee', | ||
SupplierID: 20, | ||
CategoryID: 5, | ||
QuantityPerUnit: '32 - 1 kg pkgs.', | ||
UnitPrice: 14.0000, | ||
UnitsInStock: 26, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 0, | ||
Discontinued: true, | ||
Category: { | ||
CategoryID: 5, | ||
CategoryName: 'Grains/Cereals', | ||
Description: 'Breads, crackers, pasta, and cereal' | ||
} | ||
}, { | ||
"ProductID": 43, | ||
"ProductName": "Ipoh Coffee", | ||
"SupplierID": 20, | ||
"CategoryID": 1, | ||
"QuantityPerUnit": "16 - 500 g tins", | ||
"UnitPrice": 46.0000, | ||
"UnitsInStock": 17, | ||
"UnitsOnOrder": 10, | ||
"ReorderLevel": 25, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 1, | ||
"CategoryName": "Beverages", | ||
"Description": "Soft drinks, coffees, teas, beers, and ales" | ||
ProductID: 43, | ||
ProductName: 'Ipoh Coffee', | ||
SupplierID: 20, | ||
CategoryID: 1, | ||
QuantityPerUnit: '16 - 500 g tins', | ||
UnitPrice: 46.0000, | ||
UnitsInStock: 17, | ||
UnitsOnOrder: 10, | ||
ReorderLevel: 25, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 1, | ||
CategoryName: 'Beverages', | ||
Description: 'Soft drinks, coffees, teas, beers, and ales' | ||
} | ||
}, { | ||
"ProductID": 44, | ||
"ProductName": "Gula Malacca", | ||
"SupplierID": 20, | ||
"CategoryID": 2, | ||
"QuantityPerUnit": "20 - 2 kg bags", | ||
"UnitPrice": 19.4500, | ||
"UnitsInStock": 27, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 15, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 2, | ||
"CategoryName": "Condiments", | ||
"Description": "Sweet and savory sauces, relishes, spreads, and seasonings" | ||
ProductID: 44, | ||
ProductName: 'Gula Malacca', | ||
SupplierID: 20, | ||
CategoryID: 2, | ||
QuantityPerUnit: '20 - 2 kg bags', | ||
UnitPrice: 19.4500, | ||
UnitsInStock: 27, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 15, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 2, | ||
CategoryName: 'Condiments', | ||
Description: 'Sweet and savory sauces, relishes, spreads, and seasonings' | ||
} | ||
}, { | ||
"ProductID": 45, | ||
"ProductName": "Rogede sild", | ||
"SupplierID": 21, | ||
"CategoryID": 8, | ||
"QuantityPerUnit": "1k pkg.", | ||
"UnitPrice": 9.5000, | ||
"UnitsInStock": 5, | ||
"UnitsOnOrder": 70, | ||
"ReorderLevel": 15, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 8, | ||
"CategoryName": "Seafood", | ||
"Description": "Seaweed and fish" | ||
ProductID: 45, | ||
ProductName: 'Rogede sild', | ||
SupplierID: 21, | ||
CategoryID: 8, | ||
QuantityPerUnit: '1k pkg.', | ||
UnitPrice: 9.5000, | ||
UnitsInStock: 5, | ||
UnitsOnOrder: 70, | ||
ReorderLevel: 15, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 8, | ||
CategoryName: 'Seafood', | ||
Description: 'Seaweed and fish' | ||
} | ||
}, { | ||
"ProductID": 46, | ||
"ProductName": "Spegesild", | ||
"SupplierID": 21, | ||
"CategoryID": 8, | ||
"QuantityPerUnit": "4 - 450 g glasses", | ||
"UnitPrice": 12.0000, | ||
"UnitsInStock": 95, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 0, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 8, | ||
"CategoryName": "Seafood", | ||
"Description": "Seaweed and fish" | ||
ProductID: 46, | ||
ProductName: 'Spegesild', | ||
SupplierID: 21, | ||
CategoryID: 8, | ||
QuantityPerUnit: '4 - 450 g glasses', | ||
UnitPrice: 12.0000, | ||
UnitsInStock: 95, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 0, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 8, | ||
CategoryName: 'Seafood', | ||
Description: 'Seaweed and fish' | ||
} | ||
}, { | ||
"ProductID": 47, | ||
"ProductName": "Zaanse koeken", | ||
"SupplierID": 22, | ||
"CategoryID": 3, | ||
"QuantityPerUnit": "10 - 4 oz boxes", | ||
"UnitPrice": 9.5000, | ||
"UnitsInStock": 36, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 0, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 3, | ||
"CategoryName": "Confections", | ||
"Description": "Desserts, candies, and sweet breads" | ||
ProductID: 47, | ||
ProductName: 'Zaanse koeken', | ||
SupplierID: 22, | ||
CategoryID: 3, | ||
QuantityPerUnit: '10 - 4 oz boxes', | ||
UnitPrice: 9.5000, | ||
UnitsInStock: 36, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 0, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 3, | ||
CategoryName: 'Confections', | ||
Description: 'Desserts, candies, and sweet breads' | ||
} | ||
}, { | ||
"ProductID": 48, | ||
"ProductName": "Chocolade", | ||
"SupplierID": 22, | ||
"CategoryID": 3, | ||
"QuantityPerUnit": "10 pkgs.", | ||
"UnitPrice": 12.7500, | ||
"UnitsInStock": 15, | ||
"UnitsOnOrder": 70, | ||
"ReorderLevel": 25, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 3, | ||
"CategoryName": "Confections", | ||
"Description": "Desserts, candies, and sweet breads" | ||
ProductID: 48, | ||
ProductName: 'Chocolade', | ||
SupplierID: 22, | ||
CategoryID: 3, | ||
QuantityPerUnit: '10 pkgs.', | ||
UnitPrice: 12.7500, | ||
UnitsInStock: 15, | ||
UnitsOnOrder: 70, | ||
ReorderLevel: 25, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 3, | ||
CategoryName: 'Confections', | ||
Description: 'Desserts, candies, and sweet breads' | ||
} | ||
}, { | ||
"ProductID": 49, | ||
"ProductName": "Maxilaku", | ||
"SupplierID": 23, | ||
"CategoryID": 3, | ||
"QuantityPerUnit": "24 - 50 g pkgs.", | ||
"UnitPrice": 20.0000, | ||
"UnitsInStock": 10, | ||
"UnitsOnOrder": 60, | ||
"ReorderLevel": 15, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 3, | ||
"CategoryName": "Confections", | ||
"Description": "Desserts, candies, and sweet breads" | ||
ProductID: 49, | ||
ProductName: 'Maxilaku', | ||
SupplierID: 23, | ||
CategoryID: 3, | ||
QuantityPerUnit: '24 - 50 g pkgs.', | ||
UnitPrice: 20.0000, | ||
UnitsInStock: 10, | ||
UnitsOnOrder: 60, | ||
ReorderLevel: 15, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 3, | ||
CategoryName: 'Confections', | ||
Description: 'Desserts, candies, and sweet breads' | ||
} | ||
}, { | ||
"ProductID": 50, | ||
"ProductName": "Valkoinen suklaa", | ||
"SupplierID": 23, | ||
"CategoryID": 3, | ||
"QuantityPerUnit": "12 - 100 g bars", | ||
"UnitPrice": 16.2500, | ||
"UnitsInStock": 65, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 30, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 3, | ||
"CategoryName": "Confections", | ||
"Description": "Desserts, candies, and sweet breads" | ||
ProductID: 50, | ||
ProductName: 'Valkoinen suklaa', | ||
SupplierID: 23, | ||
CategoryID: 3, | ||
QuantityPerUnit: '12 - 100 g bars', | ||
UnitPrice: 16.2500, | ||
UnitsInStock: 65, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 30, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 3, | ||
CategoryName: 'Confections', | ||
Description: 'Desserts, candies, and sweet breads' | ||
} | ||
}, { | ||
"ProductID": 51, | ||
"ProductName": "Manjimup Dried Apples", | ||
"SupplierID": 24, | ||
"CategoryID": 7, | ||
"QuantityPerUnit": "50 - 300 g pkgs.", | ||
"UnitPrice": 53.0000, | ||
"UnitsInStock": 20, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 10, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 7, | ||
"CategoryName": "Produce", | ||
"Description": "Dried fruit and bean curd" | ||
ProductID: 51, | ||
ProductName: 'Manjimup Dried Apples', | ||
SupplierID: 24, | ||
CategoryID: 7, | ||
QuantityPerUnit: '50 - 300 g pkgs.', | ||
UnitPrice: 53.0000, | ||
UnitsInStock: 20, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 10, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 7, | ||
CategoryName: 'Produce', | ||
Description: 'Dried fruit and bean curd' | ||
} | ||
}, { | ||
"ProductID": 52, | ||
"ProductName": "Filo Mix", | ||
"SupplierID": 24, | ||
"CategoryID": 5, | ||
"QuantityPerUnit": "16 - 2 kg boxes", | ||
"UnitPrice": 7.0000, | ||
"UnitsInStock": 38, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 25, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 5, | ||
"CategoryName": "Grains/Cereals", | ||
"Description": "Breads, crackers, pasta, and cereal" | ||
ProductID: 52, | ||
ProductName: 'Filo Mix', | ||
SupplierID: 24, | ||
CategoryID: 5, | ||
QuantityPerUnit: '16 - 2 kg boxes', | ||
UnitPrice: 7.0000, | ||
UnitsInStock: 38, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 25, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 5, | ||
CategoryName: 'Grains/Cereals', | ||
Description: 'Breads, crackers, pasta, and cereal' | ||
} | ||
}, { | ||
"ProductID": 53, | ||
"ProductName": "Perth Pasties", | ||
"SupplierID": 24, | ||
"CategoryID": 6, | ||
"QuantityPerUnit": "48 pieces", | ||
"UnitPrice": 32.8000, | ||
"UnitsInStock": 0, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 0, | ||
"Discontinued": true, | ||
"Category": { | ||
"CategoryID": 6, | ||
"CategoryName": "Meat/Poultry", | ||
"Description": "Prepared meats" | ||
ProductID: 53, | ||
ProductName: 'Perth Pasties', | ||
SupplierID: 24, | ||
CategoryID: 6, | ||
QuantityPerUnit: '48 pieces', | ||
UnitPrice: 32.8000, | ||
UnitsInStock: 0, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 0, | ||
Discontinued: true, | ||
Category: { | ||
CategoryID: 6, | ||
CategoryName: 'Meat/Poultry', | ||
Description: 'Prepared meats' | ||
} | ||
}, { | ||
"ProductID": 54, | ||
"ProductName": "Tourtière", | ||
"SupplierID": 25, | ||
"CategoryID": 6, | ||
"QuantityPerUnit": "16 pies", | ||
"UnitPrice": 7.4500, | ||
"UnitsInStock": 21, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 10, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 6, | ||
"CategoryName": "Meat/Poultry", | ||
"Description": "Prepared meats" | ||
ProductID: 54, | ||
ProductName: 'Tourtière', | ||
SupplierID: 25, | ||
CategoryID: 6, | ||
QuantityPerUnit: '16 pies', | ||
UnitPrice: 7.4500, | ||
UnitsInStock: 21, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 10, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 6, | ||
CategoryName: 'Meat/Poultry', | ||
Description: 'Prepared meats' | ||
} | ||
}, { | ||
"ProductID": 55, | ||
"ProductName": "Pâté chinois", | ||
"SupplierID": 25, | ||
"CategoryID": 6, | ||
"QuantityPerUnit": "24 boxes x 2 pies", | ||
"UnitPrice": 24.0000, | ||
"UnitsInStock": 115, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 20, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 6, | ||
"CategoryName": "Meat/Poultry", | ||
"Description": "Prepared meats" | ||
ProductID: 55, | ||
ProductName: 'Pâté chinois', | ||
SupplierID: 25, | ||
CategoryID: 6, | ||
QuantityPerUnit: '24 boxes x 2 pies', | ||
UnitPrice: 24.0000, | ||
UnitsInStock: 115, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 20, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 6, | ||
CategoryName: 'Meat/Poultry', | ||
Description: 'Prepared meats' | ||
} | ||
}, { | ||
"ProductID": 56, | ||
"ProductName": "Gnocchi di nonna Alice", | ||
"SupplierID": 26, | ||
"CategoryID": 5, | ||
"QuantityPerUnit": "24 - 250 g pkgs.", | ||
"UnitPrice": 38.0000, | ||
"UnitsInStock": 21, | ||
"UnitsOnOrder": 10, | ||
"ReorderLevel": 30, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 5, | ||
"CategoryName": "Grains/Cereals", | ||
"Description": "Breads, crackers, pasta, and cereal" | ||
ProductID: 56, | ||
ProductName: 'Gnocchi di nonna Alice', | ||
SupplierID: 26, | ||
CategoryID: 5, | ||
QuantityPerUnit: '24 - 250 g pkgs.', | ||
UnitPrice: 38.0000, | ||
UnitsInStock: 21, | ||
UnitsOnOrder: 10, | ||
ReorderLevel: 30, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 5, | ||
CategoryName: 'Grains/Cereals', | ||
Description: 'Breads, crackers, pasta, and cereal' | ||
} | ||
}, { | ||
"ProductID": 57, | ||
"ProductName": "Ravioli Angelo", | ||
"SupplierID": 26, | ||
"CategoryID": 5, | ||
"QuantityPerUnit": "24 - 250 g pkgs.", | ||
"UnitPrice": 19.5000, | ||
"UnitsInStock": 36, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 20, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 5, | ||
"CategoryName": "Grains/Cereals", | ||
"Description": "Breads, crackers, pasta, and cereal" | ||
ProductID: 57, | ||
ProductName: 'Ravioli Angelo', | ||
SupplierID: 26, | ||
CategoryID: 5, | ||
QuantityPerUnit: '24 - 250 g pkgs.', | ||
UnitPrice: 19.5000, | ||
UnitsInStock: 36, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 20, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 5, | ||
CategoryName: 'Grains/Cereals', | ||
Description: 'Breads, crackers, pasta, and cereal' | ||
} | ||
}, { | ||
"ProductID": 58, | ||
"ProductName": "Escargots de Bourgogne", | ||
"SupplierID": 27, | ||
"CategoryID": 8, | ||
"QuantityPerUnit": "24 pieces", | ||
"UnitPrice": 13.2500, | ||
"UnitsInStock": 62, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 20, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 8, | ||
"CategoryName": "Seafood", | ||
"Description": "Seaweed and fish" | ||
ProductID: 58, | ||
ProductName: 'Escargots de Bourgogne', | ||
SupplierID: 27, | ||
CategoryID: 8, | ||
QuantityPerUnit: '24 pieces', | ||
UnitPrice: 13.2500, | ||
UnitsInStock: 62, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 20, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 8, | ||
CategoryName: 'Seafood', | ||
Description: 'Seaweed and fish' | ||
} | ||
}, { | ||
"ProductID": 59, | ||
"ProductName": "Raclette Courdavault", | ||
"SupplierID": 28, | ||
"CategoryID": 4, | ||
"QuantityPerUnit": "5 kg pkg.", | ||
"UnitPrice": 55.0000, | ||
"UnitsInStock": 79, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 0, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 4, | ||
"CategoryName": "Dairy Products", | ||
"Description": "Cheeses" | ||
ProductID: 59, | ||
ProductName: 'Raclette Courdavault', | ||
SupplierID: 28, | ||
CategoryID: 4, | ||
QuantityPerUnit: '5 kg pkg.', | ||
UnitPrice: 55.0000, | ||
UnitsInStock: 79, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 0, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 4, | ||
CategoryName: 'Dairy Products', | ||
Description: 'Cheeses' | ||
} | ||
}, { | ||
"ProductID": 60, | ||
"ProductName": "Camembert Pierrot", | ||
"SupplierID": 28, | ||
"CategoryID": 4, | ||
"QuantityPerUnit": "15 - 300 g rounds", | ||
"UnitPrice": 34.0000, | ||
"UnitsInStock": 19, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 0, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 4, | ||
"CategoryName": "Dairy Products", | ||
"Description": "Cheeses" | ||
ProductID: 60, | ||
ProductName: 'Camembert Pierrot', | ||
SupplierID: 28, | ||
CategoryID: 4, | ||
QuantityPerUnit: '15 - 300 g rounds', | ||
UnitPrice: 34.0000, | ||
UnitsInStock: 19, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 0, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 4, | ||
CategoryName: 'Dairy Products', | ||
Description: 'Cheeses' | ||
} | ||
}, { | ||
"ProductID": 61, | ||
"ProductName": "Sirop d'érable", | ||
"SupplierID": 29, | ||
"CategoryID": 2, | ||
"QuantityPerUnit": "24 - 500 ml bottles", | ||
"UnitPrice": 28.5000, | ||
"UnitsInStock": 113, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 25, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 2, | ||
"CategoryName": "Condiments", | ||
"Description": "Sweet and savory sauces, relishes, spreads, and seasonings" | ||
ProductID: 61, | ||
ProductName: 'Sirop dérable', | ||
SupplierID: 29, | ||
CategoryID: 2, | ||
QuantityPerUnit: '24 - 500 ml bottles', | ||
UnitPrice: 28.5000, | ||
UnitsInStock: 113, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 25, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 2, | ||
CategoryName: 'Condiments', | ||
Description: 'Sweet and savory sauces, relishes, spreads, and seasonings' | ||
} | ||
}, { | ||
"ProductID": 62, | ||
"ProductName": "Tarte au sucre", | ||
"SupplierID": 29, | ||
"CategoryID": 3, | ||
"QuantityPerUnit": "48 pies", | ||
"UnitPrice": 49.3000, | ||
"UnitsInStock": 17, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 0, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 3, | ||
"CategoryName": "Confections", | ||
"Description": "Desserts, candies, and sweet breads" | ||
ProductID: 62, | ||
ProductName: 'Tarte au sucre', | ||
SupplierID: 29, | ||
CategoryID: 3, | ||
QuantityPerUnit: '48 pies', | ||
UnitPrice: 49.3000, | ||
UnitsInStock: 17, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 0, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 3, | ||
CategoryName: 'Confections', | ||
Description: 'Desserts, candies, and sweet breads' | ||
} | ||
}, { | ||
"ProductID": 63, | ||
"ProductName": "Vegie-spread", | ||
"SupplierID": 7, | ||
"CategoryID": 2, | ||
"QuantityPerUnit": "15 - 625 g jars", | ||
"UnitPrice": 43.9000, | ||
"UnitsInStock": 24, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 5, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 2, | ||
"CategoryName": "Condiments", | ||
"Description": "Sweet and savory sauces, relishes, spreads, and seasonings" | ||
ProductID: 63, | ||
ProductName: 'Vegie-spread', | ||
SupplierID: 7, | ||
CategoryID: 2, | ||
QuantityPerUnit: '15 - 625 g jars', | ||
UnitPrice: 43.9000, | ||
UnitsInStock: 24, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 5, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 2, | ||
CategoryName: 'Condiments', | ||
Description: 'Sweet and savory sauces, relishes, spreads, and seasonings' | ||
} | ||
}, { | ||
"ProductID": 64, | ||
"ProductName": "Wimmers gute Semmelknödel", | ||
"SupplierID": 12, | ||
"CategoryID": 5, | ||
"QuantityPerUnit": "20 bags x 4 pieces", | ||
"UnitPrice": 33.2500, | ||
"UnitsInStock": 22, | ||
"UnitsOnOrder": 80, | ||
"ReorderLevel": 30, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 5, | ||
"CategoryName": "Grains/Cereals", | ||
"Description": "Breads, crackers, pasta, and cereal" | ||
ProductID: 64, | ||
ProductName: 'Wimmers gute Semmelknödel', | ||
SupplierID: 12, | ||
CategoryID: 5, | ||
QuantityPerUnit: '20 bags x 4 pieces', | ||
UnitPrice: 33.2500, | ||
UnitsInStock: 22, | ||
UnitsOnOrder: 80, | ||
ReorderLevel: 30, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 5, | ||
CategoryName: 'Grains/Cereals', | ||
Description: 'Breads, crackers, pasta, and cereal' | ||
} | ||
}, { | ||
"ProductID": 65, | ||
"ProductName": "Louisiana Fiery Hot Pepper Sauce", | ||
"SupplierID": 2, | ||
"CategoryID": 2, | ||
"QuantityPerUnit": "32 - 8 oz bottles", | ||
"UnitPrice": 21.0500, | ||
"UnitsInStock": 76, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 0, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 2, | ||
"CategoryName": "Condiments", | ||
"Description": "Sweet and savory sauces, relishes, spreads, and seasonings" | ||
ProductID: 65, | ||
ProductName: 'Louisiana Fiery Hot Pepper Sauce', | ||
SupplierID: 2, | ||
CategoryID: 2, | ||
QuantityPerUnit: '32 - 8 oz bottles', | ||
UnitPrice: 21.0500, | ||
UnitsInStock: 76, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 0, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 2, | ||
CategoryName: 'Condiments', | ||
Description: 'Sweet and savory sauces, relishes, spreads, and seasonings' | ||
} | ||
}, { | ||
"ProductID": 66, | ||
"ProductName": "Louisiana Hot Spiced Okra", | ||
"SupplierID": 2, | ||
"CategoryID": 2, | ||
"QuantityPerUnit": "24 - 8 oz jars", | ||
"UnitPrice": 17.0000, | ||
"UnitsInStock": 4, | ||
"UnitsOnOrder": 100, | ||
"ReorderLevel": 20, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 2, | ||
"CategoryName": "Condiments", | ||
"Description": "Sweet and savory sauces, relishes, spreads, and seasonings" | ||
ProductID: 66, | ||
ProductName: 'Louisiana Hot Spiced Okra', | ||
SupplierID: 2, | ||
CategoryID: 2, | ||
QuantityPerUnit: '24 - 8 oz jars', | ||
UnitPrice: 17.0000, | ||
UnitsInStock: 4, | ||
UnitsOnOrder: 100, | ||
ReorderLevel: 20, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 2, | ||
CategoryName: 'Condiments', | ||
Description: 'Sweet and savory sauces, relishes, spreads, and seasonings' | ||
} | ||
}, { | ||
"ProductID": 67, | ||
"ProductName": "Laughing Lumberjack Lager", | ||
"SupplierID": 16, | ||
"CategoryID": 1, | ||
"QuantityPerUnit": "24 - 12 oz bottles", | ||
"UnitPrice": 14.0000, | ||
"UnitsInStock": 52, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 10, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 1, | ||
"CategoryName": "Beverages", | ||
"Description": "Soft drinks, coffees, teas, beers, and ales" | ||
ProductID: 67, | ||
ProductName: 'Laughing Lumberjack Lager', | ||
SupplierID: 16, | ||
CategoryID: 1, | ||
QuantityPerUnit: '24 - 12 oz bottles', | ||
UnitPrice: 14.0000, | ||
UnitsInStock: 52, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 10, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 1, | ||
CategoryName: 'Beverages', | ||
Description: 'Soft drinks, coffees, teas, beers, and ales' | ||
} | ||
}, { | ||
"ProductID": 68, | ||
"ProductName": "Scottish Longbreads", | ||
"SupplierID": 8, | ||
"CategoryID": 3, | ||
"QuantityPerUnit": "10 boxes x 8 pieces", | ||
"UnitPrice": 12.5000, | ||
"UnitsInStock": 6, | ||
"UnitsOnOrder": 10, | ||
"ReorderLevel": 15, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 3, | ||
"CategoryName": "Confections", | ||
"Description": "Desserts, candies, and sweet breads" | ||
ProductID: 68, | ||
ProductName: 'Scottish Longbreads', | ||
SupplierID: 8, | ||
CategoryID: 3, | ||
QuantityPerUnit: '10 boxes x 8 pieces', | ||
UnitPrice: 12.5000, | ||
UnitsInStock: 6, | ||
UnitsOnOrder: 10, | ||
ReorderLevel: 15, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 3, | ||
CategoryName: 'Confections', | ||
Description: 'Desserts, candies, and sweet breads' | ||
} | ||
}, { | ||
"ProductID": 69, | ||
"ProductName": "Gudbrandsdalsost", | ||
"SupplierID": 15, | ||
"CategoryID": 4, | ||
"QuantityPerUnit": "10 kg pkg.", | ||
"UnitPrice": 36.0000, | ||
"UnitsInStock": 26, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 15, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 4, | ||
"CategoryName": "Dairy Products", | ||
"Description": "Cheeses" | ||
ProductID: 69, | ||
ProductName: 'Gudbrandsdalsost', | ||
SupplierID: 15, | ||
CategoryID: 4, | ||
QuantityPerUnit: '10 kg pkg.', | ||
UnitPrice: 36.0000, | ||
UnitsInStock: 26, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 15, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 4, | ||
CategoryName: 'Dairy Products', | ||
Description: 'Cheeses' | ||
} | ||
}, { | ||
"ProductID": 70, | ||
"ProductName": "Outback Lager", | ||
"SupplierID": 7, | ||
"CategoryID": 1, | ||
"QuantityPerUnit": "24 - 355 ml bottles", | ||
"UnitPrice": 15.0000, | ||
"UnitsInStock": 15, | ||
"UnitsOnOrder": 10, | ||
"ReorderLevel": 30, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 1, | ||
"CategoryName": "Beverages", | ||
"Description": "Soft drinks, coffees, teas, beers, and ales" | ||
ProductID: 70, | ||
ProductName: 'Outback Lager', | ||
SupplierID: 7, | ||
CategoryID: 1, | ||
QuantityPerUnit: '24 - 355 ml bottles', | ||
UnitPrice: 15.0000, | ||
UnitsInStock: 15, | ||
UnitsOnOrder: 10, | ||
ReorderLevel: 30, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 1, | ||
CategoryName: 'Beverages', | ||
Description: 'Soft drinks, coffees, teas, beers, and ales' | ||
} | ||
}, { | ||
"ProductID": 71, | ||
"ProductName": "Flotemysost", | ||
"SupplierID": 15, | ||
"CategoryID": 4, | ||
"QuantityPerUnit": "10 - 500 g pkgs.", | ||
"UnitPrice": 21.5000, | ||
"UnitsInStock": 26, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 0, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 4, | ||
"CategoryName": "Dairy Products", | ||
"Description": "Cheeses" | ||
ProductID: 71, | ||
ProductName: 'Flotemysost', | ||
SupplierID: 15, | ||
CategoryID: 4, | ||
QuantityPerUnit: '10 - 500 g pkgs.', | ||
UnitPrice: 21.5000, | ||
UnitsInStock: 26, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 0, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 4, | ||
CategoryName: 'Dairy Products', | ||
Description: 'Cheeses' | ||
} | ||
}, { | ||
"ProductID": 72, | ||
"ProductName": "Mozzarella di Giovanni", | ||
"SupplierID": 14, | ||
"CategoryID": 4, | ||
"QuantityPerUnit": "24 - 200 g pkgs.", | ||
"UnitPrice": 34.8000, | ||
"UnitsInStock": 14, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 0, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 4, | ||
"CategoryName": "Dairy Products", | ||
"Description": "Cheeses" | ||
ProductID: 72, | ||
ProductName: 'Mozzarella di Giovanni', | ||
SupplierID: 14, | ||
CategoryID: 4, | ||
QuantityPerUnit: '24 - 200 g pkgs.', | ||
UnitPrice: 34.8000, | ||
UnitsInStock: 14, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 0, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 4, | ||
CategoryName: 'Dairy Products', | ||
Description: 'Cheeses' | ||
} | ||
}, { | ||
"ProductID": 73, | ||
"ProductName": "Röd Kaviar", | ||
"SupplierID": 17, | ||
"CategoryID": 8, | ||
"QuantityPerUnit": "24 - 150 g jars", | ||
"UnitPrice": 15.0000, | ||
"UnitsInStock": 101, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 5, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 8, | ||
"CategoryName": "Seafood", | ||
"Description": "Seaweed and fish" | ||
ProductID: 73, | ||
ProductName: 'Röd Kaviar', | ||
SupplierID: 17, | ||
CategoryID: 8, | ||
QuantityPerUnit: '24 - 150 g jars', | ||
UnitPrice: 15.0000, | ||
UnitsInStock: 101, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 5, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 8, | ||
CategoryName: 'Seafood', | ||
Description: 'Seaweed and fish' | ||
} | ||
}, { | ||
"ProductID": 74, | ||
"ProductName": "Longlife Tofu", | ||
"SupplierID": 4, | ||
"CategoryID": 7, | ||
"QuantityPerUnit": "5 kg pkg.", | ||
"UnitPrice": 10.0000, | ||
"UnitsInStock": 4, | ||
"UnitsOnOrder": 20, | ||
"ReorderLevel": 5, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 7, | ||
"CategoryName": "Produce", | ||
"Description": "Dried fruit and bean curd" | ||
ProductID: 74, | ||
ProductName: 'Longlife Tofu', | ||
SupplierID: 4, | ||
CategoryID: 7, | ||
QuantityPerUnit: '5 kg pkg.', | ||
UnitPrice: 10.0000, | ||
UnitsInStock: 4, | ||
UnitsOnOrder: 20, | ||
ReorderLevel: 5, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 7, | ||
CategoryName: 'Produce', | ||
Description: 'Dried fruit and bean curd' | ||
} | ||
}, { | ||
"ProductID": 75, | ||
"ProductName": "Rhönbräu Klosterbier", | ||
"SupplierID": 12, | ||
"CategoryID": 1, | ||
"QuantityPerUnit": "24 - 0.5 l bottles", | ||
"UnitPrice": 7.7500, | ||
"UnitsInStock": 125, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 25, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 1, | ||
"CategoryName": "Beverages", | ||
"Description": "Soft drinks, coffees, teas, beers, and ales" | ||
ProductID: 75, | ||
ProductName: 'Rhönbräu Klosterbier', | ||
SupplierID: 12, | ||
CategoryID: 1, | ||
QuantityPerUnit: '24 - 0.5 l bottles', | ||
UnitPrice: 7.7500, | ||
UnitsInStock: 125, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 25, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 1, | ||
CategoryName: 'Beverages', | ||
Description: 'Soft drinks, coffees, teas, beers, and ales' | ||
} | ||
}, { | ||
"ProductID": 76, | ||
"ProductName": "Lakkalikööri", | ||
"SupplierID": 23, | ||
"CategoryID": 1, | ||
"QuantityPerUnit": "500 ml", | ||
"UnitPrice": 18.0000, | ||
"UnitsInStock": 57, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 20, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 1, | ||
"CategoryName": "Beverages", | ||
"Description": "Soft drinks, coffees, teas, beers, and ales" | ||
ProductID: 76, | ||
ProductName: 'Lakkalikööri', | ||
SupplierID: 23, | ||
CategoryID: 1, | ||
QuantityPerUnit: '500 ml', | ||
UnitPrice: 18.0000, | ||
UnitsInStock: 57, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 20, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 1, | ||
CategoryName: 'Beverages', | ||
Description: 'Soft drinks, coffees, teas, beers, and ales' | ||
} | ||
}, { | ||
"ProductID": 77, | ||
"ProductName": "Original Frankfurter grüne Soße", | ||
"SupplierID": 12, | ||
"CategoryID": 2, | ||
"QuantityPerUnit": "12 boxes", | ||
"UnitPrice": 13.0000, | ||
"UnitsInStock": 32, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 15, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 2, | ||
"CategoryName": "Condiments", | ||
"Description": "Sweet and savory sauces, relishes, spreads, and seasonings" | ||
ProductID: 77, | ||
ProductName: 'Original Frankfurter grüne Soße', | ||
SupplierID: 12, | ||
CategoryID: 2, | ||
QuantityPerUnit: '12 boxes', | ||
UnitPrice: 13.0000, | ||
UnitsInStock: 32, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 15, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 2, | ||
CategoryName: 'Condiments', | ||
Description: 'Sweet and savory sauces, relishes, spreads, and seasonings' | ||
} | ||
}];`; |
@@ -1,1233 +0,1233 @@ | ||
export const products = `[{ | ||
"ProductID": 1, | ||
"ProductName": "Chai", | ||
"SupplierID": 1, | ||
"CategoryID": 1, | ||
"QuantityPerUnit": "10 boxes x 20 bags", | ||
"UnitPrice": 18.0000, | ||
"UnitsInStock": 39, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 10, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 1, | ||
"CategoryName": "Beverages", | ||
"Description": "Soft drinks, coffees, teas, beers, and ales" | ||
export const productsSourceCode = `export const products = [{ | ||
ProductID: 1, | ||
ProductName: 'Chai', | ||
SupplierID: 1, | ||
CategoryID: 1, | ||
QuantityPerUnit: '10 boxes x 20 bags', | ||
UnitPrice: 18.0000, | ||
UnitsInStock: 39, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 10, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 1, | ||
CategoryName: 'Beverages', | ||
Description: 'Soft drinks, coffees, teas, beers, and ales' | ||
} | ||
}, { | ||
"ProductID": 2, | ||
"ProductName": "Chang", | ||
"SupplierID": 1, | ||
"CategoryID": 1, | ||
"QuantityPerUnit": "24 - 12 oz bottles", | ||
"UnitPrice": 19.0000, | ||
"UnitsInStock": 17, | ||
"UnitsOnOrder": 40, | ||
"ReorderLevel": 25, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 1, | ||
"CategoryName": "Beverages", | ||
"Description": "Soft drinks, coffees, teas, beers, and ales" | ||
ProductID: 2, | ||
ProductName: 'Chang', | ||
SupplierID: 1, | ||
CategoryID: 1, | ||
QuantityPerUnit: '24 - 12 oz bottles', | ||
UnitPrice: 19.0000, | ||
UnitsInStock: 17, | ||
UnitsOnOrder: 40, | ||
ReorderLevel: 25, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 1, | ||
CategoryName: 'Beverages', | ||
Description: 'Soft drinks, coffees, teas, beers, and ales' | ||
} | ||
}, { | ||
"ProductID": 3, | ||
"ProductName": "Aniseed Syrup", | ||
"SupplierID": 1, | ||
"CategoryID": 2, | ||
"QuantityPerUnit": "12 - 550 ml bottles", | ||
"UnitPrice": 10.0000, | ||
"UnitsInStock": 13, | ||
"UnitsOnOrder": 70, | ||
"ReorderLevel": 25, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 2, | ||
"CategoryName": "Condiments", | ||
"Description": "Sweet and savory sauces, relishes, spreads, and seasonings" | ||
ProductID: 3, | ||
ProductName: 'Aniseed Syrup', | ||
SupplierID: 1, | ||
CategoryID: 2, | ||
QuantityPerUnit: '12 - 550 ml bottles', | ||
UnitPrice: 10.0000, | ||
UnitsInStock: 13, | ||
UnitsOnOrder: 70, | ||
ReorderLevel: 25, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 2, | ||
CategoryName: 'Condiments', | ||
Description: 'Sweet and savory sauces, relishes, spreads, and seasonings' | ||
} | ||
}, { | ||
"ProductID": 4, | ||
"ProductName": "Chef Anton's Cajun Seasoning", | ||
"SupplierID": 2, | ||
"CategoryID": 2, | ||
"QuantityPerUnit": "48 - 6 oz jars", | ||
"UnitPrice": 22.0000, | ||
"UnitsInStock": 53, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 0, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 2, | ||
"CategoryName": "Condiments", | ||
"Description": "Sweet and savory sauces, relishes, spreads, and seasonings" | ||
ProductID: 4, | ||
ProductName: 'Chef Antons Cajun Seasoning', | ||
SupplierID: 2, | ||
CategoryID: 2, | ||
QuantityPerUnit: '48 - 6 oz jars', | ||
UnitPrice: 22.0000, | ||
UnitsInStock: 53, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 0, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 2, | ||
CategoryName: 'Condiments', | ||
Description: 'Sweet and savory sauces, relishes, spreads, and seasonings' | ||
} | ||
}, { | ||
"ProductID": 5, | ||
"ProductName": "Chef Anton's Gumbo Mix", | ||
"SupplierID": 2, | ||
"CategoryID": 2, | ||
"QuantityPerUnit": "36 boxes", | ||
"UnitPrice": 21.3500, | ||
"UnitsInStock": 0, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 0, | ||
"Discontinued": true, | ||
"Category": { | ||
"CategoryID": 2, | ||
"CategoryName": "Condiments", | ||
"Description": "Sweet and savory sauces, relishes, spreads, and seasonings" | ||
ProductID: 5, | ||
ProductName: 'Chef Antons Gumbo Mix', | ||
SupplierID: 2, | ||
CategoryID: 2, | ||
QuantityPerUnit: '36 boxes', | ||
UnitPrice: 21.3500, | ||
UnitsInStock: 0, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 0, | ||
Discontinued: true, | ||
Category: { | ||
CategoryID: 2, | ||
CategoryName: 'Condiments', | ||
Description: 'Sweet and savory sauces, relishes, spreads, and seasonings' | ||
} | ||
}, { | ||
"ProductID": 6, | ||
"ProductName": "Grandma's Boysenberry Spread", | ||
"SupplierID": 3, | ||
"CategoryID": 2, | ||
"QuantityPerUnit": "12 - 8 oz jars", | ||
"UnitPrice": 25.0000, | ||
"UnitsInStock": 120, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 25, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 2, | ||
"CategoryName": "Condiments", | ||
"Description": "Sweet and savory sauces, relishes, spreads, and seasonings" | ||
ProductID: 6, | ||
ProductName: 'Grandmas Boysenberry Spread', | ||
SupplierID: 3, | ||
CategoryID: 2, | ||
QuantityPerUnit: '12 - 8 oz jars', | ||
UnitPrice: 25.0000, | ||
UnitsInStock: 120, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 25, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 2, | ||
CategoryName: 'Condiments', | ||
Description: 'Sweet and savory sauces, relishes, spreads, and seasonings' | ||
} | ||
}, { | ||
"ProductID": 7, | ||
"ProductName": "Uncle Bob's Organic Dried Pears", | ||
"SupplierID": 3, | ||
"CategoryID": 7, | ||
"QuantityPerUnit": "12 - 1 lb pkgs.", | ||
"UnitPrice": 30.0000, | ||
"UnitsInStock": 15, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 10, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 7, | ||
"CategoryName": "Produce", | ||
"Description": "Dried fruit and bean curd" | ||
ProductID: 7, | ||
ProductName: 'Uncle Bobs Organic Dried Pears', | ||
SupplierID: 3, | ||
CategoryID: 7, | ||
QuantityPerUnit: '12 - 1 lb pkgs.', | ||
UnitPrice: 30.0000, | ||
UnitsInStock: 15, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 10, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 7, | ||
CategoryName: 'Produce', | ||
Description: 'Dried fruit and bean curd' | ||
} | ||
}, { | ||
"ProductID": 8, | ||
"ProductName": "Northwoods Cranberry Sauce", | ||
"SupplierID": 3, | ||
"CategoryID": 2, | ||
"QuantityPerUnit": "12 - 12 oz jars", | ||
"UnitPrice": 40.0000, | ||
"UnitsInStock": 6, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 0, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 2, | ||
"CategoryName": "Condiments", | ||
"Description": "Sweet and savory sauces, relishes, spreads, and seasonings" | ||
ProductID: 8, | ||
ProductName: 'Northwoods Cranberry Sauce', | ||
SupplierID: 3, | ||
CategoryID: 2, | ||
QuantityPerUnit: '12 - 12 oz jars', | ||
UnitPrice: 40.0000, | ||
UnitsInStock: 6, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 0, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 2, | ||
CategoryName: 'Condiments', | ||
Description: 'Sweet and savory sauces, relishes, spreads, and seasonings' | ||
} | ||
}, { | ||
"ProductID": 9, | ||
"ProductName": "Mishi Kobe Niku", | ||
"SupplierID": 4, | ||
"CategoryID": 6, | ||
"QuantityPerUnit": "18 - 500 g pkgs.", | ||
"UnitPrice": 97.0000, | ||
"UnitsInStock": 29, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 0, | ||
"Discontinued": true, | ||
"Category": { | ||
"CategoryID": 6, | ||
"CategoryName": "Meat/Poultry", | ||
"Description": "Prepared meats" | ||
ProductID: 9, | ||
ProductName: 'Mishi Kobe Niku', | ||
SupplierID: 4, | ||
CategoryID: 6, | ||
QuantityPerUnit: '18 - 500 g pkgs.', | ||
UnitPrice: 97.0000, | ||
UnitsInStock: 29, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 0, | ||
Discontinued: true, | ||
Category: { | ||
CategoryID: 6, | ||
CategoryName: 'Meat/Poultry', | ||
Description: 'Prepared meats' | ||
} | ||
}, { | ||
"ProductID": 10, | ||
"ProductName": "Ikura", | ||
"SupplierID": 4, | ||
"CategoryID": 8, | ||
"QuantityPerUnit": "12 - 200 ml jars", | ||
"UnitPrice": 31.0000, | ||
"UnitsInStock": 31, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 0, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 8, | ||
"CategoryName": "Seafood", | ||
"Description": "Seaweed and fish" | ||
ProductID: 10, | ||
ProductName: 'Ikura', | ||
SupplierID: 4, | ||
CategoryID: 8, | ||
QuantityPerUnit: '12 - 200 ml jars', | ||
UnitPrice: 31.0000, | ||
UnitsInStock: 31, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 0, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 8, | ||
CategoryName: 'Seafood', | ||
Description: 'Seaweed and fish' | ||
} | ||
}, { | ||
"ProductID": 11, | ||
"ProductName": "Queso Cabrales", | ||
"SupplierID": 5, | ||
"CategoryID": 4, | ||
"QuantityPerUnit": "1 kg pkg.", | ||
"UnitPrice": 21.0000, | ||
"UnitsInStock": 22, | ||
"UnitsOnOrder": 30, | ||
"ReorderLevel": 30, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 4, | ||
"CategoryName": "Dairy Products", | ||
"Description": "Cheeses" | ||
ProductID: 11, | ||
ProductName: 'Queso Cabrales', | ||
SupplierID: 5, | ||
CategoryID: 4, | ||
QuantityPerUnit: '1 kg pkg.', | ||
UnitPrice: 21.0000, | ||
UnitsInStock: 22, | ||
UnitsOnOrder: 30, | ||
ReorderLevel: 30, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 4, | ||
CategoryName: 'Dairy Products', | ||
Description: 'Cheeses' | ||
} | ||
}, { | ||
"ProductID": 12, | ||
"ProductName": "Queso Manchego La Pastora", | ||
"SupplierID": 5, | ||
"CategoryID": 4, | ||
"QuantityPerUnit": "10 - 500 g pkgs.", | ||
"UnitPrice": 38.0000, | ||
"UnitsInStock": 86, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 0, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 4, | ||
"CategoryName": "Dairy Products", | ||
"Description": "Cheeses" | ||
ProductID: 12, | ||
ProductName: 'Queso Manchego La Pastora', | ||
SupplierID: 5, | ||
CategoryID: 4, | ||
QuantityPerUnit: '10 - 500 g pkgs.', | ||
UnitPrice: 38.0000, | ||
UnitsInStock: 86, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 0, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 4, | ||
CategoryName: 'Dairy Products', | ||
Description: 'Cheeses' | ||
} | ||
}, { | ||
"ProductID": 13, | ||
"ProductName": "Konbu", | ||
"SupplierID": 6, | ||
"CategoryID": 8, | ||
"QuantityPerUnit": "2 kg box", | ||
"UnitPrice": 6.0000, | ||
"UnitsInStock": 24, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 5, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 8, | ||
"CategoryName": "Seafood", | ||
"Description": "Seaweed and fish" | ||
ProductID: 13, | ||
ProductName: 'Konbu', | ||
SupplierID: 6, | ||
CategoryID: 8, | ||
QuantityPerUnit: '2 kg box', | ||
UnitPrice: 6.0000, | ||
UnitsInStock: 24, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 5, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 8, | ||
CategoryName: 'Seafood', | ||
Description: 'Seaweed and fish' | ||
} | ||
}, { | ||
"ProductID": 14, | ||
"ProductName": "Tofu", | ||
"SupplierID": 6, | ||
"CategoryID": 7, | ||
"QuantityPerUnit": "40 - 100 g pkgs.", | ||
"UnitPrice": 23.2500, | ||
"UnitsInStock": 35, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 0, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 7, | ||
"CategoryName": "Produce", | ||
"Description": "Dried fruit and bean curd" | ||
ProductID: 14, | ||
ProductName: 'Tofu', | ||
SupplierID: 6, | ||
CategoryID: 7, | ||
QuantityPerUnit: '40 - 100 g pkgs.', | ||
UnitPrice: 23.2500, | ||
UnitsInStock: 35, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 0, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 7, | ||
CategoryName: 'Produce', | ||
Description: 'Dried fruit and bean curd' | ||
} | ||
}, { | ||
"ProductID": 15, | ||
"ProductName": "Genen Shouyu", | ||
"SupplierID": 6, | ||
"CategoryID": 2, | ||
"QuantityPerUnit": "24 - 250 ml bottles", | ||
"UnitPrice": 15.5000, | ||
"UnitsInStock": 39, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 5, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 2, | ||
"CategoryName": "Condiments", | ||
"Description": "Sweet and savory sauces, relishes, spreads, and seasonings" | ||
ProductID: 15, | ||
ProductName: 'Genen Shouyu', | ||
SupplierID: 6, | ||
CategoryID: 2, | ||
QuantityPerUnit: '24 - 250 ml bottles', | ||
UnitPrice: 15.5000, | ||
UnitsInStock: 39, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 5, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 2, | ||
CategoryName: 'Condiments', | ||
Description: 'Sweet and savory sauces, relishes, spreads, and seasonings' | ||
} | ||
}, { | ||
"ProductID": 16, | ||
"ProductName": "Pavlova", | ||
"SupplierID": 7, | ||
"CategoryID": 3, | ||
"QuantityPerUnit": "32 - 500 g boxes", | ||
"UnitPrice": 17.4500, | ||
"UnitsInStock": 29, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 10, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 3, | ||
"CategoryName": "Confections", | ||
"Description": "Desserts, candies, and sweet breads" | ||
ProductID: 16, | ||
ProductName: 'Pavlova', | ||
SupplierID: 7, | ||
CategoryID: 3, | ||
QuantityPerUnit: '32 - 500 g boxes', | ||
UnitPrice: 17.4500, | ||
UnitsInStock: 29, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 10, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 3, | ||
CategoryName: 'Confections', | ||
Description: 'Desserts, candies, and sweet breads' | ||
} | ||
}, { | ||
"ProductID": 17, | ||
"ProductName": "Alice Mutton", | ||
"SupplierID": 7, | ||
"CategoryID": 6, | ||
"QuantityPerUnit": "20 - 1 kg tins", | ||
"UnitPrice": 39.0000, | ||
"UnitsInStock": 0, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 0, | ||
"Discontinued": true, | ||
"Category": { | ||
"CategoryID": 6, | ||
"CategoryName": "Meat/Poultry", | ||
"Description": "Prepared meats" | ||
ProductID: 17, | ||
ProductName: 'Alice Mutton', | ||
SupplierID: 7, | ||
CategoryID: 6, | ||
QuantityPerUnit: '20 - 1 kg tins', | ||
UnitPrice: 39.0000, | ||
UnitsInStock: 0, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 0, | ||
Discontinued: true, | ||
Category: { | ||
CategoryID: 6, | ||
CategoryName: 'Meat/Poultry', | ||
Description: 'Prepared meats' | ||
} | ||
}, { | ||
"ProductID": 18, | ||
"ProductName": "Carnarvon Tigers", | ||
"SupplierID": 7, | ||
"CategoryID": 8, | ||
"QuantityPerUnit": "16 kg pkg.", | ||
"UnitPrice": 62.5000, | ||
"UnitsInStock": 42, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 0, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 8, | ||
"CategoryName": "Seafood", | ||
"Description": "Seaweed and fish" | ||
ProductID: 18, | ||
ProductName: 'Carnarvon Tigers', | ||
SupplierID: 7, | ||
CategoryID: 8, | ||
QuantityPerUnit: '16 kg pkg.', | ||
UnitPrice: 62.5000, | ||
UnitsInStock: 42, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 0, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 8, | ||
CategoryName: 'Seafood', | ||
Description: 'Seaweed and fish' | ||
} | ||
}, { | ||
"ProductID": 19, | ||
"ProductName": "Teatime Chocolate Biscuits", | ||
"SupplierID": 8, | ||
"CategoryID": 3, | ||
"QuantityPerUnit": "10 boxes x 12 pieces", | ||
"UnitPrice": 9.2000, | ||
"UnitsInStock": 25, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 5, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 3, | ||
"CategoryName": "Confections", | ||
"Description": "Desserts, candies, and sweet breads" | ||
ProductID: 19, | ||
ProductName: 'Teatime Chocolate Biscuits', | ||
SupplierID: 8, | ||
CategoryID: 3, | ||
QuantityPerUnit: '10 boxes x 12 pieces', | ||
UnitPrice: 9.2000, | ||
UnitsInStock: 25, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 5, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 3, | ||
CategoryName: 'Confections', | ||
Description: 'Desserts, candies, and sweet breads' | ||
} | ||
}, { | ||
"ProductID": 20, | ||
"ProductName": "Sir Rodney's Marmalade", | ||
"SupplierID": 8, | ||
"CategoryID": 3, | ||
"QuantityPerUnit": "30 gift boxes", | ||
"UnitPrice": 81.0000, | ||
"UnitsInStock": 40, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 0, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 3, | ||
"CategoryName": "Confections", | ||
"Description": "Desserts, candies, and sweet breads" | ||
ProductID: 20, | ||
ProductName: 'Sir Rodneys Marmalade', | ||
SupplierID: 8, | ||
CategoryID: 3, | ||
QuantityPerUnit: '30 gift boxes', | ||
UnitPrice: 81.0000, | ||
UnitsInStock: 40, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 0, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 3, | ||
CategoryName: 'Confections', | ||
Description: 'Desserts, candies, and sweet breads' | ||
} | ||
}, { | ||
"ProductID": 21, | ||
"ProductName": "Sir Rodney's Scones", | ||
"SupplierID": 8, | ||
"CategoryID": 3, | ||
"QuantityPerUnit": "24 pkgs. x 4 pieces", | ||
"UnitPrice": 10.0000, | ||
"UnitsInStock": 3, | ||
"UnitsOnOrder": 40, | ||
"ReorderLevel": 5, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 3, | ||
"CategoryName": "Confections", | ||
"Description": "Desserts, candies, and sweet breads" | ||
ProductID: 21, | ||
ProductName: 'Sir Rodneys Scones', | ||
SupplierID: 8, | ||
CategoryID: 3, | ||
QuantityPerUnit: '24 pkgs. x 4 pieces', | ||
UnitPrice: 10.0000, | ||
UnitsInStock: 3, | ||
UnitsOnOrder: 40, | ||
ReorderLevel: 5, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 3, | ||
CategoryName: 'Confections', | ||
Description: 'Desserts, candies, and sweet breads' | ||
} | ||
}, { | ||
"ProductID": 22, | ||
"ProductName": "Gustaf's Knäckebröd", | ||
"SupplierID": 9, | ||
"CategoryID": 5, | ||
"QuantityPerUnit": "24 - 500 g pkgs.", | ||
"UnitPrice": 21.0000, | ||
"UnitsInStock": 104, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 25, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 5, | ||
"CategoryName": "Grains/Cereals", | ||
"Description": "Breads, crackers, pasta, and cereal" | ||
ProductID: 22, | ||
ProductName: 'Gustafs Knäckebröd', | ||
SupplierID: 9, | ||
CategoryID: 5, | ||
QuantityPerUnit: '24 - 500 g pkgs.', | ||
UnitPrice: 21.0000, | ||
UnitsInStock: 104, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 25, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 5, | ||
CategoryName: 'Grains/Cereals', | ||
Description: 'Breads, crackers, pasta, and cereal' | ||
} | ||
}, { | ||
"ProductID": 23, | ||
"ProductName": "Tunnbröd", | ||
"SupplierID": 9, | ||
"CategoryID": 5, | ||
"QuantityPerUnit": "12 - 250 g pkgs.", | ||
"UnitPrice": 9.0000, | ||
"UnitsInStock": 61, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 25, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 5, | ||
"CategoryName": "Grains/Cereals", | ||
"Description": "Breads, crackers, pasta, and cereal" | ||
ProductID: 23, | ||
ProductName: 'Tunnbröd', | ||
SupplierID: 9, | ||
CategoryID: 5, | ||
QuantityPerUnit: '12 - 250 g pkgs.', | ||
UnitPrice: 9.0000, | ||
UnitsInStock: 61, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 25, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 5, | ||
CategoryName: 'Grains/Cereals', | ||
Description: 'Breads, crackers, pasta, and cereal' | ||
} | ||
}, { | ||
"ProductID": 24, | ||
"ProductName": "Guaraná Fantástica", | ||
"SupplierID": 10, | ||
"CategoryID": 1, | ||
"QuantityPerUnit": "12 - 355 ml cans", | ||
"UnitPrice": 4.5000, | ||
"UnitsInStock": 20, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 0, | ||
"Discontinued": true, | ||
"Category": { | ||
"CategoryID": 1, | ||
"CategoryName": "Beverages", | ||
"Description": "Soft drinks, coffees, teas, beers, and ales" | ||
ProductID: 24, | ||
ProductName: 'Guaraná Fantástica', | ||
SupplierID: 10, | ||
CategoryID: 1, | ||
QuantityPerUnit: '12 - 355 ml cans', | ||
UnitPrice: 4.5000, | ||
UnitsInStock: 20, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 0, | ||
Discontinued: true, | ||
Category: { | ||
CategoryID: 1, | ||
CategoryName: 'Beverages', | ||
Description: 'Soft drinks, coffees, teas, beers, and ales' | ||
} | ||
}, { | ||
"ProductID": 25, | ||
"ProductName": "NuNuCa Nuß-Nougat-Creme", | ||
"SupplierID": 11, | ||
"CategoryID": 3, | ||
"QuantityPerUnit": "20 - 450 g glasses", | ||
"UnitPrice": 14.0000, | ||
"UnitsInStock": 76, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 30, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 3, | ||
"CategoryName": "Confections", | ||
"Description": "Desserts, candies, and sweet breads" | ||
ProductID: 25, | ||
ProductName: 'NuNuCa Nuß-Nougat-Creme', | ||
SupplierID: 11, | ||
CategoryID: 3, | ||
QuantityPerUnit: '20 - 450 g glasses', | ||
UnitPrice: 14.0000, | ||
UnitsInStock: 76, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 30, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 3, | ||
CategoryName: 'Confections', | ||
Description: 'Desserts, candies, and sweet breads' | ||
} | ||
}, { | ||
"ProductID": 26, | ||
"ProductName": "Gumbär Gummibärchen", | ||
"SupplierID": 11, | ||
"CategoryID": 3, | ||
"QuantityPerUnit": "100 - 250 g bags", | ||
"UnitPrice": 31.2300, | ||
"UnitsInStock": 15, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 0, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 3, | ||
"CategoryName": "Confections", | ||
"Description": "Desserts, candies, and sweet breads" | ||
ProductID: 26, | ||
ProductName: 'Gumbär Gummibärchen', | ||
SupplierID: 11, | ||
CategoryID: 3, | ||
QuantityPerUnit: '100 - 250 g bags', | ||
UnitPrice: 31.2300, | ||
UnitsInStock: 15, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 0, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 3, | ||
CategoryName: 'Confections', | ||
Description: 'Desserts, candies, and sweet breads' | ||
} | ||
}, { | ||
"ProductID": 27, | ||
"ProductName": "Schoggi Schokolade", | ||
"SupplierID": 11, | ||
"CategoryID": 3, | ||
"QuantityPerUnit": "100 - 100 g pieces", | ||
"UnitPrice": 43.9000, | ||
"UnitsInStock": 49, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 30, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 3, | ||
"CategoryName": "Confections", | ||
"Description": "Desserts, candies, and sweet breads" | ||
ProductID: 27, | ||
ProductName: 'Schoggi Schokolade', | ||
SupplierID: 11, | ||
CategoryID: 3, | ||
QuantityPerUnit: '100 - 100 g pieces', | ||
UnitPrice: 43.9000, | ||
UnitsInStock: 49, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 30, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 3, | ||
CategoryName: 'Confections', | ||
Description: 'Desserts, candies, and sweet breads' | ||
} | ||
}, { | ||
"ProductID": 28, | ||
"ProductName": "Rössle Sauerkraut", | ||
"SupplierID": 12, | ||
"CategoryID": 7, | ||
"QuantityPerUnit": "25 - 825 g cans", | ||
"UnitPrice": 45.6000, | ||
"UnitsInStock": 26, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 0, | ||
"Discontinued": true, | ||
"Category": { | ||
"CategoryID": 7, | ||
"CategoryName": "Produce", | ||
"Description": "Dried fruit and bean curd" | ||
ProductID: 28, | ||
ProductName: 'Rössle Sauerkraut', | ||
SupplierID: 12, | ||
CategoryID: 7, | ||
QuantityPerUnit: '25 - 825 g cans', | ||
UnitPrice: 45.6000, | ||
UnitsInStock: 26, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 0, | ||
Discontinued: true, | ||
Category: { | ||
CategoryID: 7, | ||
CategoryName: 'Produce', | ||
Description: 'Dried fruit and bean curd' | ||
} | ||
}, { | ||
"ProductID": 29, | ||
"ProductName": "Thüringer Rostbratwurst", | ||
"SupplierID": 12, | ||
"CategoryID": 6, | ||
"QuantityPerUnit": "50 bags x 30 sausgs.", | ||
"UnitPrice": 123.7900, | ||
"UnitsInStock": 0, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 0, | ||
"Discontinued": true, | ||
"Category": { | ||
"CategoryID": 6, | ||
"CategoryName": "Meat/Poultry", | ||
"Description": "Prepared meats" | ||
ProductID: 29, | ||
ProductName: 'Thüringer Rostbratwurst', | ||
SupplierID: 12, | ||
CategoryID: 6, | ||
QuantityPerUnit: '50 bags x 30 sausgs.', | ||
UnitPrice: 123.7900, | ||
UnitsInStock: 0, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 0, | ||
Discontinued: true, | ||
Category: { | ||
CategoryID: 6, | ||
CategoryName: 'Meat/Poultry', | ||
Description: 'Prepared meats' | ||
} | ||
}, { | ||
"ProductID": 30, | ||
"ProductName": "Nord-Ost Matjeshering", | ||
"SupplierID": 13, | ||
"CategoryID": 8, | ||
"QuantityPerUnit": "10 - 200 g glasses", | ||
"UnitPrice": 25.8900, | ||
"UnitsInStock": 10, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 15, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 8, | ||
"CategoryName": "Seafood", | ||
"Description": "Seaweed and fish" | ||
ProductID: 30, | ||
ProductName: 'Nord-Ost Matjeshering', | ||
SupplierID: 13, | ||
CategoryID: 8, | ||
QuantityPerUnit: '10 - 200 g glasses', | ||
UnitPrice: 25.8900, | ||
UnitsInStock: 10, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 15, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 8, | ||
CategoryName: 'Seafood', | ||
Description: 'Seaweed and fish' | ||
} | ||
}, { | ||
"ProductID": 31, | ||
"ProductName": "Gorgonzola Telino", | ||
"SupplierID": 14, | ||
"CategoryID": 4, | ||
"QuantityPerUnit": "12 - 100 g pkgs", | ||
"UnitPrice": 12.5000, | ||
"UnitsInStock": 0, | ||
"UnitsOnOrder": 70, | ||
"ReorderLevel": 20, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 4, | ||
"CategoryName": "Dairy Products", | ||
"Description": "Cheeses" | ||
ProductID: 31, | ||
ProductName: 'Gorgonzola Telino', | ||
SupplierID: 14, | ||
CategoryID: 4, | ||
QuantityPerUnit: '12 - 100 g pkgs', | ||
UnitPrice: 12.5000, | ||
UnitsInStock: 0, | ||
UnitsOnOrder: 70, | ||
ReorderLevel: 20, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 4, | ||
CategoryName: 'Dairy Products', | ||
Description: 'Cheeses' | ||
} | ||
}, { | ||
"ProductID": 32, | ||
"ProductName": "Mascarpone Fabioli", | ||
"SupplierID": 14, | ||
"CategoryID": 4, | ||
"QuantityPerUnit": "24 - 200 g pkgs.", | ||
"UnitPrice": 32.0000, | ||
"UnitsInStock": 9, | ||
"UnitsOnOrder": 40, | ||
"ReorderLevel": 25, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 4, | ||
"CategoryName": "Dairy Products", | ||
"Description": "Cheeses" | ||
ProductID: 32, | ||
ProductName: 'Mascarpone Fabioli', | ||
SupplierID: 14, | ||
CategoryID: 4, | ||
QuantityPerUnit: '24 - 200 g pkgs.', | ||
UnitPrice: 32.0000, | ||
UnitsInStock: 9, | ||
UnitsOnOrder: 40, | ||
ReorderLevel: 25, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 4, | ||
CategoryName: 'Dairy Products', | ||
Description: 'Cheeses' | ||
} | ||
}, { | ||
"ProductID": 33, | ||
"ProductName": "Geitost", | ||
"SupplierID": 15, | ||
"CategoryID": 4, | ||
"QuantityPerUnit": "500 g", | ||
"UnitPrice": 2.5000, | ||
"UnitsInStock": 112, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 20, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 4, | ||
"CategoryName": "Dairy Products", | ||
"Description": "Cheeses" | ||
ProductID: 33, | ||
ProductName: 'Geitost', | ||
SupplierID: 15, | ||
CategoryID: 4, | ||
QuantityPerUnit: '500 g', | ||
UnitPrice: 2.5000, | ||
UnitsInStock: 112, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 20, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 4, | ||
CategoryName: 'Dairy Products', | ||
Description: 'Cheeses' | ||
} | ||
}, { | ||
"ProductID": 34, | ||
"ProductName": "Sasquatch Ale", | ||
"SupplierID": 16, | ||
"CategoryID": 1, | ||
"QuantityPerUnit": "24 - 12 oz bottles", | ||
"UnitPrice": 14.0000, | ||
"UnitsInStock": 111, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 15, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 1, | ||
"CategoryName": "Beverages", | ||
"Description": "Soft drinks, coffees, teas, beers, and ales" | ||
ProductID: 34, | ||
ProductName: 'Sasquatch Ale', | ||
SupplierID: 16, | ||
CategoryID: 1, | ||
QuantityPerUnit: '24 - 12 oz bottles', | ||
UnitPrice: 14.0000, | ||
UnitsInStock: 111, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 15, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 1, | ||
CategoryName: 'Beverages', | ||
Description: 'Soft drinks, coffees, teas, beers, and ales' | ||
} | ||
}, { | ||
"ProductID": 35, | ||
"ProductName": "Steeleye Stout", | ||
"SupplierID": 16, | ||
"CategoryID": 1, | ||
"QuantityPerUnit": "24 - 12 oz bottles", | ||
"UnitPrice": 18.0000, | ||
"UnitsInStock": 20, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 15, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 1, | ||
"CategoryName": "Beverages", | ||
"Description": "Soft drinks, coffees, teas, beers, and ales" | ||
ProductID: 35, | ||
ProductName: 'Steeleye Stout', | ||
SupplierID: 16, | ||
CategoryID: 1, | ||
QuantityPerUnit: '24 - 12 oz bottles', | ||
UnitPrice: 18.0000, | ||
UnitsInStock: 20, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 15, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 1, | ||
CategoryName: 'Beverages', | ||
Description: 'Soft drinks, coffees, teas, beers, and ales' | ||
} | ||
}, { | ||
"ProductID": 36, | ||
"ProductName": "Inlagd Sill", | ||
"SupplierID": 17, | ||
"CategoryID": 8, | ||
"QuantityPerUnit": "24 - 250 g jars", | ||
"UnitPrice": 19.0000, | ||
"UnitsInStock": 112, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 20, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 8, | ||
"CategoryName": "Seafood", | ||
"Description": "Seaweed and fish" | ||
ProductID: 36, | ||
ProductName: 'Inlagd Sill', | ||
SupplierID: 17, | ||
CategoryID: 8, | ||
QuantityPerUnit: '24 - 250 g jars', | ||
UnitPrice: 19.0000, | ||
UnitsInStock: 112, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 20, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 8, | ||
CategoryName: 'Seafood', | ||
Description: 'Seaweed and fish' | ||
} | ||
}, { | ||
"ProductID": 37, | ||
"ProductName": "Gravad lax", | ||
"SupplierID": 17, | ||
"CategoryID": 8, | ||
"QuantityPerUnit": "12 - 500 g pkgs.", | ||
"UnitPrice": 26.0000, | ||
"UnitsInStock": 11, | ||
"UnitsOnOrder": 50, | ||
"ReorderLevel": 25, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 8, | ||
"CategoryName": "Seafood", | ||
"Description": "Seaweed and fish" | ||
ProductID: 37, | ||
ProductName: 'Gravad lax', | ||
SupplierID: 17, | ||
CategoryID: 8, | ||
QuantityPerUnit: '12 - 500 g pkgs.', | ||
UnitPrice: 26.0000, | ||
UnitsInStock: 11, | ||
UnitsOnOrder: 50, | ||
ReorderLevel: 25, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 8, | ||
CategoryName: 'Seafood', | ||
Description: 'Seaweed and fish' | ||
} | ||
}, { | ||
"ProductID": 38, | ||
"ProductName": "Côte de Blaye", | ||
"SupplierID": 18, | ||
"CategoryID": 1, | ||
"QuantityPerUnit": "12 - 75 cl bottles", | ||
"UnitPrice": 263.5000, | ||
"UnitsInStock": 17, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 15, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 1, | ||
"CategoryName": "Beverages", | ||
"Description": "Soft drinks, coffees, teas, beers, and ales" | ||
ProductID: 38, | ||
ProductName: 'Côte de Blaye', | ||
SupplierID: 18, | ||
CategoryID: 1, | ||
QuantityPerUnit: '12 - 75 cl bottles', | ||
UnitPrice: 263.5000, | ||
UnitsInStock: 17, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 15, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 1, | ||
CategoryName: 'Beverages', | ||
Description: 'Soft drinks, coffees, teas, beers, and ales' | ||
} | ||
}, { | ||
"ProductID": 39, | ||
"ProductName": "Chartreuse verte", | ||
"SupplierID": 18, | ||
"CategoryID": 1, | ||
"QuantityPerUnit": "750 cc per bottle", | ||
"UnitPrice": 18.0000, | ||
"UnitsInStock": 69, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 5, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 1, | ||
"CategoryName": "Beverages", | ||
"Description": "Soft drinks, coffees, teas, beers, and ales" | ||
ProductID: 39, | ||
ProductName: 'Chartreuse verte', | ||
SupplierID: 18, | ||
CategoryID: 1, | ||
QuantityPerUnit: '750 cc per bottle', | ||
UnitPrice: 18.0000, | ||
UnitsInStock: 69, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 5, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 1, | ||
CategoryName: 'Beverages', | ||
Description: 'Soft drinks, coffees, teas, beers, and ales' | ||
} | ||
}, { | ||
"ProductID": 40, | ||
"ProductName": "Boston Crab Meat", | ||
"SupplierID": 19, | ||
"CategoryID": 8, | ||
"QuantityPerUnit": "24 - 4 oz tins", | ||
"UnitPrice": 18.4000, | ||
"UnitsInStock": 123, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 30, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 8, | ||
"CategoryName": "Seafood", | ||
"Description": "Seaweed and fish" | ||
ProductID: 40, | ||
ProductName: 'Boston Crab Meat', | ||
SupplierID: 19, | ||
CategoryID: 8, | ||
QuantityPerUnit: '24 - 4 oz tins', | ||
UnitPrice: 18.4000, | ||
UnitsInStock: 123, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 30, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 8, | ||
CategoryName: 'Seafood', | ||
Description: 'Seaweed and fish' | ||
} | ||
}, { | ||
"ProductID": 41, | ||
"ProductName": "Jack's New England Clam Chowder", | ||
"SupplierID": 19, | ||
"CategoryID": 8, | ||
"QuantityPerUnit": "12 - 12 oz cans", | ||
"UnitPrice": 9.6500, | ||
"UnitsInStock": 85, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 10, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 8, | ||
"CategoryName": "Seafood", | ||
"Description": "Seaweed and fish" | ||
ProductID: 41, | ||
ProductName: 'Jacks New England Clam Chowder', | ||
SupplierID: 19, | ||
CategoryID: 8, | ||
QuantityPerUnit: '12 - 12 oz cans', | ||
UnitPrice: 9.6500, | ||
UnitsInStock: 85, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 10, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 8, | ||
CategoryName: 'Seafood', | ||
Description: 'Seaweed and fish' | ||
} | ||
}, { | ||
"ProductID": 42, | ||
"ProductName": "Singaporean Hokkien Fried Mee", | ||
"SupplierID": 20, | ||
"CategoryID": 5, | ||
"QuantityPerUnit": "32 - 1 kg pkgs.", | ||
"UnitPrice": 14.0000, | ||
"UnitsInStock": 26, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 0, | ||
"Discontinued": true, | ||
"Category": { | ||
"CategoryID": 5, | ||
"CategoryName": "Grains/Cereals", | ||
"Description": "Breads, crackers, pasta, and cereal" | ||
ProductID: 42, | ||
ProductName: 'Singaporean Hokkien Fried Mee', | ||
SupplierID: 20, | ||
CategoryID: 5, | ||
QuantityPerUnit: '32 - 1 kg pkgs.', | ||
UnitPrice: 14.0000, | ||
UnitsInStock: 26, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 0, | ||
Discontinued: true, | ||
Category: { | ||
CategoryID: 5, | ||
CategoryName: 'Grains/Cereals', | ||
Description: 'Breads, crackers, pasta, and cereal' | ||
} | ||
}, { | ||
"ProductID": 43, | ||
"ProductName": "Ipoh Coffee", | ||
"SupplierID": 20, | ||
"CategoryID": 1, | ||
"QuantityPerUnit": "16 - 500 g tins", | ||
"UnitPrice": 46.0000, | ||
"UnitsInStock": 17, | ||
"UnitsOnOrder": 10, | ||
"ReorderLevel": 25, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 1, | ||
"CategoryName": "Beverages", | ||
"Description": "Soft drinks, coffees, teas, beers, and ales" | ||
ProductID: 43, | ||
ProductName: 'Ipoh Coffee', | ||
SupplierID: 20, | ||
CategoryID: 1, | ||
QuantityPerUnit: '16 - 500 g tins', | ||
UnitPrice: 46.0000, | ||
UnitsInStock: 17, | ||
UnitsOnOrder: 10, | ||
ReorderLevel: 25, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 1, | ||
CategoryName: 'Beverages', | ||
Description: 'Soft drinks, coffees, teas, beers, and ales' | ||
} | ||
}, { | ||
"ProductID": 44, | ||
"ProductName": "Gula Malacca", | ||
"SupplierID": 20, | ||
"CategoryID": 2, | ||
"QuantityPerUnit": "20 - 2 kg bags", | ||
"UnitPrice": 19.4500, | ||
"UnitsInStock": 27, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 15, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 2, | ||
"CategoryName": "Condiments", | ||
"Description": "Sweet and savory sauces, relishes, spreads, and seasonings" | ||
ProductID: 44, | ||
ProductName: 'Gula Malacca', | ||
SupplierID: 20, | ||
CategoryID: 2, | ||
QuantityPerUnit: '20 - 2 kg bags', | ||
UnitPrice: 19.4500, | ||
UnitsInStock: 27, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 15, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 2, | ||
CategoryName: 'Condiments', | ||
Description: 'Sweet and savory sauces, relishes, spreads, and seasonings' | ||
} | ||
}, { | ||
"ProductID": 45, | ||
"ProductName": "Rogede sild", | ||
"SupplierID": 21, | ||
"CategoryID": 8, | ||
"QuantityPerUnit": "1k pkg.", | ||
"UnitPrice": 9.5000, | ||
"UnitsInStock": 5, | ||
"UnitsOnOrder": 70, | ||
"ReorderLevel": 15, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 8, | ||
"CategoryName": "Seafood", | ||
"Description": "Seaweed and fish" | ||
ProductID: 45, | ||
ProductName: 'Rogede sild', | ||
SupplierID: 21, | ||
CategoryID: 8, | ||
QuantityPerUnit: '1k pkg.', | ||
UnitPrice: 9.5000, | ||
UnitsInStock: 5, | ||
UnitsOnOrder: 70, | ||
ReorderLevel: 15, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 8, | ||
CategoryName: 'Seafood', | ||
Description: 'Seaweed and fish' | ||
} | ||
}, { | ||
"ProductID": 46, | ||
"ProductName": "Spegesild", | ||
"SupplierID": 21, | ||
"CategoryID": 8, | ||
"QuantityPerUnit": "4 - 450 g glasses", | ||
"UnitPrice": 12.0000, | ||
"UnitsInStock": 95, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 0, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 8, | ||
"CategoryName": "Seafood", | ||
"Description": "Seaweed and fish" | ||
ProductID: 46, | ||
ProductName: 'Spegesild', | ||
SupplierID: 21, | ||
CategoryID: 8, | ||
QuantityPerUnit: '4 - 450 g glasses', | ||
UnitPrice: 12.0000, | ||
UnitsInStock: 95, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 0, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 8, | ||
CategoryName: 'Seafood', | ||
Description: 'Seaweed and fish' | ||
} | ||
}, { | ||
"ProductID": 47, | ||
"ProductName": "Zaanse koeken", | ||
"SupplierID": 22, | ||
"CategoryID": 3, | ||
"QuantityPerUnit": "10 - 4 oz boxes", | ||
"UnitPrice": 9.5000, | ||
"UnitsInStock": 36, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 0, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 3, | ||
"CategoryName": "Confections", | ||
"Description": "Desserts, candies, and sweet breads" | ||
ProductID: 47, | ||
ProductName: 'Zaanse koeken', | ||
SupplierID: 22, | ||
CategoryID: 3, | ||
QuantityPerUnit: '10 - 4 oz boxes', | ||
UnitPrice: 9.5000, | ||
UnitsInStock: 36, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 0, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 3, | ||
CategoryName: 'Confections', | ||
Description: 'Desserts, candies, and sweet breads' | ||
} | ||
}, { | ||
"ProductID": 48, | ||
"ProductName": "Chocolade", | ||
"SupplierID": 22, | ||
"CategoryID": 3, | ||
"QuantityPerUnit": "10 pkgs.", | ||
"UnitPrice": 12.7500, | ||
"UnitsInStock": 15, | ||
"UnitsOnOrder": 70, | ||
"ReorderLevel": 25, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 3, | ||
"CategoryName": "Confections", | ||
"Description": "Desserts, candies, and sweet breads" | ||
ProductID: 48, | ||
ProductName: 'Chocolade', | ||
SupplierID: 22, | ||
CategoryID: 3, | ||
QuantityPerUnit: '10 pkgs.', | ||
UnitPrice: 12.7500, | ||
UnitsInStock: 15, | ||
UnitsOnOrder: 70, | ||
ReorderLevel: 25, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 3, | ||
CategoryName: 'Confections', | ||
Description: 'Desserts, candies, and sweet breads' | ||
} | ||
}, { | ||
"ProductID": 49, | ||
"ProductName": "Maxilaku", | ||
"SupplierID": 23, | ||
"CategoryID": 3, | ||
"QuantityPerUnit": "24 - 50 g pkgs.", | ||
"UnitPrice": 20.0000, | ||
"UnitsInStock": 10, | ||
"UnitsOnOrder": 60, | ||
"ReorderLevel": 15, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 3, | ||
"CategoryName": "Confections", | ||
"Description": "Desserts, candies, and sweet breads" | ||
ProductID: 49, | ||
ProductName: 'Maxilaku', | ||
SupplierID: 23, | ||
CategoryID: 3, | ||
QuantityPerUnit: '24 - 50 g pkgs.', | ||
UnitPrice: 20.0000, | ||
UnitsInStock: 10, | ||
UnitsOnOrder: 60, | ||
ReorderLevel: 15, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 3, | ||
CategoryName: 'Confections', | ||
Description: 'Desserts, candies, and sweet breads' | ||
} | ||
}, { | ||
"ProductID": 50, | ||
"ProductName": "Valkoinen suklaa", | ||
"SupplierID": 23, | ||
"CategoryID": 3, | ||
"QuantityPerUnit": "12 - 100 g bars", | ||
"UnitPrice": 16.2500, | ||
"UnitsInStock": 65, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 30, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 3, | ||
"CategoryName": "Confections", | ||
"Description": "Desserts, candies, and sweet breads" | ||
ProductID: 50, | ||
ProductName: 'Valkoinen suklaa', | ||
SupplierID: 23, | ||
CategoryID: 3, | ||
QuantityPerUnit: '12 - 100 g bars', | ||
UnitPrice: 16.2500, | ||
UnitsInStock: 65, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 30, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 3, | ||
CategoryName: 'Confections', | ||
Description: 'Desserts, candies, and sweet breads' | ||
} | ||
}, { | ||
"ProductID": 51, | ||
"ProductName": "Manjimup Dried Apples", | ||
"SupplierID": 24, | ||
"CategoryID": 7, | ||
"QuantityPerUnit": "50 - 300 g pkgs.", | ||
"UnitPrice": 53.0000, | ||
"UnitsInStock": 20, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 10, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 7, | ||
"CategoryName": "Produce", | ||
"Description": "Dried fruit and bean curd" | ||
ProductID: 51, | ||
ProductName: 'Manjimup Dried Apples', | ||
SupplierID: 24, | ||
CategoryID: 7, | ||
QuantityPerUnit: '50 - 300 g pkgs.', | ||
UnitPrice: 53.0000, | ||
UnitsInStock: 20, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 10, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 7, | ||
CategoryName: 'Produce', | ||
Description: 'Dried fruit and bean curd' | ||
} | ||
}, { | ||
"ProductID": 52, | ||
"ProductName": "Filo Mix", | ||
"SupplierID": 24, | ||
"CategoryID": 5, | ||
"QuantityPerUnit": "16 - 2 kg boxes", | ||
"UnitPrice": 7.0000, | ||
"UnitsInStock": 38, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 25, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 5, | ||
"CategoryName": "Grains/Cereals", | ||
"Description": "Breads, crackers, pasta, and cereal" | ||
ProductID: 52, | ||
ProductName: 'Filo Mix', | ||
SupplierID: 24, | ||
CategoryID: 5, | ||
QuantityPerUnit: '16 - 2 kg boxes', | ||
UnitPrice: 7.0000, | ||
UnitsInStock: 38, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 25, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 5, | ||
CategoryName: 'Grains/Cereals', | ||
Description: 'Breads, crackers, pasta, and cereal' | ||
} | ||
}, { | ||
"ProductID": 53, | ||
"ProductName": "Perth Pasties", | ||
"SupplierID": 24, | ||
"CategoryID": 6, | ||
"QuantityPerUnit": "48 pieces", | ||
"UnitPrice": 32.8000, | ||
"UnitsInStock": 0, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 0, | ||
"Discontinued": true, | ||
"Category": { | ||
"CategoryID": 6, | ||
"CategoryName": "Meat/Poultry", | ||
"Description": "Prepared meats" | ||
ProductID: 53, | ||
ProductName: 'Perth Pasties', | ||
SupplierID: 24, | ||
CategoryID: 6, | ||
QuantityPerUnit: '48 pieces', | ||
UnitPrice: 32.8000, | ||
UnitsInStock: 0, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 0, | ||
Discontinued: true, | ||
Category: { | ||
CategoryID: 6, | ||
CategoryName: 'Meat/Poultry', | ||
Description: 'Prepared meats' | ||
} | ||
}, { | ||
"ProductID": 54, | ||
"ProductName": "Tourtière", | ||
"SupplierID": 25, | ||
"CategoryID": 6, | ||
"QuantityPerUnit": "16 pies", | ||
"UnitPrice": 7.4500, | ||
"UnitsInStock": 21, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 10, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 6, | ||
"CategoryName": "Meat/Poultry", | ||
"Description": "Prepared meats" | ||
ProductID: 54, | ||
ProductName: 'Tourtière', | ||
SupplierID: 25, | ||
CategoryID: 6, | ||
QuantityPerUnit: '16 pies', | ||
UnitPrice: 7.4500, | ||
UnitsInStock: 21, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 10, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 6, | ||
CategoryName: 'Meat/Poultry', | ||
Description: 'Prepared meats' | ||
} | ||
}, { | ||
"ProductID": 55, | ||
"ProductName": "Pâté chinois", | ||
"SupplierID": 25, | ||
"CategoryID": 6, | ||
"QuantityPerUnit": "24 boxes x 2 pies", | ||
"UnitPrice": 24.0000, | ||
"UnitsInStock": 115, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 20, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 6, | ||
"CategoryName": "Meat/Poultry", | ||
"Description": "Prepared meats" | ||
ProductID: 55, | ||
ProductName: 'Pâté chinois', | ||
SupplierID: 25, | ||
CategoryID: 6, | ||
QuantityPerUnit: '24 boxes x 2 pies', | ||
UnitPrice: 24.0000, | ||
UnitsInStock: 115, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 20, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 6, | ||
CategoryName: 'Meat/Poultry', | ||
Description: 'Prepared meats' | ||
} | ||
}, { | ||
"ProductID": 56, | ||
"ProductName": "Gnocchi di nonna Alice", | ||
"SupplierID": 26, | ||
"CategoryID": 5, | ||
"QuantityPerUnit": "24 - 250 g pkgs.", | ||
"UnitPrice": 38.0000, | ||
"UnitsInStock": 21, | ||
"UnitsOnOrder": 10, | ||
"ReorderLevel": 30, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 5, | ||
"CategoryName": "Grains/Cereals", | ||
"Description": "Breads, crackers, pasta, and cereal" | ||
ProductID: 56, | ||
ProductName: 'Gnocchi di nonna Alice', | ||
SupplierID: 26, | ||
CategoryID: 5, | ||
QuantityPerUnit: '24 - 250 g pkgs.', | ||
UnitPrice: 38.0000, | ||
UnitsInStock: 21, | ||
UnitsOnOrder: 10, | ||
ReorderLevel: 30, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 5, | ||
CategoryName: 'Grains/Cereals', | ||
Description: 'Breads, crackers, pasta, and cereal' | ||
} | ||
}, { | ||
"ProductID": 57, | ||
"ProductName": "Ravioli Angelo", | ||
"SupplierID": 26, | ||
"CategoryID": 5, | ||
"QuantityPerUnit": "24 - 250 g pkgs.", | ||
"UnitPrice": 19.5000, | ||
"UnitsInStock": 36, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 20, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 5, | ||
"CategoryName": "Grains/Cereals", | ||
"Description": "Breads, crackers, pasta, and cereal" | ||
ProductID: 57, | ||
ProductName: 'Ravioli Angelo', | ||
SupplierID: 26, | ||
CategoryID: 5, | ||
QuantityPerUnit: '24 - 250 g pkgs.', | ||
UnitPrice: 19.5000, | ||
UnitsInStock: 36, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 20, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 5, | ||
CategoryName: 'Grains/Cereals', | ||
Description: 'Breads, crackers, pasta, and cereal' | ||
} | ||
}, { | ||
"ProductID": 58, | ||
"ProductName": "Escargots de Bourgogne", | ||
"SupplierID": 27, | ||
"CategoryID": 8, | ||
"QuantityPerUnit": "24 pieces", | ||
"UnitPrice": 13.2500, | ||
"UnitsInStock": 62, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 20, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 8, | ||
"CategoryName": "Seafood", | ||
"Description": "Seaweed and fish" | ||
ProductID: 58, | ||
ProductName: 'Escargots de Bourgogne', | ||
SupplierID: 27, | ||
CategoryID: 8, | ||
QuantityPerUnit: '24 pieces', | ||
UnitPrice: 13.2500, | ||
UnitsInStock: 62, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 20, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 8, | ||
CategoryName: 'Seafood', | ||
Description: 'Seaweed and fish' | ||
} | ||
}, { | ||
"ProductID": 59, | ||
"ProductName": "Raclette Courdavault", | ||
"SupplierID": 28, | ||
"CategoryID": 4, | ||
"QuantityPerUnit": "5 kg pkg.", | ||
"UnitPrice": 55.0000, | ||
"UnitsInStock": 79, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 0, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 4, | ||
"CategoryName": "Dairy Products", | ||
"Description": "Cheeses" | ||
ProductID: 59, | ||
ProductName: 'Raclette Courdavault', | ||
SupplierID: 28, | ||
CategoryID: 4, | ||
QuantityPerUnit: '5 kg pkg.', | ||
UnitPrice: 55.0000, | ||
UnitsInStock: 79, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 0, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 4, | ||
CategoryName: 'Dairy Products', | ||
Description: 'Cheeses' | ||
} | ||
}, { | ||
"ProductID": 60, | ||
"ProductName": "Camembert Pierrot", | ||
"SupplierID": 28, | ||
"CategoryID": 4, | ||
"QuantityPerUnit": "15 - 300 g rounds", | ||
"UnitPrice": 34.0000, | ||
"UnitsInStock": 19, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 0, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 4, | ||
"CategoryName": "Dairy Products", | ||
"Description": "Cheeses" | ||
ProductID: 60, | ||
ProductName: 'Camembert Pierrot', | ||
SupplierID: 28, | ||
CategoryID: 4, | ||
QuantityPerUnit: '15 - 300 g rounds', | ||
UnitPrice: 34.0000, | ||
UnitsInStock: 19, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 0, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 4, | ||
CategoryName: 'Dairy Products', | ||
Description: 'Cheeses' | ||
} | ||
}, { | ||
"ProductID": 61, | ||
"ProductName": "Sirop d'érable", | ||
"SupplierID": 29, | ||
"CategoryID": 2, | ||
"QuantityPerUnit": "24 - 500 ml bottles", | ||
"UnitPrice": 28.5000, | ||
"UnitsInStock": 113, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 25, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 2, | ||
"CategoryName": "Condiments", | ||
"Description": "Sweet and savory sauces, relishes, spreads, and seasonings" | ||
ProductID: 61, | ||
ProductName: 'Sirop dérable', | ||
SupplierID: 29, | ||
CategoryID: 2, | ||
QuantityPerUnit: '24 - 500 ml bottles', | ||
UnitPrice: 28.5000, | ||
UnitsInStock: 113, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 25, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 2, | ||
CategoryName: 'Condiments', | ||
Description: 'Sweet and savory sauces, relishes, spreads, and seasonings' | ||
} | ||
}, { | ||
"ProductID": 62, | ||
"ProductName": "Tarte au sucre", | ||
"SupplierID": 29, | ||
"CategoryID": 3, | ||
"QuantityPerUnit": "48 pies", | ||
"UnitPrice": 49.3000, | ||
"UnitsInStock": 17, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 0, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 3, | ||
"CategoryName": "Confections", | ||
"Description": "Desserts, candies, and sweet breads" | ||
ProductID: 62, | ||
ProductName: 'Tarte au sucre', | ||
SupplierID: 29, | ||
CategoryID: 3, | ||
QuantityPerUnit: '48 pies', | ||
UnitPrice: 49.3000, | ||
UnitsInStock: 17, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 0, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 3, | ||
CategoryName: 'Confections', | ||
Description: 'Desserts, candies, and sweet breads' | ||
} | ||
}, { | ||
"ProductID": 63, | ||
"ProductName": "Vegie-spread", | ||
"SupplierID": 7, | ||
"CategoryID": 2, | ||
"QuantityPerUnit": "15 - 625 g jars", | ||
"UnitPrice": 43.9000, | ||
"UnitsInStock": 24, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 5, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 2, | ||
"CategoryName": "Condiments", | ||
"Description": "Sweet and savory sauces, relishes, spreads, and seasonings" | ||
ProductID: 63, | ||
ProductName: 'Vegie-spread', | ||
SupplierID: 7, | ||
CategoryID: 2, | ||
QuantityPerUnit: '15 - 625 g jars', | ||
UnitPrice: 43.9000, | ||
UnitsInStock: 24, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 5, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 2, | ||
CategoryName: 'Condiments', | ||
Description: 'Sweet and savory sauces, relishes, spreads, and seasonings' | ||
} | ||
}, { | ||
"ProductID": 64, | ||
"ProductName": "Wimmers gute Semmelknödel", | ||
"SupplierID": 12, | ||
"CategoryID": 5, | ||
"QuantityPerUnit": "20 bags x 4 pieces", | ||
"UnitPrice": 33.2500, | ||
"UnitsInStock": 22, | ||
"UnitsOnOrder": 80, | ||
"ReorderLevel": 30, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 5, | ||
"CategoryName": "Grains/Cereals", | ||
"Description": "Breads, crackers, pasta, and cereal" | ||
ProductID: 64, | ||
ProductName: 'Wimmers gute Semmelknödel', | ||
SupplierID: 12, | ||
CategoryID: 5, | ||
QuantityPerUnit: '20 bags x 4 pieces', | ||
UnitPrice: 33.2500, | ||
UnitsInStock: 22, | ||
UnitsOnOrder: 80, | ||
ReorderLevel: 30, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 5, | ||
CategoryName: 'Grains/Cereals', | ||
Description: 'Breads, crackers, pasta, and cereal' | ||
} | ||
}, { | ||
"ProductID": 65, | ||
"ProductName": "Louisiana Fiery Hot Pepper Sauce", | ||
"SupplierID": 2, | ||
"CategoryID": 2, | ||
"QuantityPerUnit": "32 - 8 oz bottles", | ||
"UnitPrice": 21.0500, | ||
"UnitsInStock": 76, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 0, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 2, | ||
"CategoryName": "Condiments", | ||
"Description": "Sweet and savory sauces, relishes, spreads, and seasonings" | ||
ProductID: 65, | ||
ProductName: 'Louisiana Fiery Hot Pepper Sauce', | ||
SupplierID: 2, | ||
CategoryID: 2, | ||
QuantityPerUnit: '32 - 8 oz bottles', | ||
UnitPrice: 21.0500, | ||
UnitsInStock: 76, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 0, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 2, | ||
CategoryName: 'Condiments', | ||
Description: 'Sweet and savory sauces, relishes, spreads, and seasonings' | ||
} | ||
}, { | ||
"ProductID": 66, | ||
"ProductName": "Louisiana Hot Spiced Okra", | ||
"SupplierID": 2, | ||
"CategoryID": 2, | ||
"QuantityPerUnit": "24 - 8 oz jars", | ||
"UnitPrice": 17.0000, | ||
"UnitsInStock": 4, | ||
"UnitsOnOrder": 100, | ||
"ReorderLevel": 20, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 2, | ||
"CategoryName": "Condiments", | ||
"Description": "Sweet and savory sauces, relishes, spreads, and seasonings" | ||
ProductID: 66, | ||
ProductName: 'Louisiana Hot Spiced Okra', | ||
SupplierID: 2, | ||
CategoryID: 2, | ||
QuantityPerUnit: '24 - 8 oz jars', | ||
UnitPrice: 17.0000, | ||
UnitsInStock: 4, | ||
UnitsOnOrder: 100, | ||
ReorderLevel: 20, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 2, | ||
CategoryName: 'Condiments', | ||
Description: 'Sweet and savory sauces, relishes, spreads, and seasonings' | ||
} | ||
}, { | ||
"ProductID": 67, | ||
"ProductName": "Laughing Lumberjack Lager", | ||
"SupplierID": 16, | ||
"CategoryID": 1, | ||
"QuantityPerUnit": "24 - 12 oz bottles", | ||
"UnitPrice": 14.0000, | ||
"UnitsInStock": 52, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 10, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 1, | ||
"CategoryName": "Beverages", | ||
"Description": "Soft drinks, coffees, teas, beers, and ales" | ||
ProductID: 67, | ||
ProductName: 'Laughing Lumberjack Lager', | ||
SupplierID: 16, | ||
CategoryID: 1, | ||
QuantityPerUnit: '24 - 12 oz bottles', | ||
UnitPrice: 14.0000, | ||
UnitsInStock: 52, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 10, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 1, | ||
CategoryName: 'Beverages', | ||
Description: 'Soft drinks, coffees, teas, beers, and ales' | ||
} | ||
}, { | ||
"ProductID": 68, | ||
"ProductName": "Scottish Longbreads", | ||
"SupplierID": 8, | ||
"CategoryID": 3, | ||
"QuantityPerUnit": "10 boxes x 8 pieces", | ||
"UnitPrice": 12.5000, | ||
"UnitsInStock": 6, | ||
"UnitsOnOrder": 10, | ||
"ReorderLevel": 15, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 3, | ||
"CategoryName": "Confections", | ||
"Description": "Desserts, candies, and sweet breads" | ||
ProductID: 68, | ||
ProductName: 'Scottish Longbreads', | ||
SupplierID: 8, | ||
CategoryID: 3, | ||
QuantityPerUnit: '10 boxes x 8 pieces', | ||
UnitPrice: 12.5000, | ||
UnitsInStock: 6, | ||
UnitsOnOrder: 10, | ||
ReorderLevel: 15, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 3, | ||
CategoryName: 'Confections', | ||
Description: 'Desserts, candies, and sweet breads' | ||
} | ||
}, { | ||
"ProductID": 69, | ||
"ProductName": "Gudbrandsdalsost", | ||
"SupplierID": 15, | ||
"CategoryID": 4, | ||
"QuantityPerUnit": "10 kg pkg.", | ||
"UnitPrice": 36.0000, | ||
"UnitsInStock": 26, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 15, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 4, | ||
"CategoryName": "Dairy Products", | ||
"Description": "Cheeses" | ||
ProductID: 69, | ||
ProductName: 'Gudbrandsdalsost', | ||
SupplierID: 15, | ||
CategoryID: 4, | ||
QuantityPerUnit: '10 kg pkg.', | ||
UnitPrice: 36.0000, | ||
UnitsInStock: 26, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 15, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 4, | ||
CategoryName: 'Dairy Products', | ||
Description: 'Cheeses' | ||
} | ||
}, { | ||
"ProductID": 70, | ||
"ProductName": "Outback Lager", | ||
"SupplierID": 7, | ||
"CategoryID": 1, | ||
"QuantityPerUnit": "24 - 355 ml bottles", | ||
"UnitPrice": 15.0000, | ||
"UnitsInStock": 15, | ||
"UnitsOnOrder": 10, | ||
"ReorderLevel": 30, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 1, | ||
"CategoryName": "Beverages", | ||
"Description": "Soft drinks, coffees, teas, beers, and ales" | ||
ProductID: 70, | ||
ProductName: 'Outback Lager', | ||
SupplierID: 7, | ||
CategoryID: 1, | ||
QuantityPerUnit: '24 - 355 ml bottles', | ||
UnitPrice: 15.0000, | ||
UnitsInStock: 15, | ||
UnitsOnOrder: 10, | ||
ReorderLevel: 30, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 1, | ||
CategoryName: 'Beverages', | ||
Description: 'Soft drinks, coffees, teas, beers, and ales' | ||
} | ||
}, { | ||
"ProductID": 71, | ||
"ProductName": "Flotemysost", | ||
"SupplierID": 15, | ||
"CategoryID": 4, | ||
"QuantityPerUnit": "10 - 500 g pkgs.", | ||
"UnitPrice": 21.5000, | ||
"UnitsInStock": 26, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 0, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 4, | ||
"CategoryName": "Dairy Products", | ||
"Description": "Cheeses" | ||
ProductID: 71, | ||
ProductName: 'Flotemysost', | ||
SupplierID: 15, | ||
CategoryID: 4, | ||
QuantityPerUnit: '10 - 500 g pkgs.', | ||
UnitPrice: 21.5000, | ||
UnitsInStock: 26, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 0, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 4, | ||
CategoryName: 'Dairy Products', | ||
Description: 'Cheeses' | ||
} | ||
}, { | ||
"ProductID": 72, | ||
"ProductName": "Mozzarella di Giovanni", | ||
"SupplierID": 14, | ||
"CategoryID": 4, | ||
"QuantityPerUnit": "24 - 200 g pkgs.", | ||
"UnitPrice": 34.8000, | ||
"UnitsInStock": 14, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 0, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 4, | ||
"CategoryName": "Dairy Products", | ||
"Description": "Cheeses" | ||
ProductID: 72, | ||
ProductName: 'Mozzarella di Giovanni', | ||
SupplierID: 14, | ||
CategoryID: 4, | ||
QuantityPerUnit: '24 - 200 g pkgs.', | ||
UnitPrice: 34.8000, | ||
UnitsInStock: 14, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 0, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 4, | ||
CategoryName: 'Dairy Products', | ||
Description: 'Cheeses' | ||
} | ||
}, { | ||
"ProductID": 73, | ||
"ProductName": "Röd Kaviar", | ||
"SupplierID": 17, | ||
"CategoryID": 8, | ||
"QuantityPerUnit": "24 - 150 g jars", | ||
"UnitPrice": 15.0000, | ||
"UnitsInStock": 101, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 5, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 8, | ||
"CategoryName": "Seafood", | ||
"Description": "Seaweed and fish" | ||
ProductID: 73, | ||
ProductName: 'Röd Kaviar', | ||
SupplierID: 17, | ||
CategoryID: 8, | ||
QuantityPerUnit: '24 - 150 g jars', | ||
UnitPrice: 15.0000, | ||
UnitsInStock: 101, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 5, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 8, | ||
CategoryName: 'Seafood', | ||
Description: 'Seaweed and fish' | ||
} | ||
}, { | ||
"ProductID": 74, | ||
"ProductName": "Longlife Tofu", | ||
"SupplierID": 4, | ||
"CategoryID": 7, | ||
"QuantityPerUnit": "5 kg pkg.", | ||
"UnitPrice": 10.0000, | ||
"UnitsInStock": 4, | ||
"UnitsOnOrder": 20, | ||
"ReorderLevel": 5, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 7, | ||
"CategoryName": "Produce", | ||
"Description": "Dried fruit and bean curd" | ||
ProductID: 74, | ||
ProductName: 'Longlife Tofu', | ||
SupplierID: 4, | ||
CategoryID: 7, | ||
QuantityPerUnit: '5 kg pkg.', | ||
UnitPrice: 10.0000, | ||
UnitsInStock: 4, | ||
UnitsOnOrder: 20, | ||
ReorderLevel: 5, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 7, | ||
CategoryName: 'Produce', | ||
Description: 'Dried fruit and bean curd' | ||
} | ||
}, { | ||
"ProductID": 75, | ||
"ProductName": "Rhönbräu Klosterbier", | ||
"SupplierID": 12, | ||
"CategoryID": 1, | ||
"QuantityPerUnit": "24 - 0.5 l bottles", | ||
"UnitPrice": 7.7500, | ||
"UnitsInStock": 125, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 25, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 1, | ||
"CategoryName": "Beverages", | ||
"Description": "Soft drinks, coffees, teas, beers, and ales" | ||
ProductID: 75, | ||
ProductName: 'Rhönbräu Klosterbier', | ||
SupplierID: 12, | ||
CategoryID: 1, | ||
QuantityPerUnit: '24 - 0.5 l bottles', | ||
UnitPrice: 7.7500, | ||
UnitsInStock: 125, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 25, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 1, | ||
CategoryName: 'Beverages', | ||
Description: 'Soft drinks, coffees, teas, beers, and ales' | ||
} | ||
}, { | ||
"ProductID": 76, | ||
"ProductName": "Lakkalikööri", | ||
"SupplierID": 23, | ||
"CategoryID": 1, | ||
"QuantityPerUnit": "500 ml", | ||
"UnitPrice": 18.0000, | ||
"UnitsInStock": 57, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 20, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 1, | ||
"CategoryName": "Beverages", | ||
"Description": "Soft drinks, coffees, teas, beers, and ales" | ||
ProductID: 76, | ||
ProductName: 'Lakkalikööri', | ||
SupplierID: 23, | ||
CategoryID: 1, | ||
QuantityPerUnit: '500 ml', | ||
UnitPrice: 18.0000, | ||
UnitsInStock: 57, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 20, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 1, | ||
CategoryName: 'Beverages', | ||
Description: 'Soft drinks, coffees, teas, beers, and ales' | ||
} | ||
}, { | ||
"ProductID": 77, | ||
"ProductName": "Original Frankfurter grüne Soße", | ||
"SupplierID": 12, | ||
"CategoryID": 2, | ||
"QuantityPerUnit": "12 boxes", | ||
"UnitPrice": 13.0000, | ||
"UnitsInStock": 32, | ||
"UnitsOnOrder": 0, | ||
"ReorderLevel": 15, | ||
"Discontinued": false, | ||
"Category": { | ||
"CategoryID": 2, | ||
"CategoryName": "Condiments", | ||
"Description": "Sweet and savory sauces, relishes, spreads, and seasonings" | ||
ProductID: 77, | ||
ProductName: 'Original Frankfurter grüne Soße', | ||
SupplierID: 12, | ||
CategoryID: 2, | ||
QuantityPerUnit: '12 boxes', | ||
UnitPrice: 13.0000, | ||
UnitsInStock: 32, | ||
UnitsOnOrder: 0, | ||
ReorderLevel: 15, | ||
Discontinued: false, | ||
Category: { | ||
CategoryID: 2, | ||
CategoryName: 'Condiments', | ||
Description: 'Sweet and savory sauces, relishes, spreads, and seasonings' | ||
} | ||
}];` |
import { Component } from '@angular/core';<% if (dataPath) {%> | ||
import { <%= dataName %> } from '<%= dataPath %>'; <% } %><% if (mockedData) {%> | ||
import { products } from './data'; <% } %> | ||
import { <%= dataName %> } from '<%= dataPath %>'; <% } %><% if (dataSource === "Example") {%> | ||
import { products } from './data'; <% } %><% if (dataSource === "Mock Data") {%> | ||
import data from './data';<% } %><% if (editing) {%> | ||
import { FormBuilder, FormGroup } from '@angular/forms'; | ||
import { CreateFormGroupArgs } from '@progress/kendo-angular-grid';<% } %> | ||
@@ -11,5 +14,13 @@ @Component({ | ||
export class <%= classify(name) %>Component { | ||
public gridData: any[] = <% if (dataName) {%><%=dataName%><% } else {%>products<% }%>;<% if (columns.length > 0) {%> | ||
public fields = [<%=arrayify(columns)%>];<% }%> | ||
public pageSize: number = <%=pageSize%>; | ||
public gridData: any[] = <% if (dataSource === "Example") { %>products<% } else if (dataSource === "Mock Data") { %>data<% } else if (dataName) { %><%=dataName%><% } else { %>products<%} %>;<% if (paging) { %> | ||
public pageSize: number = <%=pageSize%>;<% } %><% if (editing) {%> | ||
constructor(private formBuilder: FormBuilder) { } | ||
public createFormGroup = (args: CreateFormGroupArgs): FormGroup => { | ||
// TODO: Implement default item factory. | ||
const item = args.isNew ? Object.keys(this.gridData[0]).reduce((acc, curr) => (acc as any)[curr] = null || acc, {}) : args.dataItem; | ||
return this.formBuilder.group(item); | ||
};<% } %> | ||
} |
import { Component } from '@angular/core';<% if (dataPath) {%> | ||
import { <%= dataName %> } from '<%= dataPath %>'; <% } %><% if (mockedData) {%> | ||
import { products } from './data'; <% } %> | ||
import { <%= dataName %> } from '<%= dataPath %>'; <% } %><% if (dataSource === "Example") {%> | ||
import { products } from './data'; <% } %><% if (dataSource === "Mock Data") {%> | ||
import data from './data';<% } %><% if (editing === 'inline' || editing === 'incell') {%> | ||
import { FormBuilder, FormGroup } from '@angular/forms'; | ||
import { CreateFormGroupArgs } from '@progress/kendo-angular-grid';<% } %> | ||
@@ -8,15 +11,50 @@ @Component({ | ||
template: ` | ||
<kendo-grid | ||
<% if (paging || sorting || filtering || grouping) {%>[kendoGridBinding]="gridData"<% } else {%>[data]="gridData"<% } %> | ||
[filterable]="<% if (filtering) {%> true<% } else {%>false<% } %>" | ||
[groupable]="<% if (grouping) {%>true<% } else {%>false<% } %>" | ||
[pageable]="<% if (paging) {%>true<% } else {%>false<% } %>" | ||
[pageSize]="pageSize" | ||
[sortable]="<% if (sorting) {%>true<% } else {%>false<% } %>" | ||
<% if (height) {%>[height]="<%=height%>"<% } %>><% if (columns.length > 0) {%> | ||
<kendo-grid-column | ||
*ngFor="let field of fields" | ||
[field]="field"> | ||
</kendo-grid-column> <% } %> | ||
</kendo-grid> | ||
<kendo-grid <% if (paging || sorting || filtering || grouping) {%> | ||
[kendoGridBinding]="gridData"<% } else {%>[data]="gridData"<% } %><% if (editing === 'inline') {%> | ||
[kendoGridReactiveEditing]="createFormGroup"<% }%><% if (editing === 'incell') {%> | ||
[kendoGridInCellEditing]="createFormGroup"<% }%><% if (filtering){%> | ||
[filterable]="true"<% }%><% if (grouping) {%> | ||
[groupable]="true"<% } %><% if (paging) {%> | ||
[pageable]="true"<% } %><% if (sorting) {%> | ||
[sortable]="true"<% } %><% if (resizing) {%> | ||
[resizable]="true"<% } %><% if (reordering) {%> | ||
[reorderable]="true"<% } %><% if (columnMenu) {%> | ||
[columnMenu]="true"<% } %><% if (navigable) {%> | ||
[navigable]="true"<% } %><% if (height) {%> | ||
[height]="<%=height%>"<% } %><% if (paging) {%> | ||
[pageSize]="pageSize"><% } %>><% if (columns.length) {%><% for (let column of columns) {%> | ||
<kendo-grid-column<% if (column.field) {%> | ||
field="<%=column.field%>"<% } %><% if (column.title) {%> | ||
title="<%=column.title%>"<% } %><% if (column.hidden) {%> | ||
[hidden]="<%=column.hidden%>"<% } %><% if (column.locked) {%> | ||
[locked]="<%=column.locked%>"<% } %><% if (column.sticky) {%> | ||
[sticky]="<%=column.sticky%>"<% } %><% if (column.width) {%> | ||
[width]="<%=column.width%>"<% } %><% if (column.columnMenu) {%> | ||
[columnMenu]="<%=column.columnMenu%>"<% } %><% if (column.editable) {%> | ||
[editable]="<%=column.editable%>"><% } %>></kendo-grid-column><% } %><% } %><% if (editing === 'inline') {%> | ||
<kendo-grid-command-column title="Command" [width]="220"> | ||
<ng-template kendoGridCellTemplate let-formGroup="formGroup" let-isNew="isNew"> | ||
<button kendoGridEditCommand [primary]="true">Edit</button> | ||
<button kendoGridRemoveCommand>Remove</button> | ||
<button kendoGridSaveCommand [disabled]="formGroup?.invalid"> | ||
{{ isNew ? "Add" : "Update" }} | ||
</button> | ||
<button kendoGridCancelCommand> | ||
{{ isNew ? "Discard changes" : "Cancel" }} | ||
</button> | ||
</ng-template> | ||
</kendo-grid-command-column><% } %><% if (editing === 'incell') {%> | ||
<kendo-grid-command-column title="command" [width]="220"> | ||
<ng-template kendoGridCellTemplate let-formGroup="formGroup" let-isNew="isNew"> | ||
<button kendoGridRemoveCommand>Remove</button> | ||
<button kendoGridSaveCommand [disabled]="formGroup?.invalid"> | ||
Add | ||
</button> | ||
<button kendoGridCancelCommand>Discard</button> | ||
</ng-template> | ||
</kendo-grid-command-column><% } %><% if (editing === 'incell' || editing === 'inline') {%> | ||
<ng-template kendoGridToolbarTemplate> | ||
<button kendoGridAddCommand>Add new</button> | ||
</ng-template><% } %> | ||
</kendo-grid> | ||
`,<% if (inlineStyle) {%> | ||
@@ -27,5 +65,13 @@ styles: [``]<% } else {%> | ||
export class <%= classify(name) %>Component { | ||
public gridData: any[] = <% if (dataName) {%><%=dataName%><% } else {%>products<% }%>;<% if (columns.length > 0) {%> | ||
public fields = [<%=arrayify(columns)%>];<% }%> | ||
public pageSize: number = <%=pageSize%>; | ||
public gridData: any[] = <% if (dataSource === "Example") { %>products<% } else if (dataSource === "Mock Data") { %>data<% } else if (dataName) { %><%=dataName%><% } else { %>products<%} %>;<% if (paging) { %> | ||
public pageSize: number = <%=pageSize%>;<% if (editing === 'inline' || editing === 'incell') {%> | ||
constructor(private formBuilder: FormBuilder) { } | ||
public createFormGroup = (args: CreateFormGroupArgs): FormGroup => { | ||
// TODO: Implement default item factory. | ||
const item = args.isNew ? Object.keys(this.gridData[0]).reduce((acc, curr) => (acc as any)[curr] = null || acc, {}) : args.dataItem; | ||
return this.formBuilder.group(item); | ||
};<% } %> | ||
} |
@@ -5,8 +5,17 @@ "use strict"; | ||
const core_1 = require("@angular-devkit/core"); | ||
const strings_1 = require("@angular-devkit/core/src/utils/strings"); | ||
const schematics_1 = require("@angular-devkit/schematics"); | ||
const path_1 = require("path"); | ||
const schema_1 = require("./schema"); | ||
const data_1 = require("./files/data"); | ||
const utils_1 = require("../utils"); | ||
const classify = core_1.strings.classify; | ||
const arrayify = (args) => args.map(s => `'${s}'`).join(", "); | ||
function grid(_options) { | ||
return (_tree, _context) => { | ||
var _a; | ||
_options.name = path_1.basename(_options.name); | ||
let defaults = { | ||
style: "css" | ||
}; | ||
let path = path_1.normalize('/' + path_1.dirname((_options.path + '/' + _options.name))); | ||
@@ -16,7 +25,18 @@ if (process.platform == "win32") { | ||
} | ||
const parsedComplexOptions = utils_1.parseComplexOptions(['columns'], _options); | ||
const overrides = {}; | ||
if (_options.dataSource == schema_1.DataSource.Example) { | ||
// If the data source is "Example", use a predefined template for data and columns | ||
overrides.columns = [ | ||
{ field: "ProductID", title: "ID" }, | ||
{ field: "ProductName", title: "Product Name" }, | ||
{ field: "UnitPrice", title: "Unit Price" } | ||
]; | ||
} | ||
const templateOptions = Object.assign(Object.assign(Object.assign(Object.assign(Object.assign({}, defaults), _options), parsedComplexOptions), overrides), { classify, | ||
dasherize: strings_1.dasherize, | ||
arrayify }); | ||
const templateSource = schematics_1.apply(schematics_1.url(_options.inlineTemplate ? './files/inline' : './files/html'), [ | ||
schematics_1.template(Object.assign(Object.assign({}, _options), { classify: core_1.strings.classify, dasherize: core_1.strings.dasherize, arrayify(args) { | ||
return args.map(s => `'${s}'`).join(", "); | ||
} })), | ||
schematics_1.move(_options.path), | ||
schematics_1.template(templateOptions), | ||
schematics_1.move(_options.path) | ||
]); | ||
@@ -28,7 +48,24 @@ const angularComponentOptions = { | ||
inlineStyle: _options.inlineStyle, | ||
skipTests: _options.skipTests | ||
skipTests: _options.skipTests, | ||
style: templateOptions.style | ||
}; | ||
if (_options.mockedData) { | ||
_tree.create(`${_options.path}/${_options.name}/data.ts`, `export const products = ${data_1.products}`); | ||
if (_options.dataSource == schema_1.DataSource.Example) { | ||
// Import the example datasource | ||
_tree.create(`${_options.path}/${strings_1.dasherize(_options.name)}/data.ts`, data_1.productsSourceCode); | ||
} | ||
else if (_options.dataSource == schema_1.DataSource['Mock Data']) { | ||
// Generate mocked data out of the column defitions | ||
let dataSourceCode = `export const data = [{\n`; | ||
for (let i = 0; i <= 15; i++) { | ||
for (const column of parsedComplexOptions.columns) { | ||
dataSourceCode += ` "${column.field}": "${(_a = column.title) !== null && _a !== void 0 ? _a : column.field} ${i}",\n`; | ||
} | ||
if (i < 15) { | ||
dataSourceCode += ` }, {\n`; | ||
} | ||
} | ||
dataSourceCode += ` }];\n`; | ||
dataSourceCode += `export default data;`; | ||
_tree.create(`${_options.path}/${strings_1.dasherize(_options.name)}/data.ts`, dataSourceCode); | ||
} | ||
return schematics_1.chain([ | ||
@@ -35,0 +72,0 @@ schematics_1.externalSchematic('@schematics/angular', 'component', angularComponentOptions), |
import { strings } from '@angular-devkit/core'; | ||
import { dasherize } from '@angular-devkit/core/src/utils/strings'; | ||
import { | ||
@@ -17,5 +18,11 @@ apply, | ||
import { basename, normalize, dirname, win32 } from 'path'; | ||
import { Schema } from './schema'; | ||
import { products } from './files/data'; | ||
import { DataSource, Schema } from './schema'; | ||
import { productsSourceCode } from './files/data'; | ||
import { parseComplexOptions } from '../utils'; | ||
const classify = strings.classify; | ||
const arrayify = (args: string[]) => | ||
args.map(s => `'${s}'`).join(", "); | ||
export function grid(_options: Schema): Rule { | ||
@@ -25,2 +32,6 @@ return (_tree: Tree, _context: SchematicContext) => { | ||
let defaults = { | ||
style: "css" | ||
}; | ||
let path = normalize('/' + dirname((_options.path + '/' + _options.name))); | ||
@@ -31,13 +42,29 @@ if (process.platform == "win32") { | ||
const parsedComplexOptions = parseComplexOptions(['columns'], _options); | ||
const overrides: any = {}; | ||
if (_options.dataSource == DataSource.Example) { | ||
// If the data source is "Example", use a predefined template for data and columns | ||
overrides.columns = [ | ||
{ field: "ProductID", title: "ID" }, | ||
{ field: "ProductName", title: "Product Name" }, | ||
{ field: "UnitPrice", title: "Unit Price"} | ||
] | ||
} | ||
const templateOptions = { | ||
...defaults, | ||
..._options, | ||
...parsedComplexOptions, | ||
...overrides, | ||
classify, | ||
dasherize, | ||
arrayify | ||
}; | ||
const templateSource = apply( | ||
url(_options.inlineTemplate ? './files/inline' : './files/html'), [ | ||
template({ | ||
..._options, | ||
classify: strings.classify, | ||
dasherize: strings.dasherize, | ||
arrayify(args: string[]) { | ||
return args.map(s => `'${s}'`).join(", "); | ||
} | ||
}), | ||
move(_options.path), | ||
template(templateOptions), | ||
move(_options.path) | ||
], | ||
@@ -51,8 +78,26 @@ ); | ||
inlineStyle: _options.inlineStyle, | ||
skipTests: _options.skipTests | ||
skipTests: _options.skipTests, | ||
style: templateOptions.style | ||
}; | ||
if(_options.mockedData) { | ||
_tree.create(`${_options.path}/${_options.name}/data.ts`, `export const products = ${products}`); | ||
if(_options.dataSource == DataSource.Example) { | ||
// Import the example datasource | ||
_tree.create(`${_options.path}/${dasherize(_options.name)}/data.ts`, productsSourceCode); | ||
} | ||
else if (_options.dataSource == DataSource['Mock Data']) | ||
{ | ||
// Generate mocked data out of the column defitions | ||
let dataSourceCode = `export const data = [{\n`; | ||
for (let i = 0; i <= 15; i++) { | ||
for (const column of parsedComplexOptions.columns) { | ||
dataSourceCode += ` "${column.field}": "${column.title ?? column.field} ${i}",\n`; | ||
} | ||
if (i < 15) { | ||
dataSourceCode += ` }, {\n`; | ||
} | ||
} | ||
dataSourceCode += ` }];\n`; | ||
dataSourceCode += `export default data;`; | ||
_tree.create(`${_options.path}/${dasherize(_options.name)}/data.ts`, dataSourceCode); | ||
} | ||
@@ -59,0 +104,0 @@ return chain([ |
@@ -0,1 +1,20 @@ | ||
export declare enum DataSource { | ||
/** | ||
* An example data source will be added to the project with predefined column definitions. | ||
* The data and column definitions can not be modified. | ||
* | ||
* This is the default. | ||
*/ | ||
"Example" = "Example", | ||
/** | ||
* The user is expected to provide column definitions. | ||
* A mock data will be generated out of the column definitions. | ||
*/ | ||
"Mock Data" = "Mock Data", | ||
/** | ||
* The user can specify a basic module to bind to and provide column definitions, | ||
* but in general the user will have to author some code to connect the data. | ||
*/ | ||
"Existing App Data" = "Existing App Data" | ||
} | ||
export interface Schema { | ||
@@ -11,8 +30,12 @@ path?: string; | ||
sorting?: boolean; | ||
resizing?: boolean; | ||
reordering?: boolean; | ||
columnMenu?: boolean; | ||
navigable?: boolean; | ||
pageSize?: number; | ||
height?: number; | ||
columns?: Array<string>; | ||
columns?: string; | ||
dataSource: DataSource; | ||
dataPath?: string; | ||
dataName: string; | ||
mockedData?: boolean; | ||
} |
"use strict"; | ||
Object.defineProperty(exports, "__esModule", { value: true }); | ||
exports.DataSource = void 0; | ||
var DataSource; | ||
(function (DataSource) { | ||
/** | ||
* An example data source will be added to the project with predefined column definitions. | ||
* The data and column definitions can not be modified. | ||
* | ||
* This is the default. | ||
*/ | ||
DataSource["Example"] = "Example"; | ||
/** | ||
* The user is expected to provide column definitions. | ||
* A mock data will be generated out of the column definitions. | ||
*/ | ||
DataSource["Mock Data"] = "Mock Data"; | ||
/** | ||
* The user can specify a basic module to bind to and provide column definitions, | ||
* but in general the user will have to author some code to connect the data. | ||
*/ | ||
DataSource["Existing App Data"] = "Existing App Data"; | ||
})(DataSource = exports.DataSource || (exports.DataSource = {})); |
@@ -21,3 +21,5 @@ { | ||
}, | ||
"inlineTemplate": { | ||
"progress:category": "Code Generation", | ||
"progress:display-name": "Inline template", | ||
@@ -30,2 +32,3 @@ "description": "Include template inline in the component.ts file. By default, an external template file is created and referenced in the component.ts file.", | ||
"inlineStyle": { | ||
"progress:category": "Code Generation", | ||
"description": "Include styles inline in the component.ts file. Only CSS styles can be included inline. By default, an external styles file is created and referenced in the component.ts file.", | ||
@@ -37,2 +40,3 @@ "type": "boolean", | ||
"skipTests": { | ||
"progress:category": "Code Generation", | ||
"type": "boolean", | ||
@@ -42,2 +46,10 @@ "description": "Do not create \"spec.ts\" test files for the new component.", | ||
}, | ||
"editing": { | ||
"progress:category": "Grid Features", | ||
"description": "Configures the Grid for inline or incell editing.", | ||
"type": "string", | ||
"enum": ["none", "inline", "incell"], | ||
"default": "none" | ||
}, | ||
"filtering": { | ||
@@ -50,2 +62,3 @@ "progress:category": "Grid Features", | ||
"grouping": { | ||
"progress:category": "Grid Features", | ||
"description": "Enables Grid grouping", | ||
@@ -56,2 +69,3 @@ "type": "boolean", | ||
"paging": { | ||
"progress:category": "Grid Features", | ||
"description": "Enables Grid paging", | ||
@@ -62,2 +76,3 @@ "type": "boolean", | ||
"sorting": { | ||
"progress:category": "Grid Features", | ||
"description": "Enables Grid sorting", | ||
@@ -67,3 +82,28 @@ "type": "boolean", | ||
}, | ||
"resizing": { | ||
"progress:category": "Grid Features", | ||
"description": "Enables Grid resizing", | ||
"type": "boolean", | ||
"default": false | ||
}, | ||
"reordering": { | ||
"progress:category": "Grid Features", | ||
"description": "Enables Grid reordering", | ||
"type": "boolean", | ||
"default": false | ||
}, | ||
"columnMenu": { | ||
"progress:category": "Grid Features", | ||
"description": "Enables Grid column menu", | ||
"type": "boolean", | ||
"default": false | ||
}, | ||
"navigable": { | ||
"progress:category": "Grid Features", | ||
"description": "Makes the Grid navigable", | ||
"type": "boolean", | ||
"default": false | ||
}, | ||
"pageSize": { | ||
"progress:category": "Grid Features", | ||
"description": "Sets the pageSize of a pageable Grid", | ||
@@ -74,2 +114,3 @@ "type": "number", | ||
"height": { | ||
"progress:category": "Grid Features", | ||
"description": "Sets the height of the Grid", | ||
@@ -79,29 +120,53 @@ "type": "number", | ||
}, | ||
"columns": { | ||
"progress:category": "Data Binding", | ||
"description": "Specifies the fields that will be rendered as columns in the Grid", | ||
"type": "array", | ||
"items": { | ||
"type": "string" | ||
}, | ||
"uniqueItems": true | ||
"dataSource": { | ||
"progress:category": "Data Source", | ||
"description": "Select grid data source generation strategy", | ||
"type": "string", | ||
"default": "Example", | ||
"enum": [ "Example", "Mock Data", "Existing App Data" ], | ||
"progress:enum": [{ | ||
"name": "Example", "description": "An example data source will be added to the project, with predefined column definitions." | ||
}, { | ||
"name": "Mock Data", "description": "Specify column definitions, from which mock data will be generated and added to the project." | ||
}, { | ||
"name": "Existing App Data", "description": "Provide import path. If the data module does not exist in your project, you will have to generate it by hand." | ||
}] | ||
}, | ||
"mockedData": { | ||
"description": "Enables the generation of a local data file", | ||
"type": "boolean" | ||
}, | ||
"dataPath": { | ||
"progress:category": "Data Source", | ||
"description": "Sets a path to the local data file", | ||
"type": "string", | ||
"progress:hideOnPropertyValue": { | ||
"property": "mockedData", | ||
"value": true | ||
} | ||
"progress:attributes": [ | ||
{ "type": "hideOnPropertyValue", "property": "dataSource", "values": [ "Example", "Mock Data" ] } | ||
] | ||
}, | ||
"dataName": { | ||
"progress:category": "Data Source", | ||
"description": "Sets a name to the local data property", | ||
"type": "string", | ||
"progress:hideOnPropertyValue": { | ||
"property": "mockedData", | ||
"value": true | ||
"progress:attributes": [ | ||
{ "type": "hideOnPropertyValue", "property": "dataSource", "values": [ "Example", "Mock Data" ] } | ||
] | ||
}, | ||
"columns": { | ||
"progress:category": "Data Source", | ||
"progress:type": "array", | ||
"hidden": true, | ||
"description": "Specifies the columns in the Grid", | ||
"type": "string", | ||
"progress:attributes": [ | ||
{ "type": "hideOnPropertyValue", "property": "dataSource", "values": [ "Example" ] } | ||
], | ||
"items": { | ||
"type": "object", | ||
"properties": { | ||
"field": {"type": "string"}, | ||
"title": {"type": "string"}, | ||
"hidden": {"type": "boolean"}, | ||
"locked": {"type": "boolean"}, | ||
"sticky": {"type": "boolean"}, | ||
"columnMenu": {"type": "boolean"}, | ||
"editable": {"type": "boolean"}, | ||
"width": {"type": "number"} | ||
} | ||
} | ||
@@ -108,0 +173,0 @@ } |
@@ -0,1 +1,24 @@ | ||
export enum DataSource { | ||
/** | ||
* An example data source will be added to the project with predefined column definitions. | ||
* The data and column definitions can not be modified. | ||
* | ||
* This is the default. | ||
*/ | ||
"Example" = "Example", | ||
/** | ||
* The user is expected to provide column definitions. | ||
* A mock data will be generated out of the column definitions. | ||
*/ | ||
"Mock Data" = "Mock Data", | ||
/** | ||
* The user can specify a basic module to bind to and provide column definitions, | ||
* but in general the user will have to author some code to connect the data. | ||
*/ | ||
"Existing App Data" = "Existing App Data" | ||
} | ||
export interface Schema { | ||
@@ -11,8 +34,12 @@ path?: string; | ||
sorting?: boolean; | ||
resizing?: boolean; | ||
reordering?: boolean; | ||
columnMenu?: boolean; | ||
navigable?: boolean; | ||
pageSize?: number; | ||
height?: number; | ||
columns?: Array<string>; | ||
columns?: string; | ||
dataSource: DataSource; | ||
dataPath?: string; | ||
dataName: string; | ||
mockedData?: boolean; | ||
} | ||
} |
@@ -12,1 +12,2 @@ import { Tree } from '@angular-devkit/schematics'; | ||
export declare function fileContent(tree: Tree, path: string): string; | ||
export declare const parseComplexOptions: (props: string[], options: any) => any; |
@@ -13,3 +13,3 @@ "use strict"; | ||
Object.defineProperty(exports, "__esModule", { value: true }); | ||
exports.fileContent = exports.asObservable = exports.stringify = exports.buildSelector = exports.folderName = exports.getAppModulePath = exports.findModule = exports.addImportToModule = exports.addExportToModule = exports.addDeclarationToModule = exports.addSymbolToMetadata = void 0; | ||
exports.parseComplexOptions = exports.fileContent = exports.asObservable = exports.stringify = exports.buildSelector = exports.folderName = exports.getAppModulePath = exports.findModule = exports.addImportToModule = exports.addExportToModule = exports.addDeclarationToModule = exports.addSymbolToMetadata = void 0; | ||
const core_1 = require("@angular-devkit/core"); | ||
@@ -64,1 +64,17 @@ const schematics_1 = require("@angular-devkit/schematics"); | ||
exports.fileContent = fileContent; | ||
const parseComplexOptions = (props, options) => props.reduce((acc, option) => { | ||
if (options[option]) { | ||
try { | ||
let rawValue = options[option]; | ||
let parsed = JSON.parse(rawValue); | ||
acc[option] = parsed; | ||
// console.log(`Parsing ${option}, raw: '${rawValue}', json: '${JSON.stringify(parsed, null, " ")}'`); | ||
} | ||
catch (e) { | ||
e.message = `Failed parsing '${option}' input. ${e.message}.`; | ||
throw e; | ||
} | ||
} | ||
return acc; | ||
}, {}); | ||
exports.parseComplexOptions = parseComplexOptions; |
@@ -70,1 +70,18 @@ import { strings } from '@angular-devkit/core'; | ||
} | ||
export const parseComplexOptions = | ||
(props: string[], options: any): any => props.reduce((acc, option) => { | ||
if (options[option]) { | ||
try { | ||
let rawValue = options[option]; | ||
let parsed = JSON.parse(rawValue); | ||
acc[option] = parsed; | ||
// console.log(`Parsing ${option}, raw: '${rawValue}', json: '${JSON.stringify(parsed, null, " ")}'`); | ||
} catch(e) { | ||
e.message = `Failed parsing '${option}' input. ${e.message}.`; | ||
throw e; | ||
} | ||
} | ||
return acc; | ||
}, {}); |
Sorry, the diff of this file is not supported yet
License Policy Violation
LicenseThis package is not allowed per your license policy. Review the package's license to ensure compliance.
Found 1 instance in 1 package
Major refactor
Supply chain riskPackage has recently undergone a major refactor. It may be unstable or indicate significant internal changes. Use caution when updating to versions that include significant changes.
Found 1 instance in 1 package
No v1
QualityPackage is not semver >=1. This means it is not stable and does not support ^ ranges.
Found 1 instance in 1 package
License Policy Violation
LicenseThis package is not allowed per your license policy. Review the package's license to ensure compliance.
Found 1 instance in 1 package
534484
166
12318
1
1