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}}}}),
(
