Strange Symphonies The best way to predict the future is to invent it

1. 

   mondher
   November 9th, 2009 - 16:16

   Hi Aizat,

   Thanks for this useful article.
   I’m developing an application dedicated to generate statistical reports, I would like that user after saving their stat report they save sql queries too. To do that I wrote the following module:
   module SqlHunter
   class ActiveRecord::ConnectionAdapters::AbstractAdapter

   @@queries = []
   cattr_accessor :queries
   def log_info_with_trace(sql, name, runtime)
   return unless @logger && @logger.debug?
   @@queries << sql
   end
   alias_method_chain :log_info, :trace
   end
   end

   in the controller I wrote that

   sqlfile = File.open("public/advancedStats/#{@dir_name}/advancedStatQuery.sql", 'w')
   @queries = ActiveRecord::ConnectionAdapters::AbstractAdapter::queries
   for query in @queries do
   sqlfile.write("#{query} \n")
   end
   sqlfile.close

   I also modified Rails environment by adding this line:

   ActiveRecord::Base.logger.level = Logger::DEBUG

   This program is working and I can get queries but, all queries. In contrast I need only the specific queries done by one user to generate a stat report.

   Do you have any idea to fix that,
   Thanks,

   mgatri
2. 

   Aziz@Sebastian
   November 15th, 2009 - 00:19

   Can you please tell me ,how to do application to obtain diplomatic malaysia passport ?

   how to obtain support letter from ministry of foreign affairs ?

   looking forward for your reply,

   Aziz @Sebastian
3. 

   steven
   December 18th, 2009 - 15:00

   hi man

   you have helped me heaps with the wallpaper situation, i was wondering do you know how to get rid of the navigation bar so that it only shows the wallpaper?

   regards

   steve

Leave a comment