def search_name(words, limit=None, file_type=None):
if not isinstance(words, list):
words = [words]
like_list = []
for word in words:
like_list.append('name like %s ' % repr('%' + word.upper() + '%'))
sql = "SELECT * from file WHERE %s and is_deleted != 1 " % (
" AND ".join(like_list))
if file_type != None:
sql += " AND type = %r" % file_type
sql += " ORDER BY atime DESC"
if not limit:
limit = 200
sql += " LIMIT {}".format(limit)
db = FileDB()
all = db.execute(sql)
return [FileDO.fromDict(item) for item in all]
def get_recent_modified(count):
db = FileDB()
all = db.execute(
"SELECT * FROM file WHERE is_deleted != 1 ORDER BY mtime DESC LIMIT %s"
% count)
return [FileDO.fromDict(item) for item in all]
def get_recent_visit(count):
db = FileDB()
all = db.execute(
"select * from file where is_deleted != 1 and not (related like '%%HIDE%%') order by atime desc limit %s"
% count)
return [FileDO.fromDict(item) for item in all]
def get_children_by_id(id):
db = get_db()
all = db.execute(
"SELECT * from file where parent_id = %s AND is_deleted != 1 order by sctime desc"
% id)
return [FileDO.fromDict(item) for item in all]
