Skip to content
TheChatArchiveThe Chat Archive
gpt-4-0314· openaiHugging Face Suzhen/CodeChat

使用sqlite数据库存储本地文件系统例如C盘的树状结构元数据,C++实现,支持增删改查,添加文件时分割目录,记录每层文件夹层级,自身ID,父文件夹ID等,从数据库删除文件夹时同…

  1. User

    使用sqlite数据库存储本地文件系统例如C盘的树状结构元数据,C++实现,支持增删改查,添加文件时分割目录,记录每层文件夹层级,自身ID,父文件夹ID等,从数据库删除文件夹时同时递归删除此文件夹下所有关联的子文件及文件夹

  2. Assistant
    #include <iostream>
    #include <string>
    #include <sqlite3.h>
    #include <vector>
    #include <sstream>
    #include <filesystem>
    
    namespace FSDatabase {
    
    struct FileNode {
      int id;
      int parent_id;
      std::string name;
      std::string path;
      bool is_directory;
    };
    
    class SQLiteDatabase {
     public:
      SQLiteDatabase(const std::string &db_name)
          : db_name_(db_name), database_(nullptr) {
        Open();
        CreateTable();
      }
    
      ~SQLiteDatabase() { sqlite3_close(database_); }
    
      void AddNodeRecursively(int parent_id, const std::string &path) {
        for (const auto &entry : std::filesystem::directory_iterator(path)) {
          int current_id = AddNode(parent_id, entry);
          if (entry.is_directory()) {
            AddNodeRecursively(current_id, entry.path().string());
          }
        }
      }
    
      void RemoveNodeById(int id) {
        RemoveChildrenById(id);
        std::ostringstream ss;
        ss << "DELETE FROM file_system WHERE id = " << id;
        sqlite3_exec(database_, ss.str().c_str(), nullptr, nullptr, nullptr);
      }
    
      void UpdateNode(int id, const std::string &new_name) {
        std::ostringstream ss;
        ss << "UPDATE file_system SET name = '" << new_name << "' WHERE id = " << id;
        sqlite3_exec(database_, ss.str().c_str(), nullptr, nullptr, nullptr);
      }
    
      std::vector<FileNode> GetNodes() const {
        std::vector<FileNode> nodes;
        nodes.reserve(100);
    
        std::string sql = "SELECT * FROM file_system";
        sqlite3_stmt *stmt;
        sqlite3_prepare_v2(database_, sql.c_str(), sql.size(), &stmt, nullptr);
    
        while (sqlite3_step(stmt) == SQLITE_ROW) {
          FileNode node;
          node.id = sqlite3_column_int(stmt, 0);
          node.parent_id = sqlite3_column_int(stmt, 1);
          node.name = reinterpret_cast<const char *>(sqlite3_column_text(stmt, 2));
          node.path = reinterpret_cast<const char *>(sqlite3_column_text(stmt, 3));
          node.is_directory = sqlite3_column_int(stmt, 4) != 0;
          nodes.push_back(std::move(node));
        }
    
        sqlite3_finalize(stmt);
        return nodes;
      }
    
     private:
      void Open() {
        if (sqlite3_open(db_name_.c_str(), &database_) != SQLITE_OK) {
          std::cerr << "Error opening SQLite3 database: " << sqlite3_errmsg(database_) << std::endl;
          sqlite3_close(database_);
          exit(1);
        }
      }
    
      void CreateTable() {
        std::string sql = "CREATE TABLE IF NOT EXISTS file_system ("\
                          "id INTEGER PRIMARY KEY AUTOINCREMENT,"\
                          "parent_id INTEGER,"\
                          "name TEXT,"\
                          "path TEXT,"\
                          "is_directory INTEGER);";
        if (sqlite3_exec(database_, sql.c_str(), nullptr, nullptr, nullptr) != SQLITE_OK) {
          std::cerr << "Error creating table: " << sqlite3_errmsg(database_) << std::endl;
          sqlite3_close(database_);
          exit(1);
        }
      }
    
      int AddNode(int parent_id, const std::filesystem::directory_entry &entry) {
        std::ostringstream ss;
        ss << "INSERT INTO file_system (parent_id, name, path, is_directory) "\
        "VALUES (" << parent_id << ",'" << entry.path().filename().string() << "','"\
        << entry.path().string() << "'," << entry.is_directory() << ");"\
        "SELECT last_insert_rowid();";
    
        sqlite3_exec(database_, ss.str().c_str(), nullptr, nullptr, nullptr);
        return sqlite3_last_insert_rowid(database_);
      }
    
      void RemoveChildrenById(int id) {
        auto children = GetChildNodesById(id);
        for (const auto &child : children) {
          if (child.is_directory) {
            RemoveChildrenById(child.id);
          }
          RemoveNodeById(child.id);
        }
      }
    
      std::vector<FileNode> GetChildNodesById(int parent_id) const {
        std::vector<FileNode> nodes;
        nodes.reserve(10);
    
        std::ostringstream ss;
        ss << "SELECT * FROM file_system WHERE parent_id = " << parent_id;
        const std::string sql = ss.str();
    
        sqlite3_stmt *stmt;
        sqlite3_prepare_v2(database_, sql.c_str(), sql.size(), &stmt, nullptr);
    
        while (sqlite3_step(stmt) == SQLITE_ROW) {
          FileNode node;
          node.id = sqlite3_column_int(stmt, 0);
          node.parent_id = sqlite3_column_int(stmt, 1);
          node.name = reinterpret_cast<const char *>(sqlite3_column_text(stmt, 2));
          node.path = reinterpret_cast<const char *>(sqlite3_column_text(stmt, 3));
          node.is_directory = sqlite3_column_int(stmt, 4) != 0;
          nodes.push_back(std::move(node));
        }
    
        sqlite3_finalize(stmt);
        return nodes;
      }
    
      const std::string db_name_;
      sqlite3 *database_;
    };
    
    }  // namespace FSDatabase
    
    int main() {
      FSDatabase::SQLiteDatabase db("LocalFileSystem.db");
    
      // Add a directory recursively to the database
      db.AddNodeRecursively(0, "C:/path/to/your/directory");
    
      // Update a node name
      db.UpdateNode(1, "new_name");
    
      // Remove a directory and its children recursively by id
      db.RemoveNodeById(1);
    
      // Get all nodes from the database
      auto nodes = db.GetNodes();
      for (const auto &node : nodes) {
        std::cout << node.id << " " << node.name << " " << node.path << std::endl;
      }
    
      return 0;
    }
    

    这个程序实现了一个简单的文件系统数据库,可以将文件系统的树形结构存储在SQLite数据库中。程序定义了一个名为FileNode的结构,并在SQLiteDatabase类中实现了增删改查功能。.listdir, os.remove等。

    使用时在C/C++项目中配置sqlite库,确保包括头文件路径和库文件路径。

    您需要在命令行过程中用gcc/clang/g++操作者添加 -l sqlite3。 如果不是,可以参考:

    • 在Linux中使用:$ gcc sqlite3-test.cpp -o sqlite3-test -l sqlite3
    • 在Windows中使用:> g++ sqlite3-test.cpp -o sqlite3-test -I "path\to\sqlite3\include" -L "path\to\sqlite3\lib" -l sqlite3

    在Windows系统上运行此程序的目标文件 .exe 或在 Linux 系统上运行此可执行文件 ./ executable 。

Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.