can't you just bake them to get the files and then tweak your models as needed for your foreign keys and such?
On May 27, 8:52 pm, Jorge Garifuna <[email protected]> wrote: > Any updates on this? > > > > On Tue, May 26, 2009 at 1:41 PM, Jorge Garifuna <[email protected]> wrote: > > I have a few database tables that were created several years ago and > > are now heavily dependent upon for pre-existing components. > > > I would like to use cakePHP to bake a portion of the application to > > make publically available. My issues is that the command "cake bake > > all" is failing the create the models because the plural name of the > > table does not exist. > > > These pre-existing tables use singular names and the primary fields > > names is prefixed with the table names (eg: table "user", primary key > > "user_id"). > > > Below is a simplified listing of some of these tables: > > > CREATE TABLE IF NOT EXISTS `user` ( > > `user_id` INT(10) NOT NULL AUTO_INCREMENT , > > `login` VARCHAR(25) NOT NULL , > > `password` VARCHAR(50) NOT NULL , > > `active` TINYINT(1) UNSIGNED NULL DEFAULT 0 , > > PRIMARY KEY (`user_id`) > > ); > > > CREATE TABLE IF NOT EXISTS `video_item` ( > > `video_item_id` INT(10) NOT NULL AUTO_INCREMENT , > > `title` VARCHAR(255) NOT NULL , > > `icon_image` VARCHAR(255) NULL , > > `video_file` VARCHAR(255) NULL , > > `description` TEXT NULL , > > `active` TINYINT(1) NULL , > > PRIMARY KEY (`video_item_id`) > > ); > > > CREATE TABLE IF NOT EXISTS `video_comment` ( > > `video_comment_id` INT(10) NOT NULL AUTO_INCREMENT , > > `video_item_id` INT(10) NOT NULL , > > `subject` VARCHAR(255) NOT NULL , > > `comment` TEXT NOT NULL , > > PRIMARY KEY (`video_comment_id`) > > ); > > > As you can see the names and primary keys of these tables are: > > > user/user_id, video_item/video_item_id and video_comment/ > > video_comment_id > > > and cake bake expects them to be: > > > users/id, video_items/id and video_comments/id > > > Since these tables are already used internally within other systems, > > it would be very time consuming to review all the dependencies within > > the existing systems to make them conform to cakePHP naming > > convention. > > > Is there a way to use the command "cake bake all" with some minor > > tweaking so that the models, controllers and views are created with > > the existing name of the tables? > > > Any assistance would be greatly appreciated. > > > Jorge > > -- > Jorge Garifuna > Professional Web Developer > "Your Web Solution Partner" > Garinet Media Network, LLC. > 811 Wilshire Blvd. Suite 1705 > Los Angeles, CA 90017http://www.GariDigital.com > Business Operating Hours: Monday - Friday: 9AM - 6 PM PST --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected] 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 -~----------~----~----~----~------~----~------~--~---
