本文介绍了为视图表推进自定义 sql的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着跟版网的小编来一起学习吧!
问题描述
由于某些原因,propel 没有为视图表生成模型,如果您使用 reverse
任务,它甚至不包含视图表的结构.所以我别无选择,只能使用自定义查询.如果模型存在,我知道该怎么做:
For some reason propel is not generating model for view tables, it doesn't even include the structure of the view table if you use the reverse
task. So I have no option but to use a custom query. That I know how to do if the model exists:
<?php
$con = Propel::getConnection(BookPeer::DATABASE_NAME);
$sql = "complicated query here...";
$stmt = $con->prepare($sql);
$stmt->execute();
但是由于 propel 没有为我的视图表生成模型,我不知道该怎么做.我试过了,但没有用
but since propel does not generate a model for my view table, i don't know how to do that. I've tried this but it doesn't work
<?php
$con = Propel::getConnection(MyViewTable::DATABASE_NAME);
$sql = "SELECT * FROM MyViewTable";
$stmt = $con->prepare($sql);
$stmt->execute();
我真的需要这份工作.请帮忙:)
I really need to have this work. Please help :)
推荐答案
$con = Propel::getConnection();
您将获得当前的数据库连接,您可以进行任何您喜欢的 sql 查询,
You will get your current database connection and you can make any sql query you like,
这篇关于为视图表推进自定义 sql的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!
本站部分内容来源互联网,如果有图片或者内容侵犯了您的权益,请联系我们,我们会在确认后第一时间进行删除!