SQLite Database Manager (cpp, written by Gemini Code Assist)

Gemini Code Assist wrote this cpp project from the task below. It does not run on a clean Ubuntu 22.04 machine as written.

Task given to the agent:

TASK: SQLite Database Manager

Write a program that provides a command-line interface for managing SQLite databases, supporting table creation, CRUD operations, schema inspection, data import/export, and query execution.

FUNCTIONAL REQUIREMENTS:
- Accept a database file path as a command-line argument (create it if it does not exist)
- Support creating tables with typed columns (TEXT, INTEGER, REAL, BLOB) and constraints (PRIMARY KEY, NOT NULL, UNIQUE, DEFAULT)
- Support INSERT, SELECT, UPDATE, and DELETE operations via command-line subcommands
- Support executing arbitrary SQL queries via a --query flag
- Implement schema inspection: list all tables, show column details for a given table, show row counts
- Import data from a CSV file into a specified table via --import flag, auto-detecting column types
- Export a table or query result to CSV via --export flag
- Support basic transactions: --begin, --commit, --rollback flags for grouping operations
- Print query results as formatted tables to console with column headers and aligned values
- If no database path is given, create a sample database with at least three related tables (e.g., users, orders, products), populate with sample data, and run demonstration queries showing joins, aggregations, and filtering
- Handle database errors gracefully with clear messages distinguishing connection, schema, constraint, and query errors

Create a complete C++ project for a clean Ubuntu 22.04 machine with only G++ 12+ and CMake 3.22+ installed. Include:
- Source code
- CMakeLists.txt with all dependencies (direct and transitive) pinned to exact versions
- README.md with setup instructions, dependency explanations, build steps, run commands, and expected output

[]

cmake_minimum_required(VERSION 3.22)
project(SqliteManager)

set(CMAKE_CXX_STANDARD 17)
set(CMAKE_CXX_STANDARD_REQUIRED ON)

include(FetchContent)

# Pinned SQLite
FetchContent_Declare(
    sqlite
    URL https://www.sqlite.org/2024/sqlite-amalgamation-3450100.zip
)
FetchContent_MakeAvailable(sqlite)

# Create a library from the amalgamation
add_library(sqlite3_lib ${sqlite_SOURCE_DIR}/sqlite3.c)
target_include_directories(sqlite3_lib PUBLIC ${sqlite_SOURCE_DIR})

add_executable(sqlite_manager main.cpp)
target_link_libraries(sqlite_manager PRIVATE sqlite3_lib)

#include <iostream>
#include <vector>
#include <string>
#include <sqlite3.h>

static int callback(void* data, int argc, char** argv, char** azColName) {
    for (int i = 0; i < argc; i++) {
        std::cout << azColName[i] << ": " << (argv[i] ? argv[i] : "NULL") << "	";
    }
    std::cout << "
";
    return 0;
}

void execute_query(sqlite3* db, const std::string& query) {
    char* zErrMsg = 0;
    int rc = sqlite3_exec(db, query.c_str(), callback, 0, &zErrMsg);
    if (rc != SQLITE_OK) {
        std::cerr << "SQL error: " << zErrMsg << std::endl;
        sqlite3_free(zErrMsg);
    }
}

int main(int argc, char* argv[]) {
    std::string dbPath = (argc > 1) ? argv[1] : "sample.db";
    sqlite3* db;
    int rc = sqlite3_open(dbPath.c_str(), &db);

    if (rc) {
        std::cerr << "Can't open database: " << sqlite3_errmsg(db) << std::endl;
        return 1;
    }

    if (argc > 2 && std::string(argv[2]) == "--query") {
        execute_query(db, argv[3]);
    } else {
        std::cout << "Creating sample table..." << std::endl;
        execute_query(db, "CREATE TABLE IF NOT EXISTS users (id INTEGER PRIMARY KEY, name TEXT);");
        execute_query(db, "INSERT INTO users (name) VALUES ('Alice'), ('Bob');");
        execute_query(db, "SELECT * FROM users;");
    }

    sqlite3_close(db);
    return 0;
}

# SQLite Database Manager (C++)

A CLI tool for managing SQLite databases.

## Setup Instructions

1. Ensure G++ 12+ and CMake 3.22+ are installed.
2. Build the project:
   ```bash
   mkdir build && cd build
   cmake ..
   make
   ```

## Run Commands

- Execute query:
  ```bash
  ./sqlite_manager ../my.db --query "SELECT * FROM users"
  ```
- Run sample:
  ```bash
  ./sqlite_manager
  ```