From fdf36c0af83db4fa015794e9827ccce0aa8b5a5e Mon Sep 17 00:00:00 2001
From: Kevin J Hoerr <kjhoerr@protonmail.com>
Date: Thu, 29 Dec 2022 18:03:41 -0500
Subject: Update; Switch to MongoDB

---
 src/main/resources/application.properties          |  5 +-
 src/main/resources/db/changeLog.xml                |  9 ---
 .../db/changelogs/20220804-add-pantryitem.xml      | 30 -------
 .../resources/db/changelogs/20220814-test-data.xml | 93 ----------------------
 4 files changed, 2 insertions(+), 135 deletions(-)
 delete mode 100644 src/main/resources/db/changeLog.xml
 delete mode 100644 src/main/resources/db/changelogs/20220804-add-pantryitem.xml
 delete mode 100644 src/main/resources/db/changelogs/20220814-test-data.xml

(limited to 'src/main/resources')

diff --git a/src/main/resources/application.properties b/src/main/resources/application.properties
index f36fb33..81f5248 100644
--- a/src/main/resources/application.properties
+++ b/src/main/resources/application.properties
@@ -1,3 +1,2 @@
-quarkus.liquibase.clean-at-start=true
-quarkus.liquibase.migrate-at-start=true
-quarkus.liquibase.contexts=migrate,test
+#quarkus.mongodb.connection-string=mongodb://localhost:27017
+quarkus.mongodb.database = pantry
diff --git a/src/main/resources/db/changeLog.xml b/src/main/resources/db/changeLog.xml
deleted file mode 100644
index 870baf4..0000000
--- a/src/main/resources/db/changeLog.xml
+++ /dev/null
@@ -1,9 +0,0 @@
-<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">
-   <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/20220804-add-pantryitem.xml b/src/main/resources/db/changelogs/20220804-add-pantryitem.xml
deleted file mode 100644
index f6ab0ee..0000000
--- a/src/main/resources/db/changelogs/20220804-add-pantryitem.xml
+++ /dev/null
@@ -1,30 +0,0 @@
-<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="20220804-add-pantryitem" author="kjhoerr" context="migrate">
-        <validCheckSum>8:350c0b8d4ff8ce36a2453a0fe2373684</validCheckSum>
-        <createSequence 
-            sequenceName="hibernate_sequence"
-            incrementBy="1"
-            startValue="1"
-        />
-        <createTable tableName="pantryitem">
-            <column name="id" type="int8">
-                <constraints primaryKey="true" primaryKeyName="pk_pantryitem_id" nullable="false" />
-            </column>
-            <column name="name" type="varchar(80)">
-                <constraints nullable="false" />
-            </column>
-            <column name="description" type="varchar(1000)" />
-            <column name="quantity" type="float8">
-                <constraints nullable="false" />
-            </column>
-            <column name="quantityunittype" type="varchar(40)">
-                <constraints nullable="false" />
-            </column>
-        </createTable>
-   </changeSet>
-</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
deleted file mode 100644
index b8b9ad3..0000000
--- a/src/main/resources/db/changelogs/20220814-test-data.xml
+++ /dev/null
@@ -1,93 +0,0 @@
-<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" valueSequenceNext="hibernate_sequence"/>
-            <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" valueSequenceNext="hibernate_sequence"/>
-            <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" valueSequenceNext="hibernate_sequence"/>
-            <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" valueSequenceNext="hibernate_sequence"/>
-            <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" valueSequenceNext="hibernate_sequence"/>
-            <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" valueSequenceNext="hibernate_sequence"/>
-            <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" valueSequenceNext="hibernate_sequence"/>
-            <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" valueSequenceNext="hibernate_sequence"/>
-            <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" valueSequenceNext="hibernate_sequence"/>
-            <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" valueSequenceNext="hibernate_sequence"/>
-            <column name="name" value="Baking Soda"/>
-            <column name="description" value=""/>
-            <column name="quantity" value="6.5"/>
-            <column name="quantityunittype" value="oz"/>
-        </insert>
-        <insert tableName="pantryitem">
-            <column name="id" valueSequenceNext="hibernate_sequence"/>
-            <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" valueSequenceNext="hibernate_sequence"/>
-            <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