Skip to content

Instantly share code, notes, and snippets.

@ChristinaMeno
Created March 26, 2011 17:23
Show Gist options
  • Save ChristinaMeno/888458 to your computer and use it in GitHub Desktop.
Save ChristinaMeno/888458 to your computer and use it in GitHub Desktop.
diff --git a/medley/playlist/tests/tests.py b/medley/playlist/tests/tests.py
index 4cf9bcd..d20c8e5 100644
--- a/medley/playlist/tests/tests.py
+++ b/medley/playlist/tests/tests.py
@@ -273,6 +273,7 @@ class APITestCase(TestCase):
# - Setting object (for cache timeout)
self.client.get('/lsp/_api/v1/stream/?format=json')
+ print connection.queries
self.assertEqual(5, len(connection.queries))
# Subsequent requests hit cache & require no queries
[{'time': '0.001',
'sql': 'SELECT COUNT(*)
FROM "playlist_stream"
INNER JOIN "playlist_stream_sites" ON ("playlist_stream"."id" = "playlist_stream_sites"."stream_id")
WHERE "playlist_stream_sites"."site_id" = 10097 '},
{'time': '0.001',
'sql': 'SELECT *
FROM "playlist_stream"
INNER JOIN "playlist_stream_sites" ON ("playlist_stream"."id" = "playlist_stream_sites"."stream_id")
WHERE "playlist_stream_sites"."site_id" = 10097 LIMIT 20'},
{'time': '0.003',
'sql': 'SELECT *
FROM "lsp3_history"
LEFT OUTER JOIN "lsp3_track" ON ("lsp3_history"."track_id" = "lsp3_track"."id")
LEFT OUTER JOIN "lsp3_artist" ON ("lsp3_track"."artist_id" = "lsp3_artist"."id")
LEFT OUTER JOIN "playlist_artistimage" ON ("lsp3_artist"."id" = "playlist_artistimage"."artist_id")
LEFT OUTER JOIN "ads_radiofal" ON ("lsp3_history"."fal_id" = "ads_radiofal"."id")
WHERE ("lsp3_history"."station_id" = 10097 AND "lsp3_history"."playtime" >= E\'2011-03-25 02:34:03.958012\' )
ORDER BY "lsp3_history"."playtime" DESC'},
{'time': '0.001',
'sql': 'SELECT "related_objects_relatedobject"."id",
"related_objects_relatedobject"."order",
"related_objects_relatedobject"."from_type_id",
"related_objects_relatedobject"."from_id",
"related_objects_relatedobject"."to_type_id",
"related_objects_relatedobject"."to_id",
"related_objects_relatedobject"."is_lead"
FROM "related_objects_relatedobject"
WHERE ("related_objects_relatedobject"."from_id" = 10097
AND "related_objects_relatedobject"."from_type_id" = 320
AND "related_objects_relatedobject"."is_lead" = true )
ORDER BY "related_objects_relatedobject"."from_id" ASC,
"related_objects_relatedobject"."order" ASC LIMIT 1'},
{'time': '0.001',
'sql': 'SELECT "django_site"."id",
"django_site"."domain",
"django_site"."name"
FROM "django_site"
WHERE "django_site"."id" = 10097 '},
{'time': '0.000',
'sql': 'SELECT "sitesettings_setting"."name",
"sitesettings_setting"."db_value"
FROM "sitesettings_setting"
WHERE "sitesettings_setting"."site_id" = 10097 '},
{'time': '0.000',
'sql': 'SELECT "sitesettings_setting"."id",
"sitesettings_setting"."site_id",
"sitesettings_setting"."partner_id",
"sitesettings_setting"."name",
"sitesettings_setting"."db_value"
FROM "sitesettings_setting"
WHERE ("sitesettings_setting"."site_id" = 10097 AND "sitesettings_setting"."name" = E\'playlist_api_cache_timeout_in_seconds\' )'}]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment