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]
'''
def testSelectWithCallback(self):
session = TestEnvironment.getSession()
n = session.select("SELECT COUNT() FROM Contact")[0][0]
self.assertTrue(n)
'''
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)
