similar to: Rake migrate and creating join tables

Hello there, I was wondering whether rails 1.1.1 supports N:M:K relationships that is having a pivot table with three columns which are primary keys: say, (apple_id, orange_id, lemon_id) It would be so great if Rails could be able to have id-s which as n-tuples. Thanks, Roland -- Posted via http://www.ruby-forum.com/.

I want when the user clicks on a button on the browser "Perform monthly billing run" the controller to lanch a sql DML statment to be called (in the model?) than runs something like "insert into billing (item, qnt, total_cost, billing_run_timestamp select item, qnt, item*cost as total_cost, timestamp from services where service_end_date is null" How can I run a DML

Hi all I have a new migration file created that adds some tables and fills one with some data: create_table :sound_styles do |t| t.column :name, :string, :null => false end create_table :show_types do |t| t.column :name, :string, :null => false end create_table :countries do |t| t.column :name, :string, :null => false end ActionView::Helpers::FormOptionsHelper::COUNTRIES.each

Hi All I am trying to understand if I can use migrations to migrate data under the following conditions 1. Across 2 different databases (Oracle/DB2) with same schemas. 2. Across 2 different databases (Oracle/DB2) with different schemas. I am trying to avoid writing DBI/OCI8 scripts. Can somone please shed some light if this is even possible? thanks -daya -------------- next part

I am using the restful authentication plugin and am always prompted to login if a different subdomain is accessed. I have found a couple rails "solutions", but none of them seem to work: # development.rb 1. ActionController::CgiRequest::DEFAULT_SESSION_OPTIONS[:session_key] = ".localhost" 2. ActionController::Base.session_options[:key] = ".localhost" Does anyone

I have encountered a need for float-to-int casts that saturate to min/max when the value is out of the range of the target type. It seems that there is no intrinsic to do this, currently, but on IRC it was pointed out that a patch [1] has been proposed to implement this functionality in exactly the way that I was looking for. It looks like the discussion has died out but I was hoping maybe to

I'm trying to use func_odbc to write to a MS SQL db. Here's my func_odbc conf: [OPTIN] dsn=MSSQL-Optin write=INSERT into OptIn (orgID) values (${VAL1}) Dial Plan exten => +18665551212,n,Set(ODBC_OPTIN()=dave) When I do an odbc show, it shows that I am connected to the db. If I use isql, I can write to the db, however, when I use func_odbc, a record will not write. I'm using

Hey folks, am hoping someone can set me straight with a solution to an issue that has come up involving the timing of rendered page elements in relation to the completion of an action''s execution. I have an ror search app which searches through two tables consisting of 7,000 page urls and a table w/ 87,000 related keyphrases within those pages. Search results can take anywhere from 2

Are migrations used only when you''re making changes to a database? Does it just allow the developer to avoid using raw SQL when working with databases? -- Posted via http://www.ruby-forum.com/. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to

I''ve just had a look again at the autocompletion demo that Thomas put up at http://script.aculo.us/demos/ajax/autocompleter Unfortunately, in Konqueror (3.4.1) it doesn''t work at all. Not even an error is triggered. It does work nicely in Firefox. How about Safari? I don''t have the time right now to track this down systematically (maybe latter), but just from

Hi, In "Agilge Web Development With Rails" on page 217, an example of foreign keys is shown. I am however unable to find a definition of wheater the naming of the index is significant. On the above mentioned page, this line is shown in the example: constraint fk_items_product foreign key (product_id) references products(id) In "fk_items_product", "items" is

Hi, I''m a little confused about sessions. I have two objects, object "Apple" and object "Banana". These two objects have an N:M relationship. What I am doing is listing All of the Banana objects that are associated with a single Apple, then below that listing all of the Banana objects not associated with that same Apple. The user is then allowed to change the

[1]Si vous n'arrivez pas ? lire correctement ce message cliquez ici [2]Disponis le crdit selon vous [3][email-noel_02.gif] [4][email-noel_03.gif] [5][email-noel_04.gif] [6][email-noel_05.gif] [7][email-noel_06.gif]

Is it possible to execute a DML statement against a MySQL database from within Rails? I have a table I''m using for batch processing. It needs to be truncated to reset the primary key before each batch insert statement. I looked at the API here: http://api.rubyonrails.com/classes/ActiveRecord/ConnectionAdapters/DatabaseStatements.html#M000532 and didn''t notice anything that

I''m somewhat of a newbie - played with recent versions of rails a few mths ago, but have decided to start from scratch with 1.0. I want to build my new db as much as possible with migrations, so I watched DHH''s migrations movie from rubyonrails.org. A few things confuse me: 1. He generates the model ("post") before running rake db_schema_dump. Is that necessary or

rake migrate bug with datetime: > rake db_schema_dump produced a bad schema.rb that isn''t valid ruby, it has an invalid default, unless ruby takes bare words: t.column "date_available", :datetime, :default => Sun Jan 01 00:00:00 Arabic Standard Time 2006, :null => false I don''t think the Baghdad time zone should matter. ruby 1.8.4, rails 1.1.2,

Anyone know why "rake db_schema_dump" would produce the following error: rake aborted! Don''t know how to build task ''db_schema_dump'' (See full trace by running task with --trace) Otherwise, my migrations work fine. -- Posted via http://www.ruby-forum.com/.

We''re using migrations to manage a SQL Server project and have been running into a number of issues with db_schema_dump/migrations. Can anyone confirm that these are actual issues with the SQL Server adapter and not issues with me :) 1) Fields are not properly setup with proper null settings (:null => true / false). I''m wondering if we need to update the def columns method

Oh noes! What do I do? Just installed RoR and SQLite3 yesterday, watched a screencast that said the db_schema_dump will slaughter my enemies and make my poop smell like rainbows. Now I get rake telling me that it doesn''t know how to. Any help? -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are

Hi all I''d like to dump also my data with rake db_schema_dump. Is there a way to do this? Thanks Josh -- Posted via http://www.ruby-forum.com/.