No description
Find a file
2022-07-17 22:12:04 +00:00
sql Helper script to show all the entries from St. Gallen 2022-07-17 23:57:40 +02:00
.gitignore Exclude venv directory for python dependencies 2022-07-17 16:26:58 +02:00
README.md Update README with the new files (#1) 2022-07-17 22:12:04 +00:00
requirements.txt Started python script 2022-07-17 16:27:15 +02:00
script.sh Helper script to show all the entries from St. Gallen 2022-07-17 23:57:40 +02:00
start.py Script to update the values inside the database 2022-07-17 23:57:13 +02:00

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 script
  • script.sh: Small & ugly script to execute commands inside the sql-files (see sql/)
  • sql/
    • create_db.sql: creates the small test database
    • insert_data.sql: insert some fictive test values into the database
    • show_all.sql: Shows all the data inside the database from table customers
    • show_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