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]