search for: activewarehouse

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://active...

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...

...9; ./script/../config/../vendor/rails/activesupport/lib/active_support/dependencies.rb:400:in `require'' ./script/../config/../vendor/rails/railties/lib/commands/server.rb:39 script/server:3 I have a feeling it has something to do with this little bit of code: aggregate_class = Class.new(ActiveWarehouse::Aggregate) ActiveWarehouse::Aggregate extends from ActiveRecord::Base and instances are created as needed. Is there a proper way for me to construct these classes on the fly without causing this error? Thanks. V/r Anthony Eden --~--~---------~--~----~------------~-------~--~----~ You received...

As part of the ActiveWarehouse project we''ve broken out extensions to the ActiveRecord adapters into its own subproject called AdapterExtensions. This project is specifically for extensions to the adapters themselves versus extensions to ActiveRecord::Base and its related classes. If you have extensions at the adapter l...

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 support, tested on both the native and pure ruby drivers. As always, comments and suggestions are welcome. V/r Anthony Eden --~...

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 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

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

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