NAME

sql_init - setup mysql tables for Finance::Shares web interface

SYNOPSIS

Arguments

    users=;
    sessions=;
    all=;
    layouts=;
    prompts=;
    tables=;
    q=<table_name>;...

Or

    help=;
    list=;

This CGI interface requires a number of arguments, given to the url in the usual way. For example

    http://willmot.org.uk/cgi-bin/init.pl?list=

DESCRIPTION

The command line options are:

database

The mysql database to update. (Default: 'willmot_org_uk')

user

The mysql user to log in as. (Default: 'willmot')

password

The password given when logging on to mysql. (Default: 'typg2KC')

newusers

Create a new table holding users details. Caution: all existing users' details will be lost! As the sessions table depends on this, it is also (re)created.

sessions

Create a new table holding login session details. The user information is not touched, but all currently open sessions will be closed.

list

Print a list of all the known table names.

all

A shorter way of typing all the table names.

layouts

(Re)create the layout data for the named tables.

prompts

(Re)create the help data for the named tables.

tables

(Re)create the user data for the named tables. Caution: Using this command deletes all user settings for the named tables.

mappings

(Re)create the mapping of user choices as collected to option hashes for the relevant object constructors.

help

Print a brief summary of the command line options.

man

Print this file.

help, man or list are safe in that no tables can be changed when these options are given.

For any changes to the main tables to occur, either all or a list of named tables must be given along with one or more of mysql, prompt or layout. The command to create all tables from scratch is therefore:

    shares_init --newusers --all --table --prompt --layout

Or after a minor change in the help text associated with the Models and Test tables, the following command could be given, without harming any user data:

    shares_init --prompt Model Test
    

BUGS

Please report those you find to the author.

AUTHOR

Chris Willmot, chris@willmot.org.uk

SEE ALSO

See also DBIx::Namespace