def main(): import sys sys.path.append('/Users/patrickrudiger/GeodynamoExtrapolations/InteractiveFeatureDefinition') import paraview import TestEnvironment as TE data = self.GetInput() dataOut = self.GetOutput() TE.testClassifier(data,dataOut)
def testUpdateManyRowsOneColumn(self): session = TestEnvironment.getSession() insertData = [ ["GregoryInsertTest", "Smith"], ["MaryInsertTest", "Smith"], ["RebeccaInsertTest", "Smith"] ] insertedIds = [] try: insertedIds = session.insert("Contact", ["FirstName", "LastName"], insertData ) updateRows = [] for id in insertedIds: updateRows.append( [id, ("CEO-" + id) ]) session.update( "Contact", ["title"], updateRows ) nRows = int(session.getenv("ROW_COUNT")) self.failIf(0==nRows) self.assertEqual( len(insertedIds), nRows) for row in session.select("SELECT title from Contact where ID IN('" + "','".join(insertedIds) + "')"): self.assertTrue( row[0].startswith("CEO-")) finally: if None != insertedIds: session.delete( "Contact", insertedIds )
def testUpdateManyRowsOneColumn(self): session = TestEnvironment.getSession() insertData = [["GregoryInsertTest", "Smith"], ["MaryInsertTest", "Smith"], ["RebeccaInsertTest", "Smith"]] insertedIds = [] try: insertedIds = session.insert("Contact", ["FirstName", "LastName"], insertData) updateRows = [] for id in insertedIds: updateRows.append([id, ("CEO-" + id)]) session.update("Contact", ["title"], updateRows) nRows = int(session.getenv("ROW_COUNT")) self.failIf(0 == nRows) self.assertEqual(len(insertedIds), nRows) for row in session.select( "SELECT title from Contact where ID IN('" + "','".join(insertedIds) + "')"): self.assertTrue(row[0].startswith("CEO-")) finally: if None != insertedIds: session.delete("Contact", insertedIds)
def testInsertAndFindIds(self): session = TestEnvironment.getSession() insertData = [ ["GregoryInsertTest", "Smith"], ["MaryInsertTest", "Smith"], ["RebeccaInsertTest", "Smith"]] insertedIds = [] try: insertedIds = session.insert("Contact", ["FirstName", "LastName"], insertData ) self.assertEqual(len(insertData), len(insertedIds)) for id in insertedIds: self.assertTrue( None != id ) finally: if None != insertedIds: session.delete( "Contact", insertedIds )
def testInsertAndFindIds(self): session = TestEnvironment.getSession() insertData = [["GregoryInsertTest", "Smith"], ["MaryInsertTest", "Smith"], ["RebeccaInsertTest", "Smith"]] insertedIds = [] try: insertedIds = session.insert("Contact", ["FirstName", "LastName"], insertData) self.assertEqual(len(insertData), len(insertedIds)) for id in insertedIds: self.assertTrue(None != id) finally: if None != insertedIds: session.delete("Contact", insertedIds)
def testSelectRecordsWithCallback(self): firstName = "SelectRecords2UnitTest" session = TestEnvironment.getSession() insertData = [ [firstName, "Smith"], [firstName, "Hoiles"], [firstName, "Jones"]] insertedIds = [] try: insertedIds = session.insert("Contact", ["FirstName", "LastName"], insertData ) def callback(record): self.assertEquals( firstName, record.firstName) self.assertTrue( None != record.lastName ) session.selectRecords2("SELECT firstName, lastName FROM Contact where firstName='" + firstName + "'", callback) finally: if None != insertedIds: session.delete( "Contact", insertedIds )
def testSelectRecords(self): firstName = "SelectRecords2UnitTest" session = TestEnvironment.getSession() insertData = [ [firstName, "Smith"], [firstName, "Hoiles"], [firstName, "Jones"]] insertedIds = [] try: insertedIds = session.insert("Contact", ["FirstName", "LastName"], insertData ) records = session.selectRecords("SELECT firstName, lastName FROM Contact where firstName='" + firstName + "'") self.assertEquals( len(insertData), len(records)) for rr in records: self.assertEquals( firstName, rr.firstName) self.assertTrue( None != rr.lastName ) finally: if None != insertedIds: session.delete( "Contact", insertedIds )
def testSelectDeepRecords(self): firstName = "SelectRecords2UnitTest" session = TestEnvironment.getSession() insertedAccountId = None insertedIds = [] try: insertedAccountId = session.insert("Account", ["Name"], [["SelectRecordIndusty"]] )[0] insertData = [ [insertedAccountId, firstName, "Smith"]] insertedIds = session.insert("Contact", ["accountId", "FirstName", "LastName"], insertData ) records = session.selectRecords("SELECT name, account.name, account.owner.alias FROM Contact where id='" + insertedIds[0] + "'") for rec in records: self.assertTrue( None != rec.account.owner.alias ) finally: if None != insertedIds: session.delete( "Contact", insertedIds ) if None != insertedAccountId: session.delete( "Account", [insertedAccountId])
def testSelectDeepPath(self): session = TestEnvironment.getSession() session.selectRecords( "SELECT account.owner.name, account.lastModifiedBy.alias FROM contact LIMIT 1" )[0] '''
def testSelectWithCallback(self): session = TestEnvironment.getSession() n = session.select("SELECT COUNT() FROM Contact")[0][0] self.assertTrue(n)
def testSelectDeepPath(self): session = TestEnvironment.getSession() session.selectRecords("SELECT account.owner.name, account.lastModifiedBy.alias FROM contact LIMIT 1")[0] '''
''' Created on Jan 18, 2010 @author: greg ''' import TestEnvironment session = TestEnvironment.getSession() for record in session.selectRecords( "Select firstName, lastName from Contact order by firstName asc limit 10" ): print "First name: " + record.firstName print "Last name: " + record.lastName
''' Created on Jan 18, 2010 @author: greg ''' import TestEnvironment session = TestEnvironment.getSession() for record in session.selectRecords( "Select firstName, lastName from Contact order by firstName asc limit 10"): print "First name: " + record.firstName print "Last name: " + record.lastName
def testBasicConnect(self): session = TestEnvironment.getSession() self.assertTrue( session ) n = session.select("SELECT COUNT() FROM Contact")[0][0] self.assertTrue(n)