[DataMapper] joins include group by order by when not requested = causes SQL temporary sort table

2010-06-27 Thread Kevin
, with large result sets this won't work. Any tips? Is this a known problem anyone else has run into? Any suggestions where to start looking in the source? Ciao, Kevin -- You received this message because you are subscribed to the Google Groups DataMapper group. To post to this group, send email

[DataMapper] Re: does rspec2 work with datamapper?

2010-07-13 Thread Kevin
I needed to add gem 'activerecord', RAILS_VERSION to my Gemfile. I put it in the test group. Rspec still works with DM, its just the AR gem needed to be loaded. Require doesn't do it the same was as the gemfile, apparently. Ciao, Kevin On Jul 9, 10:04 am, Kevin inspir

[DataMapper] Re: Querying invalid records?

2010-07-13 Thread Kevin
You could always hack around it with Model.find_by_sql - though that returns a frozen struct I think? Unfortunately I'm not expert enough to reply about other ways to hack around it :) -Kevin On Jul 7, 7:59 pm, David Masover ni...@slaphack.com wrote: I'm not talking about dm-validations

[DataMapper] Re: joins include group by order by when not requested = causes SQL temporary sort table

2010-07-13 Thread Kevin
Anyone else noticed this strangeness with GROUP BY and ORDER BY being included for all association retrievals? Any tips where to look in the source? -Kevin On Jun 27, 6:14 pm, Kevin inspir...@gmail.com wrote: Here's my next thing to hack/fix, hopefully: Groups HABTM Users.  Calling

[DataMapper] Re: Model update with conditions?

2010-07-13 Thread Kevin
Yeah, the source is pretty readable though for most things, I've been doing searches through it when I have questions. The API is available here to. http://rdoc.info/projects/datamapper/dm-core We should add FAQs to the wiki or something. -Kevin On Jul 7, 7:22 am, Yuri Smirnov tycoo

[DataMapper] Re: Some questions about data types

2010-07-14 Thread Kevin
Clever! This would be handy to mention in the docs/website. -Kevin On May 27, 1:46 pm, Jonathan Stott jonathan.st...@gmail.com wrote: 1. Enum Type I'm not sure about this.  It might be possible via subclassing though, as suggested. 2. unsigned smallint property :little_counter, Integer

[DataMapper] Re: Some questions about data types

2010-07-14 Thread Kevin
As a follow-up, how does one make an Integer column not_null default 0? Looks like not_null for text columns is with :length = 1..999 vs. 0.. I don't want to validate it's existence on setting, I just want to force the value to be 0 after its been created. -Kevin On May 27, 1:46 pm, Jonathan

[DataMapper] slow rails console via dm-rails = because loading all models?

2010-07-15 Thread Kevin
I don't know how to benchmark this better, but I wonder if the slowness is because we preload all the models. Isn't one of the beauties of the rails console that it'll autoload files based on what you try to instantiate? from

[DataMapper] Re: Documentation patches wanted

2010-07-18 Thread Kevin
, then I block out the bottom with __END__ and change what I'm testing in it. Then I can just run it from my editor. Its a bit slower going than being able to mess with state/etc as from a console though. Good morning! -Kevin -- You received this message because you are subscribed to the Google

[DataMapper] Re: Documentation patches wanted

2010-07-20 Thread Kevin
Another suggestion would be more info on exactly what paranoid does in terms of the get methods and destroy methods (i.e. nothing to destroy, but adds checks against the pranoiddeleted boolean or datetime being null). More info about repositories and how to change them. Perhaps an example case

[DataMapper] Re: order by field in child row

2010-07-20 Thread Kevin
You tried the obvious: u = People.first; u.houses.all(:order = [:bought_date.asc])? I'm not an expert (yet) but seems like it should work. -- You received this message because you are subscribed to the Google Groups DataMapper group. To post to this group, send email to

[DataMapper] Re: joins include group by order by when not requested = causes SQL temporary sort table

2010-07-20 Thread Kevin
Agreed, I would lve a way to globally disable this instead of having to monkey-patch :) -- You received this message because you are subscribed to the Google Groups DataMapper group. To post to this group, send email to datamap...@googlegroups.com. To unsubscribe from this group, send email

[DataMapper] Re: dm-types and Flag[]

2010-07-21 Thread Kevin
Ah, so flag assigns a bit to each flag and can add them together/etc to allow multiple flags to be set? Your failing test seems to be a bug with it, eh? Add a ticket to the lighthouse? http://datamapper.lighthouseapp.com/projects/20609-datamapper/overview -- You received this message because

[DataMapper] Re: “first” method is querying the whole relation

2010-07-25 Thread Kevin
Try querying it differently, perhaps only .all calls on the association: locations.all(:order = [:time.desc]).first.lat or even (should be same thing) locations(:order = [:time.desc]).first.lat -Kevin -- You received this message because you are subscribed to the Google Groups DataMapper

[DataMapper] Re: “first” method is querying the whole relation

2010-07-25 Thread Kevin
There must be some funny business in your models try stripping them down. If you still get troubles, post a full example script as a github gist or somewhere to try? My test with similar models (I think?) in my app. Many topics, each one has a user. Each topic has a board.

[DataMapper] Re: paranoiddatetime-and-paranoidboolean-fail-in-100

2010-07-25 Thread Kevin
I still say making a datamapper-only test script is the only/best way to test things like this (or use an rspec tests, thats what I've been doing lately and its nice since you can use spork to have the slow stuff preloaded). -Kevin -- You received this message because you are subscribed

[DataMapper] Re: Finding by association

2010-02-16 Thread Kevin Hutchinson
this helps Kevin On Feb 15, 3:38 pm, Dan Kubb (dkubb) dan.k...@gmail.com wrote: MarkMT, Unfortunately I'm getting the wrong people, consistently for a number of different cases. Is there some reason why this should not be expected to work? Can you try with edge dm-core? There was a recent fix

[DataMapper] Re: Querying via association

2010-02-16 Thread Kevin Hutchinson
I experience the same issue with MySQL 5 using dm-core 0.10.2 The generated SQL looks for the wrong ID. My workaround is to first get the orange label then list all its posts: label = Label.first(:name = 'orange') posts = label.posts This seems to work for me. Kevin On Feb 13, 9:22 am, casual

Re: [DataMapper] “first” method is querying the whole relation

2010-07-25 Thread Kevin Watt
What's the sql that you're seeing? At first I thought you were using HABTM and needed to query the :through relationship, but its just has n, it should be pretty simple (i.e. work as you expect) Ciao, Kevin Desire makes everything blossom; possession makes everything wither and fade. - Proust