Translations:Kexi/Tutorials/Importing SQLite database into Kexi/26/da: Difference between revisions

Latest revision as of 06:05, 3 March 2015

Information about message (contribute)

This message has no documentation. If you know where or how this message is used, you can help other translators by adding documentation to this message.

Message definition (Kexi/Tutorials/Importing SQLite database into Kexi)

*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.

Anmelder filen oaklandweather.kexi til et såkaldt SQL-dump (en tekstrepræsentation) ved brug af sqlite3's konsolprogram.
Fjerner de linjer fra dumpet, som ikke begynder med BEGIN, INSERT, ANALYZE eller COMMIT. Det er nødvendigt, da vi kun er interesserede i tabellens data, ikke i at oprette en ny tabel.
Sender det resulterende output tilbage til et sqlite3-konsolprogram, som modtager alle kommandoerne i outputtet og anvender dem på databasefilen oaklandweather.kexi. Den sidste kommando, som anvendes er COMMIT.