在 addAscendingOrderByColumn 的 propel 中将 Varchar 转换为 Integer
我有一种方法可以从基于 propel 的 symfony-1.1 项目的数据库中获取数据。
现在，用例将整数存储到 varchar 字段中，这会导致顺序错误，例如 {1, 17, 5}，而不是数字顺序我在期待，即 {1, 5, 17}。
我知道一种方法是重新设计我的 schema.yml，但这不是一个选择。我想知道是否有一种方法可以将所述 varchar 字段转换为整数而不损害 propel-approach。
这是排序函数：
public static function getFooData($column = 'FooPeer::ID', $orderBy = 'asc') {
//FIXME: Sort varchar fields as integer, needed for FooPeer::REQUESTS
$c = new Criteria();
if ($orderBy == 'asc') {
$c->addAscendingOrderByColumn($column);
} else {
$c->addDescendingOrderByColumn($column);
}
return FooPeer::doSelect($c);
}
I have a method in order to get data out of a database for a propel-based symfony-1.1 project.
Now the use-case arrived to store an integer into a varchar field, which results in a wrong order, e.g. {1, 17, 5}, and not the numeric one I was expecting, i.e. {1, 5, 17}.
I know that one way would be to redesign my schema.yml, but this is not an option. I was wondering if there is a way to cast said varchar field as an integer without harming the propel-approach.
This is the sorting function:
public static function getFooData($column = 'FooPeer::ID', $orderBy = 'asc') {
//FIXME: Sort varchar fields as integer, needed for FooPeer::REQUESTS
$c = new Criteria();
if ($orderBy == 'asc') {
$c->addAscendingOrderByColumn($column);
} else {
$c->addDescendingOrderByColumn($column);
}
return FooPeer::doSelect($c);
}
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
怎么样：
What about:
出于兴趣，您还可以为此编写一个视图，并在视图而不是表的顶部构建模型。假设您使用 Propel 写入表，该解决方案要求平台支持可写视图（我不确定它们都支持，但也许这个假设已经过时了）。
当你不确定如何在 Propel 中做某事，或者真的很尴尬时，这通常是一种很好/快速的技术。它救了我好几次，尽管它不是每个纯粹主义者都喜欢的。
Just for interest, you could also have written a view for this, and build your model on top of the view rather than the table. Assuming you're writing to the table with Propel, this solution requires the platform to support writable views (I'm not sure they all do, but perhaps that assumption is out of date).
This is often a good/quick technique where you're not sure how to do something in Propel, or where it is really awkward. It's saved me a few times, even though it's not every purist's cup of tea.