similar to: Rails SQL Views 0.5.0 Released

I have a DB2 schema with many ''views'' and table partitions defined in it. As per our new project requirement we have to support multiple databases (DB2,Oracle and MYSQL to be specific). The frontend application is implemented using Ruby on Rails. I am interested in exploring the possibility of using Rails Migrations to abstract out the schema to a DB independent layer. I could

I am receiving the following non-fatal error from Rails for a particular action: Error calling Dispatcher.dispatch #<ArgumentError: Anonymous modules have no name to be referenced by> ./script/../config/../vendor/rails/activesupport/lib/active_support/dependencies.rb:313:in `to_constant_name'' ./script/../config/../vendor/rails/activesupport/lib/active_support/dependencies.rb:270:in

My production environment is actually Oracle, in which case if I say: set_table_name "v_table" It will treat it as a readonly table. However, doing the same under MySQL throws an ActiveRecord::StatementInvalid error, saying that the table db.view doesn''t exist. Is there a way to get around this? I am using MySQL to test some new code I am working on, and wouldn''t

Hi! I''ve got a very strange problem. Suddenly the SQLite3 Backend stopped working. Example 1: > rake db:rollback == CreateProducts: reverting ================================================= -- drop_table(:products) rake aborted! An error has occurred, this and all later migrations canceled: SQLite3::SQLException: near "CASCADE": syntax error: DROP TABLE

Hi there, I''ve been experimenting with implementing BackgroundDRb in my rails app but am running into some problems. The primary problem I''m getting is in cleaning up worker threads, or getting any kind of response out of worker threads. If try using the response function/hash in my Worker the worker will not execute reporting that response is an unknown variable or function.

Before I file a ticket, I''ll query ya''ll about this: The API docs for acts_as_tree''s counter_cache is to create a database column called "children_count" to hold the counter_cache. I have enabled this option in my model. While writing tests I wrote a test for creating children from the a parent: message = @forum_message["parent"].find child =

ActiveWarehouse 0.1.0 is now available for use. I have posted a tutorial at http://anthonyeden.com/2006/12/20/activewarehouse-example-with-rails-svn-logs which demonstrates how to extract data from the Rails Subversion logs and turn it into a simple drill down report. The ActiveWarehouse web site is http://activewarehouse.rubyforge.org/ ActiveWarehouse is a plugin for Rails which provides

Hi all, Hope you can help me with understanding how Ruby / Rails treats arrays full of objects. Let''s say I have to arrays of objects. Both are the same kinds of objects. tomatoes = Fruit.find(:all, :conditions => [ ''tomato = ?'', true], :limit => 10) fruits = Fruit.find(:all, :limit => 10) And I want to create an array of these objects called @my_fruits,

HI all, I''ve got a migration that creates a few new tables and populates a bunch of data into those tables from existing models. It works great. As expected. Tables are created. Relationships are made. Everything comes out fine as far as the data goes. But for some reason the migration task ends with this error: rake aborted! negative argument I''ve liberally sprinkled my

I''m working on an app that uses info from a government database. For a variety of reasons (not the least of which is that their database is in MS Access), I can''t simply write a wrapper around the legacy database. Instead, we''re looking to have an "import" script in the Rails environment (it''s fine if it''s run from the server and through the

I have a Person model with attributes first_name and last_name. I want to implement autocomplete search that looks that the entire name. Hence I have a method: def full_name self.first_name + " " + self.last_name end Is it possible for me to query on full_name and have rails match the first_name and last_name fields? I currently receive this error when I try, because full_name

Hello, I need to consume a web service of an App called RedMine created with Rails, in order to have a sort of "separate" interface (not the same as the app) for one of the departments (that interact with the app) to interact with it and generate some different reports based on the same data. I don''t know much about either (ETL and Rest), all I know is that ETL seems to

I''m using the date_select and datetime_select helpers in my view, and they return Date classes from the params hash. But how do I work with Date classes, they don''t print human readable dates or times, Time classes work well I can use strftime("%H:%M") to print to the screen. Is it possible to convert a Date to a Time, Ive been tinkering in irb but have got

hey all, Im looking at switching from bluehost to a new provider. Mainly for Mongrel, trac and SVN support. I was hoping to get some feedback on the above mentioned hosting companies I have posted this as part of an existing ''what privider would you reccomend topid'' But have considered it and decidec it deserves its own topic. cheers, Adam -- Posted via

Hello all, I''m using Scriptaculous 1.6.1 on a project I''m developing. My generated HTML (generated by PHP) looks something like this: <ul id="admin-list"> <li id="li-13">Singletary, Bob (President/CEO)</li> <li id="li-12">Chatman, Jim (Vice President of Finance/CFO)</li> ... </ul> <script

I just updated to the latest revision (5445) and ran rake for ActiveSupport and received the following failures: 1) Failure: test_autoload_doesnt_shadow_name_error(DependenciesTest) [./test/dependencies_test.rb:662:in `test_autoload_doesnt_shadow_name_error'' ./test/dependencies_test.rb:655:in `test_autoload_doesnt_shadow_name_error''

In my daily development, I migrate back and forth between versions, and often do: rake load_fixtures... ... in order to populate my development database with fun data. Now, with any HABTM relationship, there are failures, as there is no way to say "which" fixtures to load first. Within an actual functional or unit test case, you could simply load them in the proper order, but

I''m actually looking to create my own markup language, after a look to the greats markdown and textilize markup languages they seem to be more complexes that what I need, so not feating with my application. Any help is welcome ;-) -- Grosjean S?bastien

We''ve finally finished up work on our application and are now beginning our beta. The site (SMS+mobile blogging+event planning+LBS+photos) is built using 100% Ruby on Rails. Many thanks to all the people who answered questions over the months on this list. Our experience with Rails was overwhelmingly positive! We''d love to hear any feedback you might have:

Hi, After reading section 9 of LARTC it seemed to me that a pure TOS based QoS setup with be sufficient for a small newtork. Interactive packets could have the highest priority, second highest for DNS and small HTTP packets and lowest prio for all others. The advantage is that, the setup would be simply a couple of iptables lines, because the default pfifo_fast qdisc already implements