Age | Commit message (Collapse) | Author | |
---|---|---|---|
2013-01-03 | Add test for get_last_statement | Simon Holywell | |
2012-11-26 | Add raw_execute() to ORM | tag | |
2012-11-26 | Fixed query logging for delete_many; added unit test for delete_many | tag | |
2012-11-23 | Multiple connection support for Idiorm | tag | |
Mutiple connections code, including documentation and unit tests. Utilizes key names to distinguish connections, but uses a default connection if none specified. I don't (yet) use multiple connections in my work (it's pending), so this has not been tested "in the wild". Added unit tests with additional connections, ran unit tests for Paris against this build too, so an unmodified Paris is forward-compatible with this commit (mulitple connections support not yet coded for Paris). Does *NOT* add support for queries across multiple connections. (I don't even want to go there ...) ##### Edge-case compatibility breaks: * ORM::_setup_identifier_quote_character visibility was changed to protected (which was likely original intent, judging by prefixed name) * May break compatibility if ORM has been extended, **and** subclasses directly utilize `::_config`, `::_db`, `::_query_log`, or `::_query_cache` instead of using pre-existing accessor methods. (Paris does not do this; all Paris tests pass) * Re-use of `Tester` class outside of Idiorm repo, as `Tester::check_equal()` was renamed to `Tester::check_equal_query()` ##### Other notes New method: `ORM::get_connection_keys()`. New `Tester` method: `Tester::check_equal_string()`. TODO: Consider adding methods to get (connection-specific) configuration info. | |||
2012-11-21 | Add raw_execute() to ORM | tag | |
2012-11-21 | Fixed query logging for delete_many; added unit test for delete_many | tag | |
2012-11-14 | Issue #57 _log_query errors when given raw ? or % | Simon Holywell | |
Thanks to Jeff Roberson <[email protected]> for his regex skills. | |||
2012-11-12 | Handle ambiguous column names when joining two tables | gerard sychay | |
2012-11-12 | Add set_expr() closing issues #43 & #59 | Simon Holywell | |
2012-11-12 | Issue #24 Add group_by_expr function | Simon Holywell | |
2012-11-12 | Issue #16 Aggregate function support | Simon Holywell | |
2012-11-12 | select_many and select_many_expr issues #49 and #69 | Simon Holywell | |
2012-11-08 | Escape sprintf % chars in queries | Kunio Murasawa | |
Thanks m92o | |||
2012-08-28 | Merge remote-tracking branch 'sandermarechal/set-array' into develop | Durham Hale | |
2012-08-28 | Merge remote-tracking branch 'sandermarechal/raw-query' into develop | Durham Hale | |
2011-03-03 | Rename order_raw to order_by_expr | Sander Marechal | |
2011-03-03 | Update multiple properties at once | Sander Marechal | |
This change alters the `set` method so you can update multiple properties at once, by passing an associative array top `set`. | |||
2011-03-02 | Allow raw queries without parameters | Sander Marechal | |
This is useful for e.g. MySQL `LOCK TABLE` or SQLite `VACUUM` commands which usually do not require parameters. | |||
2011-03-02 | Add support for raw `ORDER BY` clauses. | Sander Marechal | |
This is useful when you need to order results by something other than a column name, like the output of an SQL function. | |||
2011-01-30 | Issue #12: Fix incorrect quoting of column wildcard. Thanks pewterfish. | Jamie Matthews | |
2011-01-22 | Add support for GROUP BY - issue #13 | Jamie Matthews | |
2011-01-22 | Add support for DISTINCT - issue #13 | Jamie Matthews | |
2011-01-22 | Fix a failing test caused by count() refactor | Jamie Matthews | |
2011-01-08 | Add simple query caching - issue #11 | Jamie Matthews | |
2010-11-03 | Add where_null and where_not_null methods. Thanks for the suggestion, artcijsg | Jamie Matthews | |
2010-11-03 | Parameters to where_raw method are now optional | Jamie Matthews | |
2010-11-03 | Add where_not_equal method. Thanks for the suggestion, arcijsg | Jamie Matthews | |
2010-10-27 | Add where_id_is method, docs and test | Jamie Matthews | |
2010-10-25 | Fix test for main table alias | Jamie Matthews | |
2010-10-25 | Add table_alias method to provide ability to alias the main table in SELECT ↵ | Jamie Matthews | |
queries | |||
2010-10-25 | Add test for multiple join sources | Jamie Matthews | |
2010-10-25 | Add support for unescaped string constraints | Jamie Matthews | |
2010-10-25 | Add test and fix implementation of table aliases | Jamie Matthews | |
2010-10-25 | Add inner, left outer, right outer, full outer joins | Jamie Matthews | |
2010-10-25 | Initial work on joins. Basic test, join and _add_join methods | Jamie Matthews | |
2010-10-25 | Add select and select_expr methods to provide control over result columns | Jamie Matthews | |
2010-10-22 | Fix errors in test suite | Jamie Matthews | |
2010-10-22 | find_one method now adds LIMIT 1 to queries | Jamie Matthews | |
2010-10-22 | Simplify mock testing objects and convert query tests to use logged queries | Jamie Matthews | |
2010-10-07 | Add use_id_column method to allow specifying the ID column to use on a ↵ | Jamie Matthews | |
per-instance basis | |||
2010-10-07 | Simplify where_raw method. This method can now be used in method chains. | Jamie Matthews | |
2010-10-07 | Add where_in and where_not_in methods, tests and docs | Jamie Matthews | |
2010-09-20 | Unspecified terminal colours now printed in default colour rather than black ↵ | Jamie Matthews | |
in test runner | |||
2010-09-20 | All identifiers (table names, column names) are now quoted with backticks | Jamie Matthews | |
2010-09-20 | Add colouring to test runner, at terminal and in browser | Jamie Matthews | |
2010-09-20 | Test framework now works better when invoked from the command line | Jamie Matthews | |
2010-09-16 | Add where_not_like method, docs and test | Jamie Matthews | |
2010-09-14 | Add code, tests and docs for inequality operators: where_gt, where_lt, ↵ | Jamie Matthews | |
where_gte, where_lte | |||
2010-04-12 | Added support for COUNT queries | Jamie Matthews | |
2010-02-26 | Fixed multiple bugs in query building | Jamie Matthews | |
* ORDER BY, LIMIT and OFFSET parameters cannot be bound to the query as the database surrounds them with quotes, formining invalid SQL. They are now simply concatenated to the SQL string. The documentation has been updated to mark these as "unsafe" and not suitable for use with unfiltered user input. * ORDER BY should come before LIMIT and OFFSET. |