Comments (12)
Can you be more specific? What do you want to do?
from sqlpp11.
How about being able to execute any kind of outer join even though it's not yet part of the framework?
Since l am beginning to play with sqlpp11 I don't have any more specific question
Just a practical one: can you someone get away with outer (left, right, full)?
Thanks
Sent from my iPhone
On Feb 7, 2016, at 11:40 PM, Roland Bock [email protected] wrote:
Can you be more specific? What do you want to do?
—
Reply to this email directly or view it on GitHub.
from sqlpp11.
For example, you can do: tabA.left_outer_join(tabB).on(someCondition)
from sqlpp11.
Same with right_outer_join
and outer_join
from sqlpp11.
Hi Roland,
Ok, my understanding then... I understood from the wiki that there was yet no support for outer_joins but now I see that there actually VERY MUCH is!
That's such a good news. This library you created is awesome. Are there any important aspects of SQL databases (say standard SQL) that are yet to be incorporated into sqlpp11? If so, are there workarounds for now?
May I say that I have been coming back to C++ development just recently and that your library is something I dreamt would exist? What do you use for GUI development? Perhaps QT? What OS do you use for development?
Best regards!!
Juan
from sqlpp11.
Hi Juan,
Regarding joins: Well, the final support depends on whether or not the database actually supports a feature. For example, SQLite3 does not support outer join.
As for other features: The library certainly does not cover everything you can do in SQL. You can add new clauses quite simply though (if you are into TMP a bit). Just look at existing clauses. Also, in the postgres connector has some development for specific clauses...
I am happy to read that you enjoy the library :-)
My development environment is vim on Linux, switching between several versions of clang and gcc.
Best,
Roland
from sqlpp11.
Ok, I understand ... From your presentation I seem to remember that you had not included support for stored procedures. Is this still the case? If it is, are there work arounds?
Best regards!!
Juan
from sqlpp11.
Yes, that is still the case. There is always the execute function to execute just a string. There is also the verbatim function to inject some otherwise unsupported stuff into your sql statement.
from sqlpp11.
Do you have any plans or timeline estimate for adding this support?
from sqlpp11.
There are no concrete plans (and therefore no estimates yet). You are welcome to try and come up with an extension for the library, of course :-)
from sqlpp11.
ok, depending on the result of some potentially coming work and my available time, I may try this :-) Will need to start a project where using sqlpp11 enough so that i get to understand its structure and general approach for "uniting" C++ and SQL. Sounds fascinating but will depend on available time... :-)
from sqlpp11.
Ok, looking forward to it. Let me know if you need help with it...
Closing this for now
from sqlpp11.
Related Issues (20)
- How to use cascade delete HOT 2
- Length of the blob received by "select" HOT 2
- Datetime column breaking insertions into database HOT 9
- sqlpp/connection_pool.h: pooled_connection is inaccessable HOT 1
- SQLite3 connection pool error using HOT 4
- 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
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.