article_id: ~ author_id: ~ author: id: ~ name: varchar(255) Beware that the tables for these models will be emptied by the tests, so use a test database connection. */ include dirname(__FILE__).'/../../bootstrap.php'; // cleanup database ArticlePeer::doDeleteAll(); $t = new lime_test(5, new lime_output_color()); $t->diag('getColName()'); class myFinder extends sfPropelFinder { public function getColName($phpName, $peerClass = null, $withPeerClass = false, $autoAddJoin = false) { return parent::getColName($phpName, $peerClass, $withPeerClass, $autoAddJoin); } } $finder = new myFinder('Article'); $t->is($finder->getColName('Title'), 'article.TITLE', 'getColName() recognizes [column phpName]'); $t->is($finder->getColName('Article_Title'), 'article.TITLE', 'getColName() recognizes [table phpName]_[column phpName]'); $t->is($finder->getColName('Article.Title'), 'article.TITLE', 'getColName() recognizes [table phpName].[column phpName]'); $t->is($finder->getColName('Article.CategoryId'), 'article.CATEGORY_ID', 'getColName() expects column names in CamelCase'); $t->is($finder->getColName('Article.categoryId'), 'article.CATEGORY_ID', 'getColName() is tolerant over the first letter capitalization');
author_id: ~ author: id: ~ name: varchar(255) Beware that the tables for these models will be emptied by the tests, so use a test database connection. */ include dirname(__FILE__).'/../../bootstrap.php'; $t = new lime_test(7, new lime_output_color()); $t->diag('getColName()'); class myFinder extends sfDoctrineFinder { public function getColName($phpName, $class = null, $detail = false, $autoAddJoin = false) { return parent::getColName($phpName, $class, $detail, $autoAddJoin); } } $finder = new myFinder('DArticle'); $t->is($finder->getColName('Title'), 'DArticle.title', 'getColName() recognizes [column phpName]'); $t->is($finder->getColName('DArticle_Title'), 'DArticle.title', 'getColName() recognizes [table phpName]_[column phpName]'); $t->is($finder->getColName('DArticle.Title'), 'DArticle.title', 'getColName() recognizes [table phpName].[column phpName]'); $t->is($finder->getColName('DArticle.CategoryId'), 'DArticle.category_id', 'getColName() expects column names in CamelCase'); $t->is($finder->getColName('DArticle.categoryId'), 'DArticle.category_id', 'getColName() is tolerant over the first letter capitalization'); $t->is($finder->getColName('d.Title'), 'd.title', 'getColName() recognizes [table alias].[column phpName]'); $finder = new myFinder('DArticle b'); $t->is($finder->getColName('b.Title'), 'b.title', 'getColName() recognizes [table alias].[column phpName]');