You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
sqlite-utils insert ... --text to insert the contents of the file into a table with a single text column and a single row.
sqlite-utils insert ... --convert allows a Python function to be provided that will be used to convert each row that is being inserted into the database. See Applying conversions while inserting data, including details on special behavior when combined with --lines and --text. (#356)
sqlite-utils convert now accepts a code value of - to read code from standard input. (#353)
sqlite-utils convert also now accepts code that defines a named convert(value) function, see Converting data in columns.
db.supports_strict property showing if the database connection supports SQLite strict tables.
table.strict property (see .strict) indicating if the table uses strict mode. (#344)
Fixed bug where sqlite-utils upsert ... --detect-types ignored the --detect-types option. (#362)