Translations:Kexi/Tutorials/Importing SQLite database into Kexi/26/en: Difference between revisions
(Importing a new version from external source) |
(Importing a new version from external source) |
||
Line 1: | Line 1: | ||
*Reports the ''oaklandweather.kexi'' file to a so- | *Reports the ''oaklandweather.kexi'' file to a so-called SQL dump (a text representation) using the sqlite3 console app. | ||
*Removes from this dump any lines that do not begin with BEGIN, INSERT, ANALYZE or COMMIT. This is needed because we are only interested in data of the table, not in creating a new table. | *Removes from this dump any lines that do not begin with BEGIN, INSERT, ANALYZE or COMMIT. This is needed because we are only interested in data of the table, not in creating a new table. | ||
*Directs the resulting output to a ''sqlite3'' console app again, which receives all the commands from the output and applies them to the ''oaklandweather.kexi'' database file. The last command applied is COMMIT. | *Directs the resulting output to a ''sqlite3'' console app again, which receives all the commands from the output and applies them to the ''oaklandweather.kexi'' database file. The last command applied is COMMIT. |
Latest revision as of 13:10, 19 May 2019
- Reports the oaklandweather.kexi file to a so-called SQL dump (a text representation) using the sqlite3 console app.
- Removes from this dump any lines that do not begin with BEGIN, INSERT, ANALYZE or COMMIT. This is needed because we are only interested in data of the table, not in creating a new table.
- Directs the resulting output to a sqlite3 console app again, which receives all the commands from the output and applies them to the oaklandweather.kexi database file. The last command applied is COMMIT.