2.8 Implement a "test" feature to test the modules for all languages so that a known input will have a known output which the functions should return. Only for modules which return data and don't so anything else (like send out email). 2.6 ??? a. Perl and PHP web interfaces of the command script for GUPPS. b. Perl and PHP versions of the line command script. 2.4 ??? 1. Web interface in Python for GUPPS. 2.2 ??? 1. Admin webpages in Perl, PHP, Python. a. Add, change, delete database, tables, sequences. 2. Add Oracle and MySQL connectivity to all languages. 2.1 ??? 1. Use PostgreSQL 7.3 where it can create stored procedures which return multiple rows with multiple fields. 2. Create stored procedures which will return one row of data based on the tablename and primary id. 3. Create Perl, Php, and Python methods which will grab one row of information from a table and also get all rows of data which depend on this table. Two optional arguements will be how deep the recursion goes and if only a specific set of tables can be used. If you specify a table which isn't depedent upon it, it just ignores that table. If you specify a table and a level of recursion, the table may not be included if it is too deep. For these two cases just record silent errors. Add 3rd option which will blow up if any silent errors occur. 2.0 ??? Will be a tested version of 1.5 where 1. All perl, python, and php modules have the same core functions. All capitalzied functions need to be in all 3 languages. 2. Python will be used for GUPPS, and the Perl script will be disabled. 7-21-2002 3. Create a retore and restoreone functions to update all data in a table which is non-purged. Only restore is the date_updated is different than date_updated in table. #---------------------------------------------------------------- Wrap up all issues below before moving on. 4-15-2003 Outstanding issues are: a. Xml for all languages b. Blowfish for all languages c. uudecode, binhex, etc misc converting functions for all langugages. Convert_Html, Clean_String d. Make sure modules match each other and note which methods are unique to a language. e. Check on mail capabilities for python, perl, and php f. Have postgresql execute a stored procedure for all languages where you specify a table, start no, and end no, and it returns all the primary ids that match. Also, verbose option to return all data, or supply fields that need to be returned. g. Create test scripts to test perl, python, and php so that the Encryption and Converting methods are interchangeable. Also, test scripts for XML and other methods. List which methods are being tested. 1.6 beta ??? Read definitions of tables from xml files. 1.5 beta ??? Implement many of the mcrypt functions for Php, Perl, and Python. Save into a Encrypt module for each language. Implement Xpat XML for Php, Python, and Perl. Python - DONE for xpat. 5-14-2003 Perl - Done with xpat. 6-22-2003 Create XML modules for Php and Python also. 1. Just the validation module for dtds. 2. Parse xml documents into hashes like the current perl module does. Use XPAT as a base. -- done with Perl and Python. Php will will be done, but no validation. Test all current modules/functions for Perl, Python, and PHP for 1.3beta before doing 14.beta. Test and implement all the sample scripts for Perl, Python, and PHP. -- 7-21-2002 Added BLowfish for Python -- 5-14-2003 1.4beta 7-5-2002 Created a simple install program to choose Python, PHP, or Perl as the script you want to run. Currently, only Python is fulyl implemented. 7-3-2002 Will convert Create_Functions.pl to GUPPS.py -- Mark -- 7-4-2002 Break out all functions into modules for the line command Python script so that TK and web versions can be made from the modules. -- 7-4-2002 Finish the "pgsql" functions. One or two of them aren't done. 7-4-2002 Created methods and table to manipulate only one field in a table. 7-4-2002 1.3beta 4-11-2002 NOTE: Not every module/function has been tested in Perl, Php, and Python in the Misc module. The Php ones might not even parse right. Create XML methods for Perl --- Mark 4-1-2002 1. DTD Validation Perl has persistent database connections with/out mod_perl -- 4-08-2002 Php level 4 with gzip, uuencode, and zip -- 4-10-2002 1. Uudecode, Binhex, don't work. Until noted further, this and file options are not included. 2. Need to finish Convert_Html and Clean_String 4-11-2002 for it to really be done. 1.2beta testing 3-17-2002 Added Gzip, uuecncode, and zip to Perl -- compliant with new level 4. -- 3-16-2002 Added plpython, plpgsql, and "blank" options -- 3-16-2002 for general functions for postgresql. -- 3-16-2002 Added default to only change functions for table and not alter the table, views, sequences except if you issue "ALL" command. -- 3-16-2002 Added checks for timestamp, varchar, char, and numeric when data gets "cleaned". -- 3-16-2002 Python at level 4 with gzip, uuencode, and zip, and blowfish -- 3-17-2002 1. Until further noted, does not have file options like Perl. Programming Languages: 1. Perl = Level 4. -- 3-17-2002 (new level 4) 2. Python = Level 4 -- 3-17-2002 (new level 4) 3. Php = Level 3 -- has all modules necessary for level 4 in main source code or modules I grab from the net. Now I just have to create the modules for them as a wrapper. 1.1beta 2-05-2002 Added sample Python scripts -- Mark Nielsen -- 12-13-2001 Added Python Modules -- Mark Nielsen -- 12/12/2001 Added sample Php scripts -- Mark Nielsen -- 2-05-2002 Added php Modules -- Mark Nielsen -- 12/15/2001 Programming Languages: 1. Perl = Level 4. 2. Python = Level 3 -- 2/5/2002. 3. Php = Level 3 -- 2/5/2002. 1.0 10/2001 Creates tables, stored procedures, foriegn key constraints, Perl Modules, and sample Perl scripts. Original programming all done by Mark Nielsen. Programming Languages: 1. Perl = Level 4.