pyworkflow.mapper.sqlite_db module

This module contains some sqlite basic tools to handle Databases.

class pyworkflow.mapper.sqlite_db.SqliteDb

Bases: object

Class to handle a Sqlite database. It will create connection, execute queries and commands.

OPEN_CONNECTIONS = {}

close()

classmethod closeConnection(dbName)

getDbName()

getTableColumns(tableName)

getTables(tablePattern=None)

Return the table names existing in the Database. If tablePattern is not None, only tables matching the pattern will be returned.

getVersion()

Return the database ‘version’ that is used. Internally it make use of the SQLite PRAGMA database.user_version;

hasTable(tableName)

setVersion(version)