Displaying 20 results from an estimated 30000 matches similar to: "has_and_belongs_to_many and finder_sql options"
2006 Feb 15
3
RailsTidy: validates your HTML
Hello everybody,
I needed something to validates my HTML templates so I wrote a plugin
and here is its first version:
RailsTidy is a plugin for Ruby On Rails. It allows you to
* validate your rhtml templates,
* validate the html output of your functional tests,
* clean the html generated by rails.
For doing all this, it uses
* Tidy[1], the popular HTML validator and
2007 Jul 31
1
RXML: <ruby:put expr="1+2"/>
Hello
railers,
I''ve always been annoyed by the fact that ERB doesn''t respect XML
specs.
As I mostly write XHTML, I''m trying to write a renderer using only
valid
XML files. Here is an example of a file so you get the feeling of
what
it''s going to
do:
<?xml version="1.0" encoding="utf-8"?
>
<html
2006 Jun 01
5
History plugin
Hello,
I felt annoyed enough when having to redirect user back to their
previous location in a hackish way that I wrote this plugin.
It avoids storing POST and Ajax request. It also has a facility to
specify actions not to store in the history.
If you are interested, it''s there:
http://blog.cosinux.org/pages/rails-history
See you all,
Damien
--
Damien MERENNE
2006 Feb 13
2
Do I need separate file for each model
Hi,
I have some models in a file named genel. When I try to use one of the classes in my controller rails raises an error telling classname.rb is not forund even the file is required already.
require "genel"
require "hesaplar"
class HesaplarController < ApplicationController
def yeni_firma
@emlak_firmasi = EmlakFirmasi.new
@sehirler = Sehir.find_all
end
2012 Sep 08
3
Polymorphic has_and_belongs_to_many association
Hi,
I''m currently having the situation where I have to implement a polymorphic
has_and_belongs_to_many by introducing an in between model that handles all
the "has_many :as" and "belongs_to :polymorphic" association
implementations... and is not doing anything else. Thing I don''t like it
here is, I am unnecessarily loading AR instances only to execute SQL
2006 Jan 06
1
has_many with :finder_sql question
hi all,
I have a Class, Client, which has_many projects (Project class). the
projects depend on a session_id variable, however. So the question
is, how can I do the following:
has_many :projects,
:finder_sql => "SELECT p.* FROM projects p INNER JOIN
projects_users pu ON pu.project_id = p.id WHERE pu.user_id =
#{session[:user_id]}"
The problem is that I need to filter a
2005 Dec 30
5
HABTM with finder_sql problem (Rails bug?)
I''m building an app that needs i18n support across the entire database
(i.e. localized attributes). In order to do this I''ve created a
special HABTM join table that can be associated with _any_ other
table:
create table language_strings (
for_table varchar(255) not null,
foreign_id int not null,
language_id varchar(5) not null,
attr_name varchar(255) not null,
value text
2006 Feb 17
5
getting old values
Hi all,
I''ve add :before_update event to my model
Before updating a record I want to check if new attributes differ to old attr.
My question is how to retrieve old attributes in :before_update event ?
thanks
--
gratis egold 1$ http://shegold.com/
2006 May 22
4
naming convention for bridge tables.
I read somewhere that the correct naming of bridge tables is in alpha order.
For example. I have two tables:
houses, and colors.
If I want to create a bridge table to associate colors with houses, I would
name the table:
colors_houses
The associations work fine.
But, if I have a table named: track_houses.
Building a bridge table called: colors_track_houses, gives me model
associaton errors.
2012 Jan 30
4
Reaching into a has_and_belongs_to_many - will :through work?
Hi. I''m hoping somebody can tell me that I''ve just gotten my syntax
wrong and I can in fact do what I want to do.
I''ve got a Group, and a Group has_many Campaigns.
Campaign has_and_belongs_to_many Users (and, naturally, vice versa).
So I''ve got a groups table, a campaigns table (that has a group_id), a
campaigns_users join table (with campaign_id and
2007 Sep 06
1
finder_sql patch problem
Hello,
I have the finder_sql problem and I found this patch
http://dev.rubyonrails.org/ticket/7576; but I don''t know how to use
this patch??
I copied all the changes into the correct files and restartet the
server of my ruby on rails application, but nothing changed.
Could someone tell me please how I have to use this patch??
Thanks
Manfred
2006 Feb 28
3
[AR] #{id} namespace visibility used in finder_sql
Dears,
[Rails 1.0.0]
I''m working with a legacy schema, and around my 20+ models i''ve used
some AR constructs.
They are based on a finder_sql doing some dirty sql and using #{id}
from the ''pivot'' model for extracting data in other tables.
like :
class Division < ActiveRecord::Base
set_table_name "legacy_division"
set_primary_key
2006 Jun 09
1
finder_sql issue with has_many :through
I have an inner join query that Action Record can''t seem to pull off
conventionally, so I''m trying to use :finder_sql to utilize an sql query
that works beautifully in SQL. The problem is, when I try to call the
method, I get the following:
private method `gsub'' called for #<Array:0x267de04>
Here is my has_many code:
has_many :mod_privileges,
2005 Dec 27
0
How do I combine :finder_sql and :conditions to perform a sub-search on a custom has_many relationship?
I''m sure there''s something right under my nose that I''m missing.
I have two tables with two parallel one-to-many relationships. I wish
to use the :finder_sql parameter to essentially ''or'' the two foreign
keys.
What isn''t working for me is performing a ''sub-search''.
Let''s say the tables are "stores" and
2006 Oct 30
2
It this possible: finder_sql-like behavior for belongs_to?
Guys,
I have a need to support as has_many/belongs_to relationship on a
legacy(kind of) schema. The reason I say kind of is that the schema does
have "id" columns that are used in many associations, but this particular
has_many/belongs_to association needs to support different ones.
I''ve attached to code at the end of this email. Suffice it to say I need to
use the standard
2006 Aug 15
2
has_many + finder_sql & :include
Hello,
In a model I have:
has_many :things, :finder_sql => '' select * from other_things '' +
'' where id = #{id} ''
When I do MyClass.find(:all, :include => :things) I get a weird error:
from
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/abstract_adapter.rb:120:in
2006 Aug 13
1
Is :finder_sql using #{id} broken?
Hi All,
It seems that :finder_sql in a HABTM association only interprets a
single quoted #{id} the first time through a query. I see examples
of this being used in a few places (though with has_many) and I don''t
really see how to use :finder_sql without a #{id}.
Am I missing something or is this just broken?
--
Paul Haddad (paul.haddad@gmail.com paul@pth.com)
2006 Jul 24
1
has_many + finder_sql
from the api I got:
<pre>
has_many :subscribers, :class_name => "Person", :finder_sql =>
''SELECT DISTINCT people.* '' +
''FROM people p, post_subscriptions ps '' +
''WHERE ps.post_id = #{id} AND ps.person_id = p.id '' +
''ORDER BY p.first_name''
</pre>
I would like to pass in the
2007 Mar 21
1
Eager Loading with custom :finder_sql
Is there any way to do eager loading when using custom :finder_sql ?
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
2006 Jan 17
15
legacy database and finder_sql nightmare!
This is my first rails app with a legacy database and I''m having a
terrible time getting the models set up correctly. I have an order
table that has a primary field named order_number. I have a name table
with a primary of item_number. These two tables are liked by the
item_number and the order_number, but not as you might think. If the
order_number is 2500, then each entry in