def setUp(self):
if not testutil.mysql_enabled():
raise SkipTest, "no MySQL installed"
self.dbtable = testutil.temp_table_name() # create temp db tables
Sequence_Test.setUp(self, pygrDataPath='mysql:' + self.dbtable,
mdbArgs=dict(createLayer='temp'))
def setUp(self):
if not testutil.mysql_enabled():
raise SkipTest, "no MySQL"
createOpts = dict(source_id='int', target_id='int', edge_id='int')
self.datagraph = sqlgraph.SQLGraph(self.dbname, dropIfExists=True,
createTable=createOpts)
def setUp(self):
if not testutil.mysql_enabled():
raise SkipTest("no MySQL installed")
self.dbtable = testutil.temp_table_name() # create temp db tables
Sequence_Test.setUp(self, pygrDataPath='mysql:' + self.dbtable,
mdbArgs=dict(createLayer='temp'))
def setUp(self, serverInfo=None, dbname='test.sqlsequence_test'):
if not testutil.mysql_enabled():
raise SkipTest("no MySQL installed")
createTable = 'CREATE TABLE %s (primary_id INTEGER PRIMARY KEY \
%%(AUTO_INCREMENT)s, sequence TEXT)' % dbname
self.db = self._dbClass(dbname,
serverInfo=serverInfo,
itemClass=self._rowClass,
dropIfExists=True,
createTable=createTable,
attrAlias=dict(seq='sequence'))
self.db.cursor.execute("""\
INSERT INTO %s (sequence) VALUES ('\
CACCCTGCCCCATCTCCCCAGCCTGGCCCCTCGTGTCTCAGAACCCTCGGGGGGAGGCACAGAAGCCTTCGGGG')"""
% dbname)
self.db.cursor.execute("""\
INSERT INTO %s (sequence)
VALUES ('GAAAGAAAGAAAGAAAGAAAGAAAGAGAGAGAGAGAGACAGAAG')
""" % dbname)
self.row1 = self.db[1]
self.row2 = self.db[2]
self.EQ = self.assertEqual
def setUp(self):
if not testutil.mysql_enabled():
raise SkipTest
self.dbtable = testutil.temp_table_name() # create temp db tables
Sequence_Test.setUp(self, worldbasePath='mysql:' + self.dbtable,
mdbArgs=dict(createLayer='temp'))
def setUp(self):
if not testutil.mysql_enabled():
raise SkipTest("no MySQL")
createOpts = dict(source_id='int', target_id='int', edge_id='int')
self.datagraph = sqlgraph.SQLGraph(self.dbname, dropIfExists=True,
createTable=createOpts)
def setUp(self, serverInfo=None, dbname='test.sqlsequence_test'):
if not testutil.mysql_enabled():
raise SkipTest("no MySQL installed")
createTable = 'CREATE TABLE %s (primary_id INTEGER PRIMARY KEY \
%%(AUTO_INCREMENT)s, sequence TEXT)' % dbname
self.db = self._dbClass(dbname, serverInfo=serverInfo,
itemClass=self._rowClass, dropIfExists=True,
createTable=createTable,
attrAlias=dict(seq='sequence'))
self.db.cursor.execute("""\
INSERT INTO %s (sequence) VALUES ('\
CACCCTGCCCCATCTCCCCAGCCTGGCCCCTCGTGTCTCAGAACCCTCGGGGGGAGGCACAGAAGCCTTCGGGG')"""
% dbname)
self.db.cursor.execute("""\
INSERT INTO %s (sequence)
VALUES ('GAAAGAAAGAAAGAAAGAAAGAAAGAGAGAGAGAGAGACAGAAG')
""" % dbname)
self.row1 = self.db[1]
self.row2 = self.db[2]
self.EQ = self.assertEqual
def get_suite():
"Returns the testsuite"
tests = []
# detect mysql
if testutil.mysql_enabled():
tests.append(SQLSequence_Test)
else:
testutil.info("*** skipping SQLSequence_Test")
if testutil.sqlite_enabled():
tests.append(SQLiteSequence_Test)
else:
testutil.info("*** skipping SQLSequence_Test")
return testutil.make_suite(tests)
def get_suite():
"Returns the testsuite"
tests = []
# detect mysql
if testutil.mysql_enabled():
tests.append(SQLSequence_Test)
else:
testutil.info('*** skipping SQLSequence_Test')
if testutil.sqlite_enabled():
tests.append(SQLiteSequence_Test)
else:
testutil.info('*** skipping SQLSequence_Test')
return testutil.make_suite(tests)
def setUp(self, serverInfo=None, dbname="test.sqlsequence_test"):
if not testutil.mysql_enabled():
raise SkipTest, "no MySQL installed"
createTable = (
"""\
CREATE TABLE %s
(primary_id INTEGER PRIMARY KEY %%(AUTO_INCREMENT)s, sequence TEXT)
"""
% dbname
)
self.db = sqlgraph.SQLTable(
dbname, serverInfo=serverInfo, dropIfExists=True, createTable=createTable, attrAlias=dict(seq="sequence")
)
self.db.cursor.execute(
"""\
INSERT INTO %s (sequence)
VALUES ('CACCCTGCCCCATCTCCCCAGCCTGGCCCCTCGTGTCTCAGAACCCTCGGGGGGAGGCACAGAAGCCTTCGGGG')
"""
% dbname
)
self.db.cursor.execute(
"""\
INSERT INTO %s (sequence)
VALUES ('GAAAGAAAGAAAGAAAGAAAGAAAGAGAGAGAGAGAGACAGAAG')
"""
% dbname
)
class DNASeqRow(seqdb.DNASQLSequence):
def __len__(self): # just speed optimization
return self._select("length(sequence)") # SQL SELECT expression
# force the table object to return DNASeqRow objects
self.db.objclass(DNASeqRow)
self.row1 = self.db[1]
self.row2 = self.db[2]
self.EQ = self.assertEqual
def setUp(self):
if not testutil.mysql_enabled():
raise SkipTest("no MySQL installed")
self.load_data(writeable=self.writeable, ** self.loadArgs)
def setUp(self):
if not testutil.mysql_enabled():
raise SkipTest("no MySQL installed")
self.load_data(writeable=self.writeable, **self.loadArgs)
