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 [download:sqlconstantsplugin 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 15:17:02

Initial checkin - mostly working.

4676 by optilude on 2008-10-30 15:15:30

Make trunk

4675 by optilude on 2008-10-30 15:14:49

New hack SqlConstantsPlugin, created by optilude

(more)

Author/Contributors

Author: optilude
Contributors: