search

lightblue-platform / lightblue-docs-specs

All specifications for lightblue.
GNU General Public License v3.0
1 stars 10 forks source link

rdbms: simple scenario - insert #15

Open dcrissman opened 9 years ago

dcrissman commented 9 years ago

INSERT INTO MY_TABLE (MY_DATE, MY_NUMBER, MY_VARCHAR2) ); [ { "operation": "insert_row", "table": "my_table", "columns": [ "$non_null_columns" ] } ]

This example uses "$non_null_columns", but it leaves me wondering what that value means? It also leaves me wondering what happened to the inserted values?

bserdar commented 9 years ago

It is not completely specifiied yet but $non_null_columns will be derived from field/column mappings, and include all non-null column names and values. It will be up to the dialect to interpret that list of column/values, and write the INSERT statement.

On Thu, Mar 5, 2015 at 9:50 AM, Dennis Crissman notifications@github.com wrote:

INSERT INTO MY_TABLE (MY_DATE, MY_NUMBER, MY_VARCHAR2) ); [ { "operation": "insert_row", "table": "my_table", "columns": [ "$non_null_columns" ] } ]

This example uses "$non_null_columns", but it leaves me wondering what that value means? It also leaves me wondering what happened to the inserted values?

— Reply to this email directly or view it on GitHub https://github.com/lightblue-platform/lightblue-docs-specs/issues/15.