LuaSQLite3

Check-in [7c2c1f829c]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Update wiki doc
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 7c2c1f829cc565cdca1e33335196196a4dc08881
User & Date: e 2015-01-05 20:16:09
Context
2015-01-05
21:24
Add load_extension. Fix PUSH_INT64 for Lua < 5.3. check-in: f3fe11aaa4 user: e tags: trunk
20:16
Update wiki doc check-in: 7c2c1f829c user: e tags: trunk
19:26
Fix issue: auto-gc of db with live statements check-in: b2441f7aa8 user: e tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to doc/lsqlite3.wiki.

    73     73   		<li><a href="#stmt_get_value">stmt:get_value</a></li>
    74     74   		<li><a href="#stmt_get_values">stmt:get_values</a></li>
    75     75   		<li><a href="#stmt_isopen">stmt:isopen</a></li>
    76     76   		<li><a href="#stmt_nrows">stmt:nrows</a></li>
    77     77   		<li><a href="#stmt_reset">stmt:reset</a></li>
    78     78   		<li><a href="#stmt_rows">stmt:rows</a></li>
    79     79   		<li><a href="#stmt_step">stmt:step</a></li>
    80         -		<li><a href="#stmt_urows">stmt:urows</a></li>
           80  +        <li><a href="#stmt_urows">stmt:urows</a></li>
           81  +        <li><a href="#stmt_last_insert_rowid">stmt:last_insert_rowid</a></li>
    81     82   	</ul>
    82     83   
    83     84   	<li><a href="#methods_for_callback_contexts">Methods for callback contexts</a></li>
    84     85   	<ul>
    85     86   
    86     87   		<li><a href="#context_aggregate_count">context:aggregate_count</a></li>
    87     88   		<li><a href="#context_get_aggregate_data">context:get_aggregate_data</a></li>
................................................................................
   105    106   <hr name="index" />
   106    107   </div>
   107    108   
   108    109   <p>
   109    110   </p>
   110    111   <hr />
   111    112   <h1><a name="name">NAME</a></h1>
   112         -<p><strong>LuaSQLite 3</strong> - a Lua 5.1 and Lua 5.2 wrapper for the SQLite3 library</p>
          113  +<p><strong>LuaSQLite 3</strong> - a Lua 5.1 to 5.3 wrapper for the SQLite3 library</p>
   113    114   <p>
   114    115   </p>
   115    116   <hr />
   116    117   <h1><a name="overview">OVERVIEW</a></h1>
   117    118   <p><strong>LuaSQLite 3</strong> is a thin wrapper around the public domain SQLite3
   118    119   database engine.</p>
   119    120   <p>The <code>lsqlite3</code> module supports the creation and manipulation of 
................................................................................
   154    155   <hr />
   155    156   <h1><a name="verification_tests">VERIFICATION TESTS</a></h1>
   156    157   <p>The distribution contains a <em>tests</em> directory with some units tests using 
   157    158   an enhanced version of Michael Roth's <code>lunit</code> called <code>lunitx</code>. Some of the 
   158    159   tests were also derived from Michael's <strong>lua-sqlite3</strong> module, and more unit tests 
   159    160   added by Doug Currie. Get <code>lunitx</code> using Luarocks.</p>
   160    161   <p>The distribution also contains some functional tests by Tiago.</p>
   161         -<p>This version of <code>lsqlite3</code> was tested with SQLite 3.7.16.1.</p>
          162  +<p>This version of <code>lsqlite3</code> was tested with SQLite 3.8.7.4.</p>
   162    163   <p>
   163    164   </p>
   164    165   <hr />
   165    166   <h1><a name="reference">REFERENCE</a></h1>
   166    167   <p>
   167    168   </p>
   168    169   <hr />
................................................................................
   609    610   methods.</p>
   610    611   <p>
   611    612   </p>
   612    613   <h2><a name="stmt_bind">stmt:bind</a></h2>
   613    614   <pre>
   614    615           stmt:bind(n[,value])</pre>
   615    616   <p>Binds value to statement parameter <code>n</code>. If the type of value is string 
   616         -or number, it is bound as text or double, respectively. If <code>value</code> is a
   617         -boolean or nil or missing, any previous binding is removed. The function
          617  +it is bound as text. If the type of value is number, then with Lua prior to 5.3 
          618  +it is bound as a double, with Lua 5.3 it is bound as an integer or double
          619  +depending on its subtype using <code>lua_isinteger</code>. If <code>value</code> is a
          620  +boolean then it is bound as 0 for <code>false</code> or 1 for <code>true</code>.
          621  +If <code>value</code> is nil or missing, any previous binding is removed. The function
   618    622   returns <code>sqlite3.OK</code> on success or else a numerical error code (see
   619    623   <a href="#numerical_error_and_result_codes">Numerical error and result codes</a>).</p>
   620    624   <p>
   621    625   </p>
   622    626   <h2><a name="stmt_bind_blob">stmt:bind_blob</a></h2>
   623    627   <pre>
   624    628           stmt:bind_blob(n,blob)</pre>
................................................................................
   847    851   <h2><a name="stmt_urows">stmt:urows</a></h2>
   848    852   <pre>
   849    853           stmt:urows()</pre>
   850    854   <p>Returns an function that iterates over the values of the result set of
   851    855   statement stmt. Each iteration returns the values for the current row.
   852    856   This is the prepared statement equivalent of <a href="#db_urows"><code>db:urows()</code></a>.</p>
   853    857   <p>
          858  +</p>
          859  +<h2><a name="stmt_last_insert_rowid">stmt:last_insert_rowid</a></h2>
          860  +<pre>
          861  +        stmt:last_insert_rowid()</pre>
          862  +<p>This function returns the rowid of the most recent INSERT into the
          863  +database corresponding to this statement. 
          864  +See <a href="#db_last_insert_rowid"><code>db:last_insert_rowid()</code></a>.</p>
          865  +<p>
   854    866   </p>
   855    867   <hr />
   856    868   <h1><a name="methods_for_callback_contexts">Methods for callback contexts</a></h1>
   857    869   <p>A callback context is available as a parameter inside the callback
   858    870   functions <a href="#db_create_aggregate"><code>db:create_aggregate()</code></a> and 
   859    871   <a href="#db_create_function"><code>db:create_function()</code></a>. It can be used
   860    872   to get further information about the state of a query.</p>
................................................................................
   961    973   </pre>
   962    974   <p>For details about their exact meaning please see the <strong>SQLite3
   963    975   documentation</strong> <a href="http://www.sqlite.org/">http://www.sqlite.org/</a>.</p>
   964    976   <p>
   965    977   </p>
   966    978   <hr />
   967    979   <h1><a name="version">VERSION</a></h1>
   968         -<p>This is <code>lsqlite3</code> version <code>fsl_9</code>, also known as &quot;devel-0.9&quot;.</p>
          980  +<p>This is <code>lsqlite3</code> version <code>fsl_9u</code>, also known as &quot;devel-0.9.2-1&quot;.</p>
   969    981   <p>
   970    982   </p>
   971    983   <hr />
   972    984   <h1><a name="credits">CREDITS</a></h1>
   973    985   <p><code>lsqlite3</code> was developed by Tiago Dionizio and Doug Currie with 
   974    986   contributions from Thomas Lauer and Michael Roth.</p>
   975    987   <p>This documentation is based on the &quot;(very) preliminary&quot; documents
................................................................................
   978    990   <p>
   979    991   </p>
   980    992   <hr />
   981    993   <h1><a name="license">LICENSE</a></h1>
   982    994   <pre>
   983    995       /************************************************************************
   984    996       * lsqlite3                                                              *
   985         -    * Copyright (C) 2002-2013 Tiago Dionizio, Doug Currie                   *
          997  +    * Copyright (C) 2002-2015 Tiago Dionizio, Doug Currie                   *
   986    998       * All rights reserved.                                                  *
   987    999       * Author    : Tiago Dionizio &lt;tiago.dionizio@ist.utl.pt&gt;                *
   988   1000       * Author    : Doug Currie &lt;doug.currie@alum.mit.edu&gt;                    *
   989   1001       * Library   : lsqlite3 - a SQLite 3 database binding for Lua 5          *
   990   1002       *                                                                       *
   991   1003       * Permission is hereby granted, free of charge, to any person obtaining *
   992   1004       * a copy of this software and associated documentation files (the       *