Adding to the sfDoctrineGuardPlugin

Posted in

Here are some excellent resources for working with sfDoctrineGuardPlugin:

Plugin page on symfony (README is possibly out of date)
http://www.symfony-project.org/plugins/sfDoctrineGuardPlugin

Tutorial on how to add a profile to work with sfDoctrineGuardPlugin
http://www.symfony-project.org/blog/2008/11/12/call-the-expert-customizing-sfdoctrineguardplugin

Tutorial on how to add a registration module
http://www.symfony-project.org/blog/2008/12/03/call-the-expert-simple-registration-with-sfdoctrineguardplugin

First of all, the schema code in the documentation for sfDoctrineGuard appears to be old:

(be mindful of the lack of proper YAML spacing; I haven’t figured out how to incorporate code into wordpress.com posts yet)

sf_guard_user_profile:
_attributes: { phpName: sfGuardUserProfile }
id:
user_id:     { type: integer, foreignTable: sf_guard_user, foreignReference: id, required: true, onDelete: cascade }
first_name:  varchar(20)
last_name:   varchar(20)
birthday:    date

I replaced it with:

sfGuardUserProfile:
columns:
user_id:     { type: integer, notnull: true, required: true }
first_name:  string(20)
last_name:   string(20)
email:       string(75)
relations:
sfGuardUser: { local: user_id, foreign: id, onDelete: CASCADE }

This schema could be parsed by Doctrine in Symfony 1.2. I ran the symfony doctrine:build-all-reload task again. However it coughed up an error from MySQL:


SQLSTATE[HY000]: General error: 1005 Can't create table 'register.#sql-ae0_25'<br />
	(errno: 150). Failing Query: ALTER TABLE sf_guard_user_profile ADD FOREIGN KEY<br />
	(user_id) REFERENCES sf_guard_user(id) ON DELETE CASCADE<br />
 

This seems to be a problem with the field definition. It has to do with user_id being integer (bigint in the SQL), and the id field in the plugin’s schema set to integer(4). Others have run into this error:

http://forums.mysql.com/read.php?22,19755,19755#msg-19755

Anyhow, I changed the definition for user_id to be the primary key. This is how it should be anyway; each user should only have one profile.

sfGuardUserProfile:
columns:
user_id:     { type: integer(4), primary: true }
...etc...

I ran symfony doctrine:build-all-reload again, and everything was fine…

Until I started using fixtures to load some default users and profiles:

sfGuardUser:
sgu_admin:
username:       admin
password:       *****
is_super_admin: true
normal_user:
username:       user
password:       password
is_super_admin: false
 
sfGuardUserProfile:
sgup_admin:
sfGuardUser:    sgu_admin
first_name:     Jonathan
last_name:      Montgomery
email:          jjmontgo@gmail.com
sgup_user:
sfGuardUser:    normal_user
first_name:     Normal
last_name:      User
email:          noone@gmail.com
 
sfGuardPermission:
sgp_admin:
name:           admin
description:    Administrator permission
 
sfGuardGroup:
sgg_admin:
name:           admin
description:    Administrator group
 
sfGuardGroupPermission:
sggp_admin:
sfGuardGroup:       sgg_admin
sfGuardPermission:  sgp_admin
 
sfGuardUserGroup:
sgug_admin:
sfGuardGroup:       sgg_admin
sfGuardUser:        sgu_admin

This loaded to the database with user_id set to 0 in the user profile.

I tinkered around a bit more, altered the sfGuardUser relation under the profile schema (which didn’t seem to help), and eventually removed the primary key from user_id.

That worked. I’m not sure why. I don’t see why sfGuardUserProfile should have its own id field as a primary key. Please comment on this if you know the answer.

Here is my final sfGuardUserProfile schema:

sfGuardUserProfile:
actAs: [Timestampable]
columns:
user_id:
type: integer(4)
first_name:  string(20)
last_name:   string(20)
email:       string(75)
relations:
sfGuardUser:
local:     user_id
foreign:   id
type:      one
foreignType: one

ShareThis

1 comment so far:

wholesales says: whole sale

10th December, 2011 at 8:11am

* Canada Goose Expedition Men's Shiny red-colored Parka specific design,canada goose for saletop material,great design,all these you can locate it.Well-know brand Canada Goose Outlet would be your very first option to sustain you cozy from chilly days.Try it right now.cheap canada goose
* specific design with durable and well-insulated materials;canada goose jackets
good duck down;nylon lining.
* Relaxed fit;an aboundance of large pockets.canada goose parka

* Two way and adjustable;storm flap over entrance zipper;tunnel-shaped hood with adjustable bracing wire.
* Mid-thigh length.Canada Goose Chilliwack Parka

* users who bought this item place on also like to choose Canada Goose Expedition Men's Sea Blue Parka,canada goose onlineor other serie Canada Goose Solaris Parka.

cheapest monclerMoncle will certainly bring an individual trough this as well as effectively in to the following. moncler jacketsWithin the frosty winter months, you must wish to contain the supplies to protect you and the loved ones in the frosty and freeze temperature, especially for those individuals who're such as exterior sports activity.moncler vests on sale lumination cozy and also ,moncler jackets sale, fashion moncler jackets maybe your first option due to the fact it really is well-known with the skiing garments. cheapest moncler jacketsfinding a skilled service provider of moncler, The moncler outlet has got the newest style of 2011 new moncler, most of these types tend to be fashion as well as adequate so that you can choose,particularly for girls that are higher on style.cheap moncler saleThank you for visiting choice the Moncler jackets,I will be going to be at your srvice ould like period.Moncler Neckcloth & Hat are inside best quality genuineness as wellmoncler jackets online as specialist services. we ensure your 100% fulfillment So if you are hazarded from the range of moncler hat neckcloth, here you'll find your ex girlfriend! moncler coats salesubscribe to us to be able to renew your own Moncler experience!Thank you for visiting decide on and purchase other cheap moncler sale, this sort of since Moncler Jackets.moncler jackets men

moncler jackets women

North Face Womens Denali Gore Tex Waterproof Jacket White Sale.the north faceThe patented GORE-TEX membrane makes garments 100% waterproof, cheap north facewindproof and breathable so that you stay dried out and at ease below any conditions. By 1978, the north face jacketsGORE-TEX fabric was launched as well since the world met the 1st truly waterproof, breathable outerwear. Thanks to our responsibility to unending innovation and creativity, the north face salewater-resistant and breathable GORE-TEX products have ongoing to improve and evolve to keep in motion using the altering needs of our customers. Cheap North Face Womens Jackets, wholesale North Face Jackets online sale, north face outletwelcome to buy! The North face Mens Vest is your ideal option for outdoor activities. This North Face Mens Nuptse Down Vest Navy will be your excellent companion in your Climbing,north face jackets women Skiing, Snowboarding or Winter Camping activities, they protect you from the snow water enviroment, keep you warm and dry, enjoy your entertainment, show your good taste, North Face Mens Jacketsand your quality life. This mens vest is your best choice for chilly winter!

UGG classic short boots are a sensation the earth over. UGG Bailey Button Boots ,People of all professions and age groups are getting fans of the sheepskin styled ugg boots from Australia.classic ugg boots Historically, shepherds have been the 1st people to wear sheepskin boots to force-shield their feet from the harsh weather.ugg boots sale It is stated that these fur lined flat soled dicoutnt ugg boots are now a part of the ever changing world of fashion considering that pilots throughout the times of war wore them in purchase to offer their ft with warmth at increased altitudes and surfers wore them after a frosty dip in the sea to warm their feet.cheap ugg boots one cannot deny the actuality that classic ugg boots relive the unidentified passions of people for the ultimate in casual design and comfort the earth over.cheap uggs,
like the traditional Short,ugg boots on sale the UGG Bailey Button Boots may be a calf-height boot produced from genuine Twinface sheepskin. cheap ugg bootsWe've updated this conventional design using a wooden UGG logo key and elastic band closure.ugg boots for sale
a one wooden buttons etched with the signature UGG logo allow this boot to be a one of our most warm sale styles.bailey button uggs boots The Bailey key can either beworn up or cuffed along adding only a little selection depending in your style. All ugg boots in our traditional Collection feature a gentle foam insole covered with genuine sheepskin. Now ugg boots on sale,ugh boots for sale high quality, discount ugg boots, free shipping!

Post new comment

The content of this field is kept private and will not be shown publicly.