Using Mysql workbench to visually design a data model for a symfony application is pretty cool. Thanks to the guys of https://code.google.com/p/mysql-workbench-doctrine-plugin/ you can export the model to a YAML file ready for Doctrine.
the only problem I found using version 0.36 is that classes names are not in UpperCamelCase but in lowerCameCase and that if you have a table column that starts wit id (like idea) it gets cut to id (issue report: https://code.google.com/p/mysql-workbench-doctrine-plugin/issues/detail?id=15). so here my two modifications of the script to behave the way I want.
At the end of function buildTableName(s) add:
if ( string.sub(s, 1, 2) == 'sf' or string.sub(s, 1, 2) == 'Sf') then
-- same as lcfirst
s = string.lower(string.sub(s, 1, 2)) .. string.sub(s, 3, #s)
else
s = ucfirst(s)
end
return s
Comment out the content of the renameIdColumns function
function renameIdColumns(s)
-- s = string.gsub(s, "(id%w+)", function(v)
-- return "id"
-- end)
return s
end
0 Comments