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
