similar to: DATABASE update

Hi, I''m a brazilian developer, work in a hospital and we have a legacy database that we want to access via rails. Rails maps decimal types to float, and to circumvent this problem the suggestion one can find on the list is to represent decimal values as cents. That''s not applicable when you have to access a legacy database. I found two tickets 4274 and 4605 on rails trac,

Hi All I''m trying to combine the from_for and select helpers Right now I have form_for :service, :url => ...... do |f| select("abc", "xyz_id", @my_arr.collect {|item| [ item, "bla" ] }, {:prompt => "opt1"} ) .... end What I want to do is something like .... f.select("abc", "xyz_id", @my_arr.collect {|item|

Hi, How do I disabled asterisk to use database and storage voicemail in directory. Im getting the below error [Dec 3 19:08:53] WARNING[4934]: app_voicemail.c:3430 inboxcount: Failed to obtain database object for 'asterisk'! [Dec 3 19:08:55] WARNING[5129]: app_voicemail.c:2353 last_message_index: Failed to obtain database object for 'asterisk'! [Dec 3 19:09:04]

I''ve deployed an application using Capistrano. But on my local machine I edited one of the earlier migrations. I''ve tried "cap deploy_with_migrations", but it looks like it didn''t rebuild the database. How can I do the equivalent of this using Capistrano? "rake db:migrate VERSION=0" "rake db:migrate" -- Posted via

I''ve got a field in a database that contains a string of ids. I want to be able to remove an item from that list and save the list again. The only way I saw how to do this was to convert it to an array and back to a string again. The variable names are for an example. This code works, but I don''t think that it''s efficient. It''s all in my controller.

Hello! The November/December 2008 issue of IEEE Software has nice a tutorial on Ruby on Rails. IEEE Software is one the most prestigious magazines on Software Engineering. Tutorial: http://www.di.ufpb.br/~alan/ror-ieeesw.pdf<http://www.di.ufpb.br/%7Ealan/ror-ieeesw.pdf> Source code: http://www.di.ufpb.br/~alan/s6vis_code.zip<http://www.di.ufpb.br/%7Ealan/s6vis_code.zip> ABSTRACT:

Any thoughts on how to avoid this problem? Already tried: 1. Setting the charset and collation in migration 001 - no effect: def self.up db_name = ActiveRecord::Base::connection.current_database() execute "ALTER DATABASE #{db_name} CHARACTER SET utf8 COLLATE utf8_bin" end 2. Setting the charset and collation on each table individually - no effect:

hello all, Is there some way to generate migrations from an existing database structure? I have the schema.rb file, but it isn''t enough for me. I need the migration files.... Please help! --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send

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''m just getting into writing tests for my first RoR app. I''ve got a few data migrations to load reference data (i.e. 2-char state abbrevs, payment types, etc.). How do I get that data into the test database? I understand fixtures are to load test data. But if I duplicate these lookup tables in test fixtures, it seems like that is violating the DRY principle. Is that OK in

Hello, I get this error trying to load some data from DB. I''m using Rails 1.2.2 on Fedora Core 6 and Sybase adapter. This worked fine when application run under Rails 1.1.6 but now I''m migrating to 1.2.2 and have some problems. At browser I got: SQL Command for table_structure for tplib_bckps failed Message: schema_info not found. Specify owner.objectname or use sp_help to

Hi, all I am new to actionmailer. I am writing a script that sends emails contains lots of file names. So the email will look like: hi, filename1 filename2 filename3 . . . filenameN So I want to pass an array containing all the filenames into the email body. My code is below: class Notifier < ActionMailer::Base def log_report(recipient, files) from

Can anyone recommend a database modelling tool for the Mac? I''m building a new Rails app and want an interface to draw out the database''s entity relationship diagram, setup foreign keys and then output DDL at the end to MySQL. I''ve previously used DBDesigner, CASE Studio and some pricier enterprise software on Windows, but can''t find anything suitable for my

I saw that there''s a patch in the queue (http://dev.rubyonrails.com/ticket/1874) for a Firebird adapter. Just wondering if anyone is using this, the other Firebird adapter, or something else w/ Rails. My main interest is that sometimes Windows is a target platform, and Firebird is stable on Windows, whereas I''ve heard that the Windows version of PostgreSQL isn''t

Okay, this is something I run into a lot and don''t really have a great solution. Here is a simple example: class Blog < ActiveRecord::Base has_many :posts validates_presence_of :name end class Post < ActiveRecord::Base belongs_to :blog validates_presence_of :name validates_presence_of :blog_id end Now, if I want to create a blog and post at the same time I

I''m creating a message queue system, (think JMS message queue) Basically, I''ll be firing off an http request as soon as a row appears in a database. Now in past implementations I''ve done the following. 1. Polled the database every 0.10 seconds. 2. If something was there to work, I''d tag it as complete. 3. Create a separate thread. (no further database hits

i have rails-2.1.0 my database.yml development: adapter: oracle database: pe username: or password: or >rake db:create >rake db:version --->Current version: 0 >rake db:migrate rake aborted! ORA-12154: TNS:could not resolve the connect identifier specified (See full trace by running task with --trace) is above idea is possible, then how ? and i thing i should give service

I''ve created a table in a SQL Server database using a migration, successfully. I''ve tried to change the name of a column in the table and got the error message above when running ''rake db:migrate''. Previously I have developed using MySQL and Sqlite and migrations have worked successfully. This is an error I have not seen before. Has anybody seen this and worked

Hello everyone, I am trying to use request.remote_ip in my application to log a user''s IP address because I have been having a lot of abuse issues. basically when a user logs I simply call user.update_attribute(:last_ip, request.remote_ip). The problem is that for some reason a lot of people that have recently logged in still have NULL listed as their last_ip in the database, even

Is there a nice way in rails to automatically extract an exising database schema from an existing app and then in a new app automatically create a database based on this schema? -- 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