Skip to content

Instantly share code, notes, and snippets.

@rmanalan
Created March 31, 2009 22:40
Show Gist options
  • Save rmanalan/88456 to your computer and use it in GitHub Desktop.
Save rmanalan/88456 to your computer and use it in GitHub Desktop.
>> GroupActivityFeeder.import_rss(:rerun_all=>true)
RssSource Load (95.2ms) SELECT * FROM `rss_sources`
Join Table Columns (189.4ms) SHOW FIELDS FROM `groups_rss_sources`
Join Table Columns (179.1ms) SHOW FIELDS FROM `groups_rss_sources`
Join Table Columns (89.0ms) SHOW FIELDS FROM `groups_rss_sources`
Group Load (91.5ms) SELECT * FROM `groups` INNER JOIN `groups_rss_sources` ON `groups`.id = `groups_rss_sources`.group_id WHERE (`groups_rss_sources`.rss_source_id = 4 )
Group Load (92.0ms) SELECT * FROM `groups` INNER JOIN `groups_rss_sources` ON `groups`.id = `groups_rss_sources`.group_id WHERE (`groups_rss_sources`.rss_source_id = 3 )
Group Load (92.1ms) SELECT * FROM `groups` INNER JOIN `groups_rss_sources` ON `groups`.id = `groups_rss_sources`.group_id WHERE (`groups_rss_sources`.rss_source_id = 2 )
/Users/richmanalang/dev/connect.git/vendor/gems/rfeedparser-0.9.951/lib/rfeedparser/libxml_parser.rb:14: warning: Passing no parameters to XML::SaxParser.new is deprecated. Pass an instance of XML::Parser::Context instead.
XML::SaxParser#string is deprecated. Use XML::SaxParser.string instead
SQL (0.1ms) BEGIN
SQL (0.1ms) COMMIT
FeedPost Load (127.9ms) SELECT * FROM `posts` WHERE (`posts`.`source_id` = 3 AND `posts`.`guid` = 'http://oaklandfarmer.posterous.com/locavore-lists-the-in-season-food-near-you') AND ( (`posts`.`type` = 'FeedPost' ) ) LIMIT 1
GroupsPost Load (110.1ms) SELECT * FROM `groups_posts` WHERE (`groups_posts`.`post_id` = 580 AND `groups_posts`.`group_id` = 2) LIMIT 1
/Users/richmanalang/dev/connect.git/vendor/gems/rfeedparser-0.9.951/lib/rfeedparser/libxml_parser.rb:14: warning: Passing no parameters to XML::SaxParser.new is deprecated. Pass an instance of XML::Parser::Context instead.
XML::SaxParser#string is deprecated. Use XML::SaxParser.string instead
SQL (0.9ms) BEGIN
RssSource Update (2.2ms) UPDATE `rss_sources` SET `failed_attempts` = 0, `updated_at` = '2009-03-31 15:39:55' WHERE `id` = 2
SQL (0.6ms) COMMIT
FeedPost Load (123.7ms) SELECT * FROM `posts` WHERE (`posts`.`source_id` = 2 AND `posts`.`guid` = 'http://whybother.posterous.com/if-bitly-is-worth-8-million-tinyurl-is-worth') AND ( (`posts`.`type` = 'FeedPost' ) ) LIMIT 1
SQL (0.1ms) BEGIN
RssSource Update (0.3ms) UPDATE `rss_sources` SET `failed_attempts` = 1, `updated_at` = '2009-03-31 15:39:55' WHERE `id` = 2
SQL (0.7ms) COMMIT
/Users/richmanalang/dev/connect.git/vendor/gems/rfeedparser-0.9.951/lib/rfeedparser/libxml_parser.rb:14: warning: Passing no parameters to XML::SaxParser.new is deprecated. Pass an instance of XML::Parser::Context instead.
XML::SaxParser#string is deprecated. Use XML::SaxParser.string instead
SQL (0.1ms) BEGIN
RssSource Update (0.3ms) UPDATE `rss_sources` SET `failed_attempts` = 0, `updated_at` = '2009-03-31 15:39:57' WHERE `id` = 4
SQL (0.7ms) COMMIT
FeedPost Load (112.7ms) SELECT * FROM `posts` WHERE (`posts`.`source_id` = 4 AND `posts`.`guid` = 'http://gizmodo.com/tag/top/Gizmodo-5192475') AND ( (`posts`.`type` = 'FeedPost' ) ) LIMIT 1
SQL (0.1ms) BEGIN
RssSource Update (0.3ms) UPDATE `rss_sources` SET `failed_attempts` = 1, `updated_at` = '2009-03-31 15:39:57' WHERE `id` = 4
SQL (0.7ms) COMMIT
Join Table Columns (94.2ms) SHOW FIELDS FROM `groups_rss_sources`
Group Load (89.2ms) SELECT * FROM `groups` INNER JOIN `groups_rss_sources` ON `groups`.id = `groups_rss_sources`.group_id WHERE (`groups_rss_sources`.rss_source_id = 1 )
/Users/richmanalang/dev/connect.git/vendor/gems/rfeedparser-0.9.951/lib/rfeedparser/libxml_parser.rb:14: warning: Passing no parameters to XML::SaxParser.new is deprecated. Pass an instance of XML::Parser::Context instead.
XML::SaxParser#string is deprecated. Use XML::SaxParser.string instead
SQL (0.1ms) BEGIN
RssSource Update (0.3ms) UPDATE `rss_sources` SET `failed_attempts` = 0, `updated_at` = '2009-03-31 15:40:01' WHERE `id` = 1
SQL (0.7ms) COMMIT
FeedPost Load (136.7ms) SELECT * FROM `posts` WHERE (`posts`.`source_id` = 1 AND `posts`.`guid` = 'http://theappslab.com/?p=2661') AND ( (`posts`.`type` = 'FeedPost' ) ) LIMIT 1
SQL (0.1ms) BEGIN
RssSource Update (0.3ms) UPDATE `rss_sources` SET `failed_attempts` = 1, `updated_at` = '2009-03-31 15:40:01' WHERE `id` = 1
SQL (17.9ms) COMMIT
=> true
>>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment