From 1b42afd8c5eb9e16c6f7e93c0518cee1285ec383 Mon Sep 17 00:00:00 2001
From: Kevin J Hoerr <kjhoerr@protonmail.com>
Date: Mon, 15 Aug 2022 00:50:04 +0000
Subject: Add test data and link to q/dev

---
 src/main/resources/db/changeLog.xml                |  1 +
 .../resources/db/changelogs/20220814-test-data.xml | 93 ++++++++++++++++++++++
 2 files changed, 94 insertions(+)
 create mode 100644 src/main/resources/db/changelogs/20220814-test-data.xml

(limited to 'src/main/resources')

diff --git a/src/main/resources/db/changeLog.xml b/src/main/resources/db/changeLog.xml
index f759350..870baf4 100644
--- a/src/main/resources/db/changeLog.xml
+++ b/src/main/resources/db/changeLog.xml
@@ -5,4 +5,5 @@
     xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.6.xsd
     http://www.liquibase.org/xml/ns/dbchangelog-ext http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-ext.xsd">
    <include file="db/changelogs/20220804-add-pantryitem.xml" />
+   <include file="db/changelogs/20220814-test-data.xml" />
 </databaseChangeLog>
\ No newline at end of file
diff --git a/src/main/resources/db/changelogs/20220814-test-data.xml b/src/main/resources/db/changelogs/20220814-test-data.xml
new file mode 100644
index 0000000..c61238b
--- /dev/null
+++ b/src/main/resources/db/changelogs/20220814-test-data.xml
@@ -0,0 +1,93 @@
+<databaseChangeLog
+    xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
+    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
+    xmlns:ext="http://www.liquibase.org/xml/ns/dbchangelog-ext"
+    xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.6.xsd
+    http://www.liquibase.org/xml/ns/dbchangelog-ext http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-ext.xsd">
+   <changeSet id="20220814-test-data" author="kjhoerr" context="test">
+        <insert tableName="pantryitem">
+            <column name="id" value="1"/>
+            <column name="name" value="Flour"/>
+            <column name="description" value="Unbleached white"/>
+            <column name="quantity" value="2.3"/>
+            <column name="quantityunittype" value="lb"/>
+        </insert>
+        <insert tableName="pantryitem">
+            <column name="id" value="2"/>
+            <column name="name" value="Sugar"/>
+            <column name="description" value="Granulated"/>
+            <column name="quantity" value="9.3"/>
+            <column name="quantityunittype" value="oz"/>
+        </insert>
+        <insert tableName="pantryitem">
+            <column name="id" value="3"/>
+            <column name="name" value="Eggs"/>
+            <column name="description" value="Large white"/>
+            <column name="quantity" value="10"/>
+            <column name="quantityunittype" value="ct"/>
+        </insert>
+        <insert tableName="pantryitem">
+            <column name="id" value="4"/>
+            <column name="name" value="Baking Powder"/>
+            <column name="description" value="Double acting"/>
+            <column name="quantity" value="3.3"/>
+            <column name="quantityunittype" value="oz"/>
+        </insert>
+        <insert tableName="pantryitem">
+            <column name="id" value="5"/>
+            <column name="name" value="Oat Milk"/>
+            <column name="description" value="Unsweetened/no flavoring"/>
+            <column name="quantity" value="107"/>
+            <column name="quantityunittype" value="oz"/>
+        </insert>
+        <insert tableName="pantryitem">
+            <column name="id" value="6"/>
+            <column name="name" value="Vanilla Extract"/>
+            <column name="description" value=""/>
+            <column name="quantity" value="8.8"/>
+            <column name="quantityunittype" value="oz"/>
+        </insert>
+        <insert tableName="pantryitem">
+            <column name="id" value="7"/>
+            <column name="name" value="Almond Extract"/>
+            <column name="description" value=""/>
+            <column name="quantity" value="1.07"/>
+            <column name="quantityunittype" value="oz"/>
+        </insert>
+        <insert tableName="pantryitem">
+            <column name="id" value="8"/>
+            <column name="name" value="Canola Oil"/>
+            <column name="description" value=""/>
+            <column name="quantity" value="51"/>
+            <column name="quantityunittype" value="oz"/>
+        </insert>
+        <insert tableName="pantryitem">
+            <column name="id" value="9"/>
+            <column name="name" value="Salt"/>
+            <column name="description" value="Iodized"/>
+            <column name="quantity" value="4.5"/>
+            <column name="quantityunittype" value="oz"/>
+        </insert>
+        <insert tableName="pantryitem">
+            <column name="id" value="10"/>
+            <column name="name" value="Eggs"/>
+            <column name="description" value="Large white"/>
+            <column name="quantity" value="10"/>
+            <column name="quantityunittype" value="ct"/>
+        </insert>
+        <insert tableName="pantryitem">
+            <column name="id" value="11"/>
+            <column name="name" value="Butter"/>
+            <column name="description" value="Salted"/>
+            <column name="quantity" value="3.5"/>
+            <column name="quantityunittype" value="cups"/>
+        </insert>
+        <insert tableName="pantryitem">
+            <column name="id" value="12"/>
+            <column name="name" value="Brown Sugar"/>
+            <column name="description" value=""/>
+            <column name="quantity" value="15"/>
+            <column name="quantityunittype" value="oz"/>
+        </insert>
+   </changeSet>
+</databaseChangeLog>
\ No newline at end of file
-- 
cgit