View cargurus-interview.sql
This file contains 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
create table keywords | |
( | |
id INT PRIMARY KEY NOT NULL AUTO_INCREMENT, | |
campaign_id INT | |
); | |
create table campaign | |
( | |
id INT PRIMARY KEY NOT NULL AUTO_INCREMENT, | |
name varchar |
View batch.json
This file contains 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
{"batch":"[{\"method\":\"post\",\"relative_url\":\"act_10158095527450599/adcreatives\",\"body\":\"name=atv206-image1-&object_story_spec=%7B%22link_data%22%3A%7B%22call_to_action%22%3A%7B%22type%22%3A%22SHOP_NOW%22%2C%22value%22%3A%7B%22link%22%3A%22https%3A%2F%2Fwww.cargurus.com%2FCars%2Finventorylisting%2FviewDetailsFilterViewInventoryListing.action%3Fax8324%3D26624540%26cgagid%3D8671777%26cgcid%3D5497%26px8324%3Dp5%26sourceContext%3Dprospecting%26utm_campaign%3Dprospecting%26utm_medium%3Dcpc%26utm_source%3Dfacebook%22%7D%7D%2C%22message%22%3A%22Car+shop+with+confidence.+CarGurus+helps+you+find+the+best+deals+from+top-rated+local+dealers%21%22%2C%22link%22%3A%22https%3A%2F%2Fwww.cargurus.com%2FCars%2Finventorylisting%2FviewDetailsFilterViewInventoryListing.action%3Fax8324%3D26624540%26cgagid%3D8671777%26cgcid%3D5497%26px8324%3Dp5%26sourceContext%3Dprospecting%26utm_campaign%3Dprospecting%26utm_medium%3Dcpc%26utm_source%3Dfacebook%22%2C%22name%22%3A%22Let+Us+Help+You+Find+the+Best+Deal%22%2C%22description%22% |
View gist:2f6c458d5eb64f30678a
This file contains 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
File "/home/jenkins/workspace/edx-all-tests-auto-pr/SHARD/1/TEST_SUITE/bok-choy/common/lib/xmodule/xmodule/contentstore/mongo.py", line 40, in __init__ | |
_db.authenticate(user, password) | |
File "/home/jenkins/edx-venv/local/lib/python2.7/site-packages/pymongo/database.py", line 902, in authenticate | |
self.connection._cache_credentials(self.name, credentials) | |
File "/home/jenkins/edx-venv/local/lib/python2.7/site-packages/pymongo/mongo_client.py", line 459, in _cache_credentials | |
auth.authenticate(credentials, sock_info, self.__simple_command) | |
File "/home/jenkins/edx-venv/local/lib/python2.7/site-packages/pymongo/auth.py", line 243, in authenticate | |
auth_func(credentials[1:], sock_info, cmd_func) | |
File "/home/jenkins/edx-venv/local/lib/python2.7/site-packages/pymongo/auth.py", line 222, in _authenticate_mongo_cr | |
cmd_func(sock_info, source, query) |
View gist:9e61c2141069f3072e76
This file contains 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
@ddt.ddt | |
class OutlinePerfTest(TestCourseOutline): | |
def setUp(self): | |
with modulestore().default_store(ModuleStoreEnum.Type.split): | |
super(OutlinePerfTest, self).setUp() | |
@ddt.data(1, 2, 4, 8) | |
def test_query_counts(self, num_threads): | |
""" | |
Test that increasing threads does not increase query counts |
View gist:6b1d1c4754a7ac112396
This file contains 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
"<problem>\n <p>\n A JSDraw problem lets the user use the JSDraw editor component to draw a\n new molecule or update an existing drawing and then submit their work. \n Answers are specified as SMILES strings.\n </p>\n <p>\n I was trying to draw my favorite molecule, caffeine. Unfortunately,\n I'm not a very good biochemist. Can you correct my molecule?\n </p>\n <jsdrawresponse>\n <!-- You can set initial state of the editor by including a molfile\n inside of the jsdraw tag. Take care that indentation is preserved.\n The molfile format is sensitive to whitespace. -->\n <jsdraw>\n JSDraw201081410342D\n\n 12 13 0 0 0 0 0 V2000\n 12.0000 -6.7600 0.0000 N 0 0 0 0 0 0 0\n 10.6490 -5.9800 0.0000 C 0 0 0 0 0 0 0\n 10.6490 -4.4200 0.0000 N 0 0 0 0 0 0 0\n 12.0000 -3.6400 0.0000 C 0 0 0 0 0 0 0\n 13.3510 -4.4200 0.0000 C 0 0 0 0 0 0 |