Robert Raposa robrap
robrap
/ gist:f696fb1f097de2420498a40aab05d095
Created
April 14, 2020 19:38
Running enterprise migrations on sandbox
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| mysql> select * from django_migrations where app = 'enterprise'; | |
| +-----+------------+----------------------------------------------------------------------------------------+----------------------------+ | |
| | id | app | name | applied | | |
| +-----+------------+----------------------------------------------------------------------------------------+----------------------------+ | |
| | 117 | enterprise | 0001_initial | 2020-04-14 16:47:07.712359 | | |
| | 118 | enterprise | 0002_enterprisecustomerbrandingconfiguration | 2020-04-14 16:47:07.716199 | | |
| | 119 | enterprise | 0003_auto_20161104_0937 | 2020-04-14 16:47:07.718929 | | |
| | 120 | enterprise | 0004_auto_20161114_0434 | 2020-04-14 16:4 |
robrap
/ gist:0dfdada30cdb587f443586866a73db2c
Created
April 13, 2020 14:35
edx-platform showmigrations
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| admin | |
| [X] 0001_initial | |
| [X] 0002_logentry_remove_auto_add | |
| announcements | |
| [X] 0001_initial | |
| api_admin | |
| [X] 0001_initial | |
| [X] 0002_auto_20160325_1604 | |
| [X] 0003_auto_20160404_1618 | |
| [X] 0004_auto_20160412_1506 |
robrap
/ gist:b3acc84c18432c2176fdd59196097071
Created
April 3, 2020 20:50
Ecommerce Django 2.2 Upgrade Migration SQL
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| root@ecommerce:/edx/app/ecommerce/ecommerce# python manage.py sqlmigrate voucher 0011_auto_20200403_2046 --settings=ecommerce.settings.devstack | |
| BEGIN; | |
| -- | |
| -- Alter field offers on voucher | |
| -- | |
| ALTER TABLE `voucher_voucher_offers` DROP FOREIGN KEY `vouche_conditionaloffer_id_f9682bfb_fk_offer_conditionaloffer_id`; | |
| ALTER TABLE `voucher_voucher_offers` ADD CONSTRAINT `voucher_voucher_offe_conditionaloffer_id_f9682bfb_fk_offer_con` FOREIGN KEY (`conditionaloffer_id`) REFERENCES `offer_conditionaloffer` (`id`); | |
| ALTER TABLE `voucher_voucher_offers` DROP FOREIGN KEY `voucher_voucher_offers_voucher_id_7f9c575d_fk_voucher_voucher_id`; | |
| ALTER TABLE `voucher_voucher_offers` ADD CONSTRAINT `voucher_voucher_offers_voucher_id_7f9c575d_fk_voucher_voucher_id` FOREIGN KEY (`voucher_id`) REFERENCES `voucher_voucher` (`id`); | |
| -- |
robrap
/ gist:310b0b2d414c3dcb99a01825c0023564
Created
March 26, 2020 16:58
Django Oscar 2.0.4 Upgrade Migration SQL
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| root@ecommerce:/edx/app/ecommerce/ecommerce# ./manage.py sqlmigrate address 0006_auto_20181115_1953; wait | |
| /edx/app/ecommerce/ecommerce/ecommerce/settings/production.py:59: YAMLLoadWarning: calling yaml.load() without Loader=... is deprecated, as the default Loader is unsafe. Please read https://msg.pyyaml.org/load for full details. | |
| config_from_yaml = yaml.load(f) | |
| BEGIN; | |
| -- | |
| -- Alter field printable_name on country | |
| -- | |
| CREATE INDEX `address_country_printable_name_450b016c` ON `address_country` (`printable_name`); | |
| COMMIT; | |
| root@ecommerce:/edx/app/ecommerce/ecommerce# ./manage.py sqlmigrate basket 0013_auto_20200305_1448; wait |
robrap
/ gist:c1b5252060d4f98bab348724eb753d9b
Created
September 17, 2019 16:57
Uploaded SourceMaps for frontend-app-payment
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| {"sourcemaps":[{"id":"fdcfd0fa-7200-485c-a13b-22d3fc335336","javascriptUrl":"https://payment.edx.org/vendors~app.3dc46471043a644ed406.js","releaseName":null,"releaseId":null,"createdAt":"2019-07-25T16:16:13.731Z"},{"id":"daf8f433-dcd3-4dc6-9881-a42206cf8317","javascriptUrl":"https://payment.edx.org/app.b1b75ccb5397f0298828.js","releaseName":null,"releaseId":null,"createdAt":"2019-07-25T16:16:13.178Z"},{"id":"82cdea5d-5b54-4ea4-9176-11d93bff90da","javascriptUrl":"https://payment.edx.org/vendors~app.eac02a5171d0cda68023.js","releaseName":null,"releaseId":null,"createdAt":"2019-07-24T17:33:48.475Z"},{"id":"3387fc68-1046-42d9-97fc-cff98176619b","javascriptUrl":"https://payment.edx.org/app.2e381e806b5abd73fb6f.js","releaseName":null,"releaseId":null,"createdAt":"2019-07-24T17:33:47.940Z"},{"id":"ee7403bf-d613-430d-81f0-48a583d5a9a4","javascriptUrl":"https://payment.edx.org/vendors~app.717475c85de43587851b.js","releaseName":null,"releaseId":null,"createdAt":"2019-07-24T17:09:58.033Z"},{"id":"f78e1012-3408-4f33-b613 |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| .js-edx-header-ui .course-search-bar { | |
| position: absolute; | |
| left: 0; | |
| top: 77px; | |
| z-index: 9999; | |
| width: 100%; | |
| padding: 20px 60px; | |
| background-color: rgb(0, 125, 184); | |
| margin: 0; | |
| } |
robrap
/ gist:8bba3c62eb63b43192d8311e881db807
Created
June 14, 2017 13:31
Create courseware_index workaround
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| curl -XPUT http://localhost:9200/courseware_index | |
| curl -XPUT http://localhost:9200/courseware_index/courseware_content/_mapping -d '{"courseware_content":{"properties":{"content":{"properties":{"capa_content":{"type":"string"},"display_name":{"type":"string"},"html_content":{"type":"string"},"transcript_en":{"type":"string"}}},"content_groups":{"type":"string","index":"not_analyzed","norms":{"enabled":false},"index_options":"docs"},"content_type":{"type":"string","index":"not_analyzed","norms":{"enabled":false},"index_options":"docs"},"course":{"type":"string","index":"not_analyzed","norms":{"enabled":false},"index_options":"docs"},"course_name":{"type":"string","index":"not_analyzed","norms":{"enabled":false},"index_options":"docs"},"id":{"type":"string","index":"not_analyzed","norms":{"enabled":false},"index_options":"docs"},"location":{"type":"string","index":"not_analyzed","norms":{"enabled":false},"index_options":"docs"},"org":{"type":"string","index":"not_analyzed","norms":{"enabled":false},"index_optio |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| curl -XPUT http://localhost:9200/courseware_index | |
| curl -XPUT http://localhost:9200/courseware_index/courseware_content/_mapping -d | |
| '{"courseware_content":{"properties":{"content":{"properties":{"capa_content":{"type":"string"},"display_name":{"type":"string"},"html_content":{"type":"string"},"transcript_en":{"type":"string"}}},"content_groups":{"type":"string","index":"not_analyzed","norms":{"enabled":false},"index_options":"docs"},"content_type":{"type":"string","index":"not_analyzed","norms":{"enabled":false},"index_options":"docs"},"course":{"type":"string","index":"not_analyzed","norms":{"enabled":false},"index_options":"docs"},"course_name":{"type":"string","index":"not_analyzed","norms":{"enabled":false},"index_options":"docs"},"id":{"type":"string","index":"not_analyzed","norms":{"enabled":false},"index_options":"docs"},"location":{"type":"string","index":"not_analyzed","norms":{"enabled":false},"index_options":"docs"},"org":{"type":"string","index":"not_analyzed","norms":{"enabled":false},"index_optio |
robrap
/ gist:c43f2867e5fd106029e3d795abac673d
Created
June 14, 2017 13:11
Create courseware_index workaround:
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| curl -XPUT 'http://localhost:9200/course_team_index | |
| curl -XPUT 'http://localhost:9200/course_team_index/course_team/_mapping' -d '{"course_team":{"properties":{"country":{"type":"string","index":"not_analyzed","norms":{"enabled":false},"index_options":"docs"},"course_id":{"type":"string","index":"not_analyzed","norms":{"enabled":false},"index_options":"docs"},"date_created":{"type":"string","index":"not_analyzed","norms":{"enabled":false},"index_options":"docs"},"description":{"type":"string","index":"not_analyzed","norms":{"enabled":false},"index_options":"docs"},"discussion_topic_id":{"type":"string","index":"not_analyzed","norms":{"enabled":false},"index_options":"docs"},"id":{"type":"string","index":"not_analyzed","norms":{"enabled":false},"index_options":"docs"},"language":{"type":"string","index":"not_analyzed","norms":{"enabled":false},"index_options":"docs"},"last_activity_at":{"type":"string","index":"not_analyzed","norms":{"enabled":false},"index_options":"docs"},"name":{"type":"string","index":"not |
robrap
/ gist:350e918d181dd9d6da2644269eb0b797
Created
June 2, 2016 15:08
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 1) ERROR: test suite for <class 'common.test.acceptance.tests.lms.test_lms_instructor_dashboard.CertificateInvalidationTest'> | |
| 3) ERROR: test_create_library (common.test.acceptance.tests.studio.test_studio_home.CreateLibraryTest) | |
| 4) ERROR: test_sections_can_be_locked (common.test.acceptance.tests.studio.test_studio_outline.StaffLockTest) | |
| 5) ERROR: test_subsection_displays_lock_when_all_units_locked (common.test.acceptance.tests.studio.test_studio_outline.StaffLockTest) | |
| 6) ERROR: test_subsection_does_not_display_lock_when_some_units_locked (common.test.acceptance.tests.studio.test_studio_outline.StaffLockTest) | |
| 7) ERROR: test_subsections_can_be_locked (common.test.acceptance.tests.studio.test_studio_outline.StaffLockTest) | |
| 8) ERROR: test_toggling_staff_lock_on_section_does_not_publish_draft_units (common.test.acceptance.tests.studio.test_studio_outline.StaffLockTest) | |
| 9) ERROR: test_toggling_staff_lock_on_subsection_does_not_publish_draft_units (common.test.acceptance.tests.studio.test_studio_outline.StaffLockTest |