module sql.database_helper

Short summary

module pyensae.sql.database_helper

Contains functions to import a text file into a database (SQLite).

source on GitHub

Functions

function truncated documentation
import_flatfile_into_database Function which imports a file into a database. It the table exists, it removes it first. There is no addition.

Documentation

Contains functions to import a text file into a database (SQLite).

source on GitHub

pyensae.sql.database_helper.import_flatfile_into_database(filedb, filetext, table=None, header=True, columns=None, engine='SQLite', host='localhost', add_key=None, encoding='utf-8', fLOG=<built-in function print>)[source]

Function which imports a file into a database. It the table exists, it removes it first. There is no addition.

Parameters:
  • filedb – something.db3
  • filetext – something.txt or .tsv
  • table – table name (in the database), if None, the database name will be the filename without extension
  • columns – if header is False, this must be specified. It should be a list of column names.
  • header – boolean (does it have a header or not)
  • engine – engine to use when using a SQL server (SQLite or ODBCMSSQL)
  • host – host (server)
  • fLOG – logging function (will display information through the command line)
  • add_key – name of a key to add (or None if nothing to add)
  • encoding – encoding
Returns:

table name

Import a flat file into a SQLite database

from pyensae import import_flatfile_into_database
dbf = "database.db3"
file = "textfile.txt"
import_flatfile_into_database(dbf, file)

On Windows, SQLiteSpy is a free tool very useful to run SQL queries against a sqlite3 database.

source on GitHub