Mercurial > sqlpython

comparison docs/source/intro.rst @ 517:c36e0aa695a4

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
column autocomplete working
author Catherine Devlin <catherine.devlin@gmail.com>
date Wed, 03 Nov 2010 07:47:17 -0400
parents 920a45f244e8
children 69997c324eb9
comparison
equal deleted inserted replaced
501:1feb33957443 517:c36e0aa695a4
56 Running 56 Running
57 ------- 57 -------
58 58
59 sqlpython [username[/password][@SID]] ["SQL command 1", "@script.sql", "SQL command 2..."] 59 sqlpython [username[/password][@SID]] ["SQL command 1", "@script.sql", "SQL command 2..."]
60 60
61 or
62
63 sqlpython [--postgres|mysql] database-name username
64
61 Database connections can also be specified with URL syntax or with Oracle Easy Connect:: 65 Database connections can also be specified with URL syntax or with Oracle Easy Connect::
62 66
63 oracle://username:password@SID 67 oracle://username:password@SID
64 68
65 oracle://username:password@hostname:port/dbname 69 oracle://username:password@hostname:port/dbname
91 Version 1.7.0 of sqlpython works against PostgreSQL and MySQL, though the testing against 95 Version 1.7.0 of sqlpython works against PostgreSQL and MySQL, though the testing against
92 those databases has been very slight thus far. Help in testing and improving sqlpython's 96 those databases has been very slight thus far. Help in testing and improving sqlpython's
93 functions against those databases is welcome. Support for Microsoft SQL Server and sqlite 97 functions against those databases is welcome. Support for Microsoft SQL Server and sqlite
94 will be available as soon as those databases are added to the Gerald project, and volunteers 98 will be available as soon as those databases are added to the Gerald project, and volunteers
95 for Gerald will benefit sqlpython as well. 99 for Gerald will benefit sqlpython as well.
96
97 As of 1.7.0, sqlpython sessions can only "see" metadata within the named schema belonging
98 to the currently connected user. A fix for this is expected for 1.7.1.