migrated db examples to client_db.

bjmckenz · Apr 13, 2024 · 32be9ad · 32be9ad
1 parent 970de5a
commit 32be9ad
Show file tree

Hide file tree

Showing 13 changed files with 119 additions and 718 deletions.
diff --git a/data/containers.db b/data/containers.db
diff --git a/package-lock.json b/package-lock.json
diff --git a/package.json b/package.json
@@ -30,7 +30,6 @@
 	},
 	"type": "module",
 	"dependencies": {
-		"better-sqlite3": "^9.4.3",
 		"smui-theme": "^7.0.0-beta.16"
 	}
 }
diff --git a/src/lib/ContainerSummaryRow.svelte b/src/lib/ContainerSummaryRow.svelte
diff --git a/src/lib/ContainerTable.svelte b/src/lib/ContainerTable.svelte
diff --git a/src/lib/server/database.js b/src/lib/server/database.js
diff --git a/src/routes/+page.svelte b/src/routes/+page.svelte
@@ -6,36 +6,19 @@
 <h1>Welcome to simple Client/API site</h1>
 <p>Bits and pieces to get started in Svelte and API</p>
 
-<p>Step 1: Understand how this route works.</p>
-<button on:click={() => {goto('/fromstatic')}}>Show hard-coded Containers</button>
-
-<p>Step 2: Display data from an API</p>
+<p>Step 1: Display data from an API</p>
 <button on:click={() => {goto('/fromapi')}}>Show Containers via API</button>
 
-<p>Step 3: Set up site-wide layout</p>
-<p class=note>(go look at +layout.svelte)</p>
-
-<p>Step 4: Use Svelte MUI to display data</p>
+<p>Step 2: Use Svelte MUI to display data</p>
 <button on:click={() => {goto('/fromapi_mui')}}>Show Containers in nice table</button>
 
-<p>Step 5: Use a "form" to collect user data and make an API request</p>
+<p>Step 3: Use a "form" to collect user data and make an API request</p>
 <button on:click={() => {goto('/fetchContainer')}}>Fetch A Container</button>
 
-<p>Step 6: See how to collect data and make a POST request</p>
+<p>Step 4: See how to collect data and make a POST request</p>
 <button on:click={() => {goto('/createContainer')}}>Create A Container</button>
 
 
-<p>Step 7: See how to use a SQLITE3 database</p>
-<span class=note>(For this to work, you MUST create a file called .env at the project root, and it must have the following line in it: "DB_FILE=./data/containers.db")</span>
-<br/>
-<button on:click={() => {goto('/fromDB')}}>Use Database</button>
-
-
-<p>Step 8: See how to create Svelte components</p>
-<span class=note>(uses db, so create the .env file as above)</span>
-<br/>
-<button on:click={() => {goto('/fromDBandComponents')}}>Use Components</button>
-
 
 <style>
     .note {

diff --git a/src/routes/fromDB/+page.server.js b/src/routes/fromDB/+page.server.js
diff --git a/src/routes/fromDB/+page.svelte b/src/routes/fromDB/+page.svelte
diff --git a/src/routes/fromDBandComponents/+page.server.js b/src/routes/fromDBandComponents/+page.server.js
diff --git a/src/routes/fromDBandComponents/+page.svelte b/src/routes/fromDBandComponents/+page.svelte
diff --git a/src/routes/fromapi_mui/+page.svelte b/src/routes/fromapi_mui/+page.svelte
@@ -19,9 +19,9 @@
 		</Row>
 	</Head>
 	<Body>
-		{#each data.containers as container (container.id)}
+		{#each data.containers as container (container.containerNumber)}
 			<Row>
-				<Cell>{container.id}</Cell>
+				<Cell>{container.containerNumber}</Cell>
 				<Cell>{container.nameOfShip}</Cell>
 			</Row>
 		{/each}

diff --git a/src/routes/fromstatic/+page.svelte b/src/routes/fromstatic/+page.svelte