aeden / rails_sql_views

Rails SQL Views project extracted from ActiveWarehouse — Read more

Sort by: Priority | Votes | Last Updated

Loading…

1.

0 votes

Issue on recreating schema from a dump with a view depending on another view
1 comment Created 8 months ago by sava

Title

Body
SchemaDumper orders views alphabetically. If we have a view named 'a' in which definition view 'b' is used, then schema loading will abort with PGError: ERROR: relation 'b' does not exist
or cancel
SchemaDumper orders views alphabetically. If we have a view named 'a' in which definition view 'b' is used, then schema loading will abort with
```
PGError: ERROR:  relation 'b' does not exist
```
Comments

robertwahler Thu Aug 27 12:33:36 -0700 2009 | link

I think this is addressed in this commit:

http://github.com/robertwahler/rails_sql_views/commit/3e70425950e96c116f2de5c7d396208965f15919

Comment
I think this is addressed in this commit: http://github.com/robertwahler/rails_sql_views/commit/3e70425950e96c116f2de5c7d396208965f15919
or cancel

Parsed with GitHub Flavored Markdown
2.

0 votes

gem install rails_sql_views installs v0.6.1, not v0.7.0
1 comment Created 7 months ago by jtrupiano

Title

Body
This tripped me up because I ran into the problem in 0.6.1 where the column names weren't quoted. Once I forked your github repo though, I realized that you're on v0.7.0 and that the problem had since been fixed. Can you release this to rubyforge?
or cancel

This tripped me up because I ran into the problem in 0.6.1 where the column names weren't quoted. Once I forked your github repo though, I realized that you're on v0.7.0 and that the problem had since been fixed. Can you release this to rubyforge?

Comments

jtrupiano Mon May 25 08:02:14 -0700 2009 | link

Also, any reason that you don't have github building this either? It's a pain to have to instruct my team to download this library and build it themselves. If you include a .gemspec file in your repo, and mark this project as a rubygem in github, github will build it and host it for you.

Then in my gem manifest file for any project, I can reference the build on github (if for whatever reason you can't release to rubyforge). I'm happy to help if you're unfamiliar with these practices...

Comment
Also, any reason that you don't have github building this either? It's a pain to have to instruct my team to download this library and build it themselves. If you include a .gemspec file in your repo, and mark this project as a rubygem in github, github will build it and host it for you. Then in my gem manifest file for any project, I can reference the build on github (if for whatever reason you can't release to rubyforge). I'm happy to help if you're unfamiliar with these practices...
or cancel

Parsed with GitHub Flavored Markdown
3.

0 votes

rake db:fixtures:load fails in v0.7.0 from git
2 comments Created 5 months ago by danielblues

Title

Body
Hi, I've installed from git as a plugin with piston, it worked fine until running rake db:fixtures:load returned: undefined method `tables_with_views_included' for class `ActiveRecord::ConnectionAdapters::SQLite3Adapter' I went back to creating the views with SQL, but will try any fixes you may propose. Thanks daniel <pre> Ruby version 1.8.7 (x86_64-linux) RubyGems version 1.3.4 Rack version 1.0 Rails version 2.3.2 Active Record version 2.3.2 Action Pack version 2.3.2 Active Resource version 2.3.2 Action Mailer version 2.3.2 Active Support version 2.3.2 Environment development Database adapter sqlite3 rake db:fixtures:load --trace (in /home/dfb/Documents/ITQB/Projectos/openlabman) ** Invoke db:fixtures:load (first_time) ** Invoke environment (first_time) ** Execute environment ** Execute db:fixtures:load rake aborted! undefined method `tables_with_views_included' for class `ActiveRecord::ConnectionAdapters::SQLite3Adapter' /home/dfb/Documents/ITQB/Projectos/openlabman/vendor/plugins/rails_sql_views/lib/rails_sql_views/connection_adapters/abstract_adapter.rb:17:in `alias_method' /home/dfb/Documents/ITQB/Projectos/openlabman/vendor/plugins/rails_sql_views/lib/rails_sql_views/connection_adapters/abstract_adapter.rb:17:in `send' /home/dfb/Documents/ITQB/Projectos/openlabman/vendor/plugins/rails_sql_views/lib/rails_sql_views/connection_adapters/abstract_adapter.rb:17:in `disable_referential_integrity' /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/fixtures.rb:499:in `create_fixtures' /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/base.rb:1453:in `silence' /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/fixtures.rb:498:in `create_fixtures' /usr/lib/ruby/gems/1.8/gems/rails-2.3.2/lib/tasks/databases.rake:218 /usr/lib/ruby/gems/1.8/gems/rails-2.3.2/lib/tasks/databases.rake:217:in `each' /usr/lib/ruby/gems/1.8/gems/rails-2.3.2/lib/tasks/databases.rake:217 /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:636:in `call' /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:636:in `execute' /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:631:in `each' /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:631:in `execute' /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:597:in `invoke_with_call_chain' /usr/lib/ruby/1.8/monitor.rb:242:in `synchronize' /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:590:in `invoke_with_call_chain' /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:583:in `invoke' /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2051:in `invoke_task' /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2029:in `top_level' /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2029:in `each' /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2029:in `top_level' /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2068:in `standard_exception_handling' /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2023:in `top_level' /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2001:in `run' /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2068:in `standard_exception_handling' /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:1998:in `run' /usr/lib/ruby/gems/1.8/gems/rake-0.8.7/bin/rake:31 /usr/bin/rake:19:in `load' /usr/bin/rake:19 </pre>
or cancel
Hi,

I've installed from git as a plugin with piston, it worked fine until running rake db:fixtures:load returned:

undefined method tables_with_views_included' for classActiveRecord::ConnectionAdapters::SQLite3Adapter'

I went back to creating the views with SQL, but will try any fixes you may propose.

Thanks

daniel
```
Ruby version    1.8.7 (x86_64-linux)
RubyGems version    1.3.4
Rack version    1.0
Rails version   2.3.2
Active Record version   2.3.2
Action Pack version 2.3.2
Active Resource version 2.3.2
Action Mailer version   2.3.2
Active Support version  2.3.2
Environment development
Database adapter    sqlite3

rake db:fixtures:load --trace
(in /home/dfb/Documents/ITQB/Projectos/openlabman)
** Invoke db:fixtures:load (first_time)
** Invoke environment (first_time)
** Execute environment
** Execute db:fixtures:load
rake aborted!
undefined method `tables_with_views_included' for class `ActiveRecord::ConnectionAdapters::SQLite3Adapter'
/home/dfb/Documents/ITQB/Projectos/openlabman/vendor/plugins/rails_sql_views/lib/rails_sql_views/connection_adapters/abstract_adapter.rb:17:in `alias_method'
/home/dfb/Documents/ITQB/Projectos/openlabman/vendor/plugins/rails_sql_views/lib/rails_sql_views/connection_adapters/abstract_adapter.rb:17:in `send'
/home/dfb/Documents/ITQB/Projectos/openlabman/vendor/plugins/rails_sql_views/lib/rails_sql_views/connection_adapters/abstract_adapter.rb:17:in `disable_referential_integrity'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/fixtures.rb:499:in `create_fixtures'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/base.rb:1453:in `silence'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/fixtures.rb:498:in `create_fixtures'
/usr/lib/ruby/gems/1.8/gems/rails-2.3.2/lib/tasks/databases.rake:218
/usr/lib/ruby/gems/1.8/gems/rails-2.3.2/lib/tasks/databases.rake:217:in `each'
/usr/lib/ruby/gems/1.8/gems/rails-2.3.2/lib/tasks/databases.rake:217
/usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:636:in `call'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:636:in `execute'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:631:in `each'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:631:in `execute'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:597:in `invoke_with_call_chain'
/usr/lib/ruby/1.8/monitor.rb:242:in `synchronize'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:590:in `invoke_with_call_chain'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:583:in `invoke'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2051:in `invoke_task'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2029:in `top_level'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2029:in `each'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2029:in `top_level'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2068:in `standard_exception_handling'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2023:in `top_level'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2001:in `run'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2068:in `standard_exception_handling'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:1998:in `run'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.7/bin/rake:31
/usr/bin/rake:19:in `load'
/usr/bin/rake:19
```
Comments

robertwahler Thu Aug 27 14:27:39 -0700 2009 | link

I think this is addressed in this commit:
http://github.com/robertwahler/rails_sql_views/commit/73dc70edd6cd1325752642443c1fd3561e52860d

Comment
I think this is addressed in this commit: http://github.com/robertwahler/rails_sql_views/commit/73dc70edd6cd1325752642443c1fd3561e52860d
or cancel

danielblues Mon Aug 31 08:20:37 -0700 2009 | link

Hi,
It fixed the problem, thanks. daniel

Comment
Hi, It fixed the problem, thanks. daniel
or cancel

Parsed with GitHub Flavored Markdown

Labels

aeden / rails_sql_views

Pledgie Donations

Issue on recreating schema from a dump with a view depending on another view

Comments

gem install rails_sql_views installs v0.6.1, not v0.7.0

Comments

rake db:fixtures:load fails in v0.7.0 from git

Comments