Guest User

Untitled

a guest
Oct 17th, 2017
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.71 KB | None | 0 0
  1. # Convert priority to an odd number
  2. priority = (int(priority) * 2) - 1
  3.  
  4. queries = [
  5. ("INSERT INTO rules (rules, priority) VALUES ('{}', %s)", (int(priority),)),
  6. ("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))),
  7. ("SET @priority_inc = 2;", None),
  8. ("SET @new_priority = 0;", None),
  9. ("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),))
  10. ]
Add Comment
Please, Sign In to add comment