wiki:SqlConstantsPlugin

SQL Constants

Description

This 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.

Bugs/Feature Requests

Existing bugs and feature requests for SqlConstantsPlugin are here.

If you have any issues, create a new ticket.

Download

Download the zipped source from here.

Source

You can check out SqlConstantsPlugin from here using Subversion, or browse the source with Trac.

Example

Simply install the plugin as normal, and add a table like this to the database:

	CREATE TABLE `constants` (
	  `constant` varchar(255) NOT NULL,
	  `stringval` varchar(255) DEFAULT NULL,
	  `intval` int(11) DEFAULT NULL,
	  `floatval` float DEFAULT NULL,
	  PRIMARY KEY (`constant`)
	);

You 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).

Visit the administration panel to update constants.

Recent Changes

[4677] by optilude on 2008-10-30 16:17:02
Initial checkin - mostly working.
[4676] by optilude on 2008-10-30 16:15:30
Make trunk
[4675] by optilude on 2008-10-30 16:14:49
New hack SqlConstantsPlugin, created by optilude

Author/Contributors

Author: optilude
Contributors:

Last modified 6 years ago Last modified on Oct 30, 2008 4:14:51 PM