Skip to content

Instantly share code, notes, and snippets.

@lamp
Created October 28, 2010 15:51
Show Gist options
  • Save lamp/651643 to your computer and use it in GitHub Desktop.
Save lamp/651643 to your computer and use it in GitHub Desktop.
Presentation creation with a user called dave (id 2)
Core:
Params: {"oauth_nonce"=>"227", "format"=>nil, "action"=>"create", "seed_name"=>"development", "oauth_timestamp"=>"1288280688", "oauth_signature_method"=>"HMAC-SHA1", "user_id"=>"2", "presentation"=>{"document_content"=>"{% video %}{% id 56 %}{% endvideo %}", "title"=>"My Presentation of Doom", "document_layout"=>"", "image_asset_id"=>"49", "disclosure"=>"public", "tag_list"=>"", "document_type"=>"SMIL 3.0", "author_url"=>"", "state"=>"ready"}, "controller"=>"presentations", "oauth_token"=>"vQohJr3cUlxVSSj8Fc6ScdlR6EOKQy", "oauth_consumer_key"=>"test_consumer_key", "oauth_signature"=>"Xyw9WyHDg4L04msTEydvD2m7hYQ=", "api_version"=>"1"}
~ (0.000006) SELECT `id`, `name`, `provider_name`, `provider_url`, `google_analytics_id` FROM `seeds` WHERE `name` = 'development' ORDER BY `id` LIMIT 1
~ (0.000005) SELECT `id`, `created_at`, `updated_at`, `enabled`, `access_key`, `developer_name`, `developer_email`, `developer_url`, `name`, `web_url`, `consumer_key`, `secret`, `kind`, `permissions` FROM `o_auth_consumers` WHERE (`enabled` = TRUE AND `consumer_key` = 'test_consumer_key') ORDER BY `id` LIMIT 1
~ (0.000007) SELECT `id`, `user_id`, `consumer_id`, `expires`, `created_at`, `permissions`, `token_key`, `exchangeable`, `activated`, `secret` FROM `o_auth_tokens` WHERE `token_key` = 'vQohJr3cUlxVSSj8Fc6ScdlR6EOKQy' ORDER BY `id` LIMIT 1
~ (0.001008) SELECT `id`, `crypted_password`, `salt`, `login`, `email`, `name`, `administrator`, `billing_contact`, `created_at`, `updated_at` FROM `users` WHERE `id` = 2 ORDER BY `id` LIMIT 1
~ (0.000015) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 56 ORDER BY `id` LIMIT 1
~ (0.000018) INSERT INTO `presentations` (`title`, `author_url`, `user_id`, `state`, `disclosure`, `document_layout`, `document_content`, `document_type`, `created_at`, `updated_at`, `image_asset_id`) VALUES ('My Presentation of Doom', '', 2, 'pending', 'public', '', '{% video %}{% id 56 %}{% endvideo %}', 'SMIL 3.0', '2010-10-28 16:44:48', '2010-10-28 16:44:48', 49)
~ (0.000011) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `width`, `height`, `user_id` FROM `assets_image` WHERE `id` = 49 ORDER BY `id` LIMIT 1
merb : worker (port 5555) ~ {:dispatch_time=>0.275347, :after_filters_time=>2.3e-05, :action_time=>0.263319, :before_filters_time=>0.019965}
merb : worker (port 5555) ~
Panel:
Routed to: {"format"=>"json", "action"=>"create", "_method"=>"post", "presentation"=>{"document_content"=>"", "title"=>"My Presentation of Doom", "author"=>"", "abstract"=>"", "video_asset"=>"56", "image_asset"=>"49", "document_layout"=>"", "publish_from"=>"", "disclosure"=>"public", "tag_list"=>"", "publish_until"=>"", "author_url"=>""}, "controller"=>"presentations"}
merb : worker (port 4000) ~ Params: {"format"=>"json", "action"=>"create", "_method"=>"post", "presentation"=>{"document_content"=>"", "title"=>"My Presentation of Doom", "author"=>"", "abstract"=>"", "video_asset"=>"56", "image_asset"=>"49", "document_layout"=>"", "publish_from"=>"", "disclosure"=>"public", "tag_list"=>"", "publish_until"=>"", "author_url"=>""}, "controller"=>"presentations"}
~ (0.000158) SELECT "id", "oauth_token", "oauth_token_secret", "seed_name", "complete" FROM "installations" WHERE ("seed_name" = 'development' AND "complete" = 't') ORDER BY "id" LIMIT 1
Editing with user id 1:
Core:
merb : worker (port 5555) ~ In repository block default
merb : worker (port 5555) ~ Started request handling: Thu Oct 28 16:47:32 +0100 2010
merb : worker (port 5555) ~ Routed to: {"oauth_nonce"=>"4407", "format"=>"json", "action"=>"update", "id"=>"63", "seed_name"=>"development", "oauth_timestamp"=>"1288280852", "oauth_signature_method"=>"HMAC-SHA1", "user_id"=>"1", "presentation"=>{"document_content"=>"{% video %}{% id 56 %}{% endvideo %}", "author"=>"", "title"=>"My Presentation of Doom edited", "abstract"=>"", "document_layout"=>"", "image_asset_id"=>"49", "disclosure"=>"public", "tag_list"=>"", "author_url"=>""}, "controller"=>"presentations", "oauth_token"=>"vQohJr3cUlxVSSj8Fc6ScdlR6EOKQy", "oauth_consumer_key"=>"test_consumer_key", "oauth_signature"=>"e69yNDFqOK42x2AQkkpXw0yVriY=", "api_version"=>"1"}
merb : worker (port 5555) ~ Params: {"oauth_nonce"=>"4407", "format"=>"json", "action"=>"update", "id"=>"63", "seed_name"=>"development", "oauth_timestamp"=>"1288280852", "oauth_signature_method"=>"HMAC-SHA1", "user_id"=>"1", "presentation"=>{"document_content"=>"{% video %}{% id 56 %}{% endvideo %}", "author"=>"", "title"=>"My Presentation of Doom edited", "abstract"=>"", "document_layout"=>"", "image_asset_id"=>"49", "disclosure"=>"public", "tag_list"=>"", "author_url"=>""}, "controller"=>"presentations", "oauth_token"=>"vQohJr3cUlxVSSj8Fc6ScdlR6EOKQy", "oauth_consumer_key"=>"test_consumer_key", "oauth_signature"=>"e69yNDFqOK42x2AQkkpXw0yVriY=", "api_version"=>"1"}
~ (0.000004) SELECT `id`, `name`, `provider_name`, `provider_url`, `google_analytics_id` FROM `seeds` WHERE `name` = 'development' ORDER BY `id` LIMIT 1
~ (0.000006) SELECT `id`, `created_at`, `updated_at`, `enabled`, `access_key`, `developer_name`, `developer_email`, `developer_url`, `name`, `web_url`, `consumer_key`, `secret`, `kind`, `permissions` FROM `o_auth_consumers` WHERE (`enabled` = TRUE AND `consumer_key` = 'test_consumer_key') ORDER BY `id` LIMIT 1
~ (0.000024) SELECT `id`, `user_id`, `consumer_id`, `expires`, `created_at`, `permissions`, `token_key`, `exchangeable`, `activated`, `secret` FROM `o_auth_tokens` WHERE `token_key` = 'vQohJr3cUlxVSSj8Fc6ScdlR6EOKQy' ORDER BY `id` LIMIT 1
~ (0.000006) SELECT `id`, `crypted_password`, `salt`, `login`, `email`, `name`, `administrator`, `billing_contact`, `created_at`, `updated_at` FROM `users` WHERE `id` = 1 ORDER BY `id` LIMIT 1
~ (0.000019) SELECT `id`, `title`, `author`, `author_url`, `abstract`, `user_id`, `callback_url`, `state`, `disclosure`, `publish_from`, `publish_until`, `document_layout`, `document_content`, `document_type`, `created_at`, `updated_at`, `image_asset_id` FROM `presentations` WHERE `id` = 63 ORDER BY `id` LIMIT 1
~ (0.000008) SELECT `tags`.`id`, `tags`.`name` FROM `tags` INNER JOIN `presentation_taggables` ON `tags`.`id` = `presentation_taggables`.`tag_id` INNER JOIN `presentations` ON `presentation_taggables`.`presentation_id` = `presentations`.`id` WHERE `presentation_taggables`.`presentation_id` = 63 GROUP BY `tags`.`id`, `tags`.`name` ORDER BY `tags`.`id`
~ (0.000008) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `bit_rate`, `duration`, `audio_bit_rate`, `audio_channels`, `audio_format`, `audio_sample_rate`, `video_bit_rate`, `video_format`, `video_frame_rate`, `width`, `height`, `user_id` FROM `assets_video` WHERE `id` = 56 ORDER BY `id` LIMIT 1
~ (0.000009) UPDATE `presentations` SET `title` = 'My Presentation of Doom edited', `user_id` = 1, `updated_at` = '2010-10-28 16:47:33' WHERE `id` = 63
~ (0.000004) SELECT `id`, `source_space_window`, `source_time_window`, `file_name`, `friendly_name`, `file_size`, `file_storage_name`, `source_uri`, `licensed_at`, `licensed_by`, `licensed_under`, `published_at`, `ingest_key`, `state`, `state_changed_at`, `state_changed_url`, `state_location`, `state_message`, `created_at`, `updated_at`, `derived_internally`, `original_asset_id`, `original_asset_type`, `preset_id`, `width`, `height`, `user_id` FROM `assets_image` WHERE `id` = 49 ORDER BY `id` LIMIT 1
merb : worker (port 5555) ~ {:dispatch_time=>0.179147, :after_filters_time=>4.8e-05, :action_time=>0.176768, :before_filters_time=>0.046122}
merb : worker (port 5555) ~
Panel:
{"format"=>"json", "action"=>"update", "_method"=>"put", "id"=>"63", "presentation"=>{"document_content"=>"{% video %}{% id 56 %}{% endvideo %}", "title"=>"My Presentation of Doom edited", "author"=>"", "abstract"=>"", "video_asset"=>"56", "image_asset"=>"49", "document_layout"=>"", "publish_from"=>"", "disclosure"=>"public", "tag_list"=>"", "publish_until"=>"", "author_url"=>""}, "controller"=>"presentations"}
merb : worker (port 4000) ~ Params: {"format"=>"json", "action"=>"update", "_method"=>"put", "id"=>"63", "presentation"=>{"document_content"=>"{% video %}{% id 56 %}{% endvideo %}", "title"=>"My Presentation of Doom edited", "author"=>"", "abstract"=>"", "video_asset"=>"56", "image_asset"=>"49", "document_layout"=>"", "publish_from"=>"", "disclosure"=>"public", "tag_list"=>"", "publish_until"=>"", "author_url"=>""}, "controller"=>"presentations"}
~ (0.000169) SELECT "id", "oauth_token", "oauth_token_secret", "seed_name", "complete" FROM "installations" WHERE ("seed_name" = 'development' AND "complete" = 't') ORDER BY "id" LIMIT 1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment