Commit Graph

248 Commits

Author SHA1 Message Date
Timothy Warren 2465941fdf Skip Postgres tests if the class isn't loaded 2014-02-17 19:12:53 -05:00
Timothy Warren fa3c3efb38 Move phpunit xml file into a sane place 2014-02-17 17:07:17 -05:00
Timothy Warren a443bbc86d Fix Firebird loading issue for tests 2014-02-14 22:52:56 -05:00
Timothy Warren fabedc1d7f Add include for Firebird class so that testsuite works 2014-02-14 22:30:28 -05:00
Timothy Warren 8da96c7c2f Another go 2014-02-14 22:27:01 -05:00
Timothy Warren 5125ac4e31 Convert test suite to use PHPUnit 2014-02-14 22:08:19 -05:00
Timothy Warren 4cb7c97c60 Minor query formatting changes 2014-02-14 10:38:25 -05:00
Timothy Warren bed0d1bb04 Improve code coverage 2014-02-11 14:29:41 -05:00
Timothy Warren d4e99aa5cd Test and doc updates 2014-02-07 16:53:01 -05:00
Timothy Warren 7c0b951539 More firebird coverage 2014-02-07 15:43:25 -05:00
Timothy Warren 29f824b562 Reorganize sqlite tests and improve coverage 2014-02-07 14:18:08 -05:00
Timothy Warren 1e31196dee Add another test and try again 2014-02-06 17:07:29 -05:00
Timothy Warren c07a4fcf14 Update sqlite test for explain, attempt firebird tests on Travis CI 2014-02-06 16:48:52 -05:00
Timothy Warren 8d7b73a9a3 Tracking down a test bug for sqlite 2014-02-06 16:15:23 -05:00
Timothy Warren 8dc2079d43 Add `explain` method to query builder 2014-02-04 20:59:30 -05:00
Timothy Warren 73d6e72afc Improve test coverage of sql driver 2013-12-09 20:11:49 -05:00
Timothy Warren 4678e289aa 100% coverage of Query Builder class, remove some undocumented/unused code. 2013-12-09 19:46:34 -05:00
Timothy Warren 7397b95e8b Fix broken tests 2013-12-06 23:37:43 -05:00
Timothy Warren c53024ae6a Fix some issues with the grouping commands, and greatly expand test coverage 2013-12-06 23:00:32 -05:00
Timothy Warren 6dfb94b375 supress stupid error on bad connection test 2013-05-29 14:06:09 -04:00
Timothy Warren 9578e43722 set error mode in pdo constructor 2013-05-29 13:57:08 -04:00
Timothy Warren cd338e5aea update tests
Assume mysql is installed rather than postgres. Sqlite can not be
assumed because it will create a database if none exists.
2013-05-29 12:23:49 -04:00
Timothy Warren f6bfe414e6 Add insert batch as a function to overwrite in drivers 2013-05-03 13:07:34 -04:00
Timothy Warren 4ee865ac6d Remove insert batch, as it only works for MySQL and Postgres 2013-05-02 12:51:53 -04:00
Timothy Warren c4ec46eae4 Fix sql tests? 2013-05-02 11:59:43 -04:00
Timothy Warren 40c76b2653 Changed invalid methods to return NULL instead of FALSE, added insert_batch 2013-05-01 15:59:23 -04:00
Timothy Warren 842b4b5fd4 Fixed bug with handling functions in select 2013-04-25 08:15:56 -04:00
Timothy Warren 6959b614ab Better query logging 2013-02-28 12:22:55 -05:00
Timothy Warren e10eebb302 Removed object references 2013-02-07 16:21:02 -05:00
Timothy Warren 0e44bbaf0d Update year 2013-01-02 14:26:42 -05:00
Timothy Warren 785e5f2e1f Add interfaces 2012-12-18 16:19:52 -05:00
Timothy Warren 5a626629d7 Enable Query() function as a alias function 2012-11-08 20:02:31 -05:00
Timothy Warren 6875de3e7c Create query() method to handle database connections instead of Query_Builder class 2012-11-08 14:28:49 -05:00
Timothy Warren 47d493537e Remove some extra recursion and explicitly call more methods 2012-11-07 20:48:15 -05:00
Timothy Warren 60d5d99ee3 Fix test prefix 2012-11-07 08:46:04 -05:00
Timothy Warren 5ca46798ca Misc typo fixes, fixes #4' 2012-11-07 08:42:34 -05:00
Timothy Warren 6ecfb40c87 More cleanup/ refactoring 2012-10-31 20:21:15 +00:00
Timothy Warren 9078e19961 Documenation update and more fat trimming 2012-10-30 16:14:57 +00:00
Timothy Warren 3de38cd953 Some refactoring to eliminate some redundancy 2012-10-30 14:37:32 +00:00
Timothy Warren ee6f946782 Fix out-of-order where/set statements 2012-10-25 00:19:39 +00:00
Timothy Warren b1624e2f95 Remove more references, and update README 2012-10-23 13:40:11 +00:00
Timothy Warren 27318506d0 Fix num_rows() method 2012-09-27 17:41:29 +00:00
Timothy Warren 10de783b14 Fix contributing file, beginning of prefixes 2012-09-25 17:16:36 +00:00
Timothy Warren 13a37e10f2 Remove some references, and add autoload parameter to composer.json 2012-09-25 14:16:01 +00:00
Timothy Warren 559f3ab13a Update readme and added 'get_compiled_' methods to query builder 2012-09-13 15:44:57 +00:00
Timothy Warren 92c989e6f8 Add array of executed queries 2012-09-12 13:55:04 +00:00
Timothy Warren 4c546ed3e9 Fix issue with Query_Builder->where_in() method 2012-08-24 16:17:08 +00:00
Timothy Warren a4f730b081 Fixed issue with multiple fields in order_by, removed extranious spaces in SQL generation 2012-08-23 01:17:27 +00:00
Timothy Warren 90c6760196 Parsed join conditions fixes #2 2012-08-09 16:15:36 +00:00
Timothy Warren 6a89b48fe8 Beginning of query parser 2012-08-02 15:59:11 +00:00
Timothy Warren 091484785f Fix new test 2012-07-27 16:08:55 +00:00
Timothy Warren 9d8d07958f Minor tweaks to exceptions 2012-07-27 16:05:29 +00:00
Timothy Warren d9a4b5fbe5 Added exception for invalid drivers 2012-07-26 17:21:24 +00:00
Timothy Warren 6e76493562 Add composer.json file 2012-07-17 14:45:52 -04:00
Timothy Warren 1e71b225c5 Make mysql/postgres drivers compatible with Quercus 2012-07-05 14:19:49 -04:00
Timothy Warren 7649f75cac switch from pdo_drivers to PDO::getAvailableDrivers 2012-07-03 13:00:17 -04:00
Timothy Warren 78c10d0825 Update docs 2012-06-05 15:06:23 -04:00
Timothy Warren 121dfd1401 Remove unrelated classes and tests 2012-05-31 09:48:17 -04:00
Timothy Warren 2b0d1c207e Fix CI tests 2012-05-29 16:34:45 -04:00
Timothy Warren 35b21c31a5 Adjust autoloader 2012-05-29 14:52:27 -04:00
Timothy Warren 2c67dd03cc Set up autoloader 2012-05-21 15:18:06 -04:00
Timothy Warren 257609168e implemented mysql backup methods 2012-05-15 13:35:59 -04:00
Timothy Warren f555b179b4 Optimize foreach loops: 2012-05-14 13:33:41 -04:00
Timothy Warren bf3b072124 change db_filter function to use less memory 2012-05-14 12:34:12 -04:00
Timothy Warren 3da9cd9c19 Added more meta-information methods, with tests 2012-05-09 13:54:38 -04:00
Timothy Warren eb5d30ab21 Improve 'type_list' methods 2012-05-08 15:37:36 -04:00
Timothy Warren db1490c016 Partially implement type_list method 2012-05-08 08:31:57 -04:00
Timothy Warren e4acfda004 Add list_types abstract method to db_sql class 2012-05-07 16:05:51 -04:00
Timothy Warren 942d21a1b8 Fix tweaks 2012-05-02 12:59:52 -04:00
Timothy Warren dcdf581998 Database connection tweaks 2012-05-02 12:53:34 -04:00
Timothy Warren 31ba0881ea Remove echoing of sql statements 2012-05-01 14:19:34 -04:00
Timothy Warren 790e82729e Improve Quote_ident method of DB_PDO, fixes #3 2012-05-01 14:16:03 -04:00
Timothy Warren 1a4fd0a9af More query builder optimization 2012-05-01 13:45:11 -04:00
Timothy Warren f43e3c7ccf Remove uneeded sqlite file 2012-04-30 16:08:49 -04:00
Timothy Warren dc0a8b7bc1 More method simplification 2012-04-30 16:06:06 -04:00
Timothy Warren 008e65a872 Simplifiy select_ methods 2012-04-30 15:29:45 -04:00
Timothy Warren cd3255a8a2 Various Query Builder improvements 2012-04-30 14:49:30 -04:00
Timothy Warren baad919dca Fix logic error and update docs 2012-04-30 14:29:22 -04:00
Timothy Warren b9e2dc46c9 Streamline a few query builder methods 2012-04-30 14:22:27 -04:00
Timothy Warren 9acb171729 Fix firebird tests 2012-04-24 14:03:54 -04:00
Timothy Warren 38aadabc9b Test formatting cleanup 2012-04-24 14:00:44 -04:00
Timothy Warren 1849e2d6a8 Misc tweaks 2012-04-23 13:28:49 -04:00
Timothy Warren 8fc9a7295d Firebird fixes, moved num_rows() method to db_pdo class 2012-04-20 16:33:40 -04:00
Timothy Warren b4c22c59e3 Revert "Extend stdClass for the sake of it"
This reverts commit 5e7a5b53b0.
2012-04-20 15:36:26 -04:00
Timothy Warren 5e7a5b53b0 Extend stdClass for the sake of it 2012-04-20 15:25:25 -04:00
Timothy Warren 62a7eaf73d Add package docblock options 2012-04-20 13:17:39 -04:00
Timothy Warren 845e0fee08 Added class reference in docs folder, improved comment consistency in classes 2012-04-19 11:42:50 -04:00
Timothy Warren 698837dd02 Implemented backup data methods in mysql and pgsql drivers 2012-04-19 08:59:10 -04:00
Timothy Warren 5d5588c909 Various tweaks 2012-04-18 16:28:12 -04:00
Timothy Warren 12f53c5fd5 Split off db_util classes for each driver 2012-04-18 15:53:06 -04:00
Timothy Warren 5a4f6a3455 Add fetchObject method to Firebird_result class 2012-04-18 11:34:24 -04:00
Timothy Warren 3c74f243fe Implement more of PDOStatement in Firebird_Result class 2012-04-18 10:39:01 -04:00
Timothy Warren f03afaa98b Made Firebird_Result class Extend PDOStatement 2012-04-17 16:57:28 -04:00
Timothy Warren 16ad8b15d0 Remove pointless ODBC tests 2012-04-17 15:05:36 -04:00
Timothy Warren bf162323f0 Implemented 'having' and 'or_having' methods 2012-04-17 14:22:51 -04:00
Timothy Warren 902b6b7cb3 Implemented count_all_results method in Query Builder 2012-04-17 11:37:39 -04:00
Timothy Warren 1211ed6347 Update system table method for postgres 2012-04-17 10:56:08 -04:00
Timothy Warren 66c21338d0 More accurate method of listing tables for postgres 2012-04-17 10:49:38 -04:00
Timothy Warren f7d18b19fd Added count_all method to query_builder 2012-04-17 08:29:28 -04:00
Timothy Warren 49503dfb3d Start of last unimplemented methods 2012-04-16 13:43:41 -04:00
Timothy Warren 138e236673 Fix mysql get_system_tables method 2012-04-16 10:53:28 -04:00
Timothy Warren c4a67e3a1b fix syntax error 2012-04-13 17:39:24 -04:00
Timothy Warren 9b9ea5aeed Added 'distinct' method to query builder 2012-04-13 16:50:05 -04:00
Timothy Warren ebe1b1a647 Rearrange tests, add Settings class tests 2012-04-13 13:48:38 -04:00
Timothy Warren e745750eca Update test paths 2012-04-13 13:16:48 -04:00
Timothy Warren 272dfd62d4 Implement select_max, select_min, select_avg, and select_sum methods in query builder 2012-04-13 12:49:13 -04:00
Timothy Warren 15e7ef0832 Added 'get_where' method to query builder
Also added prep work for select_* methods
2012-04-13 11:53:11 -04:00
Timothy Warren 9a34fcffb2 Minor filestructure re-arrangement 2012-04-12 13:44:31 -04:00
Timothy Warren b6d6f06ae5 Fix test loading 2012-04-11 11:53:18 -04:00
Timothy Warren de34e24325 rearranged tests 2012-04-11 11:48:56 -04:00
Timothy Warren d1ff8d2690 Fix mysql tests 2012-04-10 14:14:31 -04:00
Timothy Warren 71eca1986d fix tests 2012-04-10 14:13:08 -04:00
Timothy Warren 86fe790f28 Reorganize drivers 2012-04-10 14:06:34 -04:00
Timothy Warren 76b522f0bd Made get_dbs method abstract 2012-04-03 16:54:33 -04:00
Timothy Warren 24ce87ca08 Added __call method to query builder 2012-04-02 09:40:16 -04:00
Timothy Warren d97312519f Multiple php version tests? 2012-03-23 09:34:29 -04:00
Timothy Warren 554d666430 Remove echo statement 2012-03-22 16:48:09 -04:00
Timothy Warren 6974a04ffd fix pgsql tests 2012-03-22 16:46:47 -04:00
Timothy Warren 6c932bf576 Fix postgres tests? 2012-03-22 16:38:07 -04:00
Timothy Warren 2355ca3b0d getenv? 2012-03-22 16:33:28 -04:00
Timothy Warren 514ed88f71 getenv? 2012-03-22 16:28:31 -04:00
Timothy Warren a75efa93f1 Lets try posgres 2012-03-22 16:26:17 -04:00
Timothy Warren 18489b4302 Connect with default username/pass if running on Travis 2012-03-22 16:19:36 -04:00
Timothy Warren 632427e164 The type is important\! 2012-03-22 16:14:36 -04:00
Timothy Warren 69995baa6d It connects, right? 2012-03-22 16:12:54 -04:00
Timothy Warren 3991dbc6a4 Query builder mysql tests 2012-03-22 16:10:12 -04:00
Timothy Warren 8e6619bda5 Attempt with mysql 2012-03-22 15:59:03 -04:00
Timothy Warren 94758ecfb5 Fix other path issue 2012-03-22 15:47:31 -04:00
Timothy Warren 4193f858c9 Fix test paths 2012-03-22 15:43:44 -04:00
Timothy Warren d6718b5973 Include simpletest for Travis 2012-03-22 15:17:12 -04:00
Timothy Warren 4a581b5617 Start of CI config 2012-03-22 15:07:27 -04:00
Timothy Warren 09f6a249d8 Updated readme with link to php.net 2012-03-19 23:46:00 -04:00
Timothy Warren 11d8ca1520 Update dREADME 2012-03-19 17:07:54 -04:00
Timothy Warren 25e278df64 Don't run tests on databases that don't exist 2012-03-19 14:36:57 -04:00
Timothy Warren 34bb867575 Minor test cleanup 2012-03-19 14:30:13 -04:00
Timothy Warren 9ed4accc54 Removed query statement output 2012-03-19 13:58:14 -04:00
Timothy Warren 58719d6ab5 Made db tests less redundant 2012-03-19 13:38:49 -04:00
Timothy Warren 0c82208694 Autoloader, and beginning of simplified testing 2012-03-19 13:24:36 -04:00
Timothy Warren 532cecf8a2 Changed Firebird_Result::execute to use the same instance 2012-03-19 12:14:31 -04:00
Timothy Warren 23538b5c9c Rename firebird driver file 2012-03-19 12:08:52 -04:00
Timothy Warren ec0269a78b Fixed mis-spelled constant name 2012-03-19 12:00:32 -04:00
Timothy Warren c024e4a5fc Added postgres tests 2012-03-19 10:40:16 -04:00
Timothy Warren 1178b5704d Fix mysql create_table method 2012-03-15 16:12:20 -04:00
Timothy Warren 0567c3443f Merge branch 'master' of github.com:aviat4ion/Query 2012-03-15 15:46:49 -04:00
Timothy Warren 2f4dfd9d9e Added mysql tests 2012-03-15 15:46:04 -04:00
Timothy Warren a304ffd134 Overhaul firebird driver to better match PDO interface. 2012-03-15 14:09:45 -04:00
Timothy Warren 39d70bf808 Updated README, updated query_builder class to accept an array as well as an object 2012-03-15 12:02:26 -04:00
Timothy Warren da107cf6e3 Initial Commit 2012-03-15 09:25:18 -04:00