SQLite3x.insertmany

def insertmany(
        self,
        TABLE: Union[AnyStr, AbstractTable],
        *args: Union[List[List], List[Tuple], Tuple[List], Tuple[Tuple], List, Tuple, Iterable],
        OR: OrOptionsType = None,
        **kwargs: Any,
) -> None:
    """
    INSERT many data into table.
    The same as regular insert but for lists of inserting values
    
    Parameters
    ----------
    TABLE : AnyStr
        Name of table
    args : Union[List, Tuple]
        1'st way set values for insert
        P.S: args also support numpy.array value
    OR : OrOptionsType
        Action in case if inserting has failed. Optional parameter.
        > OR='IGNORE'
    kwargs : Any
        An 2'st way set values for insert
    
    Returns
    ----------
        None or SQL-script in SQLStatement
    """

import sqllex as sx

db = sx.SQLite3x(path='database.db')
# db = sx.PostgreSQL(...)


db.create_table(
    'users',
    {
        'id': [sx.INTEGER],
        'name': [sx.TEXT, sx.NOT_NULL]
    }
)

users_list = [
    [0, "User_0"],
    [1, "User_1"],
    [2, "User_2"],
    [3, "User_3"],
    [4, "User_4"],
    [5, "User_5"],
    [6, "User_6"],
    [7, "User_7"],
    [8, "User_8"],
    [9, "User_9"],
]

db.insertmany('users', users_list)

db.insertmany(
    'users',
    users_list,
    OR=sx.IGNORE, # REPLACE, FAIL, ABORT, ROLLBACK
)


users_list = [
    (0, "User_0"),
    (1, "User_1"),
    (2, "User_2"),
    (3, "User_3"),
    (4, "User_4"),
    (5, "User_5"),
    (6, "User_6"),
    (7, "User_7"),
    (8, "User_8"),
    (9, "User_9"),
]

db.insertmany('users', users_list)


users_list = [
    {'id': 0, 'name': "User_0"},
    {'id': 1, 'name': "User_1"},
    {'id': 2, 'name': "User_2"},
    {'id': 3, 'name': "User_3"},
    {'id': 4, 'name': "User_4"},
    {'id': 5, 'name': "User_5"},
    {'id': 6, 'name': "User_6"},
    {'id': 7, 'name': "User_7"},
    {'id': 8, 'name': "User_8"},
    {'id': 9, 'name': "User_9"},
]

db.insertmany('users', users_list)