Add test data and link to q/dev

2 files changed, 94 insertions, 0 deletions

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