You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
Reviewed-on: #1 |
11 months ago | |
---|---|---|
sql | 11 months ago | |
.gitignore | 11 months ago | |
README.md | 11 months ago | |
requirements.txt | 11 months ago | |
script.sh | 11 months ago | |
start.py | 11 months ago |
README.md
SQLITE Test Area
This is a small test area how to edit SQLite databases and update some values according to their value.
Files
├── requirements.txt
├── script.sh
├── sql
│ ├── create_db.sql
│ ├── insert_data.sql
│ ├── show_all.sql
│ ├── show_sg.sql
│ └── update_sg.sql
├── start.py
requirements.txt
: requirements for the python scriptscript.sh
: Small & ugly script to execute commands inside the sql-files (seesql/
)sql/
create_db.sql
: creates the small test databaseinsert_data.sql
: insert some fictive test values into the databaseshow_all.sql
: Shows all the data inside the database from table customersshow_sg.sql
: Show all the data which are from St. Gallen (and will get updated)update_sg.sql
: Update the entries so the city is written consistent
start.py
: small python helper script