Re: [sqlite] detect database/table/field use
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 27/06/14 11:24, big stone wrote: > I notice some of your examples are written in Python2-only syntax. > > Would it be possible to make their syntax more Python2/3 compatible, > at least for the print function ? How does that help you? https://github.com/rogerbinns/apsw/issues/166 Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1 iEYEARECAAYFAlOtuEwACgkQmOOfHg372QSw6gCeKZ6qQrsnyWiFcRNZTgxxdI40 CQIAoJxp4Z6kzFQKWyEQHFr0R2sFY0xa =dWYR -END PGP SIGNATURE- ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] detect database/table/field use
Hi Roger, I notice some of your examples are written in Python2-only syntax. Would it be possible to make their syntax more Python2/3 compatible, at least for the print function ? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] detect database/table/field use
Roger Binns wrote on Thursday, June 26, 2014 5:38 PM > >On 26/06/14 12:58, Nelson, Erik - 2 wrote: > > I'd like to record which databases/tables/fields are accessed. Is > > there any not-too-difficult way of doing this? > > The authorizer interface will address your issue. You can just record > what it tells you, or prevent/replace with null certain columns. > > https://sqlite.org/c3ref/set_authorizer.html > > That page doesn't give any examples of what you see. The doc for my > python SQLite wrapper shows three examples: > > http://rogerbinns.github.io/apsw/example.html#authorizer-example > Thanks! -- This message, and any attachments, is for the intended recipient(s) only, may contain information that is privileged, confidential and/or proprietary and subject to important terms and conditions available at http://www.bankofamerica.com/emaildisclaimer. If you are not the intended recipient, please delete this message. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] detect database/table/field use
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 26/06/14 12:58, Nelson, Erik - 2 wrote: > I'd like to record which databases/tables/fields are accessed. Is > there any not-too-difficult way of doing this? The authorizer interface will address your issue. You can just record what it tells you, or prevent/replace with null certain columns. https://sqlite.org/c3ref/set_authorizer.html That page doesn't give any examples of what you see. The doc for my python SQLite wrapper shows three examples: http://rogerbinns.github.io/apsw/example.html#authorizer-example Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1 iEYEARECAAYFAlOskrUACgkQmOOfHg372QS4VQCePMhPvn4E1GfpBCaDzMFX9lHn lbwAnje0488t9WFZLZztJSK05ScR6ZRK =v6gt -END PGP SIGNATURE- ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] detect database/table/field use
I work with a C++ application that embeds the SQLite source and executes user-supplied queries against SQLite database(s). I'd like to record which databases/tables/fields are accessed. Is there any not-too-difficult way of doing this? Poking around in the source, it seems like a fundamental hook might be either in the lookupName() function or the internals of the Parse structure. Anyway suggestions would be appreciated. Erik -- This message, and any attachments, is for the intended recipient(s) only, may contain information that is privileged, confidential and/or proprietary and subject to important terms and conditions available at http://www.bankofamerica.com/emaildisclaimer. If you are not the intended recipient, please delete this message. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
