def _get_undateable_tag(db: DatabaseHandler) -> dict: """Return the date_invalid:undateable tag.""" tag_name = 'undateable' tag_set_name = 'date_invalid' invalid_tag = db.query( """ select t.* from tags t join tag_sets ts using ( tag_sets_id ) where t.tag = %(a)s and ts.name = %(b)s """, { 'a': tag_name, 'b': tag_set_name }).hash() if invalid_tag is None: tag_set = db.find_or_create('tag_sets', {'name': tag_set_name}) invalid_tag = db.find_or_create('tags', { 'tag': tag_name, 'tag_sets_id': tag_set['tag_sets_id'] }) return invalid_tag
def _get_undateable_tag(db: DatabaseHandler) -> dict: """Return the date_invalid:undateable tag.""" tag_name = 'undateable' tag_set_name = 'date_invalid' invalid_tag = db.query( """ select t.* from tags t join tag_sets ts using ( tag_sets_id ) where t.tag = %(a)s and ts.name = %(b)s """, {'a': tag_name, 'b': tag_set_name}).hash() if invalid_tag is None: tag_set = db.find_or_create('tag_sets', {'name': tag_set_name}) invalid_tag = db.find_or_create('tags', {'tag': tag_name, 'tag_sets_id': tag_set['tag_sets_id']}) return invalid_tag
def _get_undateable_tag(db: DatabaseHandler) -> dict: """Return the date_invalid:undateable tag.""" tag_name = 'undateable' tag_set_name = 'date_invalid' invalid_tag = db.query(""" SELECT t.* FROM tags AS t INNER JOIN tag_sets AS ts USING (tag_sets_id) WHERE t.tag = %(tag_name)s AND ts.name = %(tag_set_name)s """, { 'tag_name': tag_name, 'tag_set_name': tag_set_name, }).hash() if invalid_tag is None: tag_set = db.find_or_create('tag_sets', {'name': tag_set_name}) invalid_tag = db.find_or_create('tags', {'tag': tag_name, 'tag_sets_id': tag_set['tag_sets_id']}) return invalid_tag