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)