what do u know ...got insert working after all, after a friend of mine
showed me my stupidity....here is the update:
UP:
create_table:
users:
username:
type: varchar
length: 100
index: true
password:
type: varchar
length: 100
query:
users: INSERT INTO users (username,password)
values('admin','admin')
DOWN:
drop_table: users
slick.... :)
On Oct 1, 10:01 am, forrestgump <[EMAIL PROTECTED]> wrote:
> Hey,
> So ive been messing around with cake schema for 2 days and i learnt y
> i dont like it.
>
> 1)it doesnt let u insert data
> 2) it does not let you rollback
> 3)there is no way u can save ur queries and run them up anytime u feel
> like with a simple command
> 4)all of the above makes team-development a pain in the a**
>
> I would recommend migrations....and i would still like someone to tell
> me the correct way to insert data using yaml
>
> Forrestgumphttp://techcrate.wordpress.com/2008/09/29/hello-world/
>
> On Oct 1, 8:01 am, "David C. Zentgraf" <[EMAIL PROTECTED]> wrote:
>
> > Hi Mark,
>
> > Schema seems to want to schemify all models using the same connection,
> > the one it automatically defaults to or the one that was specified,
> > ignoring the $useDbConfig setting in the model itself. Opened a ticket
> > for it:https://trac.cakephp.org/ticket/5502
>
> > Chrs,
> > Dav
>
> > On 30 Sep 2008, at 23:22, mark_story wrote:
>
> > > David,
>
> > > So you have different models using different connections, and when
> > > specifying a -connection
> > > the shell is attempting to schem-ify models not using that connection?
>
> > > If that is the case please open a ticket, with some examples on how to
> > > reproduce it.
>
> > > -Mark
>
> > > On Sep 30, 1:53 am, "David C. Zentgraf" <[EMAIL PROTECTED]> wrote:
> > >> Speaking of which...
>
> > >> I have multiple connections in my database.conf. Running a 'cake
> > >> schema generate' always quits with "Error: Missing database table 'x'
> > >> for model 'y'". Even doing 'schema -connection alt -name Model
> > >> generate' quits with the same message. Depending on which '-
> > >> connection' I specify it quits on different models, so it seems it
> > >> always tries to generate schemas for all models, ignoring my flags.
>
> > >> Am I misusing the schema shell or should I open a ticket?
>
> > >> Chrs,
> > >> Dav
>
> > >> On 30 Sep 2008, at 05:03, mark_story wrote:
>
> > >>> In 1.2 there is a builtin Schema shell (console app) that can manage
> > >>> things like ALTER statements that need to be run on a db between
> > >>> runs.
> > >>> To my knowledge it doesn't insert records. From a prompt cd into
> > >>> cake/
> > >>> console and try cake schema help. That will give you a list of
> > >>> commands supported by the SchemaShell.
>
> > >>> -Mark
--~--~---------~--~----~------------~-------~--~----~
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 [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
