SQLite3x.executescript
def executescript(
self,
script: AnyStr = None,
) -> Union[Tuple, None]:
"""
Execute many SQL-scripts whit (or without) values
Parameters
----------
script : AnyStr
single SQLite script, might contains ph_amount
Returns
----------
Union[Tuple, None]
ABDatabase answer if it has
"""
Sames as sqlite3.executescript
Examples
import sqllex as sx
db = sx.SQLite3x(path='database.db')
# db = sx.PostgreSQL(...)
db.executescript(
"""
CREATE TABLE users (
id INTEGER PRIMARY KEY UNIQUE,
name TEXT
);
INSERT INTO users (id, text) VALUES (1, 2);
INSERT INTO users (id, text) VALUES (2, 3);
"""
)