mydatabasepilot-cvs Mailing List for MyDatabase Pilot (Page 7)
Status: Alpha
Brought to you by:
nanoface
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-13 04:36:37
|
Update of /cvsroot/mydatabasepilot/MyDatabasePilot In directory sc8-pr-cvs1:/tmp/cvs-serv29923 Modified Files: MyDatabasePilot.cfm Log Message: Functionality Added: [720514] Add ShowRecords dbProcess Index: MyDatabasePilot.cfm =================================================================== RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/MyDatabasePilot.cfm,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** MyDatabasePilot.cfm 6 Apr 2003 04:32:36 -0000 1.2 --- MyDatabasePilot.cfm 13 Apr 2003 04:36:33 -0000 1.3 *************** *** 59,65 **** <cfcase value="ShowTables"><cfinclude template="dbProcessBody/ShowTables.cfm"></cfcase> <cfcase value="ShowFields"><cfinclude template="dbProcessBody/ShowFields.cfm"></cfcase> ! <cfcase value="SelectRecords"><cfinclude template="dbProcessBody/SelectRecords.cfm"></cfcase> <cfcase value="CreateTable_Step1"><cfinclude template="dbProcessBody/CreateTable_Step1.cfm"></cfcase> <cfcase value="CreateTable_Step2">Create Table Step two</cfcase> <cfdefaultcase>Error: No dbProcess was Specified</cfdefaultcase> </cfswitch> --- 59,66 ---- <cfcase value="ShowTables"><cfinclude template="dbProcessBody/ShowTables.cfm"></cfcase> <cfcase value="ShowFields"><cfinclude template="dbProcessBody/ShowFields.cfm"></cfcase> ! <cfcase value="ShowRecords"><cfinclude template="dbProcessBody/ShowRecords.cfm"></cfcase> <cfcase value="CreateTable_Step1"><cfinclude template="dbProcessBody/CreateTable_Step1.cfm"></cfcase> <cfcase value="CreateTable_Step2">Create Table Step two</cfcase> + <cfcase value="SelectRecords"><cfinclude template="dbProcessBody/SelectRecords.cfm"></cfcase> <cfdefaultcase>Error: No dbProcess was Specified</cfdefaultcase> </cfswitch> |
From: <nan...@us...> - 2003-04-13 03:41:31
|
Update of /cvsroot/mydatabasepilot/MyDatabasePilot/dbProcessBody In directory sc8-pr-cvs1:/tmp/cvs-serv17452 Modified Files: ShowTables.cfm Log Message: Cosmetic Change: [ 720507] Drop Table, Alter Table Place holders Index: ShowTables.cfm =================================================================== RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/dbProcessBody/ShowTables.cfm,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** ShowTables.cfm 12 Apr 2003 04:19:24 -0000 1.2 --- ShowTables.cfm 13 Apr 2003 03:41:28 -0000 1.3 *************** *** 12,20 **** <!---||| Show Tables in Current Database |||---> <table width="100%" border="1" cellspacing="0" cellpadding="2"> - <tr><th colspan="3">Tables in Database:</th></tr> <tr> <th>Table Name</th> ! <th>Runs a SHOW FIELDS Query</th> ! <th>Runs Select Queries</th> </tr> <!--- Initiate a Read Only lock to ensure the integrity of session variables ---> --- 12,18 ---- <!---||| Show Tables in Current Database |||---> <table width="100%" border="1" cellspacing="0" cellpadding="2"> <tr> <th>Table Name</th> ! <th colspan="4">Commands</th> </tr> <!--- Initiate a Read Only lock to ensure the integrity of session variables ---> *************** *** 30,41 **** <!--- Show Table Name ---> <td>#Evaluate("tableList.TABLES_IN_#dbGeneralInfo.dbInUse#")#</td> ! <!--- Link to 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 Select Fields and Records ---> <td><a href="#currentPath#?#session.URLToken#&dbProcess=SelectRecords&table=#URLEncodedFormat(Evaluate("TABLES_IN_#dbGeneralInfo.dbInUse#"))#">View Records</a></td> </tr> </cfoutput> </cflock> <!--- Link to create a new table ---> ! <tr><td colspan="3"><cflock timeout=20 throwontimeout="no" type="readonly" scope="session"><cfoutput><a href="#currentPath#?#session.URLToken#&dbProcess=CreateTable_Step1">Create New Table</a></cfoutput></cflock></td></tr> ! </table> \ No newline at end of file --- 28,45 ---- <!--- 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=SelectRecords&table=#URLEncodedFormat(Evaluate("TABLES_IN_#dbGeneralInfo.dbInUse#"))#">View Records</a></td> + <!--- Link to Alter Table---> + <td>Alter Table</td> + <!--- Link to Drop Table ---> + <td>Drop Table</td> </tr> </cfoutput> </cflock> + </table> + + <!---||| Add New Table |||---> <!--- Link to create a new table ---> ! <cflock timeout=20 throwontimeout="no" type="readonly" scope="session"><cfoutput><a href="#currentPath#?#session.URLToken#&dbProcess=CreateTable_Step1">Create New Table</a></cfoutput></cflock> \ No newline at end of file |
From: <nan...@us...> - 2003-04-13 03:06:44
|
Update of /cvsroot/mydatabasepilot/MyDatabasePilot In directory sc8-pr-cvs1:/tmp/cvs-serv7931 Modified Files: index.cfm Log Message: Changed to do list Index: index.cfm =================================================================== RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/index.cfm,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** index.cfm 23 Mar 2003 03:44:23 -0000 1.1.1.1 --- index.cfm 13 Apr 2003 03:06:35 -0000 1.2 *************** *** 1,45 **** ! <!---******************************************************************************************* ! * Copyright: MyDatabase Pilot is distributed under the terms of the GNU GPL license * ! * Template: index.cfm * ! * Purpose: Initial Database Login page. * ! * You can either log into a database using a form or by clicking * ! * "Default Database" you are automatically connected to the default * ! * database defined in the Application.cfm template. * ! * Requiremets In order to use the "Default Database" feature, the database connection * ! * variables must be configured in the Aplication.cfm file * ! * Todo: -Enhance the look and feel of the form using tables and CSS * ! * -List Available Databases * ! * Known Issues/Bugs: * ! ********************************************************************************************---> ! ! <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> ! <html> ! <head> ! <title><cfoutput>#applicationName# #applicationVersion#</cfoutput></title> ! <link rel="STYLESHEET" type="text/css" href="Styles/master.css"> ! </head> ! <body> ! <cfinclude template="Include/Header.cfm"> ! <table width="100%" border="0" cellspacing="2" cellpadding="0"> ! <tr><td class="ToDo">ToDo: List Available Databases</td></tr> ! <tr><td class="Warning">Warning: This software is currently under development. It is currently in Alpha release. Which means it is not fully tested and could be unstable.</td></tr> ! <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"> ! <!--- Create Login to Database Form ---> ! <cfform action="#mainpage#?#session.URLToken#&dbProcess=ShowTables" method="post" name="FORM_LogintoDB" enablecab="yes"> ! <cfinput name="dataSource" type="text" size="40" required="yes"> Data Source<br> ! <cfinput name="userName" type="text" size="40" required="yes"> User Name<br> ! <cfinput name="password" type="password" size="40"> Password<br> ! <input name="LoginSubmit" type="submit" value="Login to MyDatabase"> ! <input name="LoginReset" type="reset" value="Clear Login Form"> ! </cfform> ! </cflock> ! </td> ! </tr> ! </table> ! <cfinclude template="Include/Footer.cfm"> ! </body> </html> --- 1,43 ---- ! <!---******************************************************************************************* ! * Copyright: MyDatabase Pilot is distributed under the terms of the GNU GPL license * ! * Template: index.cfm * ! * Purpose: Initial Database Login page. * ! * You can either log into a database using a form or by clicking * ! * "Default Database" you are automatically connected to the default * ! * database defined in the Application.cfm template. * ! * Requiremets In order to use the "Default Database" feature, the database connection * ! * variables must be configured in the Aplication.cfm file * ! * Todo: -Enhance the look and feel of the form using tables and CSS * ! * Known Issues/Bugs: * ! ********************************************************************************************---> ! ! <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> ! <html> ! <head> ! <title><cfoutput>#applicationName# #applicationVersion#</cfoutput></title> ! <link rel="STYLESHEET" type="text/css" href="Styles/master.css"> ! </head> ! <body> ! <cfinclude template="Include/Header.cfm"> ! <table width="100%" border="0" cellspacing="2" cellpadding="0"> ! <tr><td class="Warning">Warning: This software is currently under development. It is currently in Alpha release. Which means it is not fully tested and could be unstable.</td></tr> ! <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"> ! <!--- Create Login to Database Form ---> ! <cfform action="#mainpage#?#session.URLToken#&dbProcess=ShowTables" method="post" name="FORM_LogintoDB" enablecab="yes"> ! <cfinput name="dataSource" type="text" size="40" required="yes"> Data Source<br> ! <cfinput name="userName" type="text" size="40" required="yes"> User Name<br> ! <cfinput name="password" type="password" size="40"> Password<br> ! <input name="LoginSubmit" type="submit" value="Login to MyDatabase"> ! <input name="LoginReset" type="reset" value="Clear Login Form"> ! </cfform> ! </cflock> ! </td> ! </tr> ! </table> ! <cfinclude template="Include/Footer.cfm"> ! </body> </html> |
From: <nan...@us...> - 2003-04-12 04:19:27
|
Update of /cvsroot/mydatabasepilot/MyDatabasePilot/dbProcessBody In directory sc8-pr-cvs1:/tmp/cvs-serv10936 Modified Files: ShowTables.cfm Log Message: Cosmetic Change: [ 720058 ] Rename Table Links Index: ShowTables.cfm =================================================================== RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/dbProcessBody/ShowTables.cfm,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** ShowTables.cfm 23 Mar 2003 03:44:34 -0000 1.1.1.1 --- ShowTables.cfm 12 Apr 2003 04:19:24 -0000 1.2 *************** *** 1,41 **** ! <!---******************************************************************************************* ! * Copyright: MyDatabase Pilot is distributed under the terms of the GNU GPL license * ! * Template: dbProcessBody/ShowTables.cfm * ! * 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: * ! ********************************************************************************************---> ! ! <!---||| Show Tables in Current Database |||---> ! <table width="100%" border="1" cellspacing="0" cellpadding="2"> ! <tr><th colspan="3">Tables in Database:</th></tr> ! <tr> ! <th>Table Name</th> ! <th>Runs a SHOW FIELDS Query</th> ! <th>Runs Select Queries</th> ! </tr> ! <!--- Initiate a Read Only lock to ensure the integrity of session variables ---> ! <cflock timeout=20 throwontimeout="no" type="readonly" scope="session"> ! <!--- Create List of Tables ---> ! <cfoutput query="tableList"> ! <tr><!--- Detail: ! 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# ! ---> ! <!--- Show Table Name ---> ! <td>#Evaluate("tableList.TABLES_IN_#dbGeneralInfo.dbInUse#")#</td> ! <!--- Link to Table Fields and Properties ---> ! <td><a href="#currentPath#?#session.URLToken#&dbProcess=ShowFields&table=#URLEncodedFormat(Evaluate("TABLES_IN_#dbGeneralInfo.dbInUse#"))#">Table Fields with Properties</a></td> ! <!--- Link to Select Fields and Records ---> ! <td><a href="#currentPath#?#session.URLToken#&dbProcess=SelectRecords&table=#URLEncodedFormat(Evaluate("TABLES_IN_#dbGeneralInfo.dbInUse#"))#">View Selected Fields and Records</a></td> ! </tr> ! </cfoutput> ! </cflock> ! <!--- Link to create a new table ---> ! <tr><td colspan="3"><cflock timeout=20 throwontimeout="no" type="readonly" scope="session"><cfoutput><a href="#currentPath#?#session.URLToken#&dbProcess=CreateTable_Step1">Create New Table</a></cfoutput></cflock></td></tr> </table> --- 1,41 ---- ! <!---******************************************************************************************* ! * Copyright: MyDatabase Pilot is distributed under the terms of the GNU GPL license * ! * Template: dbProcessBody/ShowTables.cfm * ! * 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: * ! ********************************************************************************************---> ! ! <!---||| Show Tables in Current Database |||---> ! <table width="100%" border="1" cellspacing="0" cellpadding="2"> ! <tr><th colspan="3">Tables in Database:</th></tr> ! <tr> ! <th>Table Name</th> ! <th>Runs a SHOW FIELDS Query</th> ! <th>Runs Select Queries</th> ! </tr> ! <!--- Initiate a Read Only lock to ensure the integrity of session variables ---> ! <cflock timeout=20 throwontimeout="no" type="readonly" scope="session"> ! <!--- Create List of Tables ---> ! <cfoutput query="tableList"> ! <tr><!--- Detail: ! 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# ! ---> ! <!--- Show Table Name ---> ! <td>#Evaluate("tableList.TABLES_IN_#dbGeneralInfo.dbInUse#")#</td> ! <!--- Link to 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 Select Fields and Records ---> ! <td><a href="#currentPath#?#session.URLToken#&dbProcess=SelectRecords&table=#URLEncodedFormat(Evaluate("TABLES_IN_#dbGeneralInfo.dbInUse#"))#">View Records</a></td> ! </tr> ! </cfoutput> ! </cflock> ! <!--- Link to create a new table ---> ! <tr><td colspan="3"><cflock timeout=20 throwontimeout="no" type="readonly" scope="session"><cfoutput><a href="#currentPath#?#session.URLToken#&dbProcess=CreateTable_Step1">Create New Table</a></cfoutput></cflock></td></tr> </table> |
From: <nan...@us...> - 2003-04-12 02:39:04
|
Update of /cvsroot/mydatabasepilot/Docs In directory sc8-pr-cvs1:/tmp/cvs-serv19299 Added Files: RoadMap.html Log Message: New File Added: RoadMap.html --- NEW FILE: RoadMap.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 - DEVELOPMENT PLAN - Road Map</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;">DEVELOPMENT PLAN<br>Road Map</div> <div style="font-size: 18px; font-weight: bold; color: #003399; margin: 3px 0px;">Scope: What is this all about?</div> <p style="text-align: justify;">MyDatabase Pilot will be developed to a mature product. This will be accomplished in a series of small planned steps. This road map shows the path to maturity as envisioned at the start of this journey. The road map is subject to change as new features are identified and/or requested, and as needed to accommodate our growing audience.</p> <p style="text-align: justify;">First we need to qualify a few words/phrases. This document starts with some definitions and explanations of development lingo as it applies to MyDatabase Pilot. These definitions will help you answer questions like: What do we mean when we declare a MyDatabase Pilot release as "Alpha" or "Stable"? What does v0.9.22 mean? What branch/version is right for me?</p> <p style="text-align: justify;">At the end of this document is the actual road map, which gives you an idea of what to expect at certain stages. As mentioned before, this is somewhat like looking through the crystal ball. The further you look into the future, the fuzzier things get. So changes/updates to this map are very likely, and are more likely the further down this path we travel.</p> <div style="font-size: 18px; font-weight: bold; color: #003399; margin: 3px 0px;">Development Status: What the stages mean</div> <p style="text-align: justify;">Each release of MyDatabase Pilot will be labeled with one of five status identifiers. They are Alpha, Beta, Gamma, Stable, and Mature. Two other status identifiers will be used from time to time; however these will not be associated with any file releases. These identifiers are Planning, and Development.</p> <ul> <li><span style="font-weight: bold; color: #003399;">Pre-Release Status Identifiers:</span></li> <ul> <li style="text-align: justify;"><span style="font-weight:bold;">Planning</span> - A version of MyDatabase Pilot is said to be in <span style="font-weight:bold;">Planning</span> stage when a full development plan has not yet been completed, and is currently being laid out.</li> <li style="text-align: justify;"><span style="font-weight:bold;">Development</span> - Some developers refer to this stage as <span style="font-weight:bold;">Pre-Alpha</span>. We will refer to code that has yet to be released, as code of status <span style="font-weight:bold;">Development</span>. This code will be available through the CVS.</li> </ul> <li><span style="font-weight: bold; color: #003399;">Release Status Identifiers:</span></li> <ul> <li style="text-align: justify;"><span style="font-weight:bold;">Alpha</span> - A release will be named <span style="font-weight:bold;">Alpha</span> when a significant portion of the software plan is yet to be developed and tested. These releases will be made available only to show-case the latest snap-shot of development code, and should give an idea of some new features that are expected in the stable release.</li> <li style="text-align: justify;"><span style="font-weight:bold;">Beta</span> - Once ALL major features in the development plan have been implemented, the software will be labeled <span style="font-weight:bold;">Beta</span>. At this point extensive and documented testing will begin. No new major features will be introduced. Any new major features will have to be added to a new branch and labeled either Development or Alpha. A <span style="font-weight:bold;">Beta</span> release will show-case a product that is considered complete according to the plan, but untested. Unexpected results can still happen, and should be considered before working on mission critical data. (Make sure you have a backup)</li> <li style="text-align: justify;"><span style="font-weight:bold;">Gamma</span> - When all scheduled testing has been completed and documented, the product will be declared <span style="font-weight:bold;">Gamma</span>. At this point we believe the product is fully developed and tested in the lab according to the development plan. However the product is unproven in the field. A product will remain in <span style="font-weight:bold;">Gamma</span> state for a period of at least three months. This will give us a chance to collect user feed back. We may have missed a few bugs here and there. We may have overlooked/omitted something significant in the development plan. A <span style="font-weight:bold;">Gamma</span> release will show-case a product that is considered complete according to the plan and tested in the lab according to our testing standards. We do not expect any major problems (although it can't be ruled out), but there may be a few user issues that we may have overlooked.</li> <li style="text-align: justify;"><span style="font-weight:bold;">Stable</span> - If no major bugs or shortcomings are reported in a Gamma release for a period of three months, the product will be released as <span style="font-weight:bold;">Stable</span>. Some developers refer to this as <span style="font-weight:bold;">Production</span>. <span style="font-weight:bold;">Stable</span> release is considered complete, tested, and verified in the field. You can use this release with confidence, however no warranty is provided as according to the GNU license.</li> <li style="text-align: justify;"><span style="font-weight:bold;">Mature</span> - This designation will be assigned to branches of MyDatabase Pilot that have been well established. Based on number of downloads, and number of reported bugs. The exact download numbers will be left to the discretion of the team, but it will have to be a reasonably significant number. No major bugs for at least a year, before <span style="font-weight:bold;">Mature</span> status can be awarded to a branch.</li> </ul> </ul> <p style="text-align: justify;">A particular release can be considered both in Planning and in Development Status/Alpha release. Even though a plan is still unrefined, some developers may already have experimented with some code that represents a portion of the development plan which has been finalized. Similarly this development code may be made available via an Alpha release in order to show some of our current plans.</p> <div style="font-size: 18px; font-weight: bold; color: #003399; margin: 3px 0px;">Versioning: What the Numbers Mean</div> <p style="text-align: justify;">The nomenclature of MyDatabase Pilot versioning will be straight forward. Each release will have three sets of numbers and one letter such as 0.7.0.a.</p> <p style="text-align: justify;">The letter identifies the status of the release; a for Alpha, b for Beta, g for Gamma, s for Stable, and m for Mature.</p> <p style="text-align: justify;">The first number represents the Major releases/branches of MyDatabase Pilot. This number will remain 0 until our first stable release. Our first stable release will be identified as 1.0.0.s. New branches of MyDatabase Pilot with new major functionality/improvements will subsequently increment the first number. This is true even with the first alpha release of a new branch. For example our second major release/branch will be designated as 2.0.0.a.</p> <p style="text-align: justify;">The second number will take on two roles. Until we reach our first stable release, this number will increment as we pass major milestones in the development of our first working product. Our first Alpha release was 0.7.0.a. Our first Beta release 0.8.0.b. Our first Gamma release 0.9.0.g. Once we reach our first stable release 1.0.0.s, the role of the second number will shift to identify, that a minor feature has been added or changed.</p> <p style="text-align: justify;">The third number again takes on two meanings. In the pre first stable releases (0.x.x) it will take on the role of changes/additions/bug fixes within a given development stage. After the first stable release (1.0.0.s), the third number will indicate a maintenance/bug fix release.</p> <div style="font-size: 18px; font-weight: bold; color: #003399; margin: 3px 0px;">Branching: Different Levels of MyDatabase Pilot</div> <p style="text-align: justify;">We will create different product levels of MyDatabase Pilot. Currently we have three branches in mind. MyDatabase Pilot Basic, MyDatabase Pilot Pro, MyDatabase Pilot Dynamic.</p> <p style="text-align: justify;"><span style="font-weight:bold;">Basic Branch</span> - Our first release will mature into our MyDatabase Pilot Basic Branch. This release will be maintained as a minimal footprint product with basic functionality for administering MySQL Databases.</p> <p style="text-align: justify;"><span style="font-weight:bold;">Pro Branch</span> - Version 2.x.x will be developed with as many features as our team can dream up and users can request. This branch will be distributed as MyDatabase Pilot Pro. In order to make this product as appealing and widely excepted, this version will stick to standard HTML output. (JavaScript will be limited, and no Flash or other browser/plug-in dependent technology will be used).</p> <p style="text-align: justify;"><span style="font-weight:bold;">Dynamic Branch</span> - This branch will take all the features of MyDatabase Pilot Pro and make them interactive. The first release will be 3.0.0. Interactivity will be achieved through a combination of advanced JavaScript and/or Flash Integration. This branch will be geared to those users who want to go beyond advanced administration on a static web page and take it to a dynamic level. Expect such features as dragable/dockable tables; expanding/collapsing structures; and more.</p> <div style="font-size: 18px; font-weight: bold; color: #003399; margin: 3px 0px;">Development Cycle: The Never Ending Story</div> <p style="text-align: justify;">We will constantly look at improving MyDatabase Pilot. Even when we have reached stable/mature status, our work will not be over. We will start a new planning/development stage for a new and improved release. Improvements can come in two forms after our first stable release. They can be major improvements that will create a new branch of MyDatabase Pilot. Or minor improvements to current stable/mature branches. In either case the improvements will go through the same development stages as listed in the "Development Status" section above. The only way a new improvement can short circuit the process is if it is being filtered down from an already tested version of MyDatabase Pilot. This will maintain the integrity of the development status label attached with a particular branch.</p> <p style="text-align: justify;">Gamma releases will not be necessary for minor improvements. Once a minor release has been fully developed and tested in the lab, it can be added directly to a stable/mature branch.</p> <div style="font-size: 18px; font-weight: bold; color: #003399; margin: 3px 0px;">The Road to Maturity: What to Expect</div> <table width="100%" border="0" cellpadding="2" cellspacing="2"> <tr> <td width="33%" style="background-color: #FFCCCC; text-align: center; border: ridge;">0.7.0.a (First Alpha Release)<br />Released March 26, 2003<br>Database Connection, List Tables, System Info, Table Structure</td> <td rowspan="2"> </td> </tr> <tr> <td width="33%" style="background-color: #FFCCCC; text-align: center; border: ridge;">0.7.1.a<br />View Table Records</td> <td rowspan="2"> </td> </tr> <tr> <td width="33%" style="background-color: #FFCCCC; text-align: center; border: ridge;">0.7.2.a<br />Add New Field</td> <td rowspan="2"> </td> </tr> <tr> <td width="33%" style="background-color: #FFCCCC; text-align: center; border: ridge;">0.7.3.a<br />Alter Field</td> <td rowspan="2"> </td> </tr> <tr> <td width="33%" style="background-color: #FFCCCC; text-align: center; border: ridge;">0.7.4.a<br />Drop Field</td> <td rowspan="2"> </td> </tr> <tr> <td width="33%" style="background-color: #FFCCCC; text-align: center; border: ridge;">0.7.5.a<br />Add New Table</td> <td rowspan="2"> </td> </tr> <tr> <td width="33%" style="background-color: #FFCCCC; text-align: center; border: ridge;">0.7.6.a<br />Drop Table</td> <td rowspan="2"> </td> </tr> <tr> <td width="33%" style="background-color: #FFCCCC; text-align: center; border: ridge;">0.7.7.a<br />Alter Table (Rename Table, Alter Table Order)</td> <td rowspan="2"> </td> </tr> <tr> <td width="33%" style="background-color: #FFCCCC; text-align: center; border: ridge;">0.7.8.a<br />Select</td> <td rowspan="2"> </td> </tr> <tr> <td width="33%" style="background-color: #FFCCCC; text-align: center; border: ridge;">0.7.9.a<br />Insert</td> <td rowspan="2"> </td> </tr> <tr> <td width="33%" style="background-color: #FFCCCC; text-align: center; border: ridge;">0.7.10.a<br />Update</td> <td rowspan="2"> </td> </tr> <tr> <td width="33%" style="background-color: #FFCCCC; text-align: center; border: ridge;">0.7.11.a<br />Delete</td> <td rowspan="2"> </td> </tr> <tr> <td width="33%" style="background-color: #FFCC33; text-align: center; border: ridge;">0.8.0.b (First Beta Release)<br />Extensive testing begins; Bug fixes and minor changes will increment the last version number (0.8.x.b); No new major features will be introduced; Any new major features will be released as 2.x.x.a;</td> <td width="33%" style="background-color: #FFCCCC; text-align: center; border: ridge;">2.0.0.a (Pro Branch)<br />A lot more functionality will be added; Plan is yet to be developed;</td> <td> </td> </tr> <tr> <td width="33%" style="background-color: #99CCFF; text-align: center; border: ridge;">0.9.0.g (First Gamma Release)<br />Product is fully developed according to the plan and tested in the lab; Field testing begins; User feed back will iron out last remaining issues and increment the last version number (0.9.x.g)</td> <td> </td> <td width="33%" style="background-color: #FFCCCC; text-align: center; border: ridge;">3.0.0.a (Dynamic Branch)<br />Interactive presentation will be introduced either via JavaScript as in DynAPI, or through Flash integration</td> </tr> <tr> <td width="33%" style="background-color: #CCFFCC; text-align: center; border: ridge;">1.0.0.s (First Stable Release)<br />Minor bug fixes will increment last version number (1.0.x.s); Minor features may be filtered down from higher branches after thorough testing; Feature additions and changes will increment the second version number (1.x.0.s); No new drastic changes will be implemented in this first stable branch; We will maintain this first stable branch as the "Basic" branch for those users who only need minimal functionality, without the bells and whistles, as outlined in the development plan;</td> <td rowspan="2"> </td> </tr> <tr> <td width="33%" style="background-color: #CCCCFF; text-align: center; border: ridge;">1.?.0.m (First Mature Release)<br />Well established without major bugs reported for at least a year;</td> <td rowspan="2"> </td> </tr> </table> </body> </html> |
From: <nan...@us...> - 2003-04-09 01:37:33
|
Update of /cvsroot/mydatabasepilot/Docs In directory sc8-pr-cvs1:/tmp/cvs-serv9746 Modified Files: WhatIsMyDatabasePilot.html Log Message: Added basic functionality list to "About MyDatabase Pilot" Index: WhatIsMyDatabasePilot.html =================================================================== RCS file: /cvsroot/mydatabasepilot/Docs/WhatIsMyDatabasePilot.html,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** WhatIsMyDatabasePilot.html 6 Apr 2003 06:47:44 -0000 1.1.1.1 --- WhatIsMyDatabasePilot.html 9 Apr 2003 01:37:29 -0000 1.2 *************** *** 8,19 **** <body> <div style="font-size: 24px;font-weight: bold;color: #003399; background-color: #FFFFCC; text-align: center; margin: 3px 0px;">INTRODUCTION<br>About MyDatabase Pilot</div> <div style="font-size: 18px; font-weight: bold; color: #003399; margin: 3px 0px;">What is MyDatabase Pilot?</div> <p style="text-align: justify;">MyDatabase Pilot is a browser based GUI for MySQL databases, written in ColdFusion. It allows for easy navigation and interaction with the structure of your database. </p> <div style="font-size: 18px; font-weight: bold; color: #003399; margin: 3px 0px;">What stage of development is MyDatabase Pilot in?</div> <p style="text-align: justify;">Currently MyDatabase Pilot is in Alpha release. This is indicated by the "a" in the release version. It is designated Alpha because, a significant portion of this software is yet to be developed and tested. This release gives you a snap shot of what it is we are doing, and hopefully encourage you to join the development team.</p> <div style="font-size: 18px; font-weight: bold; color: #003399; margin: 3px 0px;">What can MyDatabase Pilot do right now?</div> <p style="text-align: justify;">Currently MyDatabase Pilot can connect to a database either through a login screen or by configuring a default database in the Application.cfm file. It can list the tables/fields in the selected database.</p> <div style="font-size: 18px; font-weight: bold; color: #003399; margin: 3px 0px;">What will MyDatabase Pilot be able to do when it is declared stable?</div> ! <p style="text-align: justify;">A list of expected features will soon be available.</p> </body> </html> --- 8,46 ---- <body> <div style="font-size: 24px;font-weight: bold;color: #003399; background-color: #FFFFCC; text-align: center; margin: 3px 0px;">INTRODUCTION<br>About MyDatabase Pilot</div> + <div style="font-size: 18px; font-weight: bold; color: #003399; margin: 3px 0px;">What is MyDatabase Pilot?</div> <p style="text-align: justify;">MyDatabase Pilot is a browser based GUI for MySQL databases, written in ColdFusion. It allows for easy navigation and interaction with the structure of your database. </p> + <div style="font-size: 18px; font-weight: bold; color: #003399; margin: 3px 0px;">What stage of development is MyDatabase Pilot in?</div> <p style="text-align: justify;">Currently MyDatabase Pilot is in Alpha release. This is indicated by the "a" in the release version. It is designated Alpha because, a significant portion of this software is yet to be developed and tested. This release gives you a snap shot of what it is we are doing, and hopefully encourage you to join the development team.</p> + <div style="font-size: 18px; font-weight: bold; color: #003399; margin: 3px 0px;">What can MyDatabase Pilot do right now?</div> <p style="text-align: justify;">Currently MyDatabase Pilot can connect to a database either through a login screen or by configuring a default database in the Application.cfm file. It can list the tables/fields in the selected database.</p> + <div style="font-size: 18px; font-weight: bold; color: #003399; margin: 3px 0px;">What will MyDatabase Pilot be able to do when it is declared stable?</div> ! <p style="text-align: justify;">It is our goal to have MyDatabase Pilot be able to have the following basic set of functionality in the first stable release:</p> ! <ul> ! <li>Seamless (and perceived continuous) Database Connection<br>(implemented since v0.7.0.a)</li> ! <li>List Tables<br>(implemented since v0.7.0.a)</li> ! <li>Provide Basic Information about MySQL Server, ColdFusion Server, and Operating System<br>(implemented since v0.7.0.a)</li> ! <li>View Table Structure<br>(implemented since v0.7.0.a)</li> ! <li>View Table Records</li> ! <li>Data Definition</li> ! <ul> ! <li>Add New Field</li> ! <li>Alter Field</li> ! <li>Drop Field</li> ! <li>Add New Table</li> ! <li>Drop Table</li> ! <li>Alter Table (Rename Table, Alter Table Order)</li> ! </ul> ! <li>Data Manipulation</li> ! <ul> ! <li>Select</li> ! <li>Insert</li> ! <li>Update</li> ! <li>Delete</li> ! </ul> ! </ul> </body> </html> |
From: <nan...@us...> - 2003-04-09 01:01:54
|
Update of /cvsroot/mydatabasepilot/Docs In directory sc8-pr-cvs1:/tmp/cvs-serv31339 Added Files: Objective.html Log Message: Objective.html file added --- NEW FILE: Objective.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 - DEVELOPMENT PLAN - Objective</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;">DEVELOPMENT PLAN<br>Objective</div> <div style="font-size: 18px; font-weight: bold; color: #003399; margin: 3px 0px;">Goal</div> <p style="text-align: justify;">MyDatabase Pilot is a browser based GUI for MySQL databases, written in ColdFusion. It allows for easy navigation and interaction with the structure of your database.</p> <div style="font-size: 18px; font-weight: bold; color: #003399; margin: 3px 0px;">Minimum Functionality to Achieve Goal</div> <p style="text-align: justify;">In order to achieve our goal for MyDatabase Pilot, we need to have a basic set of functionality that would be expected from a product with the above stated goal. The list below is what we consider to be "Minimum Functionality". When the list below has been implemented, we can consider MyDatabase Pilot to have reached Beta release. At which point extensive testing will begin.</p> <ul> <li>Seamless (and perceived continuous) Database Connection<br>(implemented since v0.7.0.a)</li> <li>List Tables<br>(implemented since v0.7.0.a)</li> <li>Provide Basic Information about MySQL Server, ColdFusion Server, and Operating System<br>(implemented since v0.7.0.a)</li> <li>View Table Structure<br>(implemented since v0.7.0.a)</li> <li>View Table Records</li> <li>Data Definition</li> <ul> <li>Add New Field</li> <li>Alter Field</li> <li>Drop Field</li> <li>Add New Table</li> <li>Drop Table</li> <li>Alter Table (Rename Table, Alter Table Order)</li> </ul> <li>Data Manipulation</li> <ul> <li>Select</li> <li>Insert</li> <li>Update</li> <li>Delete</li> </ul> </ul> <p style="text-align: justify;">The above functionality list is in roughly the chronological order of planned implementation.</p> <p style="text-align: justify;">You may wonder why we have left out Create/Drop Database.</p> <p style="text-align: justify;">Reason One: We are designing this first release to work with datasources, that are already configured in your ColdFusion Administrator. For us to have datasources, we already have created the database, thus no need for Create/Drop Database Commands.</p> <p style="text-align: justify;">Reason Two: The vast majority of MySQL users, use MySQL with web applications. A lot of web applications are created for hosted environments. In hosted environments usually web developers only have access to specific databases, opposed to the entire MySQL server. Bottom line if you need this functionality, join the development team and contribute your code.</p> <p style="text-align: justify;">The create/drop database functionality may be reconsidered in a later release. Your suggestions/code are welcome.</p> </body> </html> |
From: <nan...@us...> - 2003-04-08 03:37:05
|
Update of /cvsroot/mydatabasepilot/Docs In directory sc8-pr-cvs1:/tmp/cvs-serv20072 Modified Files: Installation.html Log Message: Corrected Spelling Index: Installation.html =================================================================== RCS file: /cvsroot/mydatabasepilot/Docs/Installation.html,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** Installation.html 6 Apr 2003 06:47:37 -0000 1.1.1.1 --- Installation.html 8 Apr 2003 03:37:01 -0000 1.2 *************** *** 19,23 **** You will be connecting to a database using a datasource, which you have already configured in you ColdFusion Administrator. Refer to your ColdFusion manual on how to create a datasource, and how to check to make sure it is functioning.</li> <li style="text-align: justify;"><span style="font-weight: bold;">Permissions:</span> Do I have sufficient permissions to work with the database?<br> ! MyDatabase Pilot is web based visual tool to show and interact with the structure of your database. Your username/password combination for your database, needs to have full permissions including Drop/Create/Update/Insert. Without full permit ions you will not be able to perform some functions.</li> </ul> --- 19,23 ---- You will be connecting to a database using a datasource, which you have already configured in you ColdFusion Administrator. Refer to your ColdFusion manual on how to create a datasource, and how to check to make sure it is functioning.</li> <li style="text-align: justify;"><span style="font-weight: bold;">Permissions:</span> Do I have sufficient permissions to work with the database?<br> ! MyDatabase Pilot is web based visual tool to show and interact with the structure of your database. Your username/password combination for your database, needs to have full permissions including Drop/Create/Update/Insert. Without full permissions you will not be able to perform some functions.</li> </ul> |
From: <nan...@us...> - 2003-04-06 07:59:11
|
Update of /cvsroot/mydatabasepilot/Docs In directory sc8-pr-cvs1:/tmp/cvs-serv17685 Added Files: DatabaseConnection.html Log Message: New File Added --- NEW FILE: DatabaseConnection.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 Connection</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 Connection</div> <div style="font-size: 18px; font-weight: bold; color: #003399; margin: 3px 0px;">Connection Mechanism</div> <p style="text-align: justify;">We need a mechanism to connect to a Database and to simulate a constant connection to a database even though this is not physically possible over the stateless nature of the world wide web. The end user must perceive as if they have an open connection to the database once they have made an initial connection. This will be accomplished with session variables in the Application.cfm file.</p> <p style="text-align: justify;">The usual database connection variables in ColdFusion are datasource, username and password. These connection variables are usually hard coded in the <cfquery> tag. We will make these variables dynamic and give them a session scope. This will allow us to simulate a constant connection to a particular database.</p> <div style="font-size: 18px; font-weight: bold; color: #003399; margin: 3px 0px;">Flexibility</div> <p style="text-align: justify;">Some users will only ever use MyDatabase Pilot with one database (or at least most of the time). While others will connect to many different databases on a regular basis. The first set of users will demand the ability to hard code the most common database connection variables in MyDatabase Pilot so they will not have to manually connect to the same database every time they start using MyDatabase Pilot. This has security implications that need to be explained in the user guide. The users who are connecting to different databases regularly, or are more security conscious and want to avoid hard coding passwords, will require a login page to connect to the database. We will provide the flexibility to both types of users.</p> <p style="text-align: justify;">We will create a login page for security conscious, and multiple database users. We will also allow our users to hard code the connection variables to the most commonly used database in the Application.cfm file, and give them a link on the login page to use this "default database".</p> </body> </html> |
From: <nan...@us...> - 2003-04-06 05:48:22
|
Update of /cvsroot/mydatabasepilot/MyDatabasePilot In directory sc8-pr-cvs1:/tmp/cvs-serv22571 Modified Files: Application.cfm Log Message: Corrected Comment Index: Application.cfm =================================================================== RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/Application.cfm,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** Application.cfm 23 Mar 2003 03:44:20 -0000 1.1.1.1 --- Application.cfm 6 Apr 2003 05:48:19 -0000 1.2 *************** *** 1,56 **** ! <!---******************************************************************************************* ! * 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: * ! ********************************************************************************************---> ! ! <!---||| 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"> ! <cferror type="monitor" template="ErrorHandling/MonitorErr.cfm"> ! <cferror type="request" template="ErrorHandling/RequestErr.cfm"> ! <cferror type="validation" template="ErrorHandling/ValidationErr.cfm"> ! ---> ! ! <!---||| 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 ---> ! <!--- 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> ! ! <!---||| Set Application-specific Variables scope variables |||---> ! <cfset applicationName = "MyDatabase Pilot"> ! <cfset applicationVersion = "v0.7.0(Alpha)"> ! <cfset applicationReleaseDate = "17th Mar 2003"> ! <cfset mainpage = "MyDatabasePilot.cfm"> ! <cfset currentPath = "#cgi.path_info#"> ! <cfset currentQueryString = "#cgi.query_string#"> ! <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"> ---> --- 1,56 ---- ! <!---******************************************************************************************* ! * 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: * ! ********************************************************************************************---> ! ! <!---||| 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"> ! <cferror type="monitor" template="ErrorHandling/MonitorErr.cfm"> ! <cferror type="request" template="ErrorHandling/RequestErr.cfm"> ! <cferror type="validation" template="ErrorHandling/ValidationErr.cfm"> ! ---> ! ! <!---||| 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 ---> ! <!--- 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> ! ! <!---||| Set Application-Wide Local scope variables |||---> ! <cfset applicationName = "MyDatabase Pilot"> ! <cfset applicationVersion = "v0.7.0(Alpha)"> ! <cfset applicationReleaseDate = "17th Mar 2003"> ! <cfset mainpage = "MyDatabasePilot.cfm"> ! <cfset currentPath = "#cgi.path_info#"> ! <cfset currentQueryString = "#cgi.query_string#"> ! <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"> ---> |
From: <nan...@us...> - 2003-04-06 04:32:41
|
Update of /cvsroot/mydatabasepilot/MyDatabasePilot In directory sc8-pr-cvs1:/tmp/cvs-serv8401 Modified Files: MyDatabasePilot.cfm Log Message: Bug Fixed: [ mydatabasepilot-Bugs-713679 ] White space is not trimmed from login form Index: MyDatabasePilot.cfm =================================================================== RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/MyDatabasePilot.cfm,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** MyDatabasePilot.cfm 23 Mar 2003 03:44:32 -0000 1.1.1.1 --- MyDatabasePilot.cfm 6 Apr 2003 04:32:36 -0000 1.2 *************** *** 1,68 **** ! <!---******************************************************************************************* ! * 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: * ! ********************************************************************************************---> ! ! <!---||| 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")> ! <!--- Initiate an Exclusive lock to ensure the integrity of session variables ---> ! <cflock timeout = "30" throwontimeout="no" type = "exclusive" scope = "session"> ! <!--- Overwrite the Session variables used for Database connection with New Values ---> ! <cfset session.dataSource = #Form.dataSource#> <!--- Data Source ---> ! <cfset session.userName = #Form.userName#> <!--- User Name ---> ! <cfset session.password = #Form.password#> <!--- Password ---> ! </cflock> ! </cfif> ! ! <!---||| Run Queries needed for body of Document based on the particular dbProcess Request |||---> ! <!--- 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"> ! <html> ! <head> ! <title><cfoutput>#applicationName# #applicationVersion#</cfoutput></title> ! <link rel="STYLESHEET" type="text/css" href="Styles/master.css"> ! </head> ! <body> ! <cfinclude template="Include/Header.cfm"> ! <table width="100%" border="0" cellspacing="0" cellpadding="0"><tr> ! <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> ! <cfcase value="ShowFields"><cfinclude template="dbProcessBody/ShowFields.cfm"></cfcase> ! <cfcase value="SelectRecords"><cfinclude template="dbProcessBody/SelectRecords.cfm"></cfcase> ! <cfcase value="CreateTable_Step1"><cfinclude template="dbProcessBody/CreateTable_Step1.cfm"></cfcase> ! <cfcase value="CreateTable_Step2">Create Table Step two</cfcase> ! <cfdefaultcase>Error: No dbProcess was Specified</cfdefaultcase> ! </cfswitch> ! </td> ! </tr></table> ! <cfinclude template="Include/Footer.cfm"> ! </body> </html> --- 1,70 ---- ! <!---******************************************************************************************* ! * 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: * ! ********************************************************************************************---> ! ! <!---||| 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")> ! <!--- Initiate an Exclusive lock to ensure the integrity of session variables ---> ! <cflock timeout = "30" throwontimeout="no" type = "exclusive" scope = "session"> ! <!--- Using the values submitted by the login in form, ---> ! <!--- trim leading and trailing white spaces and ---> ! <!--- overwrite the session variables used for database connection ---> ! <cfset session.dataSource = #Trim(Form.dataSource)#> <!--- Data Source ---> ! <cfset session.userName = #Trim(Form.userName)#> <!--- User Name ---> ! <cfset session.password = #Trim(Form.password)#> <!--- Password ---> ! </cflock> ! </cfif> ! ! <!---||| Run Queries needed for body of Document based on the particular dbProcess Request |||---> ! <!--- 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"> ! <html> ! <head> ! <title><cfoutput>#applicationName# #applicationVersion#</cfoutput></title> ! <link rel="STYLESHEET" type="text/css" href="Styles/master.css"> ! </head> ! <body> ! <cfinclude template="Include/Header.cfm"> ! <table width="100%" border="0" cellspacing="0" cellpadding="0"><tr> ! <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> ! <cfcase value="ShowFields"><cfinclude template="dbProcessBody/ShowFields.cfm"></cfcase> ! <cfcase value="SelectRecords"><cfinclude template="dbProcessBody/SelectRecords.cfm"></cfcase> ! <cfcase value="CreateTable_Step1"><cfinclude template="dbProcessBody/CreateTable_Step1.cfm"></cfcase> ! <cfcase value="CreateTable_Step2">Create Table Step two</cfcase> ! <cfdefaultcase>Error: No dbProcess was Specified</cfdefaultcase> ! </cfswitch> ! </td> ! </tr></table> ! <cfinclude template="Include/Footer.cfm"> ! </body> </html> |
From: <nan...@us...> - 2003-03-30 04:37:27
|
Update of /cvsroot/mydatabasepilot/MyDatabasePilot/Styles In directory sc8-pr-cvs1:/tmp/cvs-serv5485 Modified Files: master-test.html Log Message: Testing syncmail with Restrict posting privilege Index: master-test.html =================================================================== RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/Styles/master-test.html,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** master-test.html 30 Mar 2003 04:21:15 -0000 1.2 --- master-test.html 30 Mar 2003 04:37:14 -0000 1.3 *************** *** 10,14 **** <body> Welcome to MyDatabase Pilot - <!--- Testing syncmail ---> <p>Paragraph. This is a paragraph. <q>This is an inline quote.</q> This is a paragraph. This is a paragraph. This is a paragraph. This is a paragraph. This is a paragraph. This is a paragraph. This is a paragraph. This is a paragraph. This is a paragraph. This is a paragraph. This is a paragraph. This is a paragraph. This is a paragraph.</p> --- 10,13 ---- *************** *** 19,23 **** <h5>Heading 5</h5> <h6>Heading 6</h6> - <blockquote>This is a Block Quote</blockquote> --- 18,21 ---- |
From: <nan...@us...> - 2003-03-30 04:21:18
|
Update of /cvsroot/mydatabasepilot/MyDatabasePilot/Styles In directory sc8-pr-cvs1:/tmp/cvs-serv32395 Modified Files: master-test.html Log Message: Testing syncmail Index: master-test.html =================================================================== RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/Styles/master-test.html,v retrieving revision 1.1.1.1 retrieving revision 1.2 diff -C2 -d -r1.1.1.1 -r1.2 *** master-test.html 23 Mar 2003 03:44:37 -0000 1.1.1.1 --- master-test.html 30 Mar 2003 04:21:15 -0000 1.2 *************** *** 1,91 **** ! <!--Copyright: MyDatabase Pilot is distributed under the terms of the GNU GPL license--> ! <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> ! ! <html> ! <head> ! <title>Untitled</title> ! <link rel="STYLESHEET" type="text/css" href="master.css"> ! </head> ! ! <body> ! Welcome to Police Ordnance ! ! <p>Paragraph. This is a paragraph. <q>This is an inline quote.</q> This is a paragraph. This is a paragraph. This is a paragraph. This is a paragraph. This is a paragraph. This is a paragraph. This is a paragraph. This is a paragraph. This is a paragraph. This is a paragraph. This is a paragraph. This is a paragraph. This is a paragraph.</p> ! <h1>Heading 1</h1> ! <h2>Heading 2</h2> ! <h3>Heading 3</h3> ! <h4>Heading 4</h4> ! <h5>Heading 5</h5> ! <h6>Heading 6</h6> ! ! ! <blockquote>This is a Block Quote</blockquote> ! ! <a href="bogus page">UnVisited Link</a> ! <br> ! <a href="master-test.html">Visited Link</a> ! <table width="100%" border="0" cellpadding="0" cellspacing="0"> ! <tr class="Head"><td>Header</td></tr> ! <tr class="Odd"><td>Line 1</td></tr> ! <tr class="Even"><td>Line 2</td></tr> ! <tr class="Odd"><td>Line 3</td></tr> ! <tr class="Even"><td>Line 4</td></tr> ! </table> ! <FORM action="http://www.PoliceOrdnance.com/prog/adduser" method="post"> ! This is a Form<br> ! <fieldset> ! <LEGEND>Personal Information</LEGEND> ! <LABEL for="firstname">First name: </LABEL><input type="text" id="firstname" value="Jane"><BR> ! <LABEL for="lastname">Last name: </LABEL><input type="text" id="lastname" value="Smith"><BR> ! <LABEL for="email">email: </LABEL><input type="text" id="email" value="ja...@ao..."><BR> ! <LABEL for="password">Password: </LABEL><input type="password" value="Password"> ! </fieldset> ! ! <textarea cols="30" rows="5" class="ElegantForms">TextArea</textarea><br> ! ! <select name=""> ! <option value="1" selected>Option One</option> ! <option value="2">Option Two</option> ! <option value="3">Option Three</option> ! <option value="4">Option Four</option> ! <option value="5">Option Five</option> ! </select><br> ! ! <SELECT name="ComOS"> ! <OPTGROUP label="PortMaster 3"> ! <OPTION label="3.7.1" value="pm3_3.7.1">PortMaster 3 with ComOS 3.7.1 ! <OPTION label="3.7" value="pm3_3.7">PortMaster 3 with ComOS 3.7 ! <OPTION label="3.5" value="pm3_3.5">PortMaster 3 with ComOS 3.5 ! </OPTGROUP> ! <OPTGROUP label="PortMaster 2"> ! <OPTION label="3.7" value="pm2_3.7">PortMaster 2 with ComOS 3.7 ! <OPTION label="3.5" value="pm2_3.5">PortMaster 2 with ComOS 3.5 ! </OPTGROUP> ! <OPTGROUP label="IRX"> ! <OPTION label="3.7R" value="IRX_3.7R">IRX with ComOS 3.7R ! <OPTION label="3.5R" value="IRX_3.5R">IRX with ComOS 3.5R ! </OPTGROUP> ! </SELECT><br> ! ! ! <fieldset> ! <legend>Special</LEGEND> ! <input type="checkbox" value="" class="ElegantForms"> ! <input type="checkbox" value="" checked class="ElegantForms"><br> ! <LABEL for="male">Male: </LABEL><input id="male" type="radio" name="sex" value="Male" checked> Male<BR> ! <LABEL for="female">Female: </LABEL><INPUT id="female" type="radio" name="sex" value="Female"> Female<BR> ! <input type="button" value="Input Button" class="ElegantFormButton"><br> ! <button class="ElegantFormButton">Image Button</button><br> ! <input type="file" name="File" accept="text/plain" > ! </fieldset> ! ! <fieldset> ! <legend>Form Control</LEGEND> ! <input type="submit" value="Send" class="ElegantFormButton"> ! <input type="reset" class="ElegantFormButton"> ! </fieldset> ! </FORM> ! ! ! </body> ! </html> --- 1,92 ---- ! <!--Copyright: MyDatabase Pilot is distributed under the terms of the GNU GPL license--> ! <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> ! ! <html> ! <head> ! <title>Untitled</title> ! <link rel="STYLESHEET" type="text/css" href="master.css"> ! </head> ! ! <body> ! Welcome to MyDatabase Pilot ! <!--- Testing syncmail ---> ! ! <p>Paragraph. This is a paragraph. <q>This is an inline quote.</q> This is a paragraph. This is a paragraph. This is a paragraph. This is a paragraph. This is a paragraph. This is a paragraph. This is a paragraph. This is a paragraph. This is a paragraph. This is a paragraph. This is a paragraph. This is a paragraph. This is a paragraph.</p> ! <h1>Heading 1</h1> ! <h2>Heading 2</h2> ! <h3>Heading 3</h3> ! <h4>Heading 4</h4> ! <h5>Heading 5</h5> ! <h6>Heading 6</h6> ! ! ! <blockquote>This is a Block Quote</blockquote> ! ! <a href="bogus page">UnVisited Link</a> ! <br> ! <a href="master-test.html">Visited Link</a> ! <table width="100%" border="0" cellpadding="0" cellspacing="0"> ! <tr class="Head"><td>Header</td></tr> ! <tr class="Odd"><td>Line 1</td></tr> ! <tr class="Even"><td>Line 2</td></tr> ! <tr class="Odd"><td>Line 3</td></tr> ! <tr class="Even"><td>Line 4</td></tr> ! </table> ! <FORM action="http://www.PoliceOrdnance.com/prog/adduser" method="post"> ! This is a Form<br> ! <fieldset> ! <LEGEND>Personal Information</LEGEND> ! <LABEL for="firstname">First name: </LABEL><input type="text" id="firstname" value="Jane"><BR> ! <LABEL for="lastname">Last name: </LABEL><input type="text" id="lastname" value="Smith"><BR> ! <LABEL for="email">email: </LABEL><input type="text" id="email" value="ja...@ao..."><BR> ! <LABEL for="password">Password: </LABEL><input type="password" value="Password"> ! </fieldset> ! ! <textarea cols="30" rows="5" class="ElegantForms">TextArea</textarea><br> ! ! <select name=""> ! <option value="1" selected>Option One</option> ! <option value="2">Option Two</option> ! <option value="3">Option Three</option> ! <option value="4">Option Four</option> ! <option value="5">Option Five</option> ! </select><br> ! ! <SELECT name="ComOS"> ! <OPTGROUP label="PortMaster 3"> ! <OPTION label="3.7.1" value="pm3_3.7.1">PortMaster 3 with ComOS 3.7.1 ! <OPTION label="3.7" value="pm3_3.7">PortMaster 3 with ComOS 3.7 ! <OPTION label="3.5" value="pm3_3.5">PortMaster 3 with ComOS 3.5 ! </OPTGROUP> ! <OPTGROUP label="PortMaster 2"> ! <OPTION label="3.7" value="pm2_3.7">PortMaster 2 with ComOS 3.7 ! <OPTION label="3.5" value="pm2_3.5">PortMaster 2 with ComOS 3.5 ! </OPTGROUP> ! <OPTGROUP label="IRX"> ! <OPTION label="3.7R" value="IRX_3.7R">IRX with ComOS 3.7R ! <OPTION label="3.5R" value="IRX_3.5R">IRX with ComOS 3.5R ! </OPTGROUP> ! </SELECT><br> ! ! ! <fieldset> ! <legend>Special</LEGEND> ! <input type="checkbox" value="" class="ElegantForms"> ! <input type="checkbox" value="" checked class="ElegantForms"><br> ! <LABEL for="male">Male: </LABEL><input id="male" type="radio" name="sex" value="Male" checked> Male<BR> ! <LABEL for="female">Female: </LABEL><INPUT id="female" type="radio" name="sex" value="Female"> Female<BR> ! <input type="button" value="Input Button" class="ElegantFormButton"><br> ! <button class="ElegantFormButton">Image Button</button><br> ! <input type="file" name="File" accept="text/plain" > ! </fieldset> ! ! <fieldset> ! <legend>Form Control</LEGEND> ! <input type="submit" value="Send" class="ElegantFormButton"> ! <input type="reset" class="ElegantFormButton"> ! </fieldset> ! </FORM> ! ! ! </body> ! </html> |
From: NanoFace <nan...@po...> - 2003-03-30 03:57:42
|
Testing :-) |