aboutsummaryrefslogtreecommitdiff
path: root/src/main/resources/db
diff options
context:
space:
mode:
Diffstat (limited to 'src/main/resources/db')
-rw-r--r--src/main/resources/db/changeLog.xml1
-rw-r--r--src/main/resources/db/changelogs/20220814-test-data.xml93
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