July « 2008 « CrudVision

July 30, 2008

Eve Online Empyrean Age 1.0 Database Dump for PostgreSQL

Filed under: eve online,open source,postgres,sql — Lisa Seelye @ 18:29

Today CCP announced the release of their MS SQL dump. Following in step with past conversions here is a Postgres version. Tested with 8.0.15 but should work on everything.

This dump is odd: CCP is using integers where they mean to use booleans. So in those cases remember 1 is true, 0 is false. Good luck.

Edit: As a note the Eve Online Database Viewer is updated with this dump.

Edit 2 (July 31, 2008): I nearly forgot to give props to bunjiboys for providing the .sql files from which the above dump is derrived.

Comments (4)

Fixtures in Rails Suck – this makes them suck less

Filed under: open source,rails,snippet,testing — Lisa Seelye @ 01:31

If you've got a boat load of legacy fixtures laying around (and who doesn't?) it can be a pain now that Rails handles the ID of objects so you don't have to.

On the train back from holiday I wrote a snippet of code to migrate them:

PLAIN TEXT

RUBY:

def Util.real_yml(klass,col = 'name')
y = YAML.load_file(File.join(RAILS_ROOT,'test','fixtures',"#{klass.to_s.tableize}.yml"))
real_names = y.inject([]) { |names,(key,val)| names <<y[key][col] if y[key][col] ;names }
real_objs = klass.find :all, :conditions => [ "#{col} IN (?)",real_names ], rder => "#{col} asc"
yml = ""
real_objs.each do |real_obj|
yml += "#{real_obj.name.downcase.gsub(' ','_').gsub('-','')}:\n"
real_obj.attributes.each do |k,v|
if k =~ /_id$/ && real_obj.respond_to?(k.gsub(/_id$/,'').to_sym) && ! v.nil?
n_klass = k.gsub(/_id$/,'').camelize.constantize.find(v) rescue nil
key = k.gsub(/_id$/,'')
val = n_klass.name.downcase.gsub(' ','_').gsub('-','')
yml += " #{key}: #{val}\n"
else
yml += " #{k}: #{v}\n" unless k.to_s == 'id'
end
end
end
yml
end

The use is:

PLAIN TEXT

RUBY:

require 'util'
print Util.real_yml(Corporation)

Copy/paste into corporations.yml

So far it's working great!

Comments (0)

July 29, 2008

The decline of Rails-Core mail list

Filed under: dspam,google,ham,mail lists,rails,rails-core,spam — Lisa Seelye @ 15:35

Lately the rails-core mail list has declined in quality. Spammers have moved in and operate unfettered. Reporting offenders to Google does nothing.

In fact, in order to isolate my personal mail from spam and to keep dspam from getting very confused I've moved the rails-core list to a google mail account. It's a shame but I'm more interested in keeping my other mail free from spam and the dspam quarantine free from ham. Isolation of rails-core until Google can get the spammers off their lists will accomplish the goal.

Comments (0)