LP#1999823: update remaining buffer_* function names to osrf_buffer_* Signed-off-by: Jeff Davis <jeff.davis@bc.libraries.coop> Signed-off-by: Jason Boyer <JBoyer@equinoxOLI.org>
When returning a list of bind variables: If a default_ or actual_value is undefined for a given variable, leave it out of the JSON object altogether, rather than create an entry with a JSON null for it. That way the client can distinguish between an undefined value and a value defined as null. M Open-ILS/src/c-apps/buildSQL.c git-svn-id: svn://svn.open-ils.org/ILS/trunk@16932 dcc99617-32d9-48b4-a31d-7c20da2025e4
Qstore: support LIMIT and OFFSET clauses. Also: add some links to the IDL, that should have been there in the first place. M Open-ILS/include/openils/oils_buildq.h M Open-ILS/src/c-apps/oils_storedq.c M Open-ILS/src/c-apps/buildSQL.c M Open-ILS/src/sql/Pg/002.schema.config.sql M Open-ILS/src/sql/Pg/008.schema.query.sql A Open-ILS/src/sql/Pg/upgrade/0336.schema.query-limit-offset-fkey.sql M Open-ILS/examples/fm_IDL.xml git-svn-id: svn://svn.open-ils.org/ILS/trunk@16922 dcc99617-32d9-48b4-a31d-7c20da2025e4
Support the following built-in functions with peculiar syntax. They take no parameters and don't even accept empty parentheses: current_date current_time current_timestamp localtime localtimestamp M Open-ILS/src/c-apps/buildSQL.c git-svn-id: svn://svn.open-ils.org/ILS/trunk@16843 dcc99617-32d9-48b4-a31d-7c20da2025e4
1. Support the peculiar syntax of EXTRACT(). 2. Repair a regression to make SELECT * work again. M Open-ILS/src/c-apps/oils_storedq.c M Open-ILS/src/c-apps/buildSQL.c git-svn-id: svn://svn.open-ils.org/ILS/trunk@16842 dcc99617-32d9-48b4-a31d-7c20da2025e4
Support function calls with subfields, e.g. (func(args))."id". Note that this support treats the subfield as an optional component of the functional call, not as a type of expression in its own right. A subsequent commit will eliminate the "xfld" expression type. M Open-ILS/include/openils/oils_buildq.h M Open-ILS/src/c-apps/oils_storedq.c M Open-ILS/src/c-apps/buildSQL.c git-svn-id: svn://svn.open-ils.org/ILS/trunk@16821 dcc99617-32d9-48b4-a31d-7c20da2025e4
Support CAST expressions, taking care to avoid SQL injection. M Open-ILS/include/openils/oils_buildq.h M Open-ILS/src/c-apps/oils_storedq.c M Open-ILS/src/c-apps/buildSQL.c git-svn-id: svn://svn.open-ils.org/ILS/trunk@16738 dcc99617-32d9-48b4-a31d-7c20da2025e4
In qstore: support CASE expressions. M Open-ILS/include/openils/oils_buildq.h M Open-ILS/src/c-apps/oils_storedq.c M Open-ILS/src/c-apps/buildSQL.c git-svn-id: svn://svn.open-ils.org/ILS/trunk@16696 dcc99617-32d9-48b4-a31d-7c20da2025e4
When building string literals in SQL: escape special characters. M Open-ILS/src/c-apps/buildSQL.c git-svn-id: svn://svn.open-ils.org/ILS/trunk@16658 dcc99617-32d9-48b4-a31d-7c20da2025e4
1. Support function calls in the FROM clause. 2. Support wildcards in the SELECT clause. WARNING: the presence of a wildcard in the SELECT clause is likely to disrupt a GROUP BY by renumbering the columns. Also: the "columns" method currently cannot return the names of the columns into which a wild card is expanded. M Open-ILS/include/openils/oils_buildq.h M Open-ILS/src/c-apps/oils_storedq.c M Open-ILS/src/c-apps/buildSQL.c git-svn-id: svn://svn.open-ils.org/ILS/trunk@16628 dcc99617-32d9-48b4-a31d-7c20da2025e4
Add support for GROUP BY. M Open-ILS/include/openils/oils_buildq.h M Open-ILS/src/c-apps/oils_storedq.c M Open-ILS/src/c-apps/buildSQL.c git-svn-id: svn://svn.open-ils.org/ILS/trunk@16541 dcc99617-32d9-48b4-a31d-7c20da2025e4
Add support for BETWEEN conditions. M Open-ILS/src/c-apps/oils_storedq.c M Open-ILS/src/c-apps/buildSQL.c git-svn-id: svn://svn.open-ils.org/ILS/trunk@16538 dcc99617-32d9-48b4-a31d-7c20da2025e4
1. Add support for function calls. Note that certain functions have peculiar calling syntax. They will require special handling as exceptions, and are not yet supported. 2. Add a bit of sanity checking for numeric and string literal expressions. 3. Eliminate the function_id member of Expression. M Open-ILS/include/openils/oils_buildq.h M Open-ILS/src/c-apps/oils_storedq.c M Open-ILS/src/c-apps/buildSQL.c git-svn-id: svn://svn.open-ils.org/ILS/trunk@16537 dcc99617-32d9-48b4-a31d-7c20da2025e4
Support IN lists. M Open-ILS/src/c-apps/oils_storedq.c M Open-ILS/src/c-apps/buildSQL.c git-svn-id: svn://svn.open-ils.org/ILS/trunk@16527 dcc99617-32d9-48b4-a31d-7c20da2025e4
Support series expressions, i.e. a series of expressions separated by operators or commas. This construct will be especially useful for chains of ANDs or ORs. M Open-ILS/include/openils/oils_buildq.h M Open-ILS/src/c-apps/oils_storedq.c M Open-ILS/src/c-apps/buildSQL.c git-svn-id: svn://svn.open-ils.org/ILS/trunk@16526 dcc99617-32d9-48b4-a31d-7c20da2025e4
Support IS NULL and IS NOT NULL expressions. M Open-ILS/include/openils/oils_buildq.h M Open-ILS/src/c-apps/oils_storedq.c M Open-ILS/src/c-apps/buildSQL.c git-svn-id: svn://svn.open-ils.org/ILS/trunk@16470 dcc99617-32d9-48b4-a31d-7c20da2025e4
Implement new param_list method, which returns a list of bind variables so that the client can populate them. M Open-ILS/include/openils/oils_buildq.h M Open-ILS/src/c-apps/oils_qstore.c M Open-ILS/src/c-apps/buildSQL.c git-svn-id: svn://svn.open-ils.org/ILS/trunk@16455 dcc99617-32d9-48b4-a31d-7c20da2025e4
Implement open-ils.qstore.bind_param method, which applies actual values to bind variables (overriding default values, if any). M Open-ILS/src/c-apps/oils_qstore.c M Open-ILS/src/c-apps/buildSQL.c git-svn-id: svn://svn.open-ils.org/ILS/trunk@16454 dcc99617-32d9-48b4-a31d-7c20da2025e4
Add partial support for bind variables: load them from the database, and use default values if available. There is no mechanism yet to override the defaults. git-svn-id: svn://svn.open-ils.org/ILS/trunk@16450 dcc99617-32d9-48b4-a31d-7c20da2025e4
1. Support negation of an expression (except in a few cases where it doesn't make sense, such as negation of a number or string). 2. Support HAVING clauses. This isn't useful yet because we don't support GROUP BY yet. M Open-ILS/include/openils/oils_buildq.h M Open-ILS/src/c-apps/oils_storedq.c M Open-ILS/src/c-apps/buildSQL.c git-svn-id: svn://svn.open-ils.org/ILS/trunk@16399 dcc99617-32d9-48b4-a31d-7c20da2025e4