def test_10_editCatVariant(self): if not self.runAll: if 10 not in self.runTestCounts: return show = False print(' test_10_editCatVariant') edits = ( #cat_var_id, cat_var_name (5, 'horseee'), (6, 'oink oink'), (7, 'woof dog'), ) newExpCats = ( #catId, pathRev, catName, dMetaName0, dMetaName1, validForLatest ) newExpCatVars = ( #catVarId, pathRev, catId, catName, dMetaName0, dMetaName1, validForLatest (5, 1, 2, 'horseee', 'HRS', '', 1), (6, 1, 3, 'oink oink', 'ANKN', '', 1), (7, 1, 4, 'woof dog', 'AFTK', 'FFTK', 1), ) db = CategorizerData(self.path, self.lock) for i in range(len(edits)): catVarId = edits[i][0] catVarName = edits[i][1] db.editCatVariant(catVarId, catVarName) self._addExpDataa('catVariants', newExpCatVars) self._addExpDataa('categories', newExpCats) actCats = db.dumpTable('categories') self.compareTuples('categories', self.expDataa['categories'], actCats, show) actCatVars = db.dumpTable('catVariants') self.compareTuples('catVariants', self.expDataa['catVariants'], actCatVars, show)
def test_10_editCatVariant(self): if not self.runAll: if 10 not in self.runTestCounts: return show = False print(' test_10_editCatVariant') edits = ( #cat_var_id, cat_var_name (8, 'horseee'), (9, 'oink oink'), (10, 'woof dog'), ) newExpCats = ( #catId, pathRev, catName, dMetaName0, dMetaName1, validForLatest ) newExpCatVars = ( #catVarId, pathRev, catId, catName, dMetaName0, dMetaName1, validForLatest (8, 2, 2, 'horsey', 'HRS', '', 0), (9, 2, 3, 'piggy', 'PK', '', 0), (10, 2, 4, 'doggie', 'TJ', 'TK', 0), (8, 8, 2, 'horseee', 'HRS', '', 1), (9, 8, 3, 'oink oink', 'ANKN', '', 1), (10, 8, 4, 'woof dog', 'AFTK', 'FFTK', 1), ) db = CategorizerData(self.path, self.lock) if show: self.showTables(db, ('categories', 'catVariants')) for (catVarId, catVarName) in edits: # catVarId = edits[i][0] # catVarName = edits[i][1] db.editCatVariant(catVarId, catVarName) self._addExpDataa('catVariants', newExpCatVars) self._addExpDataa('categories', newExpCats) actCats = db.dumpTable('categories') self.compareTuples('categories', self.expDataa['categories'], actCats, show) actCatVars = db.dumpTable('catVariants') self.compareTuples('catVariants', self.expDataa['catVariants'], actCatVars, show)