ed347e841a
verticalslice and reindex cleanups and tests
Sergey Tsalkov2012-09-20 20:50:05 -07:00
2ffb770f8a
bugfix: don't fail when inserting multiple rows at once, and one of the values is NULL
Sergey Tsalkov2012-09-19 14:58:09 -07:00
ed9c29fe49
add DB::transactionDepth() for checking how many transactions are active when not using nested transactions, will return 1 or 0
Sergey Tsalkov2012-09-18 21:08:28 -07:00
9a41bf34a1
a few nested transaction cleanups functionality for committing/rolling back all active transactions
Sergey Tsalkov2012-09-18 20:54:39 -07:00
24c1b930df
add DBHelper class with functions verticalSlice and reIndex
Sergey Tsalkov2012-09-18 20:13:43 -07:00
1d5844bcc0
major redesign to enable multiple instances via "new MeekroDB()" while preserving full backwards compatability
Sergey Tsalkov2011-12-24 16:12:13 -08:00
80cc78edcd
insertUpdate() can now handle a second array for the update component, or nothing, so it'll re-use the insert array for the update component
Sergey Tsalkov2011-09-23 21:29:40 -07:00
5050205e58
add insertUpdate() function for "insert ... on duplicate key update" behavior
Sergey Tsalkov2011-09-23 19:15:41 -07:00
9f3aa571dc
add some simple tests for the WhereClause system, which will now be official and documented
Sergey Tsalkov2011-09-23 18:44:34 -07:00
164c7157a6
queryRaw() will now be officially supported, returns mysqli_result instead of array of assoc arrays
Sergey Tsalkov2011-09-23 15:57:36 -07:00
f09308a3f7
re-organize test files, make it easy to test for both php 5.2 and 5.3
Sergey Tsalkov2011-09-23 15:51:35 -07:00
7621b50a02
handle non-sql errors (such as failure to connect to MySQL server) in a user-defined way adds DB::$nonsql_error_handler and DB::$throw_exception_on_nonsql_error
Sergey Tsalkov2011-08-25 23:33:15 -07:00
4122fe52c1
collapse some redundant code into a function
Sergey Tsalkov2011-06-02 18:57:15 -04:00
8072f6ab07
use static class variable, not static function variable, to hold mysql connection
Sergey Tsalkov2011-06-01 17:30:28 -04:00
860da8d18a
insert(), replace(), and update() now handle the value NULL correctly
Sergey Tsalkov2011-05-31 21:50:24 -04:00
0ed2837f3d
on second thought, we won't have insertMany() and replaceMany(), but insert() and replace() will figure out which one you mean
v1.6
Sergey Tsalkov2011-04-29 01:48:27 -04:00
96892fa6c2
DB::$param_char can now be used to change the char that needs to appear in front of params (% is the default)
Sergey Tsalkov2011-04-28 18:41:13 -04:00
ad4889da09
revert last commit -- this is a bad way to do it, and I'll have to come up with something else to let people use strings like %i in their SQL and bypass the parser
Sergey Tsalkov2011-04-28 18:14:59 -04:00
12604d7854
bugfix: let people have literal %'s in their queries without confusing the parser by using %% instead
Sergey Tsalkov2011-04-23 20:31:18 -04:00
8c5299c2e2
* add insertMany() and replaceMany() to let you do multiple inserts in one SQL command * error and success handlers can now be set to static and object methods
Sergey Tsalkov2011-04-23 00:46:51 -04:00
964a36e4c2
sqleval() can now be used with %s, %i, and all that good stuff there is probably no good reason to do this, as things like md5() can be done from PHP, but people keep asking for it, so here it is :)
Sergey Tsalkov2011-04-22 23:29:09 -04:00
68774532e1
add delete() function -- mostly for completeness with insert(), update(), etc
Sergey Tsalkov2011-04-22 23:15:14 -04:00
2985815750
* add tests for tableList() and columnList() -- those are now supported functions * remove some unused code, minor cleanup
Sergey Tsalkov2011-04-22 23:03:37 -04:00
4faebb957c
add DB::sqleval() -- can be used with insert() and update() to inject raw sql stuff like NOW()
v1.5
Sergey Tsalkov2011-04-08 13:56:28 -04:00
819acb9bff
use fetch_row and not fetch_assoc for queryFirstField and queryFirstColumn -- it should be a bit faster
v1.4
Sergey Tsalkov2011-03-30 13:18:53 -04:00
449760eb2a
set the character encoding in the "more proper" way, as recommended by the mysqli manual
Sergey Tsalkov2011-03-17 13:14:39 -04:00
74feeb6513
now you can use DB::$success_handler to replace the "debug mode" handler in the same way that you can replace the error handler
v1.3
Sergey Tsalkov2011-03-15 16:03:56 -04:00
c14c69ffa7
let user specify port with DB::$port -- defaults to mysqli.default_port from the php config (probably 3306)
Sergey Tsalkov2011-03-15 14:42:58 -04:00
894d8a0530
various fixes for PHP 5.2 compatability -- now finally tested and working with 5.2
Sergey Tsalkov2011-03-15 13:06:45 -04:00
b6b22833e9
this is distributed under the LGPL v3 -- add copyright information
Sergey Tsalkov2011-03-13 17:16:18 -04:00
5525d22a9b
we can now throw an exception on errors if DB::$throw_exception_on_error is set
v1.2
Sergey Tsalkov2011-03-04 17:07:23 -05:00
0a7b323e81
you can now specify your own error handling function by changing DB::$error_handler
Sergey Tsalkov2011-03-04 16:49:17 -05:00
620c607f61
remove array_map with inline functions for PHP 5.2 compatability thanks to Adam for pointing this out!
Sergey Tsalkov2011-03-02 12:46:07 -05:00
78c8192fdd
increase "error output" level and fix various minor bugs none of these seem to affect functionality, it's just a matter of clean code thanks to ++ for pointing this out!
v1.1
Sergey Tsalkov2011-02-28 23:57:04 -05:00