Wiki
Download
Manual
Eggs
API
Tests
Bugs
show
edit
history
You can edit this page using
wiki syntax
for markup.
Article contents:
== awful-postgresql [[toc:]] === Description Postgresql support for [[/eggref/5/awful|awful]]. This extension provides the {{enable-db}} and {{switch-to-postgresql-database}} procedures which add Postgresql support for awful, based on the features provided by the [[/eggref/5/postgresql|postgresql egg]]. === Author [[/users/mario-domenech-goulart|Mario Domenech Goulart]] === Repository [[https://github.com/mario-goulart/awful-postgresql|https://github.com/mario-goulart/awful-postgresql]] === Requirements * [[/eggref/5/awful|awful]] * [[/eggref/5/postgresql|postgresql]] === Procedures ==== {{enable-db}} <procedure>(enable-db)</procedure> Enable Postgresql support for [[/eggref/5/awful|awful]]. This procedure basically sets up awful to use the connection, disconnection, query and query escaping procedures for Postgresql databases. ==== {{switch-to-postgresql-database}} <procedure>(switch-to-postgresql-database)</procedure> Resets all the awful db-related parameters to postgresql values (for when using multiple databases under the same awful server). === Parameters ==== {{db-result-processor}} This parameter yields a one-argument procedure (the argument is the object representing the results as returned by the postgresql bindings). The default value is: <enscript highlight=scheme> (lambda (result) (row-map identity result)) </enscript> This parameter has been added in version 0.5. === License Copyright (c) 2008-2018, Mario Domenech Goulart All rights reserved. Redistribution and use in source and binary forms, with or without modification, are permitted provided that the following conditions are met: Redistributions of source code must retain the above copyright notice, this list of conditions and the following disclaimer. Redistributions in binary form must reproduce the above copyright notice, this list of conditions and the following disclaimer in the documentation and/or other materials provided with the distribution. Neither the name of the author nor the names of its contributors may be used to endorse or promote products derived from this software without specific prior written permission. THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDERS OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. === Version history ===== version 0.7.0 * CHICKEN 5 support * Remove implementation of {{sql-quoter}} (deprecated in version 0.5) ===== version 0.6.0 * SSQL support * The default value for {{(db-inquirer)}}'s {{default}} keyword parameter is now {{'()}}. '''Warning''': this change may break your code! In case of an empty result set from a query, {{(db-inquirer)}} will now return {{'()}} instead of {{#f}}. This change can be specially harmful in case you have something like <enscript highlight=scheme> (or ($db "some query") "something") </enscript> In this example, if the query returns an empty result set, that expression would produce: * in older awful-postgresql versions: {{"something"}} * in awful-postgresql versions with this change: {{'()}} ===== version 0.5.1 * Fix application of {{db-result-processor}} (patch by Hugo Arregui) ===== version 0.5 * Added {{db-result-processor}} parameter (patch by Hugo Arregui) * Deprecated {{sql-quoter}} parameter ===== version 0.4 * Added {{switch-to-postgresql-database}} procedure ===== version 0.3 * {{db-inquirer}} supports the {{values}} keyword parameter (patch by Stephen Eilert) ===== version 0.2 * fix for {{sql-quoter}} (reflects on awful's {{sql-quote}}) ===== version 0.1 * Initial release
Description of your changes:
I would like to authenticate
Authentication
Username:
Password:
Spam control
What do you get when you subtract 11 from 17?