Thank you Josh! The plan sounds good to me since there are actually lot of code changes and its important we document that correctly.
I have a suggestion that while we are waiting for that , there are few things I need access to: There are some set of default images in database image table. I wanted to initiate the process of making a reservation on any one of those images. I needed that to test New reservation, Block reservation. So, in case there is any captured image which is used by VCL for testing purposes please let me know.This would in turn also need some computer table entries too. Overall, I would be needing some additional test data for me to test all the php files. Please let me know what can be done on that! Also I have submitted the ICLA form http://www.apache.org/licenses/#clas. Please let me know if there is anything else I am supposed to do! Any suggestions are welcome! On Tue, Jun 1, 2010 at 11:27 AM, Josh Thompson <josh_thomp...@ncsu.edu>wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Kiran, > > Wow - that's a lot of changes. We're in need of more committers, and it > sounds like you've done a lot of work already. So, this could be very > beneficial. > > As I read this, I realized we (the Apache VCL community) don't have any > guidelines in place for contributing modifications that affect large > portions > of the code. I just composed another message to this list titled > "guidelines > for contributing large modifications" to establish some guidelines. > > Before discussing your contributions further, lets wait on that process to > get > worked out so that this can be contributed in a way that most benefits the > community. > > Thanks, > Josh > > On Friday May 28, 2010, Kiran N wrote: > > Hello All, > > I have been studying VCL code and I want to be a contributor to the VCL > > development. I will identify my work as related to JIRA issue VCL-202(in > > database) started by Milen Paskov. There are few things I have been > working > > on and would like to share here. > > > > - Modified vcl.sql script to connect to Apache derby database and > create > > the database with the tables and data as in mysql. Please find the > > vcl-derby.sql attached with this email. > > - I have been working on the PHP front end code so that it can connect > > to both mysql and Apache derby database. I am not sure if I need to > > contibute to this by creating a new JIRA issue number. Please advise on > > this. - Regarding changes to the PHP front end, I have coded a new > > 'param.php' file which changes the database data fetch or update > > statements based on the type of database. I also assigns/creates some > > global variables. As stated in JIRA issue VCL-202 , there are certain > > keywords ('user', 'end', 'order' and 'key')which cannot be used as > > database columns or table names in derby , I have created global > variables > > which store the values of these keyword based on mysql/derby. > > - Apart from this in the code there are some small changes like > > DATA_FORMAT() , UNIX_TIMESTAMP() functions is not recognized in derby. > > So they have been changed accordingly. I am working on a document to > > provide the complete list of changes between mysql and derby from the > PHP > > front end code perspective. > > - Regarding connecting PHP to Apache derby, db2 runtime client with > > ibm_db2 extension is used. PDO_ODBC is the data access interface for > PHP > > which compiles directly against DB2 librraries for native access to > DB2. > > PHP is complied with ibm_db2 extension and configured accordingly. > Please > > refer to below links for better understanding. > > > > References: > > http://coffeecode.net/uploads/talks/phptropics-ibm_db2.pdf > > http://www.db2ude.com/?q=node/81 > > > > I am working on providing more explanatory documents which would help > doing > > the setup for testing and checking the connection of PHP with derby but > > this is the initial idea that i shared. Presently, I have done the setup > > and working on the PHP front end code. I will be sharing that also with > > you probably sometime next week. > > Please provide me feedback and suggestions on this! Let me know for any > > questions. > > > - -- > - ------------------------------- > Josh Thompson > Systems Programmer > Advanced Computing | VCL Developer > North Carolina State University > > josh_thomp...@ncsu.edu > 919-515-5323 > > my GPG/PGP key can be found at pgp.mit.edu > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v2.0.14 (GNU/Linux) > > iEYEARECAAYFAkwFJs8ACgkQV/LQcNdtPQOqdACffPjcOW3GrgtDVDSdV27eGo4b > LIkAn1MJDxt2QWodgoYYK6ny3MMdwghu > =FrTq > -----END PGP SIGNATURE----- > -- Thanks, Kiran