wiki:SqlConstantsPlugin

Version 1 (modified by optilude, 8 years ago) (diff)

New hack SqlConstantsPlugin, created by optilude

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 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
(more)

Author/Contributors

Author: optilude
Contributors: