Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # Convert priority to an odd number
- priority = (int(priority) * 2) - 1
- queries = [
- ("INSERT INTO rules (rules, priority) VALUES ('{}', %s)", (int(priority),)),
- ("INSERT INTO content (game_id, content_name, content_type_id, revision, rules_id) values(%s, %s, %s, 1, LAST_INSERT_ID())", (int(self.id), name, int(type))),
- ("SET @priority_inc = 2;", None),
- ("SET @new_priority = 0;", None),
- ("Update rules set rules.priority=(@new_priority := @new_priority + @priority_inc) where rules_id IN (SELECT rules_id FROM content WHERE game_id=%s GROUP BY content_id) order by rules.priority ASC", (int(self.id),))
- ]
Add Comment
Please, Sign In to add comment