patched L::L::DBIxSimple to handle omiholders and placeholders in same query; new dbix-simple.t to test it; moved loop queries to data-maps in activity_data.pl; replace pipe-delimited file with xl file in gallium data for quintiles
replaced M::Request::get_request_from_lab_number() method using multiple db lookups with get_request_id_from_lab_number() using single db lookup
13 years ago
README.txt
Contents:
debug.txt - contains debugging information; opened in overwrite mode ('>') per request
debug.log - contains debugging information; opened in append mode ('>>'); rotated using log_rotate.pl (count => 3)
sql.txt - contains SELECT query statements from application in production mode; opened in append mode; rotated using log_rotate.pl (count => 3)
dev_sql.txt - contains SELECT query statements from application in development mode; rotated using log_rotate.pl (count => 3)
{yyyy_mmdd}_sql.log - contains UPDATE/INSERT/DELETE statements from application in production mode; archived in /old daily using log_rotate.pl
dev_sql.log - contains UPDATE/INSERT/DELETE statements from application in development mode; rotated using log_rotate.pl (count => 3)
file ownership:
sql.txt 666 raj:raj
debug.log 666 raj:raj
dev_sql.log 644 raj:raj
dev_sql.txt 644 raj:raj
yyyy_mmdd_sql.log 666 www-data:www-data
