mydatabasepilot-cvs Mailing List for MyDatabase Pilot (Page 6)
Status: Alpha
Brought to you by:
nanoface
Menu
▾
▴
mydatabasepilot-cvs — CVS Commit Log
You can subscribe to this list here.
| 2003 |
Jan
|
Feb
|
Mar
(3) |
Apr
(40) |
May
(50) |
Jun
(61) |
Jul
(10) |
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|---|
|
From: <nan...@us...> - 2003-04-25 22:18:37
|
Update of /cvsroot/mydatabasepilot/Docs In directory sc8-pr-cvs1:/tmp/cvs-serv7132 Added Files: dbProcess-ShowFields.html Log Message: Added New Document: [Task #76520] add dbProcess - ShowFields --- NEW FILE: dbProcess-ShowFields.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 - ShowFields</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 - ShowFields</div> <p style="text-align: justify;">The structure of a particular table is viewable with the ShowFields dbProcess. This database process is available from the output of the ShowTables dbProcess. The ShowTables dbProcess generates a list of tables, each of which has an associated hyper link labelled "View Structure". Clicking on this link will generate a list of fields, with their properties, using the ShowFields dbProcess.</p> <div style="font-size: 18px; font-weight: bold; color: #003399; margin: 3px 0px;">Input</div> <p style="text-align: justify;">The session variables "dataSource", "username", and "password" are either configured in the Application.cfm file, or are provided by the user when filling out the "login to MyDatabase" form. These session variables are used by the required queries to connect to the database.</p> <p style="text-align: justify;">The URL variable "table" is passed to the ShowFields dbProcess when clicking the hyper link "View Structure" on the ShowTables dbProcess page.</p> <table width="100%" border="1" cellspacing="2" cellpadding="2"> <tr><th>Var Name</th><th>Scope</th><th>Type</th><th>Description</th></tr> <tr><td>dataSource</td><td>Session</td><td>String</td><td>Connection variable for current datasource</td></tr> <tr><td>userName</td><td>Session</td><td>String</td><td>Connection variable for current user name</td></tr> <tr><td>password</td><td>Session</td><td>String</td><td>Connection variable for current password</td></tr> <tr><td>table</td><td>URL</td><td>String</td><td>Name of the table for which user has requested the ShowFields dbProcess</td></tr> </table> <div style="font-size: 18px; font-weight: bold; color: #003399; margin: 3px 0px;">Query</div> <p style="text-align: justify;">The query component of the ShowTables dbProcess will be handled by the fieldList query in the Query/fieldList.cfm file.</p> <p style="text-align: justify;">See the fieldList query document for more details.</p> <div style="font-size: 18px; font-weight: bold; color: #003399; margin: 3px 0px;">Output</div> <p style="text-align: justify;">The output component of the ShowTables dbProcess will be handled by the include file dbProcessBody/ShowFields.cfm.</p> <p style="text-align: justify;">The table name will be displayed followed by a listing of fields within that table along with their properties. The field listing will include the field name, key, data type, null value allowed, default value, and extra properties.</p> <table width="100%" border="1" cellspacing="2" cellpadding="2"> <tr><th>Var Name</th> <th>Scope</th> <th>Type</th> <th>Description</th></tr> <tr><td>table</td> <td>URL</td> <td>String</td> <td>Name of the table for which user has requsted the ShowFields dbProcess</td></tr> <tr><td>fieldList.FIELD</td> <td>Query</td> <td>String</td> <td>Field Name</td></tr> <tr><td>fieldList.KEY</td> <td>Query</td> <td>String</td> <td>Primary key or any other key designation for field</td></tr> <tr><td>fieldList.TYPE</td> <td>Query</td> <td>String</td> <td>Data type of field</td></tr> <tr><td>fieldList.NULL</td> <td>Query</td> <td>String</td> <td>Are null values allowed in field</td></tr> <tr><td>fieldList.DEFAULT</td> <td>Query</td> <td>String</td> <td>Default value of field</td></tr> <tr><td>fieldList.EXTRA</td> <td>Query</td> <td>String</td> <td>Extra properties such as auto_ increment associated with field</td></tr> </table> </body> </html> |
|
From: <nan...@us...> - 2003-04-24 03:18:17
|
Update of /cvsroot/mydatabasepilot/MyDatabasePilot
In directory sc8-pr-cvs1:/tmp/cvs-serv11264
Modified Files:
Application.cfm
Log Message:
Removed Chunk of commented out code which is no longer required
Index: Application.cfm
===================================================================
RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/Application.cfm,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -d -r1.5 -r1.6
*** Application.cfm 24 Apr 2003 03:07:09 -0000 1.5
--- Application.cfm 24 Apr 2003 03:18:13 -0000 1.6
***************
*** 71,86 ****
</cfif>
</cfif>
- <!--- If requestLogIn does not exist, then set it to FALSE
- <cfif NOT IsDefined("session.requestLogIn")><cfset session.requestLogIn = 0></cfif>
-
- <!---||| Ensure that session has not expired or a default data source is provided |||--->
- <!--- If datasource is Empty String, this would indicate that no default data source was provided --->
- <!--- If user is not loggedIn and no default datasource was provided, and login page was not yet requested ... --->
- <cfif session.dataSource IS "" AND session.loggedIn IS FALSE AND session.requestLogIn IS FALSE>
- <!--- Set the requestLogIn flag to True --->
- <cfset session.requestLogIn = "1"><!--- This line is needed so user is not sent on an endless redirect, since even the login form page calls the Application.cfm file --->
- <!--- Redirect User to login form --->
- <cflocation url="index.cfm">
- </cfif>--->
<!---||| Initialize dbName |||--->
--- 71,74 ----
|
|
From: <nan...@us...> - 2003-04-24 03:07:17
|
Update of /cvsroot/mydatabasepilot/MyDatabasePilot/Query/LockRequired In directory sc8-pr-cvs1:/tmp/cvs-serv7973/Query/LockRequired Added Files: thisDatabaseName.cfm Log Message: Internal Structure Changed: [ 725992 ] Create new session var dbName --- NEW FILE: thisDatabaseName.cfm --- <!---******************************************************************************************* * Copyright: MyDatabase Pilot is distributed under the terms of the GNU GPL license * * Template: Query/LockRequired/thisDatabaseName.cfm * * Purpose: Creates a Record Set with the name of the current database * * Requiremets: - Connection Variables must already be set * * - This Query Must be called from within a session lock to ensure the * * integrity of session variables * ********************************************************************************************---> <!---||| Create a Record Set with the name of the current database |||---> <cfquery name="thisDatabaseName" datasource="#session.dataSource#" username="#session.userName#" password="#session.password#"> SELECT DATABASE() AS databaseName; </cfquery> |
|
From: <nan...@us...> - 2003-04-24 03:07:16
|
Update of /cvsroot/mydatabasepilot/MyDatabasePilot
In directory sc8-pr-cvs1:/tmp/cvs-serv7973
Modified Files:
Application.cfm MyDatabasePilot.cfm
Log Message:
Internal Structure Changed:
[ 725992 ] Create new session var dbName
Index: Application.cfm
===================================================================
RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/Application.cfm,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -d -r1.4 -r1.5
*** Application.cfm 23 Apr 2003 03:45:44 -0000 1.4
--- Application.cfm 24 Apr 2003 03:07:09 -0000 1.5
***************
*** 6,18 ****
********************************************************************************************--->
! <!---||| Set application name and enable sesson variables and enable client variables in the form of cookies |||--->
<cfapplication name="MyDatabasePilot" clientmanagement="yes" sessionmanagement="yes" setclientcookies="yes" setdomaincookies="no" sessiontimeout="#CreateTimeSpan(0,0,15,0)#">
! <!---||| Used in Debugging |||--->
<!---<cfsetting showdebugoutput="No"> Specifies whether to show debugging output--->
<!---<cfsetting enablecfoutputonly="yes"> Disables output of text that is not included inside cfoutput tags--->
<!---<cfsetting requestTimeOut = "value in seconds"> You can use this setting to increase the page time-out if your application or page frequently accesses external resources that might be particularly slow--->
! <!---||| Set custom global error handling pages |||--->
<!--- This is on the ToDo list
<cferror type="exception" template="ErrorHandling/ExceptionErr.cfm">
--- 6,25 ----
********************************************************************************************--->
! <!---------------------------------------------------------->
! <!--- Set application name and enable sesson variables --->
! <!--- and enable client variables in the form of cookies --->
! <!---------------------------------------------------------->
<cfapplication name="MyDatabasePilot" clientmanagement="yes" sessionmanagement="yes" setclientcookies="yes" setdomaincookies="no" sessiontimeout="#CreateTimeSpan(0,0,15,0)#">
! <!------------------------->
! <!--- Used in Debugging --->
! <!------------------------->
<!---<cfsetting showdebugoutput="No"> Specifies whether to show debugging output--->
<!---<cfsetting enablecfoutputonly="yes"> Disables output of text that is not included inside cfoutput tags--->
<!---<cfsetting requestTimeOut = "value in seconds"> You can use this setting to increase the page time-out if your application or page frequently accesses external resources that might be particularly slow--->
! <!---------------------------------------------->
! <!--- Set custom global error handling pages --->
! <!---------------------------------------------->
<!--- This is on the ToDo list
<cferror type="exception" template="ErrorHandling/ExceptionErr.cfm">
***************
*** 22,60 ****
--->
! <!---||| Iniialize Client Variables |||--->
<!---Add Client Variables here if any--->
! <!---||| Initialize Session Variables |||--->
! <!--- Note for Server Clusters:
! Since Session Variables can not be used in server clusters except those that support sticky sessions,
! this section (and anything that is dependent on Session Variables) may need to be rewritten as Client
! Variables for server clusters (We will see how many users actually run server cluster before spending
! to much time on this.)--->
<!--- Lock code that uses session variables to ensure data integrity --->
<cflock timeout = "30" throwontimeout="no" type = "exclusive" scope = "session">
! <!--- Initialize variables used by queries to connect to the database --->
<cfif NOT IsDefined("session.dataSource")>
! <!--- If you choose to configure a default database, you must set these variables to an actual
! database that you have complete access to --->
<cfset session.dataSource = ""> <!--- Enter default Data Source --->
<cfset session.userName = ""> <!--- Enter default User Name --->
<cfset session.password = ""> <!--- Enter default password --->
</cfif>
- </cflock>
! <!---||| Ensure that session has not expired or a default data source is provided |||--->
! <!--- Lock code that uses session variables to ensure data integrity --->
! <cflock timeout = "30" throwontimeout="no" type = "exclusive" scope = "session">
<!--- If datasource is Empty String, this would indicate that no default data source was provided --->
! <!--- If user is not loggedIn and no default datasource exists, and login page was not yet requested --->
! <cfif session.dataSource IS "" AND NOT IsDefined("session.loggedIn") AND NOT IsDefined("session.requestLogIn")>
! <!--- This line is needed so user is not sent on an endless redirect, since even the login form page calls the Application.cfm file --->
! <cfset session.requestLogIn = "1">
! <!--- Redirect User to login form if no data source exists --->
<cflocation url="index.cfm">
</cfif>
</cflock>
! <!---||| Set Application-Wide Local scope variables |||--->
<cfset applicationName = "MyDatabase Pilot">
<cfset applicationVersion = "v0.7.0(Alpha)">
--- 29,100 ----
--->
! <!---------------------------------->
! <!--- Iniialize Client Variables --->
! <!---------------------------------->
<!---Add Client Variables here if any--->
! <!------------------------------------>
! <!--- Initialize Session Variables --->
! <!------------------------------------>
! <!--- NOTE FOR SERVER CLUSTERS:
! Since Session Variables can not be used in server clusters except those that support sticky sessions,
! this section (and anything that is dependent on Session Variables) may need to be rewritten as Client
! Variables for server clusters (We will see how many users actually run server cluster before spending
! to much time on this.)--->
<!--- Lock code that uses session variables to ensure data integrity --->
<cflock timeout = "30" throwontimeout="no" type = "exclusive" scope = "session">
! <!---||| Initialize connection variables used by queries to connect to the database |||--->
! <!--- If dataSource does not exist ... --->
<cfif NOT IsDefined("session.dataSource")>
! <!--- NOTE FOR DEFAULT DATABASE USERS:
! If you choose to configure a default database, you must set the dataSource, userName and password
! variables to an actual database that you have complete access to --->
! <!--- Initialize connection variables --->
<cfset session.dataSource = ""> <!--- Enter default Data Source --->
<cfset session.userName = ""> <!--- Enter default User Name --->
<cfset session.password = ""> <!--- Enter default password --->
</cfif>
! <!---||| Ensure User is Logged In and Session has not Expired |||--->
! <!--- If session is new or has expired ... --->
! <cfif NOT IsDefined("session.loggedIn")>
! <!--- Check if default dataSource was configured --->
! <!--- If dataSource is empty string ... --->
! <cfif session.dataSource IS "">
! <!--- this would indicate that no default data source was provided and user is not logged into any datasource --->
! <cfset session.loggedIn = 0>
! <!--- Redirect User to login form --->
! <cflocation url="index.cfm">
! <cfelse>
! <!--- Otherwise user is logged in using default datasource configuration --->
! <cfset session.loggedIn = 1>
! </cfif>
! </cfif>
! <!--- If requestLogIn does not exist, then set it to FALSE
! <cfif NOT IsDefined("session.requestLogIn")><cfset session.requestLogIn = 0></cfif>
!
! <!---||| Ensure that session has not expired or a default data source is provided |||--->
<!--- If datasource is Empty String, this would indicate that no default data source was provided --->
! <!--- If user is not loggedIn and no default datasource was provided, and login page was not yet requested ... --->
! <cfif session.dataSource IS "" AND session.loggedIn IS FALSE AND session.requestLogIn IS FALSE>
! <!--- Set the requestLogIn flag to True --->
! <cfset session.requestLogIn = "1"><!--- This line is needed so user is not sent on an endless redirect, since even the login form page calls the Application.cfm file --->
! <!--- Redirect User to login form --->
<cflocation url="index.cfm">
+ </cfif>--->
+
+ <!---||| Initialize dbName |||--->
+ <!--- If dbName does not exist, and user is logged in ... --->
+ <cfif NOT IsDefined("session.dbName") AND session.loggedIn IS TRUE>
+ <!--- Find out the Database Name by calling thisDatabaseName Query --->
+ <cfinclude template="Query/LockRequired/thisDatabaseName.cfm">
+ <!--- Set dbName Variable with result of thisDatabaseName Query --->
+ <cfset session.dbName = "#thisDatabaseName.databaseName#">
</cfif>
</cflock>
! <!-------------------------------------------------->
! <!--- Set Application-Wide Local scope variables --->
! <!-------------------------------------------------->
<cfset applicationName = "MyDatabase Pilot">
<cfset applicationVersion = "v0.7.0(Alpha)">
***************
*** 65,69 ****
<cfset currentPage = "#currentPath#?#currentQueryString#">
! <!---||| Include User-Defined Functions Used on Most Pages |||--->
<!--- A need for this has not yet been determined
<cfinclude template="Functions/SomeFunction.cfm">
--- 105,111 ----
<cfset currentPage = "#currentPath#?#currentQueryString#">
! <!--------------------------------------------------------->
! <!--- Include User-Defined Functions Used on Most Pages --->
! <!--------------------------------------------------------->
<!--- A need for this has not yet been determined
<cfinclude template="Functions/SomeFunction.cfm">
Index: MyDatabasePilot.cfm
===================================================================
RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/MyDatabasePilot.cfm,v
retrieving revision 1.6
retrieving revision 1.7
diff -C2 -d -r1.6 -r1.7
*** MyDatabasePilot.cfm 21 Apr 2003 22:31:51 -0000 1.6
--- MyDatabasePilot.cfm 24 Apr 2003 03:07:09 -0000 1.7
***************
*** 8,12 ****
********************************************************************************************--->
! <!---||| Set database connection variables if new one was passed to this template |||--->
<!--- Check to see if this template was called by FORM_LogintoDB with a new dataSource --->
<cfif IsDefined("Form.dataSource")>
--- 8,12 ----
********************************************************************************************--->
! <!---||| Reset session variables if new database was requested |||--->
<!--- Check to see if this template was called by FORM_LogintoDB with a new dataSource --->
<cfif IsDefined("Form.dataSource")>
***************
*** 19,31 ****
<cfset session.userName = #Trim(Form.userName)#> <!--- User Name --->
<cfset session.password = #Trim(Form.password)#> <!--- Password --->
! <cfset session.loggedIn = "1"> <!--- Set the loggedIn Flag to True --->
</cflock>
</cfif>
<!---||| Run Queries needed for body of Document based on the particular dbProcess Request |||--->
! <!--- Run dbGeneralInfo Query --->
! <cfinclude template="Query/dbGeneralInfo.cfm">
! <!--- Run any dbProcess specific Queries --->
! <cfswitch expression="#dbProcess#">
<cfcase value="ShowTables"><cfinclude template="Query/tableList.cfm"></cfcase>
<cfcase value="ShowFields"><cfinclude template="Query/fieldList.cfm"></cfcase>
--- 19,33 ----
<cfset session.userName = #Trim(Form.userName)#> <!--- User Name --->
<cfset session.password = #Trim(Form.password)#> <!--- Password --->
! <!--- Set the loggedIn Flag to True --->
! <cfset session.loggedIn = 1>
! <!--- Find out the Database Name and Overwrite dbName Variable --->
! <cfinclude template="Query/LockRequired/thisDatabaseName.cfm">
! <cfset session.dbName = "#thisDatabaseName.databaseName#">
</cflock>
</cfif>
<!---||| Run Queries needed for body of Document based on the particular dbProcess Request |||--->
! <!--- Which dbProcess was requested? --->
! <cfswitch expression="#dbProcess#">
<cfcase value="ShowTables"><cfinclude template="Query/tableList.cfm"></cfcase>
<cfcase value="ShowFields"><cfinclude template="Query/fieldList.cfm"></cfcase>
***************
*** 52,57 ****
<cfinclude template="Include/MainMenu.cfm">
<td valign="top">
! <h2>Current Database: <cfoutput query="dbGeneralInfo">#dbInUse#</cfoutput></h2>
! <!--- Execute Requested dbProcess --->
<cfswitch expression="#dbProcess#">
<cfcase value="ShowTables"><cfinclude template="dbProcessBody/ShowTables.cfm"></cfcase>
--- 54,64 ----
<cfinclude template="Include/MainMenu.cfm">
<td valign="top">
! <!---||| Show Current Database |||--->
! <!--- Initiate a readonly lock to ensure the integrity of session variables --->
! <cflock timeout = "30" throwontimeout="no" type = "readonly" scope = "session">
! <h2>Current Database: <cfoutput>#session.dbName#</cfoutput></h2>
! </cflock>
!
! <!---||| Output the Result of User Requested dbProcess |||--->
<cfswitch expression="#dbProcess#">
<cfcase value="ShowTables"><cfinclude template="dbProcessBody/ShowTables.cfm"></cfcase>
|
|
From: <nan...@us...> - 2003-04-24 03:07:16
|
Update of /cvsroot/mydatabasepilot/MyDatabasePilot/dbProcessBody
In directory sc8-pr-cvs1:/tmp/cvs-serv7973/dbProcessBody
Modified Files:
ShowTables.cfm
Log Message:
Internal Structure Changed:
[ 725992 ] Create new session var dbName
Index: ShowTables.cfm
===================================================================
RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/dbProcessBody/ShowTables.cfm,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -d -r1.4 -r1.5
*** ShowTables.cfm 13 Apr 2003 04:58:26 -0000 1.4
--- ShowTables.cfm 24 Apr 2003 03:07:10 -0000 1.5
***************
*** 4,11 ****
* Purpose: Displays the Body Content for the ShowTables Database Process *
* Requiremets: -tableList Query must be run on same page prior to including this template *
- * -dbGeneralInfo Query must be run on same page prior to including this *
- * template *
- * Todo: *
- * Known Issues/Bugs: *
********************************************************************************************--->
--- 4,7 ----
***************
*** 24,35 ****
where MyDatabase is the name of the database currently in use. Since this variable
name is not known until run time, we need a Dynamic Variable name called:
! TABLES_IN_#dbGeneralInfo.dbInUse#
--->
<!--- Show Table Name --->
! <td>#Evaluate("tableList.TABLES_IN_#dbGeneralInfo.dbInUse#")#</td>
<!--- Link to Show Table Fields and Properties --->
! <td><a href="#currentPath#?#session.URLToken#&dbProcess=ShowFields&table=#URLEncodedFormat(Evaluate("TABLES_IN_#dbGeneralInfo.dbInUse#"))#">View Structure</a></td>
<!--- Link to Show Records --->
! <td><a href="#currentPath#?#session.URLToken#&dbProcess=ShowRecords&table=#URLEncodedFormat(Evaluate("TABLES_IN_#dbGeneralInfo.dbInUse#"))#">View Records</a></td>
<!--- Link to Alter Table--->
<td>Alter Table</td>
--- 20,31 ----
where MyDatabase is the name of the database currently in use. Since this variable
name is not known until run time, we need a Dynamic Variable name called:
! TABLES_IN_#session.dbName#
--->
<!--- Show Table Name --->
! <td>#Evaluate("tableList.TABLES_IN_#session.dbName#")#</td>
<!--- Link to Show Table Fields and Properties --->
! <td><a href="#currentPath#?#session.URLToken#&dbProcess=ShowFields&table=#URLEncodedFormat(Evaluate("TABLES_IN_#session.dbName#"))#">View Structure</a></td>
<!--- Link to Show Records --->
! <td><a href="#currentPath#?#session.URLToken#&dbProcess=ShowRecords&table=#URLEncodedFormat(Evaluate("TABLES_IN_#session.dbName#"))#">View Records</a></td>
<!--- Link to Alter Table--->
<td>Alter Table</td>
|
|
From: <nan...@us...> - 2003-04-24 03:03:50
|
Update of /cvsroot/mydatabasepilot/MyDatabasePilot/Query/LockRequired In directory sc8-pr-cvs1:/tmp/cvs-serv7029/LockRequired Log Message: Directory /cvsroot/mydatabasepilot/MyDatabasePilot/Query/LockRequired added to the repository |
|
From: <nan...@us...> - 2003-04-23 03:45:50
|
Update of /cvsroot/mydatabasepilot/MyDatabasePilot
In directory sc8-pr-cvs1:/tmp/cvs-serv31172
Modified Files:
Application.cfm
Log Message:
Internal Structure Changed:
[ 726010 ] Remove Unnecessary cfif NOT IsDefined() Calls
Index: Application.cfm
===================================================================
RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/Application.cfm,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** Application.cfm 21 Apr 2003 22:31:51 -0000 1.3
--- Application.cfm 23 Apr 2003 03:45:44 -0000 1.4
***************
*** 34,41 ****
<cflock timeout = "30" throwontimeout="no" type = "exclusive" scope = "session">
<!--- Initialize variables used by queries to connect to the database --->
! <!--- You must set these variables to an actual database that you have complete access to --->
! <cfif NOT IsDefined("session.dataSource")><cfset session.dataSource = ""></cfif> <!---Enter default Data Source --->
! <cfif NOT IsDefined("session.userName")><cfset session.userName = ""></cfif> <!--- Enter default User Name --->
! <cfif NOT IsDefined("session.password")><cfset session.password = ""></cfif> <!--- Enter default password --->
</cflock>
--- 34,44 ----
<cflock timeout = "30" throwontimeout="no" type = "exclusive" scope = "session">
<!--- Initialize variables used by queries to connect to the database --->
! <cfif NOT IsDefined("session.dataSource")>
! <!--- If you choose to configure a default database, you must set these variables to an actual
! database that you have complete access to --->
! <cfset session.dataSource = ""> <!--- Enter default Data Source --->
! <cfset session.userName = ""> <!--- Enter default User Name --->
! <cfset session.password = ""> <!--- Enter default password --->
! </cfif>
</cflock>
|
|
From: <nan...@us...> - 2003-04-23 03:28:54
|
Update of /cvsroot/mydatabasepilot/MyDatabasePilot In directory sc8-pr-cvs1:/tmp/cvs-serv26008 Modified Files: index.cfm Log Message: Bug Fix: [ 726004 ] Default Database Link Broken Index: index.cfm =================================================================== RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/index.cfm,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** index.cfm 13 Apr 2003 03:06:35 -0000 1.2 --- index.cfm 23 Apr 2003 03:28:51 -0000 1.3 *************** *** 24,28 **** <tr> <td> ! <p class="Plain">You can either login to a database by completing the form below, or if you have configured the Application.cfm file for a default database, you can <a href="MyDatabasePilot.cfm">USE DEFAULT DATABASE</a>.</p> <!--- Initiate a Read Only lock to ensure the integrity of session variables ---> <cflock timeout = "30" throwontimeout="no" type = "readonly" scope = "session"> --- 24,28 ---- <tr> <td> ! <p class="Plain">You can either login to a database by completing the form below, or if you have configured the Application.cfm file for a default database, you can <a href="MyDatabasePilot.cfm?dbProcess=ShowTables">USE DEFAULT DATABASE</a>.</p> <!--- Initiate a Read Only lock to ensure the integrity of session variables ---> <cflock timeout = "30" throwontimeout="no" type = "readonly" scope = "session"> |
|
From: <nan...@us...> - 2003-04-23 01:58:35
|
Update of /cvsroot/mydatabasepilot/Docs In directory sc8-pr-cvs1:/tmp/cvs-serv27569 Modified Files: DatabaseProcess.html Log Message: Corrected a typo Index: DatabaseProcess.html =================================================================== RCS file: /cvsroot/mydatabasepilot/Docs/DatabaseProcess.html,v retrieving revision 1.3 retrieving revision 1.4 diff -C2 -d -r1.3 -r1.4 *** DatabaseProcess.html 23 Apr 2003 01:51:26 -0000 1.3 --- DatabaseProcess.html 23 Apr 2003 01:58:32 -0000 1.4 *************** *** 15,20 **** <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 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 add a new field to a particular table;</li> <li><span style="font-weight: bold; color: #003399;">AlterField</span> - User requested to change a particular field;</li> --- 15,20 ---- <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 to see the structure 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 add a new field to a particular table;</li> <li><span style="font-weight: bold; color: #003399;">AlterField</span> - User requested to change a particular field;</li> |
|
From: <nan...@us...> - 2003-04-23 01:51:30
|
Update of /cvsroot/mydatabasepilot/Docs In directory sc8-pr-cvs1:/tmp/cvs-serv25451 Modified Files: DatabaseProcess.html Log Message: Corrected a typo Index: DatabaseProcess.html =================================================================== RCS file: /cvsroot/mydatabasepilot/Docs/DatabaseProcess.html,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** DatabaseProcess.html 22 Apr 2003 04:43:15 -0000 1.2 --- DatabaseProcess.html 23 Apr 2003 01:51:26 -0000 1.3 *************** *** 15,19 **** <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 add a new field to a particular table;</li> --- 15,19 ---- <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 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 add a new field to a particular table;</li> |
|
From: <nan...@us...> - 2003-04-22 04:43:18
|
Update of /cvsroot/mydatabasepilot/Docs In directory sc8-pr-cvs1:/tmp/cvs-serv30125 Modified Files: DatabaseProcess.html Log Message: Corrected a typo Index: DatabaseProcess.html =================================================================== RCS file: /cvsroot/mydatabasepilot/Docs/DatabaseProcess.html,v retrieving revision 1.1 retrieving revision 1.2 diff -C2 -d -r1.1 -r1.2 *** DatabaseProcess.html 22 Apr 2003 02:02:10 -0000 1.1 --- DatabaseProcess.html 22 Apr 2003 04:43:15 -0000 1.2 *************** *** 17,21 **** <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> --- 17,21 ---- <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 add a new 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> |
|
From: <nan...@us...> - 2003-04-22 04:35:23
|
Update of /cvsroot/mydatabasepilot/Docs In directory sc8-pr-cvs1:/tmp/cvs-serv28197 Added Files: dbProcess-ShowTables.html Log Message: New Document Added: dbProcess-ShowTables.html --- NEW FILE: dbProcess-ShowTables.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 - ShowTables</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 - ShowTables</div> <p style="text-align: justify;">The listing of available tables in the currently connected database will be handled by the ShowTables dbProcess. This will be the default database process that will be executed after connecting to the datasource.</p> <div style="font-size: 18px; font-weight: bold; color: #003399; margin: 3px 0px;">Input</div> <p style="text-align: justify;">The following session variables are either configured in the Application.cfm file, or are provided by the user when filling out the "login to MyDatabase" form. These session variables are used by the required queries to connect to the database.</p> <table width="100%" border="1" cellspacing="2" cellpadding="2"> <tr><th>Var Name</th><th>Scope</th><th>Type</th><th>Description</th></tr> <tr><td>dataSource</td><td>Session</td><td>String</td><td>Connection variable for current datasource</td></tr> <tr><td>userName</td><td>Session</td><td>String</td><td>Connection variable for current user name</td></tr> <tr><td>password</td><td>Session</td><td>String</td><td>Connection variable for current password</td></tr> </table> <div style="font-size: 18px; font-weight: bold; color: #003399; margin: 3px 0px;">Query</div> <p style="text-align: justify;">The query component of the ShowTables dbProcess will be handled by the tableList query in the Query/tableList.cfm file.</p> <p style="text-align: justify;">See the ShowTables query document for more details.</p> <div style="font-size: 18px; font-weight: bold; color: #003399; margin: 3px 0px;">Internal Variables</div> <p style="text-align: justify;">The tableList query creates a recordset with the column name TABLES_IN_MyDatabase where MyDatabase is the name of the database currently in use. Since this variable name is not known until run time, we need a Dynamic Variable name called: TABLES_IN_#dbGeneralInfo.dbInUse#. (The dbGeneralInfo Query is available to all dbProcess, because it is created on the MyDatabasePilot.cfm page before dbProcess handling is initiated.)</p> <table width="100%" border="1" cellspacing="2" cellpadding="2"> <tr><th>Var Name</th><th>Scope</th><th>Type</th><th>Description</th></tr> <tr><td>TABLES_IN_#dbGeneralInfo.dbInUse#</td><td>Dynamic Local</td><td>String</td><td>used to access tableList recordset</td></tr> </table> <div style="font-size: 18px; font-weight: bold; color: #003399; margin: 3px 0px;">Output</div> <p style="text-align: justify;">The output component of the ShowTables dbProcess will be handled by the include file dbProcessBody/ShowTables.cfm.</p> <p style="text-align: justify;">A read-only lock will be necessary when accessing session variables needed for href links that pass the session.URLToken variable.</p> <p style="text-align: justify;">The table listing will include the table name, a link to show table fields and properties, a link to show records in the table, a link to alter the table, a link to drop the table. In addition a link will be provided to create a new table.</p> </body> </html> |
|
From: <nan...@us...> - 2003-04-22 02:02:14
|
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> |
|
From: <nan...@us...> - 2003-04-21 22:31:54
|
Update of /cvsroot/mydatabasepilot/MyDatabasePilot
In directory sc8-pr-cvs1:/tmp/cvs-serv30705
Modified Files:
Application.cfm MyDatabasePilot.cfm
Log Message:
Bug Fix:
[ 724471 ] Session Expiry Handling Required
Added session.loggedIn = "1" flag in MyDatabasePilot.cfm
Added Active Session Checking, and session.requestLogIn = "1" flag in Application.cfm file
Index: Application.cfm
===================================================================
RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/Application.cfm,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** Application.cfm 6 Apr 2003 05:48:19 -0000 1.2
--- Application.cfm 21 Apr 2003 22:31:51 -0000 1.3
***************
*** 2,9 ****
* Copyright: MyDatabase Pilot is distributed under the terms of the GNU GPL license *
* Template: Application.cfm *
! * Purpose: Creates Client variables for connecting to database *
! * Todo: Set up custom global error handling pages *
! * Include User-Defined Functions Used on Most Pages *
! * Known Issues/Bugs: *
********************************************************************************************--->
--- 2,7 ----
* Copyright: MyDatabase Pilot is distributed under the terms of the GNU GPL license *
* Template: Application.cfm *
! * Purpose: - Creates Client variables for connecting to database *
! * - Application wide variables, functions and errorhandling *
********************************************************************************************--->
***************
*** 40,43 ****
--- 38,54 ----
<cfif NOT IsDefined("session.userName")><cfset session.userName = ""></cfif> <!--- Enter default User Name --->
<cfif NOT IsDefined("session.password")><cfset session.password = ""></cfif> <!--- Enter default password --->
+ </cflock>
+
+ <!---||| Ensure that session has not expired or a default data source is provided |||--->
+ <!--- Lock code that uses session variables to ensure data integrity --->
+ <cflock timeout = "30" throwontimeout="no" type = "exclusive" scope = "session">
+ <!--- If datasource is Empty String, this would indicate that no default data source was provided --->
+ <!--- If user is not loggedIn and no default datasource exists, and login page was not yet requested --->
+ <cfif session.dataSource IS "" AND NOT IsDefined("session.loggedIn") AND NOT IsDefined("session.requestLogIn")>
+ <!--- This line is needed so user is not sent on an endless redirect, since even the login form page calls the Application.cfm file --->
+ <cfset session.requestLogIn = "1">
+ <!--- Redirect User to login form if no data source exists --->
+ <cflocation url="index.cfm">
+ </cfif>
</cflock>
Index: MyDatabasePilot.cfm
===================================================================
RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/MyDatabasePilot.cfm,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -d -r1.5 -r1.6
*** MyDatabasePilot.cfm 18 Apr 2003 04:39:20 -0000 1.5
--- MyDatabasePilot.cfm 21 Apr 2003 22:31:51 -0000 1.6
***************
*** 19,22 ****
--- 19,23 ----
<cfset session.userName = #Trim(Form.userName)#> <!--- User Name --->
<cfset session.password = #Trim(Form.password)#> <!--- Password --->
+ <cfset session.loggedIn = "1"> <!--- Set the loggedIn Flag to True --->
</cflock>
</cfif>
|
|
From: <nan...@us...> - 2003-04-18 04:39:23
|
Update of /cvsroot/mydatabasepilot/MyDatabasePilot In directory sc8-pr-cvs1:/tmp/cvs-serv2641 Modified Files: MyDatabasePilot.cfm Log Message: Functionality Added: [ 723492 ] Add Select Query to ShowRecords dbProcess Index: MyDatabasePilot.cfm =================================================================== RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/MyDatabasePilot.cfm,v retrieving revision 1.4 retrieving revision 1.5 diff -C2 -d -r1.4 -r1.5 *** MyDatabasePilot.cfm 13 Apr 2003 06:15:21 -0000 1.4 --- MyDatabasePilot.cfm 18 Apr 2003 04:39:20 -0000 1.5 *************** *** 29,33 **** <cfcase value="ShowTables"><cfinclude template="Query/tableList.cfm"></cfcase> <cfcase value="ShowFields"><cfinclude template="Query/fieldList.cfm"></cfcase> ! <cfcase value="ShowRecords"><cfinclude template="Query/fieldList.cfm"></cfcase> <cfcase value="CreateTable_Step1"></cfcase> <cfcase value="CreateTable_Step2"></cfcase> --- 29,37 ---- <cfcase value="ShowTables"><cfinclude template="Query/tableList.cfm"></cfcase> <cfcase value="ShowFields"><cfinclude template="Query/fieldList.cfm"></cfcase> ! <cfcase value="ShowRecords"> ! <cfinclude template="Query/fieldList.cfm"> ! <cfset queryName = "selectedData"> ! <cfinclude template="Query/SELECT.cfm"> ! </cfcase> <cfcase value="CreateTable_Step1"></cfcase> <cfcase value="CreateTable_Step2"></cfcase> |
|
From: <nan...@us...> - 2003-04-18 04:17:14
|
Update of /cvsroot/mydatabasepilot/MyDatabasePilot/dbProcessBody
In directory sc8-pr-cvs1:/tmp/cvs-serv24839
Modified Files:
ShowRecords.cfm
Log Message:
Functionality Added:
[ 723484 ] List Selected Data in ShowRecords dbProcess Body
Index: ShowRecords.cfm
===================================================================
RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/dbProcessBody/ShowRecords.cfm,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** ShowRecords.cfm 14 Apr 2003 02:34:27 -0000 1.2
--- ShowRecords.cfm 18 Apr 2003 04:17:11 -0000 1.3
***************
*** 6,14 ****
* -url.table (table name) must have been passed from calling template *
********************************************************************************************--->
!
! <!---||| Show Records in Current Table |||--->
! <!--- Show table name --->
Table Name:<cfoutput>#url.table#</cfoutput>
<table width="100%" border="1" cellspacing="0" cellpadding="2">
<tr>
<!--- Create List of Field Names --->
--- 6,17 ----
* -url.table (table name) must have been passed from calling template *
********************************************************************************************--->
! <!------------------------------------->
! <!--- Show Records in Current Table --->
! <!------------------------------------->
! <!---||| Show table name |||--->
Table Name:<cfoutput>#url.table#</cfoutput>
+
<table width="100%" border="1" cellspacing="0" cellpadding="2">
+ <!---||| Create Header |||--->
<tr>
<!--- Create List of Field Names --->
***************
*** 16,18 ****
--- 19,39 ----
<cfoutput query="fieldList"><td>#FIELD#</td></cfoutput>
</tr>
+
+ <!---||| List Selected Data by Looping through each record and field |||--->
+ <!--- Loop through records using Index Loop so we can reference the recordnumber in a dynamic variable --->
+ <cfloop from="1" to="#selectedData.RecordCount#" index="i">
+ <tr>
+ <td valign="top">Update/Delete Record</td>
+ <!--- Loop through fields --->
+ <cfloop query="fieldList">
+ <!--- Output the value of a dynamically created variable which references the current field of the current record --->
+ <!--- Use the Evaluate function to get the value of the Dynamic Variable --->
+ <!--- The Dynamic variable is queryName.columName[recordNumber] --->
+ <!--- Where queryName is "selectedData" --->
+ <!--- columName is the value of fieldList.FIELD --->
+ <!--- recordNumber is "i" --->
+ <td valign="top"><cfoutput>#Evaluate("selectedData." & fieldList.FIELD & "[i]")#</cfoutput></td>
+ </cfloop>
+ </tr>
+ </cfloop>
</table>
|
|
From: <nan...@us...> - 2003-04-18 04:01:44
|
Update of /cvsroot/mydatabasepilot/MyDatabasePilot/Query
In directory sc8-pr-cvs1:/tmp/cvs-serv17080
Added Files:
SELECT.cfm
Log Message:
Functionality Added:
[ 720893 ] Create totally dynamic Select Statement
--- NEW FILE: SELECT.cfm ---
<!---*******************************************************************************************
* Copyright: MyDatabase Pilot is distributed under the terms of the GNU GPL license *
* Template: Query/SELECT.cfm *
* Purpose: - Creates a Record Set with a Dynamic Select Statement *
* - Everything from the Query Name, to the selected fields, to the selected *
* tables, limit records are dynamic, therefore all these parameter must be *
* provided, when calling this template *
* Requiremets: - Connection Variables must already be set *
* - queryName must have been passed to current template as either of Scope *
* URL or FORM *
* - Selected fields can either be passed or else it is assumed that all *
* fields "*" are required *
* - Either Table names or the select list string must have been Passed to *
* overite default "*" *
********************************************************************************************--->
<!---------------------->
<!--- Error Checking --->
<!---------------------->
<!--- Check that either a table(s) name exists or that a select string is provided to overwrite default "*" --->
<!------------------------------------------------->
<!--- Generate Select Statement Clause Strings --->
<!------------------------------------------------->
<!---||| Select Options List String |||--->
<cfparam name="selectOptionsString" default="">
<!---||| Select List Clause String |||--->
<!--- This is the only clause that is required by MySQL --->
<!--- We set it to the default of "*", which means all columns from the tables named in the FROM clause --->
<cfparam name="selectListString" default="*">
<!---||| Into Outfile Clause String |||--->
<cfparam name="intoOutfileString" default="">
<!---||| From Clause String |||--->
<!--- Set Default to Empty String --->
<cfparam name="fromString" default="">
<!--- Check to see if table value exists, scope is not specified because it could be a Local, URL, or FORM variable --->
<cfif IsDefined("table")>
<!--- Add Table to fromString --->
<cfset fromString = "#table#">
</cfif>
<!---||| Where Clause String |||--->
<cfparam name="whereString" default="">
<!---||| Group By Clause String |||--->
<cfparam name="groupByString" default="">
<!---||| Having Clause String |||--->
<cfparam name="havingString" default="">
<!---||| Order By Clause String |||--->
<cfparam name="orderByString" default="">
<!---||| Limit Clause String |||--->
<cfparam name="limitString" default="">
<!---||| Procedure Clause String |||--->
<cfparam name="procedureString" default="">
<!-------------------------------->
<!--- Execute Select Statement --->
<!-------------------------------->
<!--- Initiate a Read Only lock to ensure the integrity of session variables --->
<cflock timeout=20 throwontimeout="no" type="readonly" scope="session">
<!--- Creates a Record Set with a Dynamic Select Statement --->
<!--- Query Name is Dynamic and must be provided to this generic template --->
<cfquery name="#queryName#" datasource="#session.dataSource#" username="#session.userName#" password="#session.password#">
<!--- Select Statement --->
SELECT
<!--- List Select Options If Any --->
<cfif selectOptionsString IS NOT "">
#selectOptionsString#
</cfif>
<!--- Select List Clause (Required) --->
#selectListString#
<!--- Add Into Outfile Clause If Any --->
<cfif intoOutfileString IS NOT "">
INTO OUTFILE #intoOutfileString#
</cfif>
<!--- Add From Clause If Any --->
<cfif fromString IS NOT "">
FROM #fromString#
</cfif>
<!--- Add Where Clause If Any --->
<cfif whereString IS NOT "">
WHERE #whereString#
</cfif>
<!--- Add Group By If Any --->
<cfif groupByString IS NOT "">
GROUP BY #groupByString#
</cfif>
<!--- Add Having Clause If Any --->
<cfif havingString IS NOT "">
HAVING #havingString#
</cfif>
<!--- Add Order By Clause If Any --->
<cfif orderByString IS NOT "">
ORDER BY #orderByString#
</cfif>
<!--- Add Limit Clause If Any --->
<cfif limitString IS NOT "">
LIMIT #limitString#
</cfif>
<!--- Add Procedure Clause If Any --->
<cfif procedureString IS NOT "">
PROCEDURE #procedureString#
</cfif>
<!--- End SQL Statement --->
;
</cfquery>
</cflock>
|
|
From: <nan...@us...> - 2003-04-14 02:34:30
|
Update of /cvsroot/mydatabasepilot/MyDatabasePilot/dbProcessBody In directory sc8-pr-cvs1:/tmp/cvs-serv14355 Modified Files: ShowRecords.cfm Log Message: Functionality Added: [ 720538 ] List Field Names for ShowRecords dbProcess Index: ShowRecords.cfm =================================================================== RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/dbProcessBody/ShowRecords.cfm,v retrieving revision 1.1 retrieving revision 1.2 diff -C2 -d -r1.1 -r1.2 *** ShowRecords.cfm 13 Apr 2003 04:49:26 -0000 1.1 --- ShowRecords.cfm 14 Apr 2003 02:34:27 -0000 1.2 *************** *** 8,10 **** <!---||| Show Records in Current Table |||---> ! Test Show Records \ No newline at end of file --- 8,18 ---- <!---||| Show Records in Current Table |||---> ! <!--- Show table name ---> ! Table Name:<cfoutput>#url.table#</cfoutput> ! <table width="100%" border="1" cellspacing="0" cellpadding="2"> ! <tr> ! <!--- Create List of Field Names ---> ! <td>Field Names</td> ! <cfoutput query="fieldList"><td>#FIELD#</td></cfoutput> ! </tr> ! </table> \ No newline at end of file |
|
From: <nan...@us...> - 2003-04-13 06:35:27
|
Update of /cvsroot/mydatabasepilot/MyDatabasePilot/dbProcessBody In directory sc8-pr-cvs1:/tmp/cvs-serv23671 Modified Files: ShowFields.cfm Log Message: Header comment changed Index: ShowFields.cfm =================================================================== RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/dbProcessBody/ShowFields.cfm,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** ShowFields.cfm 23 Mar 2003 03:44:33 -0000 1.1.1.1 --- ShowFields.cfm 13 Apr 2003 06:35:24 -0000 1.2 *************** *** 1,35 **** ! <!---******************************************************************************************* ! * Copyright: MyDatabase Pilot is distributed under the terms of the GNU GPL license * ! * Template: dbProcessBody/ShowFields.cfm * ! * Purpose: Displays the Body Content for the ShowFields Database Process * ! * Requiremets: -fieldList Query must be run on same page prior to including this template * ! * -url.table (table name) must have been passed from calling template * ! * Todo: * ! * Known Issues/Bugs: * ! ********************************************************************************************---> ! ! <!---||| Show Fields in Current Table |||---> ! <table width="100%" border="1" cellspacing="0" cellpadding="2"> ! <!--- Show table name ---> ! <tr><th colspan="6">Fields in Table <cfoutput>#url.table#</cfoutput></th></tr> ! <!--- Column Headers ---> ! <tr> ! <th>Field Name</th> ! <th>Key</th> ! <th>Data Type</th> ! <th>Null Value Allowed</th> ! <th>Default Value</th> ! <th>Extra Properties</th> ! </tr> ! <!--- Create List of Fields ---> ! <cfoutput query="fieldList"> ! <tr> ! <td>#FIELD#</td> ! <td><cfif KEY IS NULL OR KEY IS ""> <cfelse>#KEY#</cfif></td> ! <td>#TYPE#</td> ! <td><cfif NULL IS "">NO<cfelse>#NULL#</cfif></td> ! <td><cfif DEFAULT IS NULL OR DEFAULT IS ""> <cfelse>#DEFAULT#</cfif></td> ! <td><cfif EXTRA IS NULL OR EXTRA IS ""> <cfelse>#EXTRA#</cfif></td> ! </tr> ! </cfoutput> </table> --- 1,33 ---- ! <!---******************************************************************************************* ! * Copyright: MyDatabase Pilot is distributed under the terms of the GNU GPL license * ! * Template: dbProcessBody/ShowFields.cfm * ! * Purpose: Displays the Body Content for the ShowFields Database Process * ! * Requiremets: -fieldList Query must be run on same page prior to including this template * ! * -url.table (table name) must have been passed from calling template * ! ********************************************************************************************---> ! ! <!---||| Show Fields in Current Table |||---> ! <table width="100%" border="1" cellspacing="0" cellpadding="2"> ! <!--- Show table name ---> ! <tr><th colspan="6">Fields in Table <cfoutput>#url.table#</cfoutput></th></tr> ! <!--- Column Headers ---> ! <tr> ! <th>Field Name</th> ! <th>Key</th> ! <th>Data Type</th> ! <th>Null Value Allowed</th> ! <th>Default Value</th> ! <th>Extra Properties</th> ! </tr> ! <!--- Create List of Fields ---> ! <cfoutput query="fieldList"> ! <tr> ! <td>#FIELD#</td> ! <td><cfif KEY IS NULL OR KEY IS ""> <cfelse>#KEY#</cfif></td> ! <td>#TYPE#</td> ! <td><cfif NULL IS "">NO<cfelse>#NULL#</cfif></td> ! <td><cfif DEFAULT IS NULL OR DEFAULT IS ""> <cfelse>#DEFAULT#</cfif></td> ! <td><cfif EXTRA IS NULL OR EXTRA IS ""> <cfelse>#EXTRA#</cfif></td> ! </tr> ! </cfoutput> </table> |
|
From: <nan...@us...> - 2003-04-13 06:15:25
|
Update of /cvsroot/mydatabasepilot/MyDatabasePilot In directory sc8-pr-cvs1:/tmp/cvs-serv19961 Modified Files: MyDatabasePilot.cfm Log Message: Internal Structure Changed: [ 720529 ] Set up a CFSwitch for dbProcess Queries Index: MyDatabasePilot.cfm =================================================================== RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/MyDatabasePilot.cfm,v retrieving revision 1.3 retrieving revision 1.4 diff -C2 -d -r1.3 -r1.4 *** MyDatabasePilot.cfm 13 Apr 2003 04:36:33 -0000 1.3 --- MyDatabasePilot.cfm 13 Apr 2003 06:15:21 -0000 1.4 *************** *** 2,12 **** * Copyright: MyDatabase Pilot is distributed under the terms of the GNU GPL license * * Template: MyDatabasePilot.cfm * ! * Purpose: DataBase Administrator Page, allows for table views, edits, * ! * updates, and deletes in MySQL Databases * ! * Basically this is a GUI for MySQL Databases written in ColdFusion * * Requiremets: The database connection variables must either be configured in the * ! * Aplication.cfm file, or passed to this template via FORM_LogintoDB. * ! * Todo: * ! * Known Issues/Bugs: * ********************************************************************************************---> --- 2,9 ---- * Copyright: MyDatabase Pilot is distributed under the terms of the GNU GPL license * * Template: MyDatabasePilot.cfm * ! * Purpose: DataBase Administrator Page, this is where the bulk of the processing * ! * calls are made from * * Requiremets: The database connection variables must either be configured in the * ! * Aplication.cfm file, or passed to this template via FORM_LogintoDB * ********************************************************************************************---> *************** *** 28,45 **** <!--- Run dbGeneralInfo Query ---> <cfinclude template="Query/dbGeneralInfo.cfm"> ! <!--- Initiate a Read Only lock to ensure the integrity of session variables ---> ! <cflock timeout=20 throwontimeout="no" type="readonly" scope="session"> ! <!--- Determine if template is in "Show all tables" mode or "Show a particular table" mode and run appropriate query ---> ! <cfif dbProcess IS "ShowTables"> ! <cfquery name="tableList" datasource="#session.dataSource#" username="#session.userName#" password="#session.password#"> ! SHOW TABLES; ! </cfquery> ! <cfelseif dbProcess IS "CreateTable_Step1"> ! <cfelse> <!--- used when dbProcess is DeleteTable, or ShowFields, or SelectRecords---> ! <cfquery name="fieldList" datasource="#session.dataSource#" username="#session.userName#" password="#session.password#"> ! SHOW FIELDS FROM #url.table#; ! </cfquery> ! </cfif> ! </cflock> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> --- 25,38 ---- <!--- Run dbGeneralInfo Query ---> <cfinclude template="Query/dbGeneralInfo.cfm"> ! <!--- Run any dbProcess specific Queries ---> ! <cfswitch expression="#dbProcess#"> ! <cfcase value="ShowTables"><cfinclude template="Query/tableList.cfm"></cfcase> ! <cfcase value="ShowFields"><cfinclude template="Query/fieldList.cfm"></cfcase> ! <cfcase value="ShowRecords"><cfinclude template="Query/fieldList.cfm"></cfcase> ! <cfcase value="CreateTable_Step1"></cfcase> ! <cfcase value="CreateTable_Step2"></cfcase> ! <cfcase value="SelectRecords"></cfcase> ! <cfdefaultcase>Error: No dbProcess was Specified</cfdefaultcase> ! </cfswitch> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> |
|
From: <nan...@us...> - 2003-04-13 05:47:31
|
Update of /cvsroot/mydatabasepilot/MyDatabasePilot/Query In directory sc8-pr-cvs1:/tmp/cvs-serv13828 Added Files: fieldList.cfm Log Message: Functionality Added: [ 720526 ] Create a New File Query/fieldList.cfm --- NEW FILE: fieldList.cfm --- <!---******************************************************************************************* * Copyright: MyDatabase Pilot is distributed under the terms of the GNU GPL license * * Template: Query/fieldList.cfm * * Purpose: Creates a Record Set with a list of fields and their properties * * in the current database * * Requiremets: - Connection Variables must already be set * * - Table name must have been passed to current template as a URL Variable * ********************************************************************************************---> <!---||| Find out the list of Fields and their properties in the Current Table |||---> <!--- Initiate a Read Only lock to ensure the integrity of session variables ---> <cflock timeout=20 throwontimeout="no" type="readonly" scope="session"> <!--- Create Recordset with a List of field names and their properties ---> <cfquery name="fieldList" datasource="#session.dataSource#" username="#session.userName#" password="#session.password#"> SHOW FIELDS FROM #url.table#; </cfquery> </cflock> |
|
From: <nan...@us...> - 2003-04-13 05:36:56
|
Update of /cvsroot/mydatabasepilot/MyDatabasePilot/Query In directory sc8-pr-cvs1:/tmp/cvs-serv12055 Added Files: tableList.cfm Log Message: Functionality Added: [ 720522 ] Create a New File Query/tableList.cfm --- NEW FILE: tableList.cfm --- <!---******************************************************************************************* * Copyright: MyDatabase Pilot is distributed under the terms of the GNU GPL license * * Template: Query/tableList.cfm * * Purpose: Creates a Record Set with a list of tables in the current database * * Requiremets: Connection Variables must already be set * ********************************************************************************************---> <!---||| Find out the list of Tables in the Current Database |||---> <!--- Initiate a Read Only lock to ensure the integrity of session variables ---> <cflock timeout=20 throwontimeout="no" type="readonly" scope="session"> <!--- Create Recordset with a List of Table Names ---> <cfquery name="tableList" datasource="#session.dataSource#" username="#session.userName#" password="#session.password#"> SHOW TABLES; </cfquery> </cflock> |
|
From: <nan...@us...> - 2003-04-13 05:29:38
|
Update of /cvsroot/mydatabasepilot/MyDatabasePilot/Query In directory sc8-pr-cvs1:/tmp/cvs-serv10136 Modified Files: dbGeneralInfo.cfm Log Message: Header comment changed Index: dbGeneralInfo.cfm =================================================================== RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/Query/dbGeneralInfo.cfm,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** dbGeneralInfo.cfm 23 Mar 2003 03:44:36 -0000 1.1.1.1 --- dbGeneralInfo.cfm 13 Apr 2003 05:29:34 -0000 1.2 *************** *** 1,17 **** ! <!---******************************************************************************************* ! * Copyright: MyDatabase Pilot is distributed under the terms of the GNU GPL license * ! * Template: dbGeneralInfo.cfm * ! * Purpose: Creates a Record Set with General Information about the Database Server * ! * Requiremets: Connection Variables must already be set * ! * Todo: * ! * Known Issues/Bugs: * ! ********************************************************************************************---> ! ! <!---||| Collect General Information about the Database Currently in use and the Database Server |||---> ! <!--- Initiate a Read Only lock to ensure the integrity of session variables ---> ! <cflock timeout=20 throwontimeout="no" type="readonly" scope="session"> ! <!--- Create Recordset with general database info ---> ! <cfquery name="dbGeneralInfo" datasource="#session.dataSource#" username="#session.userName#" password="#session.password#"> ! SELECT VERSION() AS version, NOW() AS serverTime, DATABASE() AS dbInUse; ! </cfquery> </cflock> --- 1,15 ---- ! <!---******************************************************************************************* ! * Copyright: MyDatabase Pilot is distributed under the terms of the GNU GPL license * ! * Template: Query/dbGeneralInfo.cfm * ! * Purpose: Creates a Record Set with General Information about the Database Server * ! * Requiremets: Connection Variables must already be set * ! ********************************************************************************************---> ! ! <!---||| Collect General Information about the Database Currently in use and the Database Server |||---> ! <!--- Initiate a Read Only lock to ensure the integrity of session variables ---> ! <cflock timeout=20 throwontimeout="no" type="readonly" scope="session"> ! <!--- Create Recordset with general database info ---> ! <cfquery name="dbGeneralInfo" datasource="#session.dataSource#" username="#session.userName#" password="#session.password#"> ! SELECT VERSION() AS version, NOW() AS serverTime, DATABASE() AS dbInUse; ! </cfquery> </cflock> |
|
From: <nan...@us...> - 2003-04-13 04:58:29
|
Update of /cvsroot/mydatabasepilot/MyDatabasePilot/dbProcessBody
In directory sc8-pr-cvs1:/tmp/cvs-serv2065
Modified Files:
ShowTables.cfm
Log Message:
Functionality Changed: [ 720520 ] Change View Records to Reference ShowRecords dbProcess
Index: ShowTables.cfm
===================================================================
RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/dbProcessBody/ShowTables.cfm,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** ShowTables.cfm 13 Apr 2003 03:41:28 -0000 1.3
--- ShowTables.cfm 13 Apr 2003 04:58:26 -0000 1.4
***************
*** 31,35 ****
<td><a href="#currentPath#?#session.URLToken#&dbProcess=ShowFields&table=#URLEncodedFormat(Evaluate("TABLES_IN_#dbGeneralInfo.dbInUse#"))#">View Structure</a></td>
<!--- Link to Show Records --->
! <td><a href="#currentPath#?#session.URLToken#&dbProcess=SelectRecords&table=#URLEncodedFormat(Evaluate("TABLES_IN_#dbGeneralInfo.dbInUse#"))#">View Records</a></td>
<!--- Link to Alter Table--->
<td>Alter Table</td>
--- 31,35 ----
<td><a href="#currentPath#?#session.URLToken#&dbProcess=ShowFields&table=#URLEncodedFormat(Evaluate("TABLES_IN_#dbGeneralInfo.dbInUse#"))#">View Structure</a></td>
<!--- Link to Show Records --->
! <td><a href="#currentPath#?#session.URLToken#&dbProcess=ShowRecords&table=#URLEncodedFormat(Evaluate("TABLES_IN_#dbGeneralInfo.dbInUse#"))#">View Records</a></td>
<!--- Link to Alter Table--->
<td>Alter Table</td>
|
|
From: <nan...@us...> - 2003-04-13 04:49:30
|
Update of /cvsroot/mydatabasepilot/MyDatabasePilot/dbProcessBody In directory sc8-pr-cvs1:/tmp/cvs-serv32433 Added Files: ShowRecords.cfm Log Message: Functionality Added: [720519] Add File dbProcessBody/ShowRecords.cfm --- NEW FILE: ShowRecords.cfm --- <!---******************************************************************************************* * Copyright: MyDatabase Pilot is distributed under the terms of the GNU GPL license * * Template: dbProcessBody/ShowRecords.cfm * * Purpose: Displays the Records of the selected Table * * Requiremets: -fieldList Query must be run on same page prior to including this template * * -url.table (table name) must have been passed from calling template * ********************************************************************************************---> <!---||| Show Records in Current Table |||---> Test Show Records |
