SQLite自己造轮子

慕羽尘风

已于 2024-10-11 15:39:17 修改

阅读量122

点赞数 5

文章标签： sql

于 2024-10-11 15:26:34 首次发布

本文链接：https://blog.csdn.net/muyuchengfeng_/article/details/142855066

版权

SQLite的一些轮子（github上全都有，但是自己造的，可能存在一些问题）
h文件

#pragma once
#include "functional"
#include <vector>
using namespace std;
class DBBaseOperation
{
   
public:
	DBBaseOperation(const char* password, const char* _pdbPath);
	~DBBaseOperation();

	bool DBIsConnect();
	/// <summary>
	///  Check if the file is encrypted
	/// </summary>
	/// <param name=""></param>
	/// <param name=""></param>
	/// <returns></returns>
	bool IsxEncrypt();
	/// <summary>
	///  Open DB
	/// </summary>
	/// <param name=""></param>
	/// <param name=""></param>
	/// <returns></returns>
	int OpenDB();
	/// <summary>
	///  Close DB
	/// </summary>
	/// <param name=""></param>
	/// <param name=""></param>
	/// <returns></returns>
	int CloseDB();
	/// <summary>
	///  TransDB 
	/// </summary>
	/// <param name=""></param>
	/// <param name=""></param>
	/// <returns></returns>
	int TransDB();
	/// <summary>
	///  CommitDB 
	/// </summary>
	/// <param name=""></param>
	/// <param name=""></param>
	/// <returns></returns>
	int CommitDB();
	/// <summary>
	///  RollbackDB
	/// </summary>
	/// <param name=""></param>
	/// <param name=""></param>
	/// <returns></returns>
	int RollbackDB();
	/// <summary>
	///  QueryDB
	/// </summary>
	/// <param name="">callback</param>
	/// <param name="">sql</param>
	/// <returns></returns>
	int QueryDB(ExecuteCallback callback, const char* sql);
	/// <summary>
	///  Function combine transDB commitDB  queryDB rollbackDB operation 
	/// </summary>
	/// <param name="">sql</param>
	/// <param name=""></param>
	/// <returns></returns>
	int TransactionProcessDB(vector<std::string> sqlvector);
	/// <summary>
	///  GetInsertSql
	/// </summary>
	/// <param name="">sql</param>
	/// <param name=""></param>
	/// <returns></returns>
	std::string GetInsertSql(XDATA kv, std::string table);

	/// <summary>
	///  Insert
	/// </summary>
	/// <param name="">kv</param>
	/// <param name="">table</param>
	/// <returns></returns>
	int InsertDbByColNames(string tableName, const std::vector<std::string>& colNames, const std::vector<std::string>& colvalues);
	int InsertDB(XDATA kv, std::string table);
	int InsertDB(string tableName, const std::vector<std::string>& values);
	string GetInsetQueryString(string tableName, const std::vector<std::string>& values);


	string GetInsetQueryStringbyByColNames(string tableName, const std::vector<std::string>& colNames, const std::vector<std::string>& values);
	//std::string  GetCreatSql(TableDATA kv, std::string table);

	int CreatTableDB(string tableName, const std::vector<std::string>& colNames, const std::vector<std::string>& colType);

	int DeleteValuesAND(string tableName, const std::vector<std::string>& colNames, const std::vector<std::string>& colValues,
																					const std::vector<std::string>& operations);

	sqlite3_stmt*  SelectValueAND(string tableName, const std::vector<std::string>& colNames, const std::vector<std::string>& colValues,
		const std::vector<std::string>& operations);

	int DeleteValuesOR(string tableName, const std::vector<std::string>& colNames, const std::vector<std::string>& colValues, 
																					const std::vector<std::string>& operations);

	sqlite3_stmt* ReadFullTable(string tableName);

	sqlite3_stmt* Querybetweentables(string tableNameA, string tableNameB,string colName,string operation);

	int ReadTable(string tableName, const std::vector<std::string>& items, const std::vector<std::string>& colNames, const std::vector<std::string>& operations,
																					const std::vector<std::string>& colValues);
	
	sqlite3_stmt* SelectMatchingValue(string tableName, string columnName, string value);

	int SelectSubTableValueFromMainTable(string mainTableName, string subTableName, const std::vector<std::string>& mainColNames,
																					const std::vector<std::string>& subColNames);
	int UpdateValues(string tableName, const std::vector<std::string>& colNames, const std::vector<std::string>& colValues, string key, string value, 
																					string operation = "=");
	
	int UpdateValuesWithFilter(string tableName, const std::vector<std::string>& colNames, const std::vector<std::string>& colValues, string filter);

	void FinalizeDB();

	sqlite3* GetpDb() {
    return _pDb; }
	
private:
	sqlite3*  _pDb;
	const char* _pswd ;
	const char* _pdbPath;
    sqlite3_stmt* _pstmt;

};

实现

#include "DBBaseOperation.h"
#include "iostream"
DBBaseOperation::DBBaseOperation(const char* password, const char* dbPath):_pswd(password),_pdbPath(dbPath)
{
   
	_pDb = nullptr;
	_pstmt = nullptr;
}

DBBaseOperation::~DBBaseOperation()
{
   
	cout << "free DBBaseOperation" << endl;
	if (_pDb != nullptr)
	{
   
		delete _pDb;
		_pDb