SQLite3x

Main class to interact with SQLite3 databases, belongs to the sqllex-databases family, child of AbstractDatabase.

import sqllex as sx

db = sx.SQLite3x(
    path="data/my_data.db", # path to db location, might be Path type
    
    # Optional parameters
    template={
        'users': {
            'id': [sx.INTEGER, sx.AUTOINCREMENT],
            'name': sx.TEXT
        }
    },
        
    # Create connection to database with database class object initialisation
    init_connection=True,
    
    # Optional sqlite connection parameters
    check_same_thread=False
)

  

SQLite3x Public Methods

Properties

    * - available only for this specific database-class

Back to home

Sqllex

main