search for: fks

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 and other special data mangling outside the well-bevahed application CRUD functionality. So, I was thinking, why is FK co...

Quick question. Say I have a geographical database with counties and zip codes where counties have and belong to many zip codes. zip_codes (id, zip_code) counties (id, name) When I create the association table, the Rails way says to do the following: counties_zip_codes (county_id, zip_code_id). However, given that zip_codes.zip_code is itself a candidate key, I would much prefer to do the

...on 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 should ask: does Rails really prefer to stay out of environments like mine where complex PKs and FKs, stored procedures, and table names that aren''t always drawn from language (plural vs singular names) are deeply embedded in our infrastructure? Do people like me in places like mine just stay out of Rails? Thanks all. -- Posted via http://www.ruby-forum.com/.

...eateuser MyMachine$ -j DOMAIN -L I get an error (NT_STATUS_ACCESS_DENIED). I use a script to do this, (I used the same script at my work and at the other location). What could possibly be wrong here ??? Thanks, Wouter Eerdekens -- Wouter Eerdekens wouter.eerdekens@fks.be fks bvba - Formal and Knowledge Systems http://www.fks.be/ Luikersteenweg 65 Tel: ++32-(0)11-21 49 11 B-3500 HASSELT Fax: ++32-(0)11-22 04 19

I''m looking for a plugin/whatever for preloading fixtures, to run tests with FKs defined. Specifying load order just doesn''t work for me, I need to purge the test db, load all fixtures, and only then create the FK constraints. Any suggestions? Isak --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Go...

Maybe I''m missing the point? Lets take for example albums of pictures. If I have a scaffold for each, and I''m showing an album, what if I want to list all of the pictures that are in the album? Surely, I''d want to call the List action in the picture controller. render_component would do this perfectly. But we''re told not to use render_component. So

Hello, As a rails newbie, i have stumbled upon some tutorials promoting migratons. I have thought, wow, cool and started using them right away. However, now that i am reading the RoR list on a daily basis, i have seen also mails ranging from ''migrations are not always the best'' to ''migrations are evil'' and even ''i would not use migrations even

...Category model I want to essentially combine the Controllers and views into one so that when you create/edit/show/destroy a Category you can also create the Books from the same views/actions. I''ve added the appropriate belongs_to and has_many relationships to each model (and the table pk/fks are in place): Book belongs_to: category Category has_many: books Thanks

Dear List, (History) My company has an old DOS based application that we run from our Windows NT4/Windows2K workstatsions. This DOS app is based on DB3/DB4 (yea the old (1987?) one with one file per table and separate files for FKs and the like ) Anyhow...we had it on an NT server that we would map a drive to and then launch...peachy. No we have more users of that application < 15 and our NT server couldn't open enough file handles or something and performance lagged. As is the case with DOS based apps (running on W...

...-------------------------------------------- Date: Tue, 27 Jul 1999 15:16:37 -0700 (PDT) From: Mike Holling <myke@ees.com> To: samba@samba.org Subject: Using //server/share%username ? Message-ID: <Pine.BSF.4.10.9907271509390.23017-100000@phluffy.fks.bt> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII I'm trying to get win9x clients to connect to a Samba 2.0.4b server on FreeBSD 3.2-STABLE. Some of these machines have Windows logins different from the Unix user on the server, and the smb...

Hiya RoR gurus, I work at a .NET shop, but I enjoy learning Ruby. So, I wanna prototype some of our product''s screens using Rails (and hopefullly AJAX). One thing I''m not sure about, since I''m a Rails noob, is whether ActiveRecord will get along with our database... So I have two questions: * Can I have ActiveRecord get along with our PascalCase naming conventions?

...that to get the child for any parent, you just find the same id1 and id2. So the compound primary key is sort of an informal kind of foreign key. I''m not a DBA, but the only possible reason I can think of why this was done this was is that it was done in MySQL before you could create FKs. So, what I"m trying to do is create RoR models from these. In general I need. class Parent < ActiveRecord::Base set_table_name "parent" # it doesn''t follow naming convention has_one :child end class Child < ActiveRecord::Base set_table_name "child&quot...

...;> ts = MetaphoneAnalyzer.new.token_stream(nil, "the quick brown fox jumped over the lazy dog") => $<Curtis::Analysis::Metaphonefilter...... at version=:double> >> while token = ts.next >> p token >> end ["KK", nil] ["PRN", nil] ["FKS", nil] ["JMP", "AMP"] ["AFR", nil] ["LS", nil] ["TK", nil] => nil As you can see it has been metaphoned. Now if someone were to search but inadvertently type ''qwick'' instead of ''quick'' it would still mat...

Is there any reason why AR has never supported foreign-key constraints? I can understand the lack of support for triggers and stored procedures since they are highly dependent on the database to create a wrap API around them. But this is not the case for foreign keys. This is specially important for open-source projects like Redmine/Chiliproject and Gitorious where you shouldn''t be

Hi List! May I tap into your combined common sense ? I have a legacy logging app that needs to be modernized. At the moment, Data is going to be stored in 5 tables, one table is going to contain more than 200 million and 2 others about 60 million rows. Mysql will be used, unless someone sees a major advantage in using something else (at the moment data is stored in a raw positioned file format,

...;6&Te_y^s;h)Ya^qe z2>Gw<28<|wZoB!bIEq!=kFCqo^AhL;!<HzWO-7j4;A8lh1W|Pw%I6<sWtBhX5^qN2 z7!s2p(i_B`zJlQtNLIg20aLQPOd%KHrxh)vDN-JiHQCfqwg?jE`L5tp;Z~>sb9+{o zdx0l6MI}{mGb)UoIt)w3m=wvyyqv;2OYFsn__NqxoZlllzofw@fABDeDdHE)Uq+@6 z{lh<lRAHal1pD`ChSFM3;NtCyfC?x!d<_i)Xj)>>fk_tasfkS=idA^Jos|4kEQ$%o zexF}<)zJVOsLP^=KCp=-@VxC_ze4|bwuDBHHtGS`4-C2b1ivJ%&+DgVo9ztK*erG- z&@8c}6R-hiE-=U(e{-Pr+|biZSEJ!`ZnDw);qa0yXaV`@-7-?d{8ODe{A{}1+agr9 zfB{Su^=7;|wP=Z2-r4#Wo%jVx8=PNkM%ot%0>~xZfHEOs!n{HUmpgQzTaMh_q=yzm zTzp5YoZU5IjbetlOGC}=QZjkfbHKImQz|!Q8JifqZ(LX}l7{<QU_I6HL$5gx0;5=...

...wxKpA_ls>*V%M(|)m|TuOq+0>uzpc5LizvS zlZYR3e2<$(2k1;T!to|uuD6&%$E!7oO|nLWpY4=ulO}Cj$s5BT;x{w&O~v00XviT9 zsj8X(NrC6ZSHj{dk>cqb=V_a2m|zuRW;!}0zcy>w+7fpsYbQWpZbbi;)Xc5R+ at gMS z1N;AC>uM)rmfFPYDHXav8}pAY-U;GQEdR~1P)2mUOJ>Z<M-5u0Bsz4ch4o+JwrQHD zcrB4~lcO-T7%|$Y52NZ$n0Y{G)Wfksjkz?5e@(2DVQjCAZIQGQ%dA{<mT1I;IV{T= z-vg-#!ho1|Il4V2Sy*zNXu2&)s#-CLs?3hABc<S18dHC at L4X=-SdX2#)QddcyyTJo z at xK_OthdpDULUK9i&@XjrPnDACf2#o2+52U8Nbe%#Rt`ivHf2$T(sRsPa=-^gdHLJ zjTg;uf?sQx3T`R+Zz+RK>P3{^#cd%1P5l#5$W53;1E~zx&8ouwOcbM#DDJK>m)(ex z(jAA7BBG at AAWG^jL~->b3NI!~d...

I'm using a Asterisk 1.6.1.6 with dahdi. We need to redirect phone calls to a certain number when there is nobody. So I read about call reflection but the call reflection applications on bristuff are not for 1.6.1.6. Are there any other applications or patches that provides call reflection for Asterisk 1.6.1.6?? Greetz TM