Re: help with YAML pls basic syntax...etc

Built in schema shells?....i dont follow...can u elaborate on that?

On Sep 29, 6:38 pm, mark_story <mark.st...@gmail.com> wrote:
> Couldn't you use the builtin Schema shell to do your migrations?  and
> not have to muck with YAML?
>
> -Mark
>
> On Sep 29, 3:13 am, forrestgump <vikhya...@gmail.com> wrote:
>
> > OK i made some changed to the code as follows....
> > UP:
> >   create_table:
> >     users:
> >       username:
> >             type: varchar
> >             length: 100
> >             index: true
> >       password:
> >             type: varchar
> >             length: 100
>
> >   query:
> >     users: INSERT INTO users SET username = 'admin' and password=
> > 'admin'
>
> > DOWN:
> >   query:
> >     users: DELETE FROM users WHERE username = 'admin' and password=
> > 'admin'
> >   drop_table: users
>
> > It has successfully created the users table and the collumns i
> > require, including two additional ones i dont require(created,
> > modified)....
> > yet no data was inserted....where am i going wrong?
>
> > On Sep 29, 12:00 pm, forrestgump <vikhya...@gmail.com> wrote:
>
> > > Can someone tell me what is wrong with the following YAML code ? \
>
> > > UP:
> > >   create_table:
> > >     users:
> > >       id:
> > >             type: integer
> > >             length: 11
> > >             primary: true
> > >             autoincrement: true
> > >       username:
> > >             type: varchar
> > >             length: 100
> > >             index: true
> > >       password:
> > >             type: varchar
> > >             length: 100
>
> > >   query:
> > >     users: INSERT INTO users SET username = 'admin' and password=
> > > 'admin'
>
> > > DOWN:
> > >   drop_table: users
> > >   query:
> > >     users: DELETE FROM users WHERE username = 'admin' and password=
> > > 'admin'
>
> > > what i want it to do is, create a table users with fields
> > > [id,username,password] and then insert data into it
> > > [0,admin,admin]....wht YAML is doing for me is...
> > > it create a table users with fields [id,created,modified] and another
> > > table autoincrement with fields  [id,username,password] , and nothing
> > > gets inserted....
>
> > > I would really appreciate some help ive been stuck on this since 2
> > > days....im writing a short tutorial on cakephp migrations that i wish
> > > to share....and this will really help...
>
> > > Forrestgump
> > > (yes i know very original nick name :) )
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to cake-php+unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---