similar to: remote database ActiveRecord model

Hey guys, I know I can run search(q).total_hits, but if I try to put :limit=>0 it gives me an error. I don''t want it actually query any of the results, I just want it to tell me how many total_hits I would have if I wanted to search it. How can I do this? -- Posted via http://www.ruby-forum.com/.

Hello, Im using the following amazon web service API for S3 : http://amazon.rubyforge.org/ The problem is that after I establish a connection using establish_connection!, and try using the "store" command, I keep getting the following error. However, if I reboot my webrick server, it works fine for about one hour and then starts throwing this error: Errno::EINVAL in

I know this is probably stupidly simple, but I can''t seem to figure it out. I have a many-to-many association using HABTM. Im trying to clear all the stuff in the join table and call destroy on all the joined items. For example if I have a many to many for albums and photos, def method album=Album.find(4) album.photos.clear # NOW HOW DO I DESTROY ALL THOSE PHOTOS? end The things I

I''m hoping someone has encountered this before. I''m using AAF trunk and trying to multi_search across 2 models. It works fine on my windows (Webricks) dev env but now that i''ve deployed to linux, (Apache, FastCGI) I''m getting the following error: ArgumentError ( isn''t a valid directory argument. You should use either a String or a Directory):

Hi there! How can i use 2 database connections in my rails application ( if it''s possible of course ): one for reading from DB and one for writing to DB? Thanks, Dmitry -- 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

I''m having a weird problem. Recently, on all my environments, one of my two indexed models is not returning any results to acts_as_ferret. However, the folder is being created for it and Im not receiving any errors. On my two models, I call the following: Book.rebuild_index User.rebuild_index When I call those commands through either my live app "ruby script/server" or

This is currently the contents of "app-backup" in my cron.daily. -- #!/bin/sh # Cron Job for Mixbook Code Backup # # Updated February 1, 2007 cd /var/rails/beta rake s3:backup:scm --trace >> /var/rails/beta/log/backup.log cd /var/rails/beta/log echo "Backup Successful on" >> backup.log date >> backup.log echo "--" >> backup.log -- When I run

Hi, I have a has_many association between Book and Page. I have acts_as_ferret running on only the Book model. However, when I update the a page, it calls the auto update index on the Book model as well just in case any of the ferret fields were changed. How can I stop acts_as_ferret from auto updating the index on its own, especially when nothing changes? -- Posted via

I have an application that creates quite a few threads. I keep getting the "mysql too many connections" error. ActiveRecord does not close the connection once a thread had died out. To make things worse mysql has a wait_timeout variable that would basically kill off these connections for me, but there is a bug and I can not change the value of it. I have tried at least 10 different

Have the jpackage-packaged things like tomcat5 been moved into the disto repositories? Do they work with sun java? In particular, tomcat5 used to require jta. The one yum installs doesn't mention it now, but it also doesn't work with sun java 1.5 installed the jpackage way. What am I missing? -- Les Mikesell lesmikesell at gmail.com

Hi. If i had a RoR application dealing with very reserved personal informations about my customers, if my hosting provider would like to, i guess it would be easy for him to steal the data by simply peeking the username and password inside the database.yml file. Is there a way to hide the database password from indiscrete eyes ? Thanks, Marcus Ob. -- Posted via http://www.ruby-forum.com/.

How do I get ''save'' to execute without commit? I have tried: ActiveRecord::Base.connection.begin_db_transaction # do some stuff that doesn''t issue a database COMMIT statement # then: @myObject.save # this issues a COMMIT but it shouldn''t! Shouldn''t it wait until I''ve called: ActiveRecord::Base.connection.commit_db_transaction ? what am

I''m in an Oracle shop, and it''s the 1 thing that gets on my bosses nerves. I wish they would support this. Anyone any idea if or when it will be supported? Thanks Chris -- Posted via http://www.ruby-forum.com/.

I want to copy data from one database to another using rails. But, it seems that rails only will talk to one database at a time. Is there a way around this? Any help would be greatly appreciated. -- Best Regards, -Larry "Work, work, work...there is no satisfactory alternative." --- E.Taft Benson -------------- next part -------------- An HTML attachment was scrubbed...

Hi, I am creating a Rails front-end for a legacy application. For this application the username and password for the database must be provided by the user. i.e. each session needs a separate connection to the database using the credentials of the user logged in to that session. Does anyone have any idea where to even start? It seems like Rails won''t boot without a database

Hi, I really need help to understand what is happening while Rails connect to a database, (we area actually using postgresql, so my example will be with postgresql) What I understand is Rails is able to connect to different DB. Actually, this is what we want, and we have made some tests, everything is juste fine. However, all these tests lead us to some important questions that we did find the

I have a small table that is used to temporarily queue requests, as such it does not have an id field (or any other primary key), because it doesn''t make sense to have one. When I created an ActiveRecord class and tried to save it, I get: ActiveRecord::StatementInvalid: PGError: ERROR: relation "temp_requests_id_seq" does not exist It keeps looking for the id to auto

My Rails application requires a very busy worker process running in the background at all times. I am launching this non-interactive process using script/runner. This process is very busy and is communicating with the MySQL server constantly. As I started putting some load on the system to test, I started running into performance issues. I have since discovered that Rails is only using 1

I''m currently using ruby-postgres (the compiled interface to PostgreSQL), and I''m seeing a huge performance hit with larger :binary fields in ActiveRecord subclasses owing, it appears, to the use of the bytea field type and the fact that using that datatype necessitates an in-memory "unescape" conversion. The best I can tell from looking at the Postgres Active

I''m trying to create a sequence with no gaps in my db (contrived example, but should work out the same as my real one), and believe db-managed transactions are the way to go about this. It''s my first real ''go'' at transactions, so I may be mistaken about how things really work. Anyway.. Consider this example code: Class Invoice < ActiveRecord::Base def