wiki:SqlConstantsPlugin

Maintain list of static data as key-value pairs

Description

This plugin can be used to manage constants (key/value pairs) stored in the database, which can then be used in report queries. It adds a new administration control panel from which the key/value pairs can be maintained.

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

Source

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

Installation

General instructions on installing Trac plugins can be found on the TracPlugins page.

Configuration

When the plugin is installed, 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:

Last modified 7 years ago Last modified on Nov 24, 2016, 6:52:05 PM