Log message #109946

# At Username Text
# Aug 7th 2008, 14:44 moelee or sheepcontroller
# Aug 7th 2008, 14:44 moelee the controller would be name sheepscontroller?
# Aug 7th 2008, 14:44 moelee err if the table was named sheep
# Aug 7th 2008, 14:43 moelee sheep
# Aug 7th 2008, 14:43 moelee so like
# Aug 7th 2008, 14:43 Eddie_CRO maybe retrival from db should be somehow formatted?
# Aug 7th 2008, 14:43 Eddie_CRO anyone has any experience with non english characters? mysql db is in utf-8, pages are in utf-8 but they don't display them right...?
# Aug 7th 2008, 14:43 bG^_ generally speaking, it's a VERY bad habit inserting/updating with views
# Aug 7th 2008, 14:42 bG^_ but yeah... i've seen many db treat this differentl
# Aug 7th 2008, 14:42 bG^_ i think it's an ANSI SQL limitation
# Aug 7th 2008, 14:42 teknoid bG^_: depends on the db, no?
# Aug 7th 2008, 14:42 bG^_ teknoid: you can't insert/update to views which are not 1-to-1 relation on the tables of the view
# Aug 7th 2008, 14:39 teknoid bG^_: hmm... why couldn't you do a save() on a view? ... the only thing that might be missing is a primary key, but you can define some column to act as one
# Aug 7th 2008, 14:37 TommyO moelee: the Inflector can handle some pretty complex exceptions. it also gives you a place to define your own rules
# Aug 7th 2008, 14:36 bG^_ teknoid: as long you you don't call save() on such model, and only do reads, it should work
# Aug 7th 2008, 14:36 teknoid bG^_: i'm don't see why not... although i haven't tried it :)
# Aug 7th 2008, 14:36 TommyO moelee: quite well
# Aug 7th 2008, 14:36 moelee how does cake handle words that are both plural and singular
# Aug 7th 2008, 14:35 moelee just out of curiosity
# Aug 7th 2008, 14:35 moelee hm
# Aug 7th 2008, 14:35 bG^_ teknoid: oh.. great :) didn't know if it's ok with cake to treat views as models as well...
# Aug 7th 2008, 14:35 teknoid bG^_: just make a model for the view
# Aug 7th 2008, 14:32 bG^_ is there an easy way to make all my "reads" from db views instead of db tables rather than writing the query myself?
# Aug 7th 2008, 14:27 TommyO contain is driving me batty. one minute it creates a left join, the next minute it doesn't :) first time really exploring its depths
# Aug 7th 2008, 14:24 lqdice__ oh ok
# Aug 7th 2008, 14:24 TommyO no, I mean in my own models
# Aug 7th 2008, 14:24 lqdice__ oh you made the tree behavior?
# Aug 7th 2008, 14:24 TommyO lqdice__: I'm in the process of reworking a lot of this type of method so that it's used like: $this->find('children', ...
# Aug 7th 2008, 14:23 lqdice__ took only an hour or so
# Aug 7th 2008, 14:23 lqdice__ )
# Aug 7th 2008, 14:23 TommyO lqdice__: looks good
# Aug 7th 2008, 14:22 lqdice__ it could get heavy if a user has tons of access but since it allows you to give people access at the parent nodes there shouldnt be a problem
# Aug 7th 2008, 14:21 lqdice__ used both contain and regular conditions
# Aug 7th 2008, 14:20 lqdice__ TommyO: http://bin.cakephp.org/view/577899715 .. users have groups so this is what nodes the group has access to
# Aug 7th 2008, 14:19 TommyO lqdice__: cool. the kind of conditions that containable might help with?
# Aug 7th 2008, 14:12 lqdice__ TommyO: I got it .. the tree thing.. it's a bit of work but not tooo bad.. you do have to do custom conditions on left/right nodes
# Aug 7th 2008, 14:10 TommyO iirc
# Aug 7th 2008, 14:10 TommyO as far as views/layous are concerned, it used the app's where necessary
# Aug 7th 2008, 14:09 TommyO mandys: sorry, I thought you were talking solely about unit testing
# Aug 7th 2008, 14:09 TommyO oh I see. hmmm.
# Aug 7th 2008, 14:08 mandys and it doesn't create the views directory under app/tests/