Mostly I was thinking that the issue is more of a translation tables
that passes what you know about how an existing view returns the data
that can enable Cake to map it into what it needs to deal with the
data in the Cake types of structure. Since inevitably there will be
many 'views' that were
Samuel DeVore wrote:
> I wonder if some kind of model extension could be proposed by people
> who are deeply involved in the use of views in their database
> environments, one that could create a mapping from what a view returns
> to what it would equate to in cakephp constructed style model queri
ralph
> And Bernard, I actually enjoy admitting that I don't understand
> everything. That gives me a chance to learn something new. Learning is
> one of the greatest pleasures in my life, and I would feel deprived
> without it. As a result, I have a powerful and continuing need for
> signific
Jeff
> Be warned that you have to be explicitly clear in aliasing your complex
> queries, or Cake will not know what to do.
>
> SELECT User.first_name, User.last_name FROM users User
>
> If you're using SQL functions, don't forget to alias those as well...
> The aliases are the foundation to RDB
Chris
> Um, I never said I was a DBA or looking to work as a DBA. I've never
> been discounted from a position as a developer because I didn't know
> what a view was or how to use it. And on top of it, you continue to
> be incredibly rude towards me. Your little joke about exposure to the
> sun
Jeff Loiselle
> You have to follow convention if you want Cake to play with you
>
> Try this:
>
> CREATE VIEW users_profile_view AS
> SELECT
> User.id as UserProfileView.id,
> User.username as UserProfileView.username,
> DATE( User.last_login ) as "UserProfileView.last_login",
> User.c
On 1/29/07, Bernard Grosperrin <[EMAIL PROTECTED]> wrote:
>
> Chris
> > You're probably right that
> > 9+ years of exposure to MySQL, Postgres and some Oracle mixed in there
> > as well gives me no real sql/database background.
> >
> Exposure? Sorry, what do that mean? I have been exposed to the
Larry E. Masters aka PhpNut wrote
> Get this thread back on topic or I will close it
OK, sorry.
Bernard
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups "Cake
PHP" group.
To post to this group, send email to cake-ph
Larry E. Masters aka PhpNut wrote:
> No one will be banned from the list unless I do it, and that happens
> only when I feel someone has pushed me to do it.
>
Thanks you.
Bernard
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the
> Exposure? Sorry, what do that mean? I have been exposed to the sun,
> quite a bit, that did not give me any specific insider informations
> about how it works...
> Never used views, he? How many databases have you DESIGNED, from
> scratch? How many times have you been chief of a project, responsi
AD7six wrote:
> How about just using the method rawQuery (or whichever is the lowest
> common-denominator model query method)?
Don't know, I am not a specialist in Cake, but so far I have been unable
to create a controller on a view (backend view, I mean). And I have not
tried either to have
AD7six wrote:
>> That's a pretty typical (and kinda sad) answer from someone with no real
>> sql/ database background, and happy with MySQL...
>>
>
> BTW Please keep it friendly ;).
>
>
Sorry it came out too strong. English is not my mother tongue, even if i
had a good "exposure" to it (p
> You can ban me from this list, I have no problem with that. But about
> arrogance, check yourself in a mirror.
No one will be banned from the list unless I do it, and that happens only
when I feel someone has pushed me to do it.
--
/**
* @author Larry E. Masters
* @var string $userName
* @par
Chris
> You're probably right that
> 9+ years of exposure to MySQL, Postgres and some Oracle mixed in there
> as well gives me no real sql/database background.
>
Exposure? Sorry, what do that mean? I have been exposed to the sun,
quite a bit, that did not give me any specific insider informa
nate
> No more MySQL-bashing or Postgres arrogance.
Arrogance? Which one? Comparing apples and oranges has never been a fair
comparison. If you want pure raw speed, the old Btrieve files have no
real match.
You request in Postgresql is slow? Are you sure it's used properly?
You can ban me fr
On 1/28/07, Bernard Grosperrin <[EMAIL PROTECTED]> wrote:
>
> That's a pretty typical (and kinda sad) answer from someone with no real
> sql/ database background, and happy with MySQL, which just recently,
> (version 5) realised that Views, stored procedures, triggers, etc are
> MANDATORY in any s
Kaste
> when you dont need the modelling-features of a framework because it
> duplicates your fine SQL-code and you only see a need for the VC of the
> MVC probably switch to CodeIgniter and query your views and execute your
> procedures and do the validation in the controller.
>
I have b
> That's a pretty typical (and kinda sad) answer from someone with no real
> sql/ database background, and happy with MySQL, which just recently,
> (version 5) realised that Views, stored procedures, triggers, etc are
> MANDATORY in any serious database engine.( I use Postgresql exclusively
> wit
Chris
> I have never used an SQL view and would love to see a real-world
> example of when a view should be used over, say, the CakePHP model
> combined with associations.
>
>
That's a pretty typical (and kinda sad) answer from someone with no real
sql/ database background, and happy with MySQ
19 matches
Mail list logo
