def read(self): try: # self.readUser() col = ["Text", "WindowPosition", "Theme"] limit = "limit 2" if self.debug else '' rs = self.db.execute( "SELECT {0} FROM Note WHERE ParentId='{1}' {2}".format( _.join(col, ','), self.id, limit)) return {"res": self.convert(rs)['res']} except Exception as e: return {"e": e}
def dumpBackupOneRow(self): try: col = ["*"] limit = "LIMIT 2" if self.debug else '' rs = self.db.execute( "SELECT {0} FROM Note WHERE ParentId='{1}' {2}".format( _.join(col, ','), self.id, limit)) self.backup = self.convert(rs)['res'] return {"res": True} except Exception as e: return {"e": e}
def parser(k): cols = [ "Text", "WindowPosition", "Id", "ParentId", "Theme", "CreatedAt", "UpdatedAt" ] parms = [ self.temp[k]['Text'], self.temp[k]['WindowPosition'], uuid.uuid1(), self.id, self.temp[k]['Theme'], int(time.time()), int(time.time()) ] for index in range(0, len(parms)): parms[index] = "'{0}'".format(parms[index]) if self.debug: for index in range(0, len(cols)): print(cols[index], " = ", parms[index]) sql = "INSERT INTO Note ({0}) VALUES ({1})".format( _.join(cols, ','), _.join(parms, ",")) print("sql", sql) self.db.execute(sql) self.conn.commit()
} } } }, lambda value, property_path: '.'.join(property_path) + '==' + value), { 'level1': { 'value': 'level1.value==value 1', 'level2': { 'value': 'level1.level2.value==value 2', 'level3': { 'value': 'level1.level2.level3.value==value 3' } } } }), (([['value 1', [['value 2', ['value 3']]]]], lambda value, property_path: (_.join(property_path, '.') + '==' + value)), [['0.0==value 1', [['0.1.0.0==value 2', ['0.1.0.1.0==value 3']]]]]), ]) def test_map_values_deep(case, expected): assert _.map_values_deep(*case) == expected @parametrize('case,expected', [(({ 'characters': [{ 'name': 'barney' }, { 'name': 'fred' }] }, { 'characters': [{ 'age': 36
'value': 'value 2', 'level3': { 'value': 'value 3' } }}}, lambda value, property_path: '.'.join(property_path) + '==' + value), {'level1': { 'value': 'level1.value==value 1', 'level2': { 'value': 'level1.level2.value==value 2', 'level3': { 'value': 'level1.level2.level3.value==value 3' } }}}), (([['value 1', [['value 2', ['value 3']]]]], lambda value, property_path: (_.join(property_path, '.') + '==' + value)), [['0.0==value 1', [['0.1.0.0==value 2', ['0.1.0.1.0==value 3']]]]]), ]) def test_map_values_deep(case, expected): assert _.map_values_deep(*case) == expected @parametrize('case,expected', [ (({'characters': [{'name': 'barney'}, {'name': 'fred'}]}, {'characters': [{'age': 36}, {'age': 40}]}), {'characters': [{'name': 'barney', 'age': 36}, {'name': 'fred', 'age': 40}]}), (({'characters': [{'name': 'barney'}, {'name': 'fred'}, {}]}, {'characters': [{'age': 36}, {'age': 40}]}),
"level1": { "value": "level1.value==value 1", "level2": { "value": "level1.level2.value==value 2", "level3": { "value": "level1.level2.level3.value==value 3" }, }, } }, ), ( ( [["value 1", [["value 2", ["value 3"]]]]], lambda value, property_path: (_.join(property_path, ".") + "==" + value), ), [["0.0==value 1", [["0.1.0.0==value 2", ["0.1.0.1.0==value 3"]]]]], ), ], ) def test_map_values_deep(case, expected): assert _.map_values_deep(*case) == expected @parametrize( "case,expected", [ ( ( {
def get_page_titles(cursor, page_ids): cursor.execute("SELECT title FROM pages WHERE id IN (" + _.join(page_ids, ',') + ")") return _.pluck(cursor.fetchall(), 'title')
def test_join(case, expected): assert _.join(*case) == expected
lambda value, property_path: ".".join(property_path) + "==" + value, ), { "level1": { "value": "level1.value==value 1", "level2": { "value": "level1.level2.value==value 2", "level3": {"value": "level1.level2.level3.value==value 3"}, }, } }, ), ( ( [["value 1", [["value 2", ["value 3"]]]]], lambda value, property_path: (_.join(property_path, ".") + "==" + value), ), [["0.0==value 1", [["0.1.0.0==value 2", ["0.1.0.1.0==value 3"]]]]], ), ], ) def test_map_values_deep(case, expected): assert _.map_values_deep(*case) == expected @parametrize( "case,expected", [ ( ( {"characters": [{"name": "barney"}, {"name": "fred"}]},
lambda value, property_path: ".".join(property_path) + "==" + value, ), { "level1": { "value": "level1.value==value 1", "level2": { "value": "level1.level2.value==value 2", "level3": {"value": "level1.level2.level3.value==value 3"}, }, } }, ), ( ( [["value 1", [["value 2", ["value 3"]]]]], lambda value, property_path: (_.join(property_path, ".") + "==" + value), ), [["0.0==value 1", [["0.1.0.0==value 2", ["0.1.0.1.0==value 3"]]]]], ), ], ) def test_deep_map_values(case, expected): assert _.deep_map_values(*case) == expected @parametrize( "case,expected", [ (({}, ["one", "two", "three", "four"], 1), {"one": {"two": {"three": {"four": 1}}}}), (({}, "one.two.three.four", 1), {"one": {"two": {"three": {"four": 1}}}}), (