Relapse's Cupboard - Code Templater

Home
> Code
> Code Templater

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'localhost' (using password: NO) in /home2/relapse/public_html/adodb/drivers/adodb-mysql.inc.php on line 358

What's this?

The code templater is a method of fast-generating a PHP application framework based on its database design. Each table is given its own include file for a single entity and a list of entities (that's two files per table), and a PHP each for editing an object and listing all objects of a single table. Many:many join tables are made select boxes for tables to fight over.

The key to all this is the database design. This is based of an XHTML - using the ADODB data format so the design is easilly imported into any database.

Debugging: Parser

users

IDN	c	10	Key	Nullable
NAME	c	255	Not Key	Nullable
EMAIL	c	255	Not Key	Nullable
CREATED	t		Not Key	Not Null

user_roles

IDN	c	10		Key	Nullable
ROLE	c	10		Key	Nullable

roles

ROLE	c	20	Key	Nullable
ROLE_FULL	c	255	Not Key	Not Null
DESCRIPTION	X	4000	Not Key	Nullable

tblAudit

UID	c	10	Key	Nullable
SYSDATE	t		Key	Nullable		Default:now
ACTIONID	i4		Key	Nullable	Auto-incremented
ACTION	c	255	Not Key	Not Null
PAGE	c	255	Not Key	Not Null

site_reports

RID	i4		Key	Nullable	Auto-incremented
EFFECTIVE_DATE	T		Key	Nullable
OWNER_UID	c	10	Not Key	Not Null
SID	i4		Not Key	Not Null
COMMAND	X	4000	Not Key	Not Null
SITE_FILTER	X	4000	Not Key	Nullable
LID	i4		Not Key	Not Null
COMMENT	X	4000	Not Key	Nullable
CREATED	t		Not Key	Not Null
CATCHUP	l		Not Key	Nullable

schedule_reports

SCID	i4		Key	Nullable	Auto-incremented
EFFECTIVE_DATE	T		Key	Nullable
ACTIVE	L		Not Key	Nullable
RID	i4		Not Key	Not Null
YEAR	c	4	Not Key	Not Null		Default:*
MONTH	c	2	Not Key	Not Null		Default:*
DAY	c	2	Not Key	Not Null		Default:*
WEEKDAY	c	1	Not Key	Not Null		Default:*
HOUR	c	2	Not Key	Not Null		Default:*
MINUTE	c	2	Not Key	Not Null		Default:*
SECOND	c	2	Not Key	Not Null		Default:*
COMMENTS	XL		Not Key	Nullable
NOTIFY_OWNER_COMPLETE	l		Not Key	Nullable
NOTIFY_OTHER_COMPLETE	l		Not Key	Nullable
OTHER_EMAIL	X	2000	Not Key	Nullable
NOTIFY_OWNER_ERROR	l		Not Key	Nullable

report_logs

LID	i8	Key	Nullable	Auto-incremented
WHEN_RAN	t	Key	Nullable
SCID	i4	Not Key	Nullable
SUCCESS	l	Not Key	Not Null
SEVERITY	i2	Not Key	Nullable
OUTPUT	XL	Not Key	Nullable
AUTOMATIC	l	Not Key	Nullable

report_programs

RID	i4		Key	Nullable	Auto-incremented
NAME	c	255	Not Key	Not Null
COMMAND	x	4000	Not Key	Not Null
HELP_TEXT	x	4000	Not Key	Not Null

config

CONFIGID	i4		Key	Nullable	Auto-incremented
FIELD	c	255	Not Key	Not Null
VALUE=	x	2000	Not Key	Nullable

logfile_logs

LID	i8	Key	Nullable	Auto-incremented
WHEN_RAN	t	Key	Nullable
SCID	i4	Not Key	Nullable
SUCCESS	l	Not Key	Not Null
SEVERITY	i2	Not Key	Nullable
OUTPUT	XL	Not Key	Nullable
AUTOMATIC	l	Not Key	Nullable

logfile_locations

LID	i4		Key	Nullable	Auto-incremented
LOCAL_LOCATION	x	500	Not Key	Not Null
FOREIGN_LOCATION	x	500	Not Key	Not Null
FOREIGN_USER	x	500	Not Key	Not Null
MASK	x	500	Not Key	Not Null
COMMAND	x	500	Not Key	Not Null

catchups

CID	i4	Key	Nullable	Auto-incremented
STARTDATE	t	Not Key	Not Null
ENDDATE	t	Not Key	Not Null
RID	i4	Not Key	Not Null
REASON	XL	Not Key	Nullable

schedule_log_dl

SCID	i4		Key	Nullable	Auto-incremented
EFFECTIVE_DATE	T		Key	Nullable
ACTIVE	L		Not Key	Nullable
LID	i4		Not Key	Not Null
YEAR	c	4	Not Key	Not Null		Default:*
MONTH	c	2	Not Key	Not Null		Default:*
DAY	c	2	Not Key	Not Null		Default:*
WEEKDAY	c	1	Not Key	Not Null		Default:*
HOUR	c	2	Not Key	Not Null		Default:*
MINUTE	c	2	Not Key	Not Null		Default:*
SECOND	c	2	Not Key	Not Null		Default:*
COMMENTS	XL		Not Key	Nullable

sites

SID	i4	Key	Nullable	Auto-incremented
STORED_IN	i2	Not Key	Not Null
TABLE_KEY	i4	Not Key	Not Null
SUBSITES	L	Not Key	Not Null

config_man

CID	i4			Key	Nullable
CONFIG_ITEM_ID	i4			Not Key	Not Null

wsd

WID	i4		Key	Nullable
HOSTNAME	c	255	Not Key	Not Null
SITEPATH	c	255	Not Key	Not Null