diff options
Diffstat (limited to 'src/main/resources/db/changelogs')
| -rw-r--r-- | src/main/resources/db/changelogs/20220814-test-data.xml | 93 |
1 files changed, 93 insertions, 0 deletions
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 |