P3X GitList

Raw Blame View

June 3, 2019

Browse Changes

new DB function get_tables

5ff9cca8684dc4378f5493989edfcc27a4077e2f 5ff9cca

RAJ authored on 03/06/2019 11:49:21

May 15, 2019

Browse Changes

QueryLog - apply new-lines to comma-seperated list only for SELECT vars (makes mess of INSERT's); add 'VALUES' to list of keywords for formatting

f8b6a7829cca28eec4af365ab34482dbe390633b f8b6a78

RAJ authored on 15/05/2019 16:33:34
Browse Changes

QueryLog - substitute placeholders in query * output still formatted manually since SQL::Abstract::Tree new-lines ORDER BY inside a GROUP_CONCAT, and doesn't separate SELECT fields into new-lines

c842778c53b1a38317e058be7c60b74b505904ab c842778

RAJ authored on 15/05/2019 14:05:53

April 24, 2019

Browse Changes

remove DBIx::Simple::OO - not required, parent support ->object(s) anyway

7db392777b78e9ed61be6670233ce21f8c11c1cb 7db3927

RAJ authored on 24/04/2019 11:54:01

April 23, 2019

Browse Changes

method for external calls to _replace_omniholder; replace self->{dbd} with self->dbh->{Driver}{Name}

68ac7f3ff5d1d48be402300fdec1461b8780cbeb 68ac7f3

RAJ authored on 23/04/2019 17:50:22

March 27, 2019

Browse Changes

adapt Local::DB::_mysql_connection_params to handle remote db connection using username & password

71b9ff3554dcf63399f4e70d6628742328d7b08b 71b9ff3

RAJ authored on 27/03/2019 13:13:42

March 5, 2019

Browse Changes

change 'SHOW COLUMNS' data type from hash to array so lc_columns() setting doesn't matter (ie hash key = field or Field)

e3e20c8d9c0945a465faa0f821a951495e3b9b2d e3e20c8

RAJ authored on 05/03/2019 17:36:31

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

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