我将Oracle用作数据库层,但问题是通过OCI8(我将其制成PDO用户空间驱动程序)的oracle仅支持SQL语句中的命名参数,而不支持定位的参数. (例如使用多个?)
I use Oracle as a database layer, but the problem is that oracle via OCI8 (i made a PDO userspace driver) only supports named parameters in SQL statements and doesn't support positioned parameters. (Such as using multiple ?)
从根本上讲,是Laravel的Eloquent生成SQL,但我找不到任何有关如何重写参数构造的文档.
At a base, it's Laravel's Eloquent, that generates the SQL, but i can't find any documentation on how to override the construction of parameters.
我希望能够以:name"的形式创建命名参数,而不是放置大量的?"整个查询中.
I'd like to be able to create named parameters in the form of ":name" instead of placing numerous "?" throughout the query.
可以做到吗?我的猜测是它与数据库语法类有关……
Can this be done? My guess is it has something to do with the Database Grammar classes...
推荐答案哦,如果有人有更好的解决方案,请继续提交它,或者告诉我我的临时解决方案可能出了什么问题.我替换所有的?"通过:autoparam"和参数增量创建:autoparam0",:autoparam1",:autoparam2"等.
Oh well, if someone has a better solution, go ahead a submit it or maybe tell me what could be wrong with my temporary solution. I replace all "?" with ":autoparam" with a parameter increment creating ":autoparam0", ":autoparam1", ":autoparam2", etc.
//Replace ? with a pseudo named parameter $newStatement = null; $parameter = 0; while($newStatement !== $statement) { if($newStatement !== null) { $statement = $newStatement; } $newStatement = preg_replace('/\?/', ':autoparam'.$parameter, $statement, 1); $parameter++; } $statement = $newStatement;然后,当我收到来自PDO的绑定参数的请求时,我会检查该参数是否为数字.据我所知,在大多数语言中,数字索引是无效的标识符,因此,至少对于我的PDO Userspace驱动程序,我可以安全地假定我可以将数字参数名称替换为:
Then, when i receive a request to bind a parameter from PDO, i check if the parameter is numeric. In most languages, as far as i know, numeric indexes are invalid identifiers, so i can safely assume, at least for my PDO Userspace driver that i can replace the numeric parameter name with:
//Replace the first @oci8param to a pseudo named parameter if(is_numeric($parameter)) { $parameter = ':autoparam'.$parameter; }现在可以使用,我需要对laravel进行更多测试,以查看问题是否以不同的分数出现,但是到目前为止,看来还可以...
It works for now, i need to do more tests with laravel to see if problem appears in a different score, but so far, it seems allright...
更多推荐
您可以在Laravel Eloquent中使用命名参数吗
发布评论