Database connections

db.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

db.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

db.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

db.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

db.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

db.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