Maintain list of static data as key-value pairs in SQL

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.

enhancement	0 / 1

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

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. Also, intval and floatval will contain the int/float equivalent if possible, ie 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
Maintainer: Martin Aspeli
Contributors: