<style type="text/css" media="all"> body { color: #FFFFFF; background-color: #112CB8; font-family: "Arial", "Luxi Sans", "Helvetica", sans-serif; } a { color: yellow; background-color: inherit; text-decoration: none; } a:visited { color: #FFA500; background-color: inherit; text-decoration: none; } a:hover { color: inherit; background-color: inherit; text-decoration: underline; } table { width: 100%; border-style: solid; border-width: 1px; border-collapse: separate; border-spacing: 0pt; border-color: white; margin: 6pt 0pt; } td { vertical-align: top; border-style: none; margin: 8pt; } td.solid { border-style: solid; border-width: 0px 0px 1px 0px; } pre { margin: 8pt; } .scanner { border-style: solid; border-width: 1px 0px; border-color: white; } .service { border-style: solid; border-width: 1px; border-color: white; } .other { border-style: solid; border-width: 1px; border-color: white; } </style> <h1>Database connections</h1> <!-- NAME: db.MySQLdb --> <table border="1"><tr><td class="other"><a name="db.MySQLdb"><h3>db.MySQLdb()</h3></a> <pre>MySQL database connection. Requires: MySQLdb python module Usage: db.MySQLdb(host='127.0.0.1',port=3306,dbname='sagator', dbuser='sagator',dbpasswd='xxxxxx') Parameters: host - database server hostname or unix socket path port - tcp socket port for database server dbname - database name dbuser - authorization username dbpasswd - authorization password Database creation script: scripts/db/mysql.sh</pre> </td></tr></table> <!-- NAME: db.pg --> <table border="1"><tr><td class="other"><a name="db.pg"><h3>db.pg()</h3></a> <pre>PostgreSQL support via pg python module. Requires: pg python module Usage: db.pg(host='127.0.0.1',port=5432,dbname='sagator', dbuser='sagator',dbpasswd='xxxxxx') Parameters: host - database server hostname port - tcp socket port for database server dbname - database name dbuser - authorization username dbpasswd - authorization password Database creation script: scripts/db/pgsql.sh</pre> </td></tr></table> <!-- NAME: db.pgdb --> <table border="1"><tr><td class="other"><a name="db.pgdb"><h3>db.pgdb()</h3></a> <pre>PostgreSQL support via pgdb python module. [recomended] Requires: pgdb python module Usage: db.pgdb(host='127.0.0.1',port=5432,dbname='sagator', dbuser='sagator',dbpasswd='xxxxxx') Parameters: host - database server hostname port - tcp socket port for database server dbname - database name dbuser - authorization username dbpasswd - authorization password Database creation script: scripts/db/pgsql.sh</pre> </td></tr></table> <!-- NAME: db.psycopg --> <table border="1"><tr><td class="other"><a name="db.psycopg"><h3>db.psycopg()</h3></a> <pre>PostgreSQL support via psycopg python module. Requires: psycopg python module Usage: db.psycopg(host='127.0.0.1',port=5432,dbname='sagator', dbuser='sagator',dbpasswd='xxxxxx') Parameters: host - database server hostname port - tcp socket port for database server dbname - database name dbuser - authorization username dbpasswd - authorization password Database creation script: scripts/db/pgsql.sh</pre> </td></tr></table> <!-- NAME: db.sqlite --> <table border="1"><tr><td class="other"><a name="db.sqlite"><h3>db.sqlite()</h3></a> <pre>SQLite database conenction. Requires: sqlite python module Usage: db.sqlite(dbname='/var/lib/sagator/sqlitedb') Parameters: dbname - database name Database creation script: scripts/db/sqlite.sh</pre> </td></tr></table>