DZone Snippets: Demimismo's Code Snippets

Setting user locale in Globalize, the working solution

demimismo (David Arango) — Thu, 14 Aug 2008 10:19:07 GMT

This example application, provided as Globalize's, documentation doesn't work at all.

This is what worked for me:



    before_filter :set_locale



    def set_locale

      request_language = request.env['HTTP_ACCEPT_LANGUAGE']

      request_language = request_language.nil? ? nil : request_language[/[^,;]+/].split('-')[0]



      @locale = params[:locale] || request_language || Locale.base_language.code



      if !params[:locale].nil? && LOCALES.keys.include?(params[:locale].to_sym)

        Locale.set LOCALES[@locale.to_sym]

      else

        redirect_to params.merge('locale' => @locale)

      end

    end

Sharing has_many extensions

demimismo (David Arango) — Wed, 23 Jul 2008 12:21:45 GMT

Sometimes you extend an ActiveRecord association this way:



has_many :things do

  def active

    find :all, :conditions => ['active = ?', true]

  end

end

You can share the same extensions using a lambda:





extensions = lambda {

  def active

    find :all, :conditions => ['active = ?', true]

  end

}



has_many :things, &extensions

has_many :more_things, &extensions

Processing large CSV files

demimismo (David Arango) — Tue, 10 Jun 2008 11:17:48 GMT



  # this method allows fast CSV processing, it reads file_name, generates a new

  # CSV file and inserts all data in a mysql table using LOAD DATA INFILE



    # you can use it like this:



    load_csv_data(PRELOAD_DIR+'socios.csv', 'users') do |csv, thing_id, row|

      csv << [thing_id,

        row['NOMBRE'].to_s.to_permalink+'.'+row['APELLIDOS'].to_s.to_permalink, #  login

        row['E_MAIL'], #  email

        row['SEXO'],  #  gender

        (row['NO_DATOS'] == 'S' || row['NO_DATOS'] == 'VERDADERO' ? 1 : 0 ), #  no_datos

      ]

    end





  def load_csv_data(file_name, table_name)

    STDERR.print("\nParsing '#{file_name}' to insert data in '#{table_name}'\n")



    n_lines = (%x[wc -l #{file_name}]).split(' ')[0].to_f

    time_start = Time.now

    begin

      require 'fastercsv'

      count = 0.0



      csv_string = FasterCSV.open("data.csv", "w", { :col_sep => ";", :force_quotes => true })  do |csv|

      FasterCSV.open("#{file_name}", { :col_sep => "\t", :headers => :first_row }).each do |row|

        thing_id = row[0].to_i

        if thing_id && thing_id > 0

          

          yield csv, thing_id, row



          percentage = ((count += 1) * 100.0)/n_lines

          STDERR.print "%.0f%%..." % percentage if (percentage.modulo(2.0) < 0.001)

        end

        end

      end

    rescue EOFError

      f.close

    end

    total_lines = (%x[wc -l data.csv]).split(' ')[0].to_i

    STDERR.print("\nInserting #{total_lines} lines in table '#{table_name}'\n")

    ActiveRecord::Base.connection.execute("LOAD DATA INFILE '#{File.join(File.dirname(__FILE__), '..', '..', 'data.csv')}' IGNORE INTO TABLE #{table_name} FIELDS TERMINATED BY ';' ENCLOSED BY '\"';")

    warn("Finished importing '#{file_name}'.\nLines: #{n_lines.to_i.to_s} (#{(n_lines.to_i - total_lines.to_i).to_s} lost)\nTime: %.2f minutes\n" % ((Time.now - time_start)/60))

  end

Merry xmas

demimismo (David Arango) — Tue, 12 Dec 2006 21:49:50 GMT



3.times  {|i| puts 'h'+'o'*(i+1)+"!"}

Extracting web page title

demimismo (David Arango) — Wed, 29 Nov 2006 21:24:59 GMT

Easy extracting html 'title' element from an url



require 'open-uri'



URI.parse('http://google.es').open do |f|

	f.each {|l| if md = (/\s*(.*)\s*<\/title>/iu).match(l) then print md[1] end }
<br />end
<br /></code>
<br />
</article>
</main></body></html>