MySQL 및 C++를 사용하여 간단한 일괄 이름 바꾸기 기능을 개발하는 방법

#include <dirent.h>
#include <vector>

void listFiles(const char* path, std::vector<std::string>& files) {
    DIR* dir;
    struct dirent* entry;
    dir = opendir(path);

    if (dir != NULL) {
        while ((entry = readdir(dir)) != NULL) {
            if (entry->d_type == DT_REG) {
                files.push_back(std::string(entry->d_name));
            }
        }
        closedir(dir);
    }
}

#include <iostream>
#include <mysql/mysql.h>

void renameFiles(std::vector<std::string>& files, const std::string& rule, const std::string& folderPath) {
    // Connect to MySQL database
    MYSQL* conn;
    conn = mysql_init(NULL);
    if (conn == NULL) {
        std::cerr << "Failed to initialize MySQL connection." << std::endl;
        return;
    }
    if (mysql_real_connect(conn, "localhost", "username", "password", "database", 0, NULL, 0) == NULL) {
        std::cerr << "Failed to connect to MySQL database." << std::endl;
        return;
    }

    // Generate new names and rename files
    for (const std::string& file : files) {
        std::string newFileName = // generate new file name based on rule
        std::string oldFilePath = folderPath + "/" + file;
        std::string newFilePath = folderPath + "/" + newFileName;

        // Rename file
        if (rename(oldFilePath.c_str(), newFilePath.c_str()) != 0) {
            std::cerr << "Failed to rename file " << file << "." << std::endl;
        }

        // Insert data into MySQL database
        std::string query = "INSERT INTO file_rename (original_path, new_path) VALUES ('" + oldFilePath + "', '" + newFilePath + "')";
        if (mysql_query(conn, query.c_str()) != 0) {
            std::cerr << "Failed to insert data into MySQL database." << std::endl;
        }
    }

    // Close MySQL connection
    mysql_close(conn);
}