similar to: Testing with foreign keys

Hello folks, I use to think that a relational databases without foreign keys constraints enforced strictly by the RDBMS were no good, piece of crap, data junk. However, I''ve also learned the hard way that FKs constraints imposes serious difficulties when moving data around, specially between different DBs, or for loading test data or for upgrading DBs schemas, or for porting DBs

Hello everyone! I seem to be have a bit of a problem setting up a few network folders for a my office on a Qnap storage device running Samba -v3.5.2. So I ask: when the 'write list' of a share contains ONLY groups, and a user tries to log on to that share, then samba authenticates against the primary group only of that user only?? Here is the example that fails: -the user is

Hi all, In the AWDR author use the execute method to declare foreign keys: execute "alter table.... add constraint.... foreign key...." Is there a ruby sintax to declare a foreign key in a migration class? -- Posted via http://www.ruby-forum.com/.

It seems like running sieve-filter from the console ignores the separator setting, thus not letting me filter into folder names containing dots. Normal delivery using lda handles it just fine, but not when using the sieve-filter command. Character not allowed in mailbox name: '.' Is there anyway to override this or is patching and recompiling the source my only option? # dovecot

ActiveResource basic auth currently breaks when certain chars are used in the user name and/or password field, e.g. ''@'' as part of the user name. I created a ticket on the issue[1], but closed it again as I''m not sure where the responsibility really belongs. It''s a showstopper for us, though.. Thoughts? [1] <http://dev.rubyonrails.org/ticket/10902>

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

Good day, does anyone here have a clue on how to make use of the NoSQL database "Riak" with Camping? I am building my website and Riak seems like pretty much the ultimate database! This would probably ruin every little feature in ActiveRecord, I don''t think I''d be able to do any has_many''s or belongs_to but I''d LOVE to be proven wrong. As far as

Just playing around with converting an apps to the new REST goodness in edge rails, and I''m trying to work out how to convert/write the functional tests. Is the recommended way to explicitly use the actions (e.g. get :show, :id => ...; post :create,..., etc) and test the routes separately, or duplicate the request, in which case how is that done get "/", :id => 5

I already have a simple role based access control system (User, Role, Privilege, Client) in place for my web layer, which checks User.authorized?(controller, action, client) from a before filter. What do you think about using this method for auth checks on the model layer as well, only with made up controller/action strings? (e.g. "model::Period", "close") A bit simplistic

Frankly I''m losing tolerance for the MS "stack." And I''m intrigued by Rails. But in my outfit I''m not only the web person, but also the application person and the DBA. So when I read that Rails doesn''t want to handle things like "compound keys" I blew right by those claims, thinking, "no way." But before I go deeper, I

I use Oracle and i really want to use migrations, but there seems to be no way to setup foreign key constraints. Is this true? If it is then doesn''t that make migrations useles with Oracle? Thanks Chris -- Posted via http://www.ruby-forum.com/.

Hi.. Guys new plugin again Foreign Key Associations is a plugin that automatically creates associations based on foreign-keys. The associations are created at runtime-ie. as your ActiveRecord models are loaded-so they will always be up-to-date. For example, given a foreign-key from a customer_id column in an orders table to an id column in a customers table, the plugin creates:

I''m having performance issues with one of my actions, and think I''ve narrowed it down to too many sql queries. I have a form with ~60 lines, which takes ~6 sec to save, 60%+ of that is db io. There''s 650+ lines of log data, most of which are AR/queries. The app is a simple dual entry book keeping thingy, and the form in question contains a journal entry along with a

I can''t seem to disable rails logging when using Mongrel. Any fix for this? Also unanswered on the Rails forum: http://www.ruby-forum.com/topic/109422#784596 Re: how can I disable the SQL logging which occurs in develo Posted by Greg Hauptmann (Guest) on 29.05.2007 21:22 You''re exactly correct Isak! Thanks. The logging functionality worked as it should in webrick. Is seems

Does anyone know how to extend the buit-in rake tasks like test:unit. I want to custom load some fixtures in a particular order. Thanks, Zack

I put my nav system in application layout. that way any controller loading will have the nav system. I have one problem though - the <%= yield %> is in the body, so how would my controllers specify other css files? my application layout would look like this: <html> <head> title css include javascript include </head> <body> nav system <%=yield%>

We have a fairly expensive task that we''d rather not schedule too many instances of in parallel. Couldn''t get pool_size to limit the amount of workers, and I figure that''s hardly optimal anyway, so would like to have the work queued up for a single named worker instead, running as soon as possible. Using MiddleMan.schedule_worker() with :job_key does start off a

Hi everyone, First of all, could you please CC me, I am not (yet) subscribed to this list. Now my problem: I created a test setup at my office that uses winbind to authenticate linux users to a Windows NT server (they log in with DOMAIN+username), as described in the winbindd manpage. I followed their setup completely. (at my work I am using RedHat 7.1 and the winbindd daemon found in the

I am using the the authorization recipe outlined in Rails Recipes.Is it possible for one role, say ''admin'', to have access to every action on every controller without explicitly having to create a Right for each? I know this will not work as is, and to force it to do so would violate MVC, but is there some other way to accomplish having something like this in a controller:

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