Module _cubrid
[hide private]
[frames] | no frames]

Module _cubrid

CUBRID API Module for Python


Version: 9.3.0.0001

Classes [hide private]
  DatabaseError
  Error
  InterfaceError
  NotSupportedError
  connection
Returns a CUBRID connection object.
  cursor
Cursor class.
  lob
Lob class.
  set
Set class.
Functions [hide private]
 
connect(url, user=..., password=...)
Establish the environment for connecting to your server by using connection information passed with a url string argument.
 
escape_string()
Escape special characters in a string for use in an SQL statement
Variables [hide private]
  CUBRID_COMMIT_CLASS_COMMIT_INSTANCE = 2
  CUBRID_COMMIT_CLASS_UNCOMMIT_INSTANCE = 1
  CUBRID_EXEC_ASYNC = 1
  CUBRID_EXEC_ONLY_QUERY_PLAN = 8
  CUBRID_EXEC_QUERY_ALL = 2
  CUBRID_EXEC_QUERY_INFO = 4
  CUBRID_EXEC_THREAD = 16
  CUBRID_REP_CLASS_COMMIT_INSTANCE = 4
  CUBRID_REP_CLASS_REP_INSTANCE = 5
  CUBRID_REP_CLASS_UNCOMMIT_INSTANCE = 3
  CUBRID_SCH_ATTRIBUTE = 4
  CUBRID_SCH_COLUMN_PRIVILEGE = 14
  CUBRID_SCH_CONSTRAINT = 11
  CUBRID_SCH_CROSS_REFERENCE = 19
  CUBRID_SCH_DIRECT_SUPER_TABLE = 15
  CUBRID_SCH_EXPORTED_KEYS = 18
  CUBRID_SCH_IMPORTED_KEYS = 17
  CUBRID_SCH_METHOD = 6
  CUBRID_SCH_METHOD_FILE = 8
  CUBRID_SCH_PRIMARY_KEY = 16
  CUBRID_SCH_QUERY_SPEC = 3
  CUBRID_SCH_SUBTABLE = 10
  CUBRID_SCH_SUPERTABLE = 9
  CUBRID_SCH_TABLE = 1
  CUBRID_SCH_TABLE_ATTRIBUTE = 5
  CUBRID_SCH_TABLE_METHOD = 7
  CUBRID_SCH_TABLE_PRIVILEGE = 13
  CUBRID_SCH_TRIGGER = 12
  CUBRID_SCH_VIEW = 2
  CUBRID_SERIALIZABLE = 6
  SEEK_CUR = 1
  SEEK_END = 2
  SEEK_SET = 0
  __package__ = None
Function Details [hide private]

connect(url, user=..., password=...)

 

Establish the environment for connecting to your server by using connection information passed with a url string argument. If the HA feature is enabled in CUBRID, you must specify the connection information of the standby server, which is used for failover when failure occurs, in the url string argument of this function. If the user name and password is not given, then the "PUBLIC" connection will be made by default. Exclusive use of keyword parameters strongly recommended. Consult the CUBRID CCI documentation for more details. Parameters:

 <url> ::= <host>:<db_name>:<db_user>:<db_password>:[?<properties>]
     <properties> ::= <property> [&<property>]
     <property> ::= althosts=<alternative_hosts> [&rctime=<time>]
     <alternative_hosts> ::= <standby_broker1_host>:<port>
            [,<standby_broker2_host>:<port>]
     <host> := HOSTNAME | IP_ADDR
     <time> := SECOND

   host : A host name or IP address of the master database
   db_name : A name of the database
   db_user : A name of the database user
   db_password : A database user password
   alhosts: Specifies the broker information of the standby server,
     which is used for failover when it is impossible to connect to
     the active server. You can specify multiple brokers for failover,
     and the connection to the brokers is attempted in the order listed
     in alhosts
   rctime : An interval between the attempts to connect to the active
     broker in which failure occurred. After a failure occurs, the
     system connects to the broker specified by althosts (failover),
     terminates the transaction, and then attempts to connect to the
     active broker of the master database at every rctime. The default
     value is 600 seconds.

Return a connection object.