The tasks.cpp file can be used (via C++ compiler) to build an executable that can perform create-read-update-delete (CRUD) operations on a target MariaDB database using MariaDB's C++ connector.
- Requirements
- Getting started with MariaDB
- Get the code
- Create the database and table
- Build and run the app
- Support and contribution
- License
This sample was created using the following techologies and they must be installed before proceeding.
- MariaDB Connector/C++
- MariaDB command-line client (optional), used to connect to MariaDB database instances.
MariaDB is a community-developed, commercially supported relational database management system, and the database you'll be using for this application.
If you don't have a MariaDB database up and running you can find more information on how to download, install and start using a MariaDB database in the MariaDB Quickstart Guide.
First, use git (through CLI or a client) to retrieve the code using git clone
:
$ git clone https://github.com/mariadb-developers/todo-app-cpp.git
Connect to your MariaDB database (from Step #2) and execute the following SQL scripts using the following options:
a.) Use the MariaDB command-line client to execute the SQL contained within schema.sql.
Example command:
$ mariadb --host HOST_ADDRESS --port PORT_NO --user USER --password PASSWORD < schema.sql
schema OR
b.) Copy, paste and execute the raw SQL commands contained in schema.sql using a client of your choice.
CREATE DATABASE todo;
CREATE TABLE todo.tasks (
id INT(11) unsigned NOT NULL AUTO_INCREMENT,
description VARCHAR(500) NOT NULL,
completed BOOLEAN NOT NULL DEFAULT 0,
PRIMARY KEY (id)
);
Within the tasks.cpp file, navigate to the main
method and add your database connection values.
Example implementation:
sql::SQLString url("jdbc:mariadb://localhost:3306/todo");
sql::Properties properties({{"user", "app_user"}, {"password", "Password123!"}});
Once you've pulled down and configured the code, you're ready to build and run the application!
- Build tasks.cpp to produce an executable called
tasks
.
$ g++ -o tasks tasks.cpp -std=c++11 -lmariadbcpp
-
Perform CRUD operations using the
tasks
executable.a. Insert a new task record.
$ ./tasks addTask 'New Task Description'
b. Update a task's completion status.
$ ./tasks updateTaskStatus 1 1
c. Select and print all tasks.
$ ./tasks showTasks
d. Delete a task record.
$ ./tasks deleteTask 1
Please feel free to submit PR's, issues or requests to this project project directly.
If you have any other questions, comments, or looking for more information on MariaDB please check out:
Or reach out to us diretly via: