| 1 | == awful-sql-de-lite |
|---|
| 2 | |
|---|
| 3 | [[toc:]] |
|---|
| 4 | |
|---|
| 5 | === Description |
|---|
| 6 | |
|---|
| 7 | Sqlite3 support for [[/eggref/4/awful|awful]]. |
|---|
| 8 | |
|---|
| 9 | This extension provides the {{enable-db}} and |
|---|
| 10 | {{switch-to-sql-de-lite-database}} procedures which add Sqlite3 |
|---|
| 11 | support for awful, based on the features provided by the |
|---|
| 12 | [[/eggref/4/sql-de-lite|sql-de-lite egg]]. |
|---|
| 13 | |
|---|
| 14 | === Author |
|---|
| 15 | |
|---|
| 16 | [[/users/mario-domenech-goulart|Mario Domenech Goulart]] |
|---|
| 17 | |
|---|
| 18 | |
|---|
| 19 | === Repository |
|---|
| 20 | |
|---|
| 21 | [[https://github.com/mario-goulart/awful-sql-de-lite|https://github.com/mario-goulart/awful-sql-de-lite]] |
|---|
| 22 | |
|---|
| 23 | |
|---|
| 24 | === Requirements |
|---|
| 25 | |
|---|
| 26 | * [[/eggref/4/awful|awful]] |
|---|
| 27 | * [[/eggref/4/sql-de-lite|sql-de-lite]] |
|---|
| 28 | |
|---|
| 29 | |
|---|
| 30 | === Procedures |
|---|
| 31 | |
|---|
| 32 | ==== {{enable-db}} |
|---|
| 33 | <procedure>(enable-db)</procedure> |
|---|
| 34 | |
|---|
| 35 | Enable Sqlite3 support for [[/eggref/4/awful|awful]]. This procedure basically sets up awful to use the connection, disconnection, query and query escaping procedures for Sqlite3 databases. |
|---|
| 36 | |
|---|
| 37 | |
|---|
| 38 | ==== {{switch-to-sql-de-lite-database}} |
|---|
| 39 | <procedure>(switch-to-sql-de-lite-database)</procedure> |
|---|
| 40 | |
|---|
| 41 | Resets all the awful db-related parameters to sql-de-lite values (for |
|---|
| 42 | when using multiple databases under the same awful server). |
|---|
| 43 | |
|---|
| 44 | |
|---|
| 45 | See also the |
|---|
| 46 | [[/eggref/4/awful-sqlite3|awful-sqlite3]] egg |
|---|
| 47 | for Sqlite3 support using the |
|---|
| 48 | [[/eggref/4/sqlite3|sqlite3]] egg. |
|---|
| 49 | |
|---|
| 50 | |
|---|
| 51 | === License |
|---|
| 52 | |
|---|
| 53 | Copyright (c) 2008-2018, Mario Domenech Goulart |
|---|
| 54 | All rights reserved. |
|---|
| 55 | |
|---|
| 56 | Redistribution and use in source and binary forms, with or without |
|---|
| 57 | modification, are permitted provided that the following conditions are |
|---|
| 58 | met: |
|---|
| 59 | |
|---|
| 60 | Redistributions of source code must retain the above copyright |
|---|
| 61 | notice, this list of conditions and the following disclaimer. |
|---|
| 62 | |
|---|
| 63 | Redistributions in binary form must reproduce the above copyright |
|---|
| 64 | notice, this list of conditions and the following disclaimer in the |
|---|
| 65 | documentation and/or other materials provided with the distribution. |
|---|
| 66 | |
|---|
| 67 | Neither the name of the author nor the names of its contributors may |
|---|
| 68 | be used to endorse or promote products derived from this software |
|---|
| 69 | without specific prior written permission. |
|---|
| 70 | |
|---|
| 71 | THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS |
|---|
| 72 | "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT |
|---|
| 73 | LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS |
|---|
| 74 | FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE |
|---|
| 75 | COPYRIGHT HOLDERS OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, |
|---|
| 76 | INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES |
|---|
| 77 | (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR |
|---|
| 78 | SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) |
|---|
| 79 | HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, |
|---|
| 80 | STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) |
|---|
| 81 | ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED |
|---|
| 82 | OF THE POSSIBILITY OF SUCH DAMAGE. |
|---|
| 83 | |
|---|
| 84 | |
|---|
| 85 | |
|---|
| 86 | === Version history |
|---|
| 87 | |
|---|
| 88 | ===== version 0.7.0 |
|---|
| 89 | * Remove {{sql-quoter}} (deprecated in version 0.5) |
|---|
| 90 | * Drop dependency on regex |
|---|
| 91 | |
|---|
| 92 | ===== version 0.6.0 |
|---|
| 93 | * SSQL support |
|---|
| 94 | |
|---|
| 95 | ===== version 0.5 |
|---|
| 96 | * Deprecate {{sql-quoter}} |
|---|
| 97 | * Bug fix: actually use the {{default}} keyword parameter for {{(db-inquirer)}} |
|---|
| 98 | |
|---|
| 99 | ===== version 0.4 |
|---|
| 100 | * Added {{switch-to-sql-de-lite-database}} procedure |
|---|
| 101 | |
|---|
| 102 | ===== version 0.3 |
|---|
| 103 | * {{db-inquirer}} supports the {{values}} keyword parameter (patch by Stephen Eilert) |
|---|
| 104 | |
|---|
| 105 | ===== version 0.2 |
|---|
| 106 | * Fix for {{sql-quoter}} (reflects on awful's {{sql-quote}}) |
|---|
| 107 | |
|---|
| 108 | ===== version 0.1 |
|---|
| 109 | * Initial release |
|---|
