cami
/
sqlite-things
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
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.
15 Commits
1 Branch
0 Tags
295 KiB
Python 85.3%
Shell 14.7%
 
 
main
Branches Tags
${ item.name }
Create tag ${ searchTerm }
Create branch ${ searchTerm }
from 'main'
${ noResults }
Go to file
cami f1d0c15426 Update README with the new files (#1) 
Reviewed-on: #1
 		11 months ago
sql Helper script to show all the entries from St. Gallen 11 months ago
.gitignore Exclude venv directory for python dependencies 11 months ago
README.md Update README with the new files (#1) 11 months ago
requirements.txt Started python script 11 months ago
script.sh Helper script to show all the entries from St. Gallen 11 months ago
start.py Script to update the values inside the database 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 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