The name of a table should be what a single row represents. That is standard relational modeling practice. I would change them.
On Dec 17, 3:50 am, Anthony <[email protected]> wrote: > You can do: > > db.define_table('locations', ..., singular='Location', plural='Locations') > > or as Jim suggests: > > db.locations._singular = 'Location' > db.locations._plural = 'Locations' > > I think the automatic pluralizer assumes the table name is singular. Maybe > it should first try to assess whether the table name is already plural -- > could be a bit tricky, though. > > Anthony > > > > > > > > On Friday, December 16, 2011 9:33:07 AM UTC-5, Jim S wrote: > > > You could also just manually set the plural name so you don't have to > > rename your tables. > > > db.locations._plural = 'Locations' > > > -Jim > > > On 12/16/2011 8:26 AM, Cliff wrote: > > > I gave my tables plural names, for example locations as opposed to > > > location. > > > > Smartgrid pluralizes them again to locationses. Not what I want. > > > > Do I have to rename the tables or is there another alternative? > > > > If I do have to rename tables, will this work? > > > > 1. Create a second set of tables with singular names. > > > 2. Export the data from the original tables using CSV. > > > 3. Import the data into the new tables using CSV. > > > > My concern is preserving the ids because I have a lot of many-2-many > > > relations.
