summaryrefslogtreecommitdiff
path: root/test
AgeCommit message (Collapse)Author
2013-01-04Add HAVING clause support to query builderSimon Holywell
2013-01-04Issue #74 escaping quote symbols in "_quote_identifier_part"Simon Holywell
2013-01-03Issue #90 When using set_expr alone it doesn't trigger query creationSimon Holywell
2013-01-03Add test for get_last_statementSimon Holywell
2012-11-26Add raw_execute() to ORMtag
2012-11-26Fixed query logging for delete_many; added unit test for delete_manytag
2012-11-14Issue #57 _log_query errors when given raw ? or %Simon Holywell
Thanks to Jeff Roberson <[email protected]> for his regex skills.
2012-11-12Handle ambiguous column names when joining two tablesgerard sychay
2012-11-12Add set_expr() closing issues #43 & #59Simon Holywell
2012-11-12Issue #24 Add group_by_expr functionSimon Holywell
2012-11-12Issue #16 Aggregate function supportSimon Holywell
2012-11-12select_many and select_many_expr issues #49 and #69Simon Holywell
2012-11-08Escape sprintf % chars in queriesKunio Murasawa
Thanks m92o
2012-08-28Merge remote-tracking branch 'sandermarechal/set-array' into developDurham Hale
2012-08-28Merge remote-tracking branch 'sandermarechal/raw-query' into developDurham Hale
2011-03-03Rename order_raw to order_by_exprSander Marechal
2011-03-03Update multiple properties at onceSander Marechal
This change alters the `set` method so you can update multiple properties at once, by passing an associative array top `set`.
2011-03-02Allow raw queries without parametersSander Marechal
This is useful for e.g. MySQL `LOCK TABLE` or SQLite `VACUUM` commands which usually do not require parameters.
2011-03-02Add 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-30Issue #12: Fix incorrect quoting of column wildcard. Thanks pewterfish.Jamie Matthews
2011-01-22Add support for GROUP BY - issue #13Jamie Matthews
2011-01-22Add support for DISTINCT - issue #13Jamie Matthews
2011-01-22Fix a failing test caused by count() refactorJamie Matthews
2011-01-08Add simple query caching - issue #11Jamie Matthews
2010-11-03Add where_null and where_not_null methods. Thanks for the suggestion, artcijsgJamie Matthews
2010-11-03Parameters to where_raw method are now optionalJamie Matthews
2010-11-03Add where_not_equal method. Thanks for the suggestion, arcijsgJamie Matthews
2010-10-27Add where_id_is method, docs and testJamie Matthews
2010-10-25Fix test for main table aliasJamie Matthews
2010-10-25Add table_alias method to provide ability to alias the main table in SELECT ↵Jamie Matthews
queries
2010-10-25Add test for multiple join sourcesJamie Matthews
2010-10-25Add support for unescaped string constraintsJamie Matthews
2010-10-25Add test and fix implementation of table aliasesJamie Matthews
2010-10-25Add inner, left outer, right outer, full outer joinsJamie Matthews
2010-10-25Initial work on joins. Basic test, join and _add_join methodsJamie Matthews
2010-10-25Add select and select_expr methods to provide control over result columnsJamie Matthews
2010-10-22Fix errors in test suiteJamie Matthews
2010-10-22find_one method now adds LIMIT 1 to queriesJamie Matthews
2010-10-22Simplify mock testing objects and convert query tests to use logged queriesJamie Matthews
2010-10-07Add use_id_column method to allow specifying the ID column to use on a ↵Jamie Matthews
per-instance basis
2010-10-07Simplify where_raw method. This method can now be used in method chains.Jamie Matthews
2010-10-07Add where_in and where_not_in methods, tests and docsJamie Matthews
2010-09-20Unspecified terminal colours now printed in default colour rather than black ↵Jamie Matthews
in test runner
2010-09-20All identifiers (table names, column names) are now quoted with backticksJamie Matthews
2010-09-20Add colouring to test runner, at terminal and in browserJamie Matthews
2010-09-20Test framework now works better when invoked from the command lineJamie Matthews
2010-09-16Add where_not_like method, docs and testJamie Matthews
2010-09-14Add code, tests and docs for inequality operators: where_gt, where_lt, ↵Jamie Matthews
where_gte, where_lte
2010-04-12Added support for COUNT queriesJamie Matthews
2010-02-26Fixed multiple bugs in query buildingJamie 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.
generated by cgit v1.2.3 (git 2.25.1) at 2024-07-18 03:32:00 +0000