similar to: Importing Database into Rails App database?

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 am working on and will be publicly showing ActiveRecord some love around the time of the RubyConf*MI [1] in late August. My main focus is getting AR to better handle inserts, updates and merges when working large sets of data. It can improve improve performance by 400% to 600% in preliminary benchmarks. I am coding this in a way so it can be patched to AR easily, and with that in mind

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

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 trying to load conversion data into a postgresql database using activewarehouse-etl. I can create a flat file output from the conversion data without problem. However, when I try to load into the table using the information contained in config/database.yml I see this error: /usr/lib64/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/ base.rb:1959:in `method_missing'':

Buenas, Quiero hacer una ingesta de datos en una base de datos de un servidor. El proceso es hacer una consulta en la base de datos, que me dice uqe columnas tengo que coger. Una vez hecha dicha consulta, abrir un csv, coger las columnas que me indicaba esa base de datos y subir el dato concreto del csv a una base de datos. Estoy pensando en usar Apache Flume o similar, pero es en un servidor

I''m new to Puppet, and I''m a software developer, not a sysadmin, so be gentle. I have puppet managing some files via templates, and one of the template variables that needs to be plugged in is a password of sorts that shouldn''t be generally available. In particular, it can''t be stored in the manifest, as that''s stored in version control, and the

I have been using Ruby on Rails for around 6 weeks now (so far I love it), but I''ve gotten to a point in the application where I need to allow the user to upload comma deliminated text files that will get loaded into one of the database tables. Before I get started doing this, I was wondering anyone knows of any examples or tutorials that deal with this. I''d rather do it

Hello, I''m having trouble with transactions with rails 3.0.3 and mysql 5. I''d like to import data etl-batch-style: class Job < ActiveRecord::Base # ... def perform_etl connection.transaction do extract # some connection.execute / job.update_attribute stuff transform # some connection.execute / job.update_attribute stuff end end #... end

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

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

This is probably a noob question.. I have a fairly large query (the result takes along time to return) that I need to export to CSV after it is displayed with a view. Basically a link at the bottom of the page, "Export to CSV". I''ve found the rails wiki solution: http://wiki.rubyonrails.com/rails/pages/HowtoExportDataAsCSV . The only problem is that I would like to have this

I have bdrb successfully set up and running in a local project. It''s doing two things: 1) processing large csv files and using ActiveRecord to insert 2) sending large batches of emails using ActionMailer In development both work well. I see my ActionMailer emails in the log (though it''s the development.log -- odd?) On the production server csv processing works well, but

Hello I have been using LAMP for the last 6 years and i am now finally making the choice to move over to RoR. This MVC stuff is all very new to me. As i have no trouble understanding ruby code... or any code for that matter.. my challange comes in getting my head around the MVC stuff. Is there any demos articles that you guys have seen that takes a site or a business breif and explains where

See the blog post at http://blog.lonestarsoftware.net/2007/03/09/active_resources-010-released/ Reading through the rails blogosphere last week, I read a post (which I can not find again) that suggested a completely different approach to AJAX use in rails apps. The idea was to create a Javascript proxy to the ActiveRecord models and allow AR operations to be called from the client. I see this

Rails SQL Views 0.5.0 is now available from http://rubyforge.org/frs/?group_id=2435&release_id=8685 and shortly as a Gem (gem install rails_sql_views). More information on Rails SQL Views can be found at http://activewarehouse.rubyforge.org/rails_sql_views/ This release finally fixes the SchemaDumper issues, including the necessary select statement for the view. It also introduces PostgreSQL

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

Hello, Recently attachment_fu stopped resizing images for me. I''m puzzled because before today it was resizing them and I don''t know what''s changed. Here''s my code: class Product < ActiveRecord::Base has_attachment :content_type => :image, :storage => :file_system, :max_size => 18.megabytes,

I''ve inherited an EAV database and there''s really no option to remodel it. Data is stored as key_name, key_value pairs Trying to return a meaningful, unified recordset is far too complex to be efficient. I''ve decided to make use of the MySQL GROUP_CONCAT, and CONCAT_WS functions to return a fast query result, with the consolidated fields as one string. The final data is

Hello I''ve now read a lot about application-level authentication in Rails, but I need to do database-level authentication. The reason is that my database needs to have the current_user (database current_user, not current_user defined in an ActiveRecord Model) set to execute triggers for automatically updating audit tables. So it is not enough to have a session check against a User