SQLite3x.replace
def replace(
self,
TABLE: Union[AnyStr, AbstractTable],
*args: Any,
WHERE: WhereType = None,
**kwargs: Any,
) -> None:
"""
REPLACE data into table
Parameters
----------
TABLE : AnyStr
Name of table
WHERE : WhereType
Optional parameter for conditions
> WHERE=(db['table_name']['column_name'] == 'some_value')
"""
Examples
import sqllex as sx
db = sx.SQLite3x(path='db-1.db')
# db = sx.PostgreSQL(...)
db.create_table(
'users',
{
'id': [sx.INTEGER, sx.PRIMARY_KEY, sx.UNIQUE],
'name': [sx.TEXT, sx.NOT_NULL, sx.DEFAULT, 'Unknown']
}
)
...
db.replace('users', 1, 'User1')
db.replace('users', [2, "User2"])
db.replace('users', (3, 'User3'))
db.replace('users', id=4, name="User4")
db.replace(
TABLE='users',
id=5, name="User5"
)
# for SQLIte3xTable
users = db['users']
users.replace([5, "User5"])