== Database connections ============================== MySQLdb() | 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 pg() | 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 pgdb() | 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 psycopg() | 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 pymysql() | MySQL database connection. | | Requires: pymysql python module | | Usage: db.pymysql(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 sqlite() | 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