Skip to content

0.1.3 - Schema Introspection, JSON, Savepoints, Interrupt

Choose a tag to compare

@arcanii arcanii released this 11 Mar 09:43
· 16 commits to main since this release
1bdaa09

What's New in 0.1.3

  • SQLite3_Schema.bas — new module: schema introspection via PRAGMA. GetTableList, GetViewList, GetColumnInfo, GetIndexList, GetIndexColumns, GetForeignKeys, GetCreateSQL, GetDatabaseInfo, GetTriggerList
  • SQLite3_JSON.bas — new module: 15 wrappers for SQLite's built-in JSON functions (requires SQLite 3.38+). JSONExtract, JSONSet, JSONInsert, JSONReplace, JSONRemove, JSONPatch, JSONValid, JSONSearch, JSONGroupArray, JSONGroupObject, JSONEach, JSONType, JSONBuildObject, JSONBuildArray
  • Savepoints — nested transactions added to SQLite3Connection: Savepoint, ReleaseSavepoint, RollbackToSavepoint, SavepointDepth
  • Interrupt — conn.Interrupt calls sqlite3_interrupt to cancel a running query
  • Failed-test summary — RunAllTests now prints a consolidated list of every failure at the end so nothing gets lost in the output
  • ViewExists, IndexExists — added to SQLite3_Helpers.bas alongside the existing TableExists
  • 4 new test suites (26-29), 69 new tests — total 240 tests