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
- add_column
- connect
- create_table
- create_temp_table
- create_temporary_table
- delete
- disconnect
- drop
- execute
- executemany
- executescript
- foreign_keys *
- get_columns
- get_columns_names
- get_table
- insert
- insertmany
- journal_mode *
- markup
- pragma *
- remove_column
- replace *
- select
- select_all
select_distinct- table_info *
- update
- updatemany
Properties
* - available only for this specific database-class