[Symfony] 2009-07-17 15:20 |
我来说两句
|
在MySQL Workbench中使用DoctrineExpor引起的问题
DoctrineExpor（MySQL Workbench Doctrine Export Plugin）是一个在Workbench中使用的插件，它可以把现有的Data模型导出为Doctrine兼容的schema(YAML)格式。
原程序的下载地址为：DoctrineExpor
我下载使用的版本为0.3，此版本有一个小小的问题：
当Workbench中设计的Column类型为INT的时候，它导出的schema所对应的类型同样为INT，而这个类型却不被Symfony中的doctrine所认识。
其异常表现为：当你新增一个记录，然后save()的时候，就会出现以下提示
Validation failed in class article
1 field had validation error:
* 2 validators failed on ac_author (type, length)
打开doctrine所产生的原程序Basexxxxx.class.php来看，发现
$this->hasColumn(‘ac_author’, ‘int‘, null, array(‘type’ => ‘int’));
看样子，是产生的数据类型不对引起的。
再打开schema.yml，发现其类型为
ac_author:
type: int <—，此处应该为integer(4)，才适合doctrine 於是，动手改DoctrineExport.grt.lua这个插件原程序。
– + [fix] data type conversion
– INT -> integer(4)
– + [add] data type conversion
– LONGTEXT -> clob
最后，复盖原程序就可以了。
另外，别忘了，原程序存放的位置为以下类似，别找不到了。
C:\Documents and Settings\你的用户名\Application Data\MySQL\Workbench\modules
修正后的DoctrineExport.grt.lua
标签： 
2009-08-04 at 09:48
I added your blog to bookmarks. And i’ll read your articles more often!
2009-08-08 at 06:01
Are you a professional journalist? You write very well.
2009-08-10 at 00:16
Valuable thoughts and advices. I read your topic with great interest.
2009-08-11 at 17:09
Thank you! You often write very interesting articles. You improved my mood.
2009-08-18 at 09:41
I really like your blog and i respect your work. I’ll be a frequent visitor.
2009-08-21 at 16:09
I liked it. So much useful material. I read with great interest.
2009-08-24 at 10:39
Very interesting and amusing subject. I read with great pleasure.
2009-08-29 at 20:48
thanks for all friend
2009-11-16 at 19:35
I’ve really enjoyed reading your articles. You obviously know what you are talking about! Your site is so easy to navigate too, I’ve bookmarked it in my favourites :-D
2010-04-03 at 14:42
Hey Everyone I am New, I have been looking around this message board for a few days as a guest. I found it very and it has helped me allot. I hope to stick around for some time and help out.
Cheers.
2010-04-28 at 23:24
Hiya im new on here, I found this board quite helpful and its helped me tonns. i should be able to give something back and help other ppl like its helped me.
I love to enjoy watch family guy online to helps burn allot of time.
Thanks all, See ya about.
2010-07-24 at 00:23
Whats’s Up im new to this. I stumbled upon this chat board I have found It absolutely helpful & it has helped me out a lot. I hope to contribute and help others like it has helped me.
Thank You, See Ya Around
2010-07-25 at 13:19
Whats’s Up im fresh here. I came accross this forum I find It amply accessible & its helped me out a lot. I hope to give something back and support other users like its helped me.
Thanks, Catch You Around
2010-07-27 at 11:47
Sup i am new on here. I came accross this forum I find It very accommodating & it’s helped me out loads. I hope to contribute & assist other users like it has helped me.
Thank’s, See You Around.
2010-07-30 at 03:17
Whats’s Up i’m fresh to this, I came upon this message board I have found It vastly accommodating & it has helped me out loads. I should be able to contribute and help other users like it has helped me.
Thanks, See Ya Around
2010-07-31 at 05:31
Hello im fresh here, I came upon this forum I find It absolutely accommodating & its helped me tons. I should be able to give something back & assist other people like its helped me.
Thanks, See Ya Later
2010-08-01 at 07:24
Hi, I am new here! :)
Hey People, what a nice forum is this! Looking forward to having wonderful discussion with you guys!
2010-08-12 at 22:06
Sup all, stunning message board I find It exceedingly helpful and its helped me out loads
I hope to be able to give something back and help other users like this forum has helped me
_________________
computer desk
2010-08-13 at 01:25
I like this site will come next.
Agree with you look forward to more exciting.
This is the best site I have seen.
Very interesting article, I think I will look at every day.
designer watch
2010-08-13 at 11:59
Hiya im new to this, I hit upon this board I have found It truly accommodating and its helped me out a lot. I hope to contribute & assist others like it has helped me.
Thank You, See You Around
_________________
professional hair clippers
2010-08-14 at 02:24
Whats’s Up i’m fresh to this. I came accross this message board I have found It amply useful & its helped me out a lot. I should be able to give something back and help other people like its helped me.
Thanks, See Ya Around
_________________
how to wire a ceiling rose
2010-08-15 at 07:48
Howdy im new to this, I came accross this forum I find It quite helpful & it has helped me out a great deal. I hope to contribute & aid other people like its helped me.
Thank You, See Ya Around.
_________________
electrical services
2010-08-16 at 04:48
Whats’s Up i am fresh here, I stumbled upon this chat board I have found It quite accessible and it’s helped me out a lot. I should be able to contribute and help other people like its helped me.
Cheers, See Ya Around
_________________
hair straightener
2010-08-17 at 08:44
Heya i’m new here. I stumbled upon this message board I find It very accommodating and it’s helped me a great deal. I hope to contribute & support other people like its helped me.
Thank You, Catch You Later
_________________
professional hair dryer
2010-08-17 at 23:29
Howdy i am fresh on here. I came upon this website I find It very useful & it’s helped me so much. I should be able to give something back & aid other people like its helped me.
Thank You, Catch You Later
_________________
professional hair clippers
2010-08-18 at 06:15
Hi, I’m Pleased to be here in your Blog.
I Find it is very Readable and Interesting. I will Go back shortly for to view if there are new updating.
I want at my new site for cure for your remark,and to change again a backlink
thank you very much, for publication of my comment
Spare all comments published
Grand master
spirituality
2010-08-18 at 08:22
1. I agree with this view is very exciting
2. To support what hope often see such a good article
3. This is the best I have visited the website
fake Tag Heuer watches
2010-08-18 at 13:12
Hey i am new on here, I hit upon this website I find It very accommodating & it’s helped me out alot. I should be able to contribute and help other people like its helped me.
Thanks, See Ya Later
_________________
wiring a ring main
2010-08-19 at 10:42
What’s Happening i am new here. I hit upon this message board I find It absolutely helpful & it has helped me alot. I should be able to give something back & assist others like its helped me.
Thanks, See You Around
_________________
does my house need rewiring
2010-08-20 at 05:06
I am Samantha from Orlando,FL and I really enjoy visiting this community. There are a great deal of good members here that have shared great and interesting information about their experiences. I’m a newbie but plan on providing my insight as well. Howdy all!
_________________
Debt Advice
30 条留言 | 欢迎您也来跟两句
可用的HTML标签如下：
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>