Stacksmith icon indicating copy to clipboard operation
Stacksmith copied to clipboard

SQLite database commands

Open uliwitness opened this issue 10 years ago • 1 comments

Queries should ideally be specified as something between LINQ and the search command's syntax. Make it so users don't have to escape query values etc., not unlike prepared statements in SQL. Maybe even throw in SQL support while we're at it.

uliwitness avatar Jan 15 '15 10:01 uliwitness

This seems like a starter bug at first, but to do this right, we don't want to expose the user to SQL syntax. So there'd need to be parser support for parsing an expression and then generating some sort of format string from it (same thing we'd need for the "sort" command). Alternately, one could fake it like in the "download" command and generate a function with a name impossible for the user to type based on the expression, and then call that function to generate the query string. Might involve some CNodeTransformation subclasses to wrap up the query parameters without the user having to do it manually.

uliwitness avatar Mar 18 '17 13:03 uliwitness