Skip to content

Latest commit

 

History

History
26 lines (17 loc) · 1014 Bytes

README.md

File metadata and controls

26 lines (17 loc) · 1014 Bytes

This repo contains the GCMRC Sandbar Workbench software. This is a small, lightweight desktop software application for managing Grand Canyon sandbars and the results from the Sandbar Python Analysis.

Requirements

The software was coded using Microsoft Visual Studio 2022 and relies on several Nuget packages, including System.Data.SQLites and DBUp.

Database

The latest version of the Workbench uses a single SQLite database. It no longer uses a master MySQL database.

Create a new DB with the contents of the SQL File:

sqlite3 -init workbench_schema_data.sql workbench.sqlite ""

Export Schema from DB:

# Export only the schema
sqlite3 workbench.sqlite .schema > workbench_schema.sql
# Export everything including Data
sqlite3 workbench.sqlite .dump > workbench_schema_data.sql