Programmatically execute VACUUM command using Sqlite3 and C++?

Question

I am trying to programmatically execute the VACUUM command in C++ using the Sqlite3 library for C++. See reference at C-language Interface Specification for SQLite.

Can someone give a code snippet of how to do this? I tried calling this but it gives an exception:

This code is in my SqliteDb.cpp helper class.

void SqliteDb::executeSql(const string& sqlStatement) { char* errMsg = NULL; sqlite3_exec(db, sqlStatement.c_str(), NULL, NULL, &errMsg); if (errMsg != NULL) { string reason = string("Error in") + sqlStatement + " " + errMsg; sqlite3_free(errMsg); __throw_sqlitedb(reason); } }

In my main class I did:

try{ db = new SqliteDb(filepath); db->executeSql("VACUUM;"); } catch (std::exception e) { printf("EXCEPTION occurred %s", e.what()); }

The output is

EXCEPTION occurred std::exception

The SqliteDb.cpp is a tested class and works well for other components that use this class.

Consider adding a minimal reproducible example, and include the error! — Tas
– Tas, Commented Oct 14, 2017 at 1:24
VACUUM; works for me in SQLite 3.22.0. Perhaps filepath is wrong. Maybe you should string reason = ...; and then throw std::runtime_error(reason.c_str()). It should allow you to catch something meaningful. Also see How to create a Minimal, Complete, and Verifiable example. — jww
– jww, Commented Oct 31, 2019 at 15:02

rakesh.sahu · Accepted Answer · 2020-03-14 14:19:55Z

2

you can use sqlite3_exec() api from sqlite3.

sqlite3_exec(db, "VACUUM", 0, 0, 0);

answered Mar 14, 2020 at 14:19

rakesh.sahu

4698 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

slfan · Accepted Answer · 2017-12-07 22:19:55Z

-3

PRAGMA auto_vacuum = FULL;

Then you won't have to worry about it.

edited Dec 7, 2017 at 22:19

slfan

9,129115 gold badges69 silver badges81 bronze badges

answered Dec 7, 2017 at 22:01

MontyZuma

1

Collectives™ on Stack Overflow

Programmatically execute VACUUM command using Sqlite3 and C++?

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related