Good example. Let's ponder this...
On Sun, Jun 13, 2010 at 4:50 AM, Togg <[email protected]> wrote:
> Yes, the models are only indirectly involved so I use direct SQL. I
> need to join different tables and have a query taking quite long...
>
> Imagine we have three models, People, Cities, Countries.
> The People belongs to a City.
> The City belongs to a Country (Country has many Cities)
>
> In my country index page I want now to display a part which only loads
> on request.
> Regard the query as a database sanity checker because the data is not
> populated by hobo, but externally.
>
> def unassigned
> tmp = People.find_by_sql("SELECT DISTINCT `cities` FROM `people`
> WHERE NOT EXISTS.
> (SELECT * FROM `cities`
> JOIN `countries` ON `cities`.`country_id` = `country`.`id`
> WHERE `people`.`city` = `city`.`name`)")
> @unassigned = String.new
> tmp.each do |x|
> @unassigned += x.city + ", " unless x.city.nil?
> end
> render :partial => "unassigned", :object => @unassigned <--- I
> want to replace this all by a hobo way...
> end
>
> This query will determine all cities which are either currently not
> assigned to a country, or cities which are not even defined in the
> cities table.
>
> Best regards,
> Sebastian
>
> On 13 Jun., 01:03, Owen Dall <[email protected]> wrote:
> > Sebastian,
> >
> > Can you explain a little more about what you are trying to accomplish in
> > terms of your model relationships. Or are you dropping down to actual
> SQL
> > and what to make a tag for that?
> >
> > -Owen
> >
> >
> >
> > On Sat, Jun 12, 2010 at 7:40 AM, Togg <[email protected]> wrote:
> > > Hi all,
> >
> > > I tried to use <do part="my-part"> to update div on request when I
> > > click a button, but it didn't work.
> > > Basically the div is initially empty, and only on request I want to
> > > start the time consuming SQL query and display the result (also have
> > > indicator that the request is still processing maybe)
> >
> > > Can someone post a short example how to do this correctly?
> >
> > > Best regards,
> > > Sebastian
> >
> > > --
> > > You received this message because you are subscribed to the Google
> Groups
> > > "Hobo Users" group.
> > > To post to this group, send email to [email protected].
> > > To unsubscribe from this group, send email to
> > > [email protected]<hobousers%[email protected]>
> <hobousers%[email protected]<hobousers%[email protected]>
> >
> > > .
> > > For more options, visit this group at
> > >http://groups.google.com/group/hobousers?hl=en.
> >
> > --
> > - Owen
> >
> > Owen Dall, Chief Systems Architect
> > Barquin International
> > Cell: 410-991-0811
>
> --
> You received this message because you are subscribed to the Google Groups
> "Hobo Users" group.
> To post to this group, send email to [email protected].
> To unsubscribe from this group, send email to
> [email protected]<hobousers%[email protected]>
> .
> For more options, visit this group at
> http://groups.google.com/group/hobousers?hl=en.
>
>
--
- Owen
Owen Dall, Chief Systems Architect
Barquin International
Cell: 410-991-0811
--
You received this message because you are subscribed to the Google Groups "Hobo
Users" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/hobousers?hl=en.
