[Mydatabasepilot-cvs] Docs DatabaseProcess.html,NONE,1.1

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

Update of /cvsroot/mydatabasepilot/Docs
In directory sc8-pr-cvs1:/tmp/cvs-serv7485

Added Files:
	DatabaseProcess.html 
Log Message:
New Document Added: DatabaseProcess.html

--- NEW FILE: DatabaseProcess.html ---
<?xml version="1.0" encoding="iso-8859-1"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>MyDatabase Pilot Docs - ALGORITHM ANALYSIS - Database Process</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
</head>
<body>
<div style="font-size: 24px;font-weight: bold;color: #003399; background-color: #FFFFCC; text-align: center; margin: 3px 0px;">ALGORITHM ANALYSIS<br>Database Process</div>
<p style="text-align: justify;">MyDatabase Pilot is an application which allows for easy navigation and interaction with the structure of a database. Most of the functionality of MyDatabase Pilot requires the same 3 step frame work. First the user requests an action, this in turn requires a call to a database through a datasource, which is then translated into an output in the client browser. This common frame work will be used to tie together the various functionalities for MyDatabase Pilot as a single coherent application. The file MyDatabasePilot.cfm will act as the common frame work gateway which will execute the various requested database processes.</p>

<div style="font-size: 18px; font-weight: bold; color: #003399; margin: 3px 0px;">Step One of Common Framework - User Request</div>
<p style="text-align: justify;">Every call to MyDatabasePilot.cfm will require the input of the type of function to perform. This input is the equivalent of a user request, or what does the user want to do? The user requests will be passed to MyDatabasePilot.cfm in either a URL or FORM variable, depending on where the MyDatabasePilot.cfm was called from. This input variable will be called dbProcess - which stands for database process.</p>
<p style="text-align: justify;">dbProcess can have one and only one of the following valid values:</p>
<ul>
	<li><span style="font-weight: bold; color: #003399;">ShowTables</span> - User requested a list of tables in current database;</li>
	<li><span style="font-weight: bold; color: #003399;">ShowFields</span> - User requested a to see Sturcture of a particular table;</li>
	<li><span style="font-weight: bold; color: #003399;">ShowRecords</span> - User requested to see the Records of a particular table;</li>
	<li><span style="font-weight: bold; color: #003399;">AddField</span> - User requested to a field to a particular table;</li>
	<li><span style="font-weight: bold; color: #003399;">AlterField</span> - User requested to change a particular field;</li>
	<li><span style="font-weight: bold; color: #003399;">DropField</span> - User requested to delete a particular field;</li>
	<li><span style="font-weight: bold; color: #003399;">CreateTable</span> - User requested to create a new table;</li>
	<li><span style="font-weight: bold; color: #003399;">AlterTable</span> - User requested to change a particular table;</li>
	<li><span style="font-weight: bold; color: #003399;">RenameTable</span> - User requested to rename a particular table;</li>
	<li><span style="font-weight: bold; color: #003399;">DropTable</span> - User requested to delete a particular table;</li>
	<li><span style="font-weight: bold; color: #003399;">Select</span> - User requested to execute a SELECT statement;</li>
	<li><span style="font-weight: bold; color: #003399;">Insert</span> - User requested to execute an INSERT statement;</li>
	<li><span style="font-weight: bold; color: #003399;">Update</span> - User requested to execute an UPDATE statement;</li>
	<li><span style="font-weight: bold; color: #003399;">Delete</span> - User requested to execute a DELETE statement;</li>
</ul>

<div style="font-size: 18px; font-weight: bold; color: #003399; margin: 3px 0px;">Step Two of Common Framework - Database Command or Query</div>
<p style="text-align: justify;">Once a dbProcess has been provided to MyDatabasePilot.cfm, the necessary query(s) can be executed. Use a CFSwitch tag to find out which dbProcess was requested. Execute the needed queries for the requested dbProcess case. Use include files for query calls. Store the queries in the Query directory.</p>

<div style="font-size: 18px; font-weight: bold; color: #003399; margin: 3px 0px;">Step Three of Common Framework - Output the Result of User Request</div>
<p style="text-align: justify;">Use the same CFSwitch structure as used for the queries, to find out which dbProcess was requested. Print the needed output for the requested dbProcess case. If no dbProcess was provided, use the defaultcase to throw an error. Use include files for each of dbProcess cases. The input files will be stored in the dbProcessBody directory. Each dbProcess will have it's own file named exactly as the dbProcess. For example the ShowTables dbProcess will have an output file of dbProcessBody/ShowTables.cfm.</p>
</body>
</html>