def testgensimplesql(self):
types, _, _ = randgentable(2, 5, 1)
sqls = genSimpleSQL(types, 2)
for sql in sqls:
assert isinstance(sql, list)
for s in sql:
assert isinstance(s, str)
def testgenview(self):
types, _, _ = randgentable(2, 5, 1)
sql = genSimpleSQL(types, 2)
views = genView(sql.pop(), 1, joincond=False)
for v in views:
assert len(v) == 3
assert isinstance(v[0], str)
assert isinstance(v[1], tuple)
assert isinstance(v[2], str)
def testgenjoin(self):
types, _, _ = randgentable(3, 3, 3)
idcol = genJoin(types, 4)
# an empty result is meaningless
assert idcol is not []
for i in idcol:
# join table number
assert len(i) <= 4
for tableid, colnum in i:
# correct result
assert isinstance(tableid, int)
assert isinstance(colnum, int)
def testgencol(self):
types, _, _ = randgentable(3, 3, 3)
# the maximum number of columns is 3
cols = genCol(types, 4)
for col in cols:
# it cannot be empty
assert cols is not []
assert len(col) <= 3
# correct type
for i, coln in col:
assert isinstance(coln, DataType)
def setUp(self):
self.types, self.values, self.sql = randgen.randgentable()
def testgensqlwithjoin(self):
# FIXME: bug when rownum=0
types, _, _ = randgentable(8, 5, 3)
sqls = genSelectWithJoin(types, 5, 2)
def setUp(self) -> None:
self.types, self.values, _ = randgentable(2, 5, 3)