API tools faq
paste
Advertisement
chfoo0

tinytown sql

chfoo0
Oct 29th, 2014
174
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.49 KB | None | 0 0
raw download clone embed print report
  1. INFO:sqlalchemy.engine.base.Engine:BEGIN (implicit)
  2. INFO:sqlalchemy.engine.base.Engine:SELECT blocked_users.username AS blocked_users_username, blocked_users.note AS blocked_users_note
  3. FROM blocked_users
  4. WHERE blocked_users.username = ?
  5. LIMIT ? OFFSET ?
  6. INFO:sqlalchemy.engine.base.Engine:('testuser', 1, 0)
  7. INFO:sqlalchemy.engine.base.Engine:COMMIT
  8. INFO:sqlalchemy.engine.base.Engine:BEGIN (implicit)
  9. INFO:sqlalchemy.engine.base.Engine:SELECT blocked_users.username AS blocked_users_username, blocked_users.note AS blocked_users_note
  10. FROM blocked_users
  11. WHERE blocked_users.username = ?
  12. LIMIT ? OFFSET ?
  13. INFO:sqlalchemy.engine.base.Engine:('127.0.0.1', 1, 0)
  14. INFO:sqlalchemy.engine.base.Engine:COMMIT
  15. INFO:sqlalchemy.engine.base.Engine:BEGIN (implicit)
  16. INFO:sqlalchemy.engine.base.Engine:SELECT projects.name AS projects_name, projects.min_version AS projects_min_version, projects.min_client_version AS projects_min_client_version, projects.alphabet AS projects_alphabet, projects.url_template AS projects_url_template, projects.request_delay AS projects_request_delay, projects.redirect_codes AS projects_redirect_codes, projects.no_redirect_codes AS projects_no_redirect_codes, projects.unavailable_codes AS projects_unavailable_codes, projects.banned_codes AS projects_banned_codes, projects.body_regex AS projects_body_regex, projects.method AS projects_method, projects.enabled AS projects_enabled, projects.autoqueue AS projects_autoqueue, projects.num_count_per_item AS projects_num_count_per_item, projects.max_num_items AS projects_max_num_items, projects.lower_sequence_num AS projects_lower_sequence_num, projects.autorelease_time AS projects_autorelease_time
  17. FROM projects
  18. WHERE projects.autorelease_time > ?
  19. INFO:sqlalchemy.engine.base.Engine:(0,)
  20. INFO:sqlalchemy.engine.base.Engine:COMMIT
  21. INFO:sqlalchemy.engine.base.Engine:BEGIN (implicit)
  22. INFO:sqlalchemy.engine.base.Engine:SELECT items.id AS items_id, items.project_id AS items_project_id, items.lower_sequence_num AS items_lower_sequence_num, items.upper_sequence_num AS items_upper_sequence_num, items.datetime_claimed AS items_datetime_claimed, items.tamper_key AS items_tamper_key, items.username AS items_username, items.ip_address AS items_ip_address
  23. FROM items JOIN projects ON projects.name = items.project_id
  24. WHERE items.username IS NULL AND NOT (EXISTS (SELECT 1
  25. FROM items, items AS items_1
  26. WHERE items.project_id = items_1.project_id AND items_1.ip_address = ?)) AND projects.enabled = 1 AND projects.min_version <= ? AND projects.min_client_version <= ?
  27. LIMIT ? OFFSET ?
  28. INFO:sqlalchemy.engine.base.Engine:('127.0.0.1', 8, 4, 1, 0)
  29. INFO:sqlalchemy.engine.base.Engine:SELECT projects.name AS projects_name, projects.min_version AS projects_min_version, projects.min_client_version AS projects_min_client_version, projects.alphabet AS projects_alphabet, projects.url_template AS projects_url_template, projects.request_delay AS projects_request_delay, projects.redirect_codes AS projects_redirect_codes, projects.no_redirect_codes AS projects_no_redirect_codes, projects.unavailable_codes AS projects_unavailable_codes, projects.banned_codes AS projects_banned_codes, projects.body_regex AS projects_body_regex, projects.method AS projects_method, projects.enabled AS projects_enabled, projects.autoqueue AS projects_autoqueue, projects.num_count_per_item AS projects_num_count_per_item, projects.max_num_items AS projects_max_num_items, projects.lower_sequence_num AS projects_lower_sequence_num, projects.autorelease_time AS projects_autorelease_time, anon_1.queue_size AS anon_1_queue_size
  30. FROM projects LEFT OUTER JOIN (SELECT items.project_id AS project_id, count(items.id) AS queue_size
  31. FROM items GROUP BY items.project_id) AS anon_1 ON projects.name = anon_1.project_id
  32. WHERE projects.autoqueue = 1 AND projects.enabled = 1 AND projects.min_version <= ? AND projects.min_client_version <= ? AND coalesce(anon_1.queue_size, ?) < projects.max_num_items AND NOT (EXISTS (SELECT 1
  33. FROM items
  34. WHERE items.ip_address = ? AND items.project_id = projects.name)) ORDER BY random()
  35. LIMIT ? OFFSET ?
  36. INFO:sqlalchemy.engine.base.Engine:(8, 4, 0, '127.0.0.1', 1, 0)
  37. INFO:sqlalchemy.engine.base.Engine:SELECT EXISTS (SELECT 1
  38. FROM items
  39. WHERE items.ip_address = ?) AS anon_1
  40. INFO:sqlalchemy.engine.base.Engine:('127.0.0.1',)
  41. INFO:sqlalchemy.engine.base.Engine:SELECT max(projects.min_version) AS max_1, max(projects.min_client_version) AS max_2
  42. FROM projects
  43. LIMIT ? OFFSET ?
  44. INFO:sqlalchemy.engine.base.Engine:(1, 0)
  45. INFO:sqlalchemy.engine.base.Engine:ROLLBACK
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!