Re: [sqlite] detect database/table/field use

2014-06-27 Thread Roger Binns
-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

2014-06-27 Thread big stone
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

2014-06-26 Thread Nelson, Erik - 2
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

2014-06-26 Thread Roger Binns
-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