P3X GitList

January 21, 2018

Browse Changes

move arg to dump query from sam_query() to dbix constructor

13a67dcf87a47883ac17c5dce70ea1ccb9cda848 13a67dc

RAJ authored on 21/01/2018 20:48:08

January 19, 2018

Browse Changes

document retention of NO_QUERY_LOGS for legacy scripts * rearrange order for Komodo source-tree

d5a94c0545ccf80794c19251112fd13b657faaa3 d5a94c0

RAJ authored on 19/01/2018 11:38:22

January 17, 2018

Browse Changes

interim commit

9fa88c52d66e6117f5e5fb92e2152db831b88f6a 9fa88c5

RAJ authored on 17/01/2018 10:15:33

October 4, 2017

Browse Changes

adapt _mysql_connection_params() to accept optional port arg

51cf60a6b78a50314b6aaea2a3964d9e62e2a046 51cf60a

RAJ authored on 04/10/2017 11:21:12

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