Python basicSQLExec Examples

Example #1

 def execute(self):
     is_super = None
     conn = dbconn.connect(self.dburl, utility=True)
     try:
         q = "SELECT usesuper FROM pg_user WHERE usename = user"
         rows = catalog.basicSQLExec(conn, q)
         is_super = rows[0][0]
     except Exception, e:
         raise MoveFilespaceError(str(e))

Example #2

File: filespace.py Project: 50wu/gpdb

 def execute(self):
     is_super = None
     conn = dbconn.connect(self.dburl, utility=True)
     try:
         q = "SELECT usesuper FROM pg_user where usename = user"
         rows = catalog.basicSQLExec(conn, q)
         is_super = rows[0][0]
     except Exception, e:
         raise MoveFilespaceError(str(e))

Example #3

def runQuery(query):
    global dbConn
    if dbConn == None:
        logger.error("Error: Not connected to database.")
        sys.exit(1)

    try:
        rows = catalog.basicSQLExec(dbConn, query)
    except Exception, e:
        logger.error("Error: Failed to run query: %s" % (str(e)))
        sys.exit(1)

Example #4

File: gpgenfsmap.py Project: PengJi/gpdb-comments

def runQuery(query):
    global dbConn
    if dbConn == None:
        logger.error("Error: Not connected to database.")
        sys.exit(1)

    try:
        rows = catalog.basicSQLExec(dbConn, query)
    except Exception, e:
        logger.error("Error: Failed to run query: %s" % (str(e)))
        sys.exit(1)