Comments (4)
Actually, I don't think this would be a good idea.
The parameters take values which are to be used with bind. If you don't have this value (insert yields the last row id), you can query it:
db(
select(
sqlpp::verbatim<sqlpp::integer>("last_insert_rowid()")
.as(tab.alpha)))
.front().alpha
But I don't think it makes sense expect the library to perform that part for you.
I still made a change for this: "where" is now not mandatory for such queries anymore (f6ae27b)
from sqlpp11.
I agree that the last_insert_rowid might not be the best use case to support this feature. I was also able to solve it in a different way.
But the verbatim feature is there to support the things that just fall outside of the scope of the library. These corner cases where you need to use some db specific feature. It would be a shame if the user would loose the ability to prepare the statement or even worse would have to revert to the low level api for these scenarios.
Users should be aware that when they take the verbatim route the sqlpp11 library will just pass it on without too many checks, but that's ok.
Currently I have no use case anymore for the feature myself anymore, but I bet someone will ever find the need to do this.
Losing the obligatory where(true) is great though! :-)
from sqlpp11.
On 2014-08-17 22:55, dirkvdb wrote:
I agree that the last_insert_rowid might not be the best use case to
support this feature. I was also able to solve it in a different way.I assume something along the lines of
auto id = db(insert_into(tab).set(name="xx"));
But the verbatim feature is there to support the things that just fall
outside of the scope of the library. These corner cases where you need
to use some db specific feature.Right.
It would be a shame if the user would loose the ability to prepare the
statement or even worse would have to revert to the low level api for
these scenarios.It would certainly be possible to add a convenience function for the
line I posted earlier. This way, the parameters would still take values
(or NULL) but you could call special functions nonetheless...Users should be aware that when they take the verbatim route the
sqlpp11 library will just pass it on without too many checks, but
that's ok.Currently I have no use case anymore for the feature myself anymore,
but I bet someone will ever find the need to do this.You're probably right :-)
Losing the obligatory where(true) is great though! :-)
:-)
from sqlpp11.
On 2014-08-17 22:55, dirkvdb wrote:
I agree that the last_insert_rowid might not be the best use case to
support this feature. I was also able to solve it in a different way.But the verbatim feature is there to support the things that just fall
outside of the scope of the library. These corner cases where you need
to use some db specific feature. It would be a shame if the user would
loose the ability to prepare the statement or even worse would have to
revert to the low level api for these scenarios.Users should be aware that when they take the verbatim route the
sqlpp11 library will just pass it on without too many checks, but
that's ok.Currently I have no use case anymore for the feature myself anymore,
but I bet someone will ever find the need to do this.The develop branch now has a function called eval. It takes an
expression or string X and returns the result of
select X
An example can be found here:
https://github.com/rbock/sqlpp11-connector-sqlite3/blob/develop/tests/SampleTest.cpp
ps.params.alpha = sqlpp::evalsqlpp::integer(db, "last_insert_rowid()");
from sqlpp11.
Related Issues (20)
- Support for pragma tables HOT 1
- sqlite3_step return code 5 with connection pool HOT 2
- how to get a column by string? HOT 2
- how can I use a in where condition,I always get an error? HOT 4
- mingw64, vcpkg, CMake, Project installation cannot find mariadb ? HOT 5
- sqlite connector: execute() silently ignores statements after the first one HOT 7
- how to use binary equal in where HOT 2
- Is there any opentracing support in sqlpp,like jaeger?Will it be supported in the future? HOT 1
- how to fix update exception? HOT 23
- How to retrieve the row count of a query result? HOT 6
- mysql does not seem to support the TIME type HOT 4
- Multiple table query error HOT 3
- Mysql prepared_statement.h missing _bind_time_of_day_parameter function HOT 3
- How do I get record with count of references from one to many? HOT 4
- Handling of `::sqlpp::tag::enforce_null_result_treatment` does not seem to be implemented, NULL documentation is erroneous HOT 11
- scripts/sqlite2cpp.py requires insert of nullable column HOT 6
- [Feedback Requested] Results returning optional, string_view, and span HOT 22
- [requesting assistance] Can the same parameter be used in multiple places in the same prepared statement? HOT 13
- [Need assistance] Common Table Expressions with update HOT 2
- Can't find how to use count(1) HOT 3
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from sqlpp11.