You cannot do that. The dot commands are not SQL, and SQLite only
understands SQL. The dot commands are provided by the shell executable.
You could simply look at its source code, see how each specific command
is implemented, and reimplement that functionality in your app.
HG wrote:
> I want to get a dump of an sqlite3 database using the sqlite3 library without
> adding a dependency on the sqlite3 executable.
>
> Does the sqlite3 library support execution of dot commands. The following
> fails for me :-
>
> --
> import sqlite3
>
> conn = sqlite3.connect('media_db.db')
> c = conn.cursor()
> c.execute('.dump\n')
> c.execute('.dump')
> conn.commit()
> c.close()
>
> Traceback (most recent call last):
> File "test.py", line 5, in <module>
> c.execute('.dump\n')
> sqlite3.OperationalError: near ".": syntax error
> --
>
> Kindly suggest.
>
> Thank You,
> Himanshu
>
>
> Add more friends to your messenger and enjoy! Go to
> http://messenger.yahoo.com/invite/
> _______________________________________________
> sqlite-users mailing list
> [email protected]
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
