Greg Slepak  committed e6a6a0f

database_sqlite3 -> 1.2

  • Participants
  • Parent commits 177217a

Comments (0)

Files changed (2)

   * DF:activate-plugin can now be used to load all lisp files in a directory
   * db/database_utils includes for-query-with-db, assoc-row-with-db, query-cell-with-db and others
   * db/database_orm - DB.OBJ - a very simple ORM for DF.DB
+  * db/database_sqlite3 updated to version 1.2 (see its docs for what's new)
   * fixed Jeff's JSON.lsp plugin (switched to " instead of ' for strings)
-  * fixed handling of floats in Sqlite3 on some architectures (more improvements needed though, see TODO)
   * fixed bug in definition of define-smacro
 Version 0.6

File example-site/dragonfly-framework/plugins-inactive/db/database_sqlite3.lsp

 ;; @module Sqlite3
 ;; @description SQLite3 subclass of DF.DB. Only lists Sqlite3 specific functions.
-;; @version 1.1.3
+;; @version 1.2
 ;; @author Greg Slepak 
 ;; @location
 ;; <h3>Features not found in newLISP's sqlite3.lsp:</h3>
 ;; <li>Multiple active SQL statements</li>
 ;; <li>Supports reuse of SQL statements through parameter rebinding</li>
 ;; <li>Supports BLOB data-type as per 'DF.DB' and 'DF.BLOB' specification</li>
+;; <li>Supports 'true' by converting it to value 1 (as integer)</li>
 ;; <li>Conforms to generic 'DF.DB' interface</li>
 ;; <li>Grabs integers directly through 64-bit function</li>
 ;; <li>Can go through results row-by-row</li>
 ;; <h3>Requirements</h3>
 ;; See module @link DF.DB for requirements.
 ;; <h3>Version history</h3>
-;; <b>1.1.3</b> &bull; temporary fix for handling of floats, now import sqlite3 functions globally
+;; <b>1.2.0</b> &bull; temporary fix for handling of floats, sqlite3 functions globally for speed, binding 'true' is handled as 1
 ;; <b>1.1.2</b> &bull; fixed a bug in 'get-string-cast' and implemented 'DF.SQL:col-name'
 ;; <b>1.1.1</b> &bull; improved readability in error logging, fixed binding of integers on 32-bit newlisp builds<br/>
 ;; <b>1.1.0</b> &bull; support for 'DF.BLOB'<br/>
 		((nil? value) (failable (sqlite3_bind_null stmt idx)))
 		; DF.BLOB is the vehicle for using 'sqlite3_bind_blob' instead of 'sqlite3_bind_text'
 		((context? value) (failable (sqlite3_bind_blob stmt idx value:blob (length value:blob) -1)))
+		((true? value) (bind-param-at-index stmt 1 idx))
 		(true (throw-error "can't bind; unhandled type for value: " value))