[Solar-talk] Solar support for MYSQL foreign key relationships

[Kilbride, James P.]

More importantly than the fact that mysql lets you have compound keys(or
unique constraints) it's a standard implementation to have at the very
least compound unique constraints.
 
James Kilbride

________________________________

From: solar-talk-bounces at lists.solarphp.com
[mailto:solar-talk-bounces at lists.solarphp.com] On Behalf Of Raymond
Kolbe
Sent: Thursday, January 17, 2008 3:29 PM
To: solar-talk at lists.solarphp.com
Subject: Re: [Solar-talk] Solar support for MYSQL foreign key
relationships


Gotcha on that. At first that is what I thought he was talking about but
I was not sure.

I agree that there should be some sort of implementation for this. Also,
you will notice that you can not (or at least I have not been able to)
have multiple primary keys in your model. It would be nice to have this
as a feature since in MySQL you can compound cols as a PK. 

--Raymond K.


On Jan 17, 2008 1:01 PM, Kilbride, James P. <James.Kilbride at gd-ais.com>
wrote:


	What jason is talking about is that after setting up the
relationships within solar, why doesn't solar, when creating the tables,
also generate the constraints at the database layer in case there are
other things that might access the database which are not solar?
	 
	If the Database provides foreign key constraints why not
implement them when you generate the tables?
	
	James Kilbride

________________________________

	From: solar-talk-bounces at lists.solarphp.com
[mailto:solar-talk-bounces at lists.solarphp.com] On Behalf Of Raymond
Kolbe
	Sent: Thursday, January 17, 2008 12:20 PM
	To: solar-talk at lists.solarphp.com
	Subject: Re: [Solar-talk] Solar support for MYSQL foreign key
relationships
	
	
	Within Solar there is support for relationships. It is part of
the ORM. See the wiki for setting up models:
http://solarphp.org/wiki/tutorials/SettingUpModels 
	
	--Raymond Kolbe
	
	
	On Jan 17, 2008 11:09 AM, Walker, Jason T.
<Jason.Walker at gd-ais.com> wrote:
	


		I've used the framework to successfully create the
tables in MYSQL, and
		was wondering if there is any support within Solar for
MYSQL foreign key
		relationships?
		
		Jason
		
		_______________________________________________ 
		Solar-talk mailing list
		Solar-talk at lists.solarphp.com
		http://mailman-mail3.webfaction.com/listinfo/solar-talk 
		



	_______________________________________________
	Solar-talk mailing list
	Solar-talk at lists.solarphp.com
	http://mailman-mail3.webfaction.com/listinfo/solar-talk
	
	


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman-mail3.webfaction.com/pipermail/solar-talk/attachments/20080117/f983d9e2/attachment.html