def test(): from pyre.extensions import postgres as pyrepg # initialize the module exceptions import pyre.db.exceptions as exceptions pyrepg.registerExceptions(exceptions) # make a connection connection = pyrepg.connect("dbname=postgres") # execute a command try: pyrepg.execute(connection, "no-such-command") assert False except pyrepg.ProgrammingError: pass # and return it return connection
def test(): # import journal # journal.debug("postgres.init").active = True # journal.debug("postgres.connection").active = True # journal.debug("postgres.execution").active = True from pyre.extensions import postgres as pyrepg # initialize the module exceptions import pyre.db.exceptions as exceptions pyrepg.registerExceptions(exceptions) # make a connection connection = pyrepg.connect("dbname=postgres") # execute a command command = "SELECT datname FROM pg_database WHERE datname='postgres'" result = pyrepg.execute(connection, command) # check that we got what we expected assert result == (('datname', ), ('postgres', )) # and return the connection and the resulting tuple return connection, result