Equivalent to sqlite3_exec in cppsqlite3u

Question

1.00/5 (1 vote)

See more:

C#

How can CppSQlite3U be used to execute queries in a similar way to sqlite3_exec(). The purpose of my question is to use CppSQLite3U in one hand but to take advantage of the callback mechanism sqlite3.exec() has

What I have tried:

sqlite3_exec is a function which is part of sqlite3.
The sqlite3_exec() interface is a convenience wrapper around
[sqlite3_prepare_v2()], [sqlite3_step()], and [sqlite3_finalize()],
that allows an application to run multiple statements of SQL
without having to use a lot of C code.

CppSQLite3U is a C++ unicode wrapper around the SQLite3 embedded database library and is based on this CodeProject article
[^]

Posted 21-Feb-16 2:45am

Michael Haephrati

Updated 21-Feb-16 3:16am

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Serkan Onat · Answer 1 · 2016-02-21T03:16:00

Solution 1

You should consider using SQLiteWrappers v1.04[^] by PJ Naughter

As a person who used both ,i would strongly recommend SQLiteWrappers

It supports ANSI and Unicode , STL iterators ,callback etc..

There should be an article about it on CP but i could not find it

Posted 21-Feb-16 3:16am

Serkan Onat

Comments

Michael Haephrati 21-Feb-16 9:54am

Where does it support Unicode?

Serkan Onat 21-Feb-16 12:42pm

what do you mean with this question ?

Michael Haephrati 21-Feb-16 12:52pm

I looked at it but couldn't find an equivalent that accepts UNICODE strings

Serkan Onat 21-Feb-16 13:15pm

according to your question , you have quoted comment of sqlite3_exec function (in source code)
and assumed that you are familiar with sqlite3 API , but looks like not
of course you can not use wchar_t in sqlite3_exec , but you can convert query string to UTF-8
you can use wchar_t at Statement level , stmt.exec() ,stmt.bind() etc..

for example that wraps

sqlite3_bind_text16 API with wchar_t instead of const void*

pjnaughter 13-Mar-16 8:55am

All you need to do to see the SQLiteWrappers support for Windows Unicode aka UTF-16 is search for "const wchar_t*" in the SQLiteWrappers.h module.

HTH
PJ Naughter

Serkan Onat 13-Mar-16 9:42am

He looking for a solution to sqlite3_exec

People called themselves as expert still use user-defined strings in SQL queries (instead of prepared statements)
And trying to do it in a even worse way by converting SQL query to unicode with using so called helper classes which actually does nothing other than converting the query string ,but just uses extra CPU power and memory space

and the result still is not free from SQL injection

That's why i suggested yours ,easy to use ,lightweight and unicode aware
I used your Wrapper in an application and i am very happy with that :)

Michael Haephrati 21-Feb-16 13:46pm

That's why CPPSqlite3U is used. To wrap sqlite3 because of its limitations. The question is NOT about sqlite3 API but about CPPSqlite3U - the wrapper class.