Changes between Initial Version and Version 1 of SqlConstantsPlugin


Ignore:
Timestamp:
Oct 30, 2008, 4:14:51 PM (6 years ago)
Author:
optilude
Comment:

New hack SqlConstantsPlugin, created by optilude

Legend:

Unmodified
Added
Removed
Modified
  • SqlConstantsPlugin

    v1 v1  
     1= SQL Constants =
     2
     3== Description ==
     4
     5This plugin adds a new administration control panel that can be used to manage constants (key/value pairs) stored in the database. These can then be used in report queries.
     6
     7== Bugs/Feature Requests ==
     8
     9Existing bugs and feature requests for SqlConstantsPlugin are
     10[report:9?COMPONENT=SqlConstantsPlugin here].
     11
     12If you have any issues, create a
     13[http://trac-hacks.org/newticket?component=SqlConstantsPlugin&owner=optilude new ticket].
     14
     15== Download ==
     16
     17Download the zipped source from [download:sqlconstantsplugin here].
     18
     19== Source ==
     20
     21You can check out SqlConstantsPlugin from [http://trac-hacks.org/svn/sqlconstantsplugin here] using Subversion, or [source:sqlconstantsplugin browse the source] with Trac.
     22
     23== Example ==
     24
     25Simply install the plugin as normal, and add a table like this to the database:
     26
     27{{{
     28        CREATE TABLE `constants` (
     29          `constant` varchar(255) NOT NULL,
     30          `stringval` varchar(255) DEFAULT NULL,
     31          `intval` int(11) DEFAULT NULL,
     32          `floatval` float DEFAULT NULL,
     33          PRIMARY KEY (`constant`)
     34        );
     35}}}
     36
     37You can then use this in report queries. The stringval column will always be stored. intval and floatval will contain the int/float equivalent if possible (i.e. the input could be cast to an int).
     38
     39Visit the administration panel to update constants.
     40
     41== Recent Changes ==
     42
     43[[ChangeLog(sqlconstantsplugin, 3)]]
     44
     45== Author/Contributors ==
     46
     47'''Author:''' [wiki:optilude] [[BR]]
     48'''Contributors:'''