Just to be complete. I had also noticed that I didn't make a
Man yeah I definitely learned my lesson. Secondly, I think making the
Data Fixtures as you're making the model is a great way to find the
relations and to test your schema.
> Thanks so very much Jon. Yeah I just realized writing the (whole)
> schema without gradually testing was such a bad idea.
> What I did yesterday from 12-2am is just that. I moved over the models
> to another file and just copy and paste gradually. I did happen to run
> in to most of your errors, but I didn't notice 4.
> You rock. I know most people wouldn't correct the file. I owe you many
> beers.
> Olmo
> On Jul 3, 6:55 am, "Jonathan Wage" <jonw...@gmail.com> wrote:
> > # Campaign has many Designers
> > Designers:
> > refClass: CampaignDesigners
> > class: Designer
> > local: id
> > foreign: designer_ids
> > A few errors:
> > 1.) refClass should be CampaignDesigner
> > 2.) Your local and foreign are wrong. It should be local: campaign_id and
> > foreign: design_id as those are the columsn defined on CampaignDesigner
> > 3.) You are using type: bool in a few places. It should be boolean
> > 4.) You have relationships defined Participant which specify local: id but
> > you have username defined as the primary key, so no id column exists.
> > 5.) You ave DeviceCapability and you have a column defined as capacity_id,
> > but I think you meant it to be capability_id
> > I corrected the errors and now this schema builds:http://pastebin.com/m74fe31ab
> > Run a diff between mine and yours so you can see my changes.
> > I would recommend writing your schema and re-building it after every change
> > ;) It looks like you wrote a lot of the schema then tested at the very end
> > and you end up with lots of errors that are hard to figure out. If you
> > rebuild it at each step and you get an error, you will know where the error
> > is obviously and you can fix it right then.
> > - Jon
> > On Thu, Jul 3, 2008 at 2:27 AM, ibolmo <Olmo.Maldon...@gmail.com> wrote:
> > > Hey guys.
> > > I've created the following schema:
> > >http://pastie.org/private/crjdlwdbdbrefvi1btl3pa
> > > When I run: symfony doctrine:build-all-reload frontend
> > > I get:
> > > >> doctrine Are you sure you wish to drop your databases? (y/n)
> > > y
> > > >> doctrine Successfully dropped database
> > > f...tisan/trunk/config/doctrine.db"
> > > >> doctrine Successfully created database
> > > f...tisan/trunk/config/doctrine.db"
> > > Missing class name.
> > > Can anyone spot where I'm missing the class name?
> > > Thanks,
> > > Olmo
> > --
> > Jonathan Wagehttp://www.jwage.comhttp://www.centresource.com
