similar to: Accessing Postgres large objects

Hi, Anyone got any cool tricks for converting a Rails site (in this case, a typo installation) from a mysql database to a postgresql database? I''ve got it almost working -- I''m doing a SQL dump from mysql and loading it into postgres. However, mysql does booleans as a tinyint with 0 = false and 1 = true. When I try to import that into a postgres database that expects booleans

I don''t even know if this is possible. I want to use an object as an attribute for one of my classes. I can save it to the db fine, looks like...but I need to be able to use it after I pull the object from the db. Right now the attribute is just a String, but I need it to be a Runt::Intersect object. Does anyone know how I can unserialize the attribute so I can use it as an object?

Hi guys, I''ve been able to successfully install the postgres adapter for a remote database machine to get rails up. My machine is running on Fedora 2. Rails version 1.1.2. Is my yml config correct? I am getting this error when I execute script/generate scaffold service_contents content : exists app/controllers/ exists app/helpers/ create app/views/spiel exists

I need to do some precise math, going to 12-14 decimal places, so I''m using BigDecimal. How can I store this in a db? I''m using postgresql 8.1.0, if that matters at all. I found a plugin [1] but it gives me the error "You have a nil object when you didn''t expect it! The error occurred while evaluating nil.each_pair," with no line number. The plugin itself

Hello everyone, I''m trying to migrate a working app from Postgres to MySQL, and I''m trying to use a migration to get it done rather than alter all my database table creation scripts to MySQL syntax. I''ve done loads of work with Postgres, but am a real newbie with MySQL... I did a ''rake db_schema_dump'' from my Postgres app, and got a nice looking

I am in a holding pattern while client decides upon changes and so I am working some things out internally so it seems to me that indexing frequently searched table fields might be useful. I am using postgres and via postgres, I have added an index to one of my tables whose index is the same name as the column name. The ''find'' screen I am using this to judge populates a number

In my model I''d like to write a method that accesses the attributes by name. A very simple implementation would be class MyModel < ActiveRecord::Base def get_value(attribute) return value_of_attribute end end Then I can call it with m.get_value(:name) to get the value of the name column in the db. I''m not sure what to put in for

I created a project, made a migration, generated scaffolding...start up webrick and I get nothing. To simplify things, I just started another project and generated a controller, still getting nothing. The index page loads fine, but nothing beyond that. If I go to anything that should give me a 404, the page is just blank. The Webrick console just says a 500 (nothing explaining why), and

I''m trying to set up switchtower, following the info in the Manual, but am getting this error when I run "rake remote_exec ACTION=setup": servers: ["cantona.dnswatchdog.com"] /usr/lib/ruby/gems/1.8/gems/net-ssh-1.0.3/lib/net/ssh/transport/packet-stream.rb:203:in `sysread'': bignum too big to convert into `long'' (RangeError) from

I''m using Jim Weirich''s Builder library. The code I want to spec is xml.video do xml.id @video_id xml.views @views xml.date(@date.to_s) if @date end I''d like to mock it, rather than asserting that the XML is the right string. I can do one spec: specify "should create a video tag" do @mock_builder.should_receive(:video)

I''m setting up a basic shopping cart type app, and the products we have will have multiple options. Size, color, etc. I''m trying to figure out how I can collect the the options that are selected when a user adds the item to their cart. An OptionSet is a group of options ("Size", "Color", etc), and an ItemOption is the option itself ("12 oz",

I''m trying to add an RSS feed to my app, and am going through the Rails Recipes chapter on doing so. I get the following error when I request the feed: undefined method `gmtime'' for #<DateTime: 1963061961/800,0,2299161> ... 7: xml.pubDate CGI.rfc1123_date(@posts.first.created_on) Any idea what''s up? Pat

I wanted to fix some things up in the trunk, so I set up the databases and ran the unit tests. A bunch fail for postgres, and even more error out. I know of two postgresql adapters: postgres-pr and ruby-postgres. Strangely, they each fail different tests. So if I want to fix things up, which one should I be using? For that matter, which adapter should I be using for production? Finding out

I''m having an argument with my son :) I have a table with about 1500 objects called entries. I need to do something with about 100 of them (schedule manually) I say I should just mark them with a boolean when I have scheduled them. (manual == true) My son says I should pull them out of the entries table and copy them to new objects (lets call them "manual" objects, and store

I''ve got a form that should post to user/login. The code to start the tag is: <%= start_form_tag { :controller => "user", :action => "login" } %> That gives me this exception: compile error script/../config/../app/views/user/login.rhtml:1: parse error, unexpected tASSOC, expecting ''}'' _erbout = ''''; _erbout.concat((

I''ve got two models, a Company and a User, and a Company belongs_to a User. When I create/edit a company object, I''d like to be able to modify the associated user. Can I do this directly with form helpers? Something like text_field("company.user", "login") Right now I''m having a user object and a company object, and then associating them with

I''m working with a remote API that calls a URL in my app, passing in a parameter named action. So the request would look like: http://localhost/my_controller?action=foo Routing correctly interprets the controller action as index. However, it sets params[:action] to index as well. I know that''s how it''s supposed to work...but it means I lose the action parameter

Started a new Rails project, and installed RSpec and the Rails plugin vendor/plugins/rspec (svn://rubyforge.org/var/svn/rspec/trunk/rspec) - 1332 vendor/plugins/rspec_on_rails (svn://rubyforge.org/var/svn/rspec/trunk/rspec_on_rails/vendor/plugins/rspec_on_rails) - 1332 Generated the rspec file, created a model...the spec runs fine if I do ruby spec/models/foo_spec.rb. Running rake though gives

I''m writing a simple app that doesn''t need to use a database. I added :active_record to the config.frameworks -= line in environment.rb file. This lets me run ./script/generate fine without complaining about no connection. However if I try to run a functional test, it complains about no connection being established. Well...I don''t want a connection to be established.

I mentioned this in another thread, but I''ve got a formal request now. After reading tons of stuff about REST, I don''t really get it. I need to see an example. I''d like someone to write up an example blog app with these requirements - RESTful using the simply_restful plugin (or edge rails) - allows posting of comments to articles - has categories for posts No need