P3X GitList

Raw Blame View

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

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

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

January 25, 2016

Browse Changes

added new functions in Utils; corrected syntax in debugging section of DB

4358fb1a4749464fe5ec2966a57151a16f210ba9 4358fb1

RAJ authored on 25/01/2016 14:47:18

October 10, 2015

Browse Changes

new DB::count() sub; Paginator takes siblings arg; QueryLogger formats LIMIT & OFFSET in sql

150d0fe88255a47af1142623c5ffbd6f02312b0d 150d0fe

RAJ authored on 10/10/2015 14:15:48

August 25, 2015

Browse Changes

replaced Log::Dispatch::File::Rolling with Log::Dispatch::File for deployment since LDF::Rolling creates redundant file and doesn't handle file permissions properly, and file rotation handled by cron anyway; added today() to Local::Utils

edc628ee28a467661d77bd63ceded50045ffaa79 edc628e

RAJ authored on 25/08/2015 11:48:07

August 24, 2015

Browse Changes

moves all query logging functions to QueryLogger

ff1201cd61d48e1515175f0395584c008807ab6b ff1201c

RAJ authored on 24/08/2015 16:21:17
Browse Changes

branched for query-log testing

cead34fc74eba6bca66fb4ba8bac6c94460c22d0 cead34f

RAJ authored on 24/08/2015 14:33:51

August 17, 2015

Browse Changes

added method to Local::DB to auto-inflate date(time)s, can be suppressed using var NO_AUTO_DATE_INFLATION set in calling class

94ea903b1fe8659026cb5cec74253c1a1544fd1e 94ea903

RAJ authored on 17/08/2015 11:45:59