v0.3.0

v0.3.0

Added

• added execute_batch() where we can run multiple chained sql statements (via ;) at runtime.

• added _bulk methods for write statements to easily have bulk operation without resorting to transactions

• Generates an init() method if you are connecting via an external sql file. This allows us to easily run whatever is defined in that sql file.

• Generates a open_connected_db() method if you are connecting via an external sqlite database. This allows us to easily connect to the database after naming it at macro level.

• Nested transactions are now supported

Fixed

• compile time checks for virtual tables are not supported. Added this specific error for better clarity.

• more robust error handling and suggestions for STRICT Table to get maximum benefits of this library. It will auto detect types that are valid but invalid in STRICT table and will suggest the correct type. It will also suggest using CHECK (col in (0 or 1)) if you want to get bool type safety

• doc comments for most commonly used functions are written deatilly

• panic within transaction now rollback Database, preventing it from deadlock

• CREATE TABLE detection is now more robust by using AST parsing instead of string matching.

Breaking Changes

• fn name changes
  1. execute_runtime() → execute()
  2. query_runtime → query()

Internal

• unify type mapping and remove redundant code
• Removed check_constraint field in ColumnInfo struct as it is no longer being used
• removed exec fn and replaced all macro genreation which dependent on it with execute_batch