rendered paste body def prepare_display ( self ): cur = db.database.cursor ( ) cur.execute ( "select id,name,filename,rating,filename_preview,sentence_preview,size_preview,has_tag from fonts where fonts.filename=?", ( self.paf, ) ) result = [i for i in cur] try: try: font_db = result[0] self.id_db = font_db[0] self.font = font_db[1] except: return try: self.rating = font_db[3] except: self.rating = "NC" try: self.preview = font_db[4] self.preview_sentence = font_db[5] self.preview_size = font_db[6] except: self.preview = False self.preview_sentence = False self.preview_size = False if font_db[7] == 1: self.has_tag = 1 cur.execute ( "select id,tag from tags, fonts_tags where tags.id = fonts_tags.id_tag and fonts_tags.id_font = ?", ( font_db[0], ) ) self.tags = [i for i in cur.fetchall ( )] else: self.tags = [] self.has_tag = 0 finally: cur.close ( )