Copyright(c) 2020-
Author: Chaitanya Tejaswi (github.com/CRTejaswi) License: GPL v3.0+
Personal notes.
SQLite
SQLServer
MySQL
PostGreSQL
MongoDB
- TASK: Write classes to CRUD SQL databases. (Entries are from this dataset.)
- Implement
outCsvmethod. - Modify methods to automate CRUDing using a CSV file.
| Task | Command |
|---|---|
| Open file | sqlite3 file.db |
.open file.db |
|
| Exit | .exit |
| List all commands | .help |
| List all databases | .database |
| List tables from current database | .table [PATTERN] |
| Show structure of all tables | .fullschema |
| Show structure of a table | .schema TABLENAME |
| Save query-results (one/more) to file | .once FILENAME |
.output FILENAME |
|
| Execute SQL queries from file | .read FILENAME |