Created
March 31, 2009 22:40
-
-
Save rmanalan/88456 to your computer and use it in GitHub Desktop.
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
>> 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