Skip to content

Instantly share code, notes, and snippets.

@efischer19
Created August 10, 2017 19:16
Show Gist options
  • Save efischer19/fcc63118c73c2e35c8ddef33808239ff to your computer and use it in GitHub Desktop.
Save efischer19/fcc63118c73c2e35c8ddef33808239ff to your computer and use it in GitHub Desktop.
id fetch all SQL
#!/usr/bin/python
# -*- coding: utf-8 -*-
[
{u'time': u'0.004',
u'sql': u'SELECT `submissions_submission`.`id`, `submissions_submission`.`uuid`, `submissions_submission`.`student_item_id`, `submissions_submission`.`attempt_number`, `submissions_submission`.`submitted_at`, `submissions_submission`.`created_at`, `submissions_submission`.`raw_answer`, `submissions_submission`.`status` FROM `submissions_submission` WHERE (`submissions_submission`.`id` <= 7 AND `submissions_submission`.`id` >= 0) ORDER BY `submissions_submission`.`submitted_at` DESC, `submissions_submission`.`id` DESC'
},
{u'time': u'0.000',
u'sql': u"UPDATE `submissions_submission` SET `uuid` = '3fca942d09da41da92c1879851b1c512' WHERE `submissions_submission`.`id` = 7"
},
{u'time': u'0.000',
u'sql': u"UPDATE `submissions_submission` SET `uuid` = '524dd0a385a14c749d0a910798efad8e' WHERE `submissions_submission`.`id` = 5"
},
{u'time': u'0.000',
u'sql': u"UPDATE `submissions_submission` SET `uuid` = 'ffe50a97e19345e48f1a62b1401b07e9' WHERE `submissions_submission`.`id` = 4"
},
{u'time': u'0.000',
u'sql': u"UPDATE `submissions_submission` SET `uuid` = 'd057f32ec283463698b74fe8a5407b13' WHERE `submissions_submission`.`id` = 6"
},
{u'time': u'0.000',
u'sql': u"UPDATE `submissions_submission` SET `uuid` = 'c5f888b8868446bda994c4a7acfeadf9' WHERE `submissions_submission`.`id` = 2"
},
{u'time': u'0.000',
u'sql': u"UPDATE `submissions_submission` SET `uuid` = '88f6ae6f67f411e7b72e08002779ca96' WHERE `submissions_submission`.`id` = 1"
},
]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment