Skip to content

Instantly share code, notes, and snippets.

@singingwolfboy

singingwolfboy/gist:bb6e412017947674df50

Last active August 29, 2015 14:16
Show Gist options
  • Save singingwolfboy/bb6e412017947674df50 to your computer and use it in GitHub Desktop.
Save singingwolfboy/bb6e412017947674df50 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
SELECT r.name AS repo_name, pr.number, u.login AS github_username, pr.title, pr.created_at
FROM github_pull_request AS pr, github_repository AS r, github_user as u
WHERE pr.base_repo_id = r.id
AND pr.user_id = u.id
AND pr.state = 'open'
AND pr.created_at < NOW() - INTERVAL '45 days'
ORDER BY pr.created_at;
repo_name | number | github_username | title | created_at
-------------------------+--------+-----------------+-----------------------------------------------------------------------------------------------------+---------------------
xqueue | 59 | jtauber | Checker API Docs | 2013-08-01 12:57:30
xserver | 6 | e0d | updating boto, django and new relic | 2013-10-31 18:44:06
acid-block | 3 | cpennington | Add a test that counts the number of children rendered, to make sure that that matches expectations | 2014-02-21 12:01:20
acid-block | 6 | nedbat | Test sending Unicode from Javascript | 2014-04-02 17:55:26
xqueue | 80 | davestgermain | Added an option for blocking get requests, possible when running with gevent | 2014-04-17 21:25:40
configuration | 1197 | e0d | logging config, refactoring, more handler calls | 2014-06-10 15:55:15
edx-platform | 4277 | singingwolfboy | Update mako to 1.0.0 | 2014-07-01 20:29:40
edx-platform | 4278 | singingwolfboy | Update Markdown to 2.5.2 | 2014-07-01 20:53:48
edx-ora2 | 521 | wedaly | Add a link to the instructor dash in the course staff debug info | 2014-07-22 19:11:18
edx-platform | 4539 | carsongee | Adds longerusername to support usernames longer than 30 characters | 2014-07-24 14:25:41
edx-platform | 4575 | lamagnifica | Course re-run section and refs to it in others | 2014-07-28 13:30:35
edx-platform | 4576 | tusbar | Change template default filtering from dangerous to safe | 2014-07-28 14:06:29
xblock-sdk | 24 | pmitros | API access to scenario list | 2014-07-30 02:22:13
opaque-keys | 30 | cpennington | Make DefinitionLocator safer to use | 2014-08-01 15:26:12
xqueue | 88 | singingwolfboy | Update newrelic to 2.22.1.20 | 2014-08-01 19:04:33
xqueue | 89 | singingwolfboy | Update requests to 2.5.1 | 2014-08-01 19:16:26
edx-platform | 4831 | cpennington | Add a default CONTENTSTORE definition to the LMS dev.py | 2014-08-14 15:57:05
edx-platform | 4870 | singingwolfboy | Skip slow tests | 2014-08-18 15:59:26
edx-submissions | 10 | cpennington | WIP: Update django | 2014-09-03 17:19:41
configuration | 1548 | e0d | E0d/service builder | 2014-09-16 12:31:57
edx-val | 27 | mhoeber | WIP: API doc | 2014-09-23 13:48:35
edx-platform | 5409 | martynjames | edX Solutions Team: Cast grade weight to float | 2014-09-26 20:36:14
edx-platform | 5411 | martynjames | edX Solutions Team: New CourseAssistantRole | 2014-09-26 20:41:33
configuration | 1614 | singingwolfboy | Don't use {{ }} for loop variables when it's unnecessary | 2014-10-07 15:57:22
edx-platform | 5516 | cpennington | Remove some deprecated api usage from the code | 2014-10-08 02:46:12
repo-tools | 19 | singingwolfboy | edx-analytics-api-client is deprecated, and should be removed | 2014-10-14 14:19:17
edx-platform | 5579 | fredsmith | github requirements don't need to use the -e flag | 2014-10-14 19:23:36
edx-platform | 5581 | jzoldak | Add expected whitespace to capa multiple choice response test | 2014-10-14 20:39:24
edx-platform | 5602 | mattdrayer | edX Solutions Team: Runtime Profiler contribution | 2014-10-16 15:45:23
edx-platform | 5807 | Shrhawk | Fixed empty display name with original value | 2014-10-31 11:23:14
edx-platform | 5882 | muhammad-ammar | Use Split ModuleStore | 2014-11-07 15:15:29
edx-platform | 5889 | Shrhawk | Fix jump_to_id url | 2014-11-10 10:16:33
harprofiler | 25 | cgoldberg | packaging with a setup.py and proper package hierarchy | 2014-11-11 20:07:06
configuration | 1697 | trungpham | allow ansible to be pulled from a private repo | 2014-11-12 19:10:19
XBlock | 271 | cpennington | Allow XBlock to run under python 3 | 2014-11-19 16:37:09
edx-platform | 6000 | cahrens | WIP: Hackathon xblock editor | 2014-11-20 16:37:29
edx-platform | 6009 | clytwynec | fixup! Upgraded to Django 1.5 | 2014-11-20 21:11:49
XBlock | 275 | nedbat | Ned/fix pylint py3 | 2014-11-21 10:43:16
edx-platform | 6016 | cpennington | Upgrade django-debug-toolbar to 1.2.2 | 2014-11-21 14:06:06
edx-platform | 6017 | cpennington | Prep for Django 1.5: Pass all GitExportErrors as unicode strings | 2014-11-21 14:21:18
XBlock | 276 | singingwolfboy | Python 3 support | 2014-11-21 15:14:28
edx-platform | 6020 | cpennington | Don't parse xml in all tests | 2014-11-21 16:49:53
edx-val | 33 | cpennington | Test with django 1.4 - 1.6 | 2014-11-21 17:55:35
edx-platform | 6028 | cahrens | WIP: Default Studio editing support for xblocks | 2014-11-21 20:02:02
edx-platform | 6029 | benpatterson | Add static code analysis tools. | 2014-11-21 20:02:53
edx-documentation | 35 | shnayder | [WIP] Adds a summary of the ORA2 data schema. | 2014-11-23 15:46:05
edx-platform | 6035 | doctoryes | WIP: Convert vertical XModule to pure XBlock. | 2014-11-24 14:14:21
edx-platform | 6048 | zubair-arbi | remove mathjax form main xmodule requirement and add it on problem addin... | 2014-11-25 10:50:11
edx-platform | 6061 | jzoldak | WIP do not merge | 2014-11-25 20:53:22
configuration | 1723 | benpatterson | Add vagrant tests for devstack. | 2014-11-26 19:33:18
edx-platform | 6081 | kluo | Implement themed enrollment email feature | 2014-11-27 00:13:59
edx-ora2 | 640 | regisb | Allow file upload backends other than S3 | 2014-11-27 16:58:35
configuration | 1724 | e0d | E0d/optionally update ssh config | 2014-11-28 01:49:04
edx-platform | 6119 | cpennington | Backfill migrations for the courseware app | 2014-12-02 20:38:40
edx-ora2 | 643 | fmyzjs | To package missing modules | 2014-12-07 07:34:52
edx-platform | 6167 | fmyzjs | To support UNICODE xblock.location | 2014-12-07 08:46:15
edx-platform | 6169 | Shrhawk | Add method to remove unanswered responses | 2014-12-08 11:45:35
edx-platform | 6190 | bdero | Public Course Import/Export API | 2014-12-09 03:41:43
configuration | 1736 | benpatterson | Add analytics-pipeline as a mounted dir. | 2014-12-09 21:58:45
configuration | 1747 | fmyzjs | Use COMMON_GIT_MIRROR | 2014-12-14 08:42:46
edx-ora2 | 646 | caesar2164 | Allow PDF uploads in image upload | 2014-12-15 19:26:44
edx-platform | 6279 | nedbat | Add the Microsoft Office Mix XBlock | 2014-12-16 20:26:55
edx-platform | 6280 | jmclaus | Fix for TNL-1018. | 2014-12-16 20:43:33
edx-platform | 6284 | zubair-arbi | fix integrity errors issue by adding MySQL transaction isolation level | 2014-12-17 09:44:17
configuration | 1752 | defance | Custom requirements installation fix on vanillas | 2014-12-17 16:59:06
configuration | 1753 | defance | Add edxapp_custom_debian_pkgs field to install extra packages | 2014-12-17 17:06:03
edx-platform | 6331 | njdup | Added keyword substitution for course announcements | 2014-12-19 19:58:31
edx-platform | 6338 | cpennington | XBlockAside Handlers | 2014-12-19 22:06:13
acid-block | 10 | cpennington | Fix for LMS aside tests | 2014-12-19 22:07:40
edx-platform | 6347 | jzoldak | [WIP] Enable travis builds for edx-platform | 2014-12-22 17:13:37
edx-ora2 | 651 | symbolist | Multiple prompts 1: Block initialization, xml import/export. | 2014-12-23 14:25:37
edx-ora2 | 654 | symbolist | Multiple prompts 3: LMS | 2014-12-24 12:37:51
edx-ora2 | 655 | symbolist | Multiple prompts 2: Studio | 2014-12-24 12:39:31
edx-platform | 6375 | stephensanchez | Sanchez/update redeem code schema | 2014-12-24 16:20:12
edx-platform | 6378 | singingwolfboy | Mako safe-by-default | 2014-12-24 19:30:49
edx-platform | 6395 | mhoeber | WIP - Separate platform docstrings project | 2014-12-29 23:11:39
configuration | 1763 | feanil | Only run dependencies conditionally. | 2014-12-30 20:28:15
edx-platform | 6431 | Shrhawk | Numeric input type resolve accessibility issues | 2015-01-02 13:01:32
configuration | 1766 | mulby | WIP: Install analytics pipeline | 2015-01-05 13:56:28
edx-analytics-pipeline | 55 | mulby | Support docker | 2015-01-05 13:59:09
edx-platform | 6444 | sarina | Set REQUIRE_COURSE_EMAIL_AUTH to False | 2015-01-05 16:42:31
edx-platform | 6449 | mulby | Transmit events to the OLI analytics service | 2015-01-05 18:45:20
configuration | 1773 | feanil | Use the V1 Hipchat token. | 2015-01-06 22:20:10
edx-platform | 6479 | adampalay | fix bug with certificate generation command | 2015-01-07 15:19:52
edx-platform | 6502 | jimabramson | Cache runtime in base.py per request | 2015-01-08 18:35:25
edx-platform | 6503 | singingwolfboy | Pull discussion underscore templates out into individual files | 2015-01-08 19:19:50
edx-platform | 6505 | carsongee | Add Staff Graded Assignments XBlock to edx-platform | 2015-01-08 20:35:42
edx-platform | 6511 | chrisndodge | (WIP) Cdodge/wl 167 extract cybersource transactions | 2015-01-09 00:05:19
edx-platform | 6519 | Shrhawk | replace double quotes with single for aria-label | 2015-01-09 12:34:16
edx-analytics-dashboard | 225 | lamagnifica | Ahodges/doc/answer dist | 2015-01-09 14:52:51
edx-documentation | 90 | lamagnifica | Cross references to Insights | 2015-01-09 15:33:24
edx-documentation | 92 | mhoeber | Saudi Projects | 2015-01-09 16:28:21
edx-platform | 6531 | awais786 | Aamir khan/ecom 335 caching api | 2015-01-09 19:06:24
(93 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment