On Fri, Aug 1, 2014 at 3:41 PM, Simon Slavin <slav...@bigfraud.org> wrote:
> > > On 1 Aug 2014, at 8:11pm, Jim Callahan <jim.callahan.orla...@gmail.com> > wrote: > > > > Why does Python get to see the innards of a View; when the query just > > involves columns (in a view) that flow straight through from the base > table > > (as opposed to being joined from some other table)? > > A VIEW is just a way of saving a SELECT statement for execution later. > Correct a view is a saved SELECT statement. My question is the division of labor. IMHO, from a DBA virtual table perspective shouldn't the engine closest to the data (SQLite in this case) parse and run the SELECT statement specified by the view? and just return a resultset to the calling program? Why is Python parsing the AS SELECT clause of the CREATE VIEW statement? Shouldn't Python just pass 'SELECT FirstName LastName FROM ActiveVoters LIMIT 3' to SQLite and SQLite parse, recognize that ActiveVoters is a VIEW, run the SQL and substitute it like a macro-preprocessor before anyone (especially the calling program) is the wiser? I can't ask the Python list if I can't specify the correct behavior of a correct implementation of the call level interface. I have many time used a view in place of a table in MS Access and indeed, I connected MS Access via ODBC to an ancestor of this database and MS Access saw an ancestor of this view as a table. I expect something similar from Python, R or Java. A view is not just supposed to be a convenience from the command line interface and unusable from other programs; is it? Jim >> If you execute the SELECT statement from the VIEW definition as if it was a >> separate SELECT statement, do you get an error message of some kind ? Works OK at command line and does not give any error messages. Almost impossible to do from Python at my current level of ignorance. > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
