P3X GitList

February 17, 2017

Browse Changes

bugfix - taking vars from @_ does not remove them so 'shift' gets 1st element

b474b5dcf990788fbfeb724cb30287d6e7b88c00 b474b5d

RAJ authored on 17/02/2017 12:44:14

February 15, 2017

Browse Changes

moved DB::dump_query to Local::Utils for sharing with LIMS::Local::DBIxSimple; new DB method insert_or_update_if_greater()

ba3e9978bbe2a41eb365240927d686e62227c05f ba3e997

RAJ authored on 15/02/2017 15:08:52

January 30, 2017

Browse Changes

update_or_insert method for Local::DB - uses SQL::Abstract insert() and appends ON DUPLICATE KEY

1e772c747c32045728360e74bbef379d3f65cead 1e772c7

RAJ authored on 30/01/2017 13:54:52
Browse Changes

new function to map_hashes but with addition of index key as part of hashref - ie does not delete index key unlike map_hashes()

e87c97391d84be4a86c27a55461e0fbed65c6b1c e87c973

RAJ authored on 30/01/2017 11:24:21

December 10, 2016

Browse Changes

QueryLogger uses D2-app /logs dir, even if script called from elsewhere via .cgi script - was creating logfiles relative to calling script, so cgi-bin needed symlink to logs dir

ae2fdb6e698a5402d892a7170001c64b15db7551 ae2fdb6

RAJ authored on 10/12/2016 15:38:19

November 25, 2016

Browse Changes

new methods dump_query, clone and math_sum; added DBIx::Simple::OO to allow ->objects call

a48d9f615f0950c8b01ab154429ef5efb01395b2 a48d9f6

RAJ authored on 25/11/2016 12:08:13

May 18, 2016

Browse Changes

patched _autoinflate_dates() to handle zero values (ie false but still defined)

f2b9357affb819b734d2021d7a915d824c657999 f2b9357

RAJ authored on 18/05/2016 22:29:36
Browse Changes

new methods DB::get_cols & InsertMulti::insert_ignore_multi & InsertMulti::update_or_insert_multi

2feb71e7a66010f95488b1d8a0f277e0ae9a0e2d 2feb71e

RAJ authored on 18/05/2016 14:48:46

May 11, 2016

Browse Changes

new SQL::Abstract plugin to provide insert_multi function - will be ported to role; more functions for Utils

5cf7da925821e92297ba4d3d990e0f2c5a3d4e40 5cf7da9

RAJ authored on 11/05/2016 16:38:09

February 24, 2016

Browse Changes

setting $Local:DB::NO_LOG_QUERIES true was preventing sql trace output in QueryLogger::log_query so moved it to QueryLogger to take effect on dispatcher log() command; new Utils::datetime_to_string method + test file

4f2f559c5213cc5d5b1be934fdf8e924dcec199a 4f2f559

RAJ authored on 24/02/2016 17:17:52

February 17, 2016

Browse Changes

new vars ::DB::NO_QUERY_LOGS to suppress query logging & ::DBIx::Simple::Result::STRINGIFY_DATETIME to return datetime string rather than object

479fc3200ec38036f8339f36089ae3908b165dcb 479fc32

RAJ authored on 17/02/2016 13:03:53

February 16, 2016

Browse Changes

added row(), column() & value() methods to DBIx::Simple::Result & DBIx::Lite::ResultSet

c9ae992986d3b3952d00565afbd40cb31a1b70fa c9ae992

RAJ authored on 16/02/2016 10:03:00

February 15, 2016

Browse Changes

added hash() and array() to Local::DBIx::Simple::Result to return in list or scalar context - original only returned scalar ref, and to inflate dates in array()

d2825eb8bce6ce86bf3fe4f7106905925200355d d2825eb

RAJ authored on 15/02/2016 09:25:22

February 9, 2016

Browse Changes

corrected error in single-apostrope escape

75f6c94032aaa24af5ce98e7bd031b7f2239cc96 75f6c94

RAJ authored on 09/02/2016 22:45:49
Browse Changes

new XMLSimple to add single-apostrophe escaping lacking in original

bb8c5cec5ea64a8c1ed1f4249ff9914cb58803c0 bb8c5ce

RAJ authored on 09/02/2016 16:57:54