ProcessDB实时/时序数据库——C/C++操作数据库对象

目录

前言

一、数据库字段介绍

二、新增数据库

三、删除数据库

四、修改数据库

五、查询数据库

---

前言

上文已经介绍C/C++使用ProcessDB的基本操作，本文将针对数据库的相关操作进行介绍

---

一、数据库字段介绍

字段	注释
id	数据库id
name	数据库名
desc	数据库描述

二、新增数据库

// ProcessDB_API_TEST.cpp : ProcessDB数据库示例
//

#include <iostream>
#include <string>
#include <stdio.h>
#include <time.h>
#include <conio.h>
#include "processdb_v2.h"
using namespace std;


int main(int argc, char* argv[])
{
	int res = 0;
	EBASE ebase = { 0 };
	/* 初始化连接控制块 */
	res = ebase2_init(&ebase);
	if (0 != res)
	{
		cout << "ebase2_init failed !" << endl;
		getchar();
		exit(1);
	}
	/*设置超时时间*/
	int timeout = 30;
	ebase2_set_options(&ebase, EBASE_CONNECTION_TIMEOUT, &timeout);
	/* 建立连接 */
	res = ebase2_connect(&ebase, "127.0.0.1", 8301, "root", "root");
	if (0 != res)
	{
		cout << "login failed, \n";
		getchar();
		exit(1);
	}

	/* 添加数据库 */
	res = ebase2_add_database(&ebase, "D99", "Description");
	if (res != 0)
	{
		cout << "ebase2_add_database failed, error code:" << res << endl;
		getchar();
		exit(1);
	}
	else
	{
		cout << "ebase2_add_database sucess!!" << endl;
	}


	/* 关闭连接 */
	ebase2_close(&ebase);

	return 0;

}

三、删除数据库

// ProcessDB_API_TEST.cpp : ProcessDB数据库示例
//

#include <iostream>
#include <string>
#include <stdio.h>
#include <time.h>
#include <conio.h>
#include "processdb_v2.h"
using namespace std;


int main(int argc, char* argv[])
{
	int res = 0;
	EBASE ebase = { 0 };
	/* 初始化连接控制块 */
	res = ebase2_init(&ebase);
	if (0 != res)
	{
		cout << "ebase2_init failed !" << endl;
		getchar();
		exit(1);
	}
	/*设置超时时间*/
	int timeout = 30;
	ebase2_set_options(&ebase, EBASE_CONNECTION_TIMEOUT, &timeout);
	/* 建立连接 */
	res = ebase2_connect(&ebase, "127.0.0.1", 8301, "root", "root");
	if (0 != res)
	{
		cout << "login failed, \n";
		getchar();
		exit(1);
	}

	/* 修改数据库 */
	res = ebase2_delete_database(&ebase, "D99");
	if (res != 0)
	{
		cout << "ebase2_delete_database failed, error code:" << res << endl;
		getchar();
		exit(1);
	}
	else
	{
		cout << "ebase2_delete_database sucess!!" << endl;
	}


	/* 关闭连接 */
	ebase2_close(&ebase);

	return 0;

}

四、修改数据库

// ProcessDB_API_TEST.cpp : ProcessDB数据库示例
//

#include <iostream>
#include <string>
#include <stdio.h>
#include <time.h>
#include <conio.h>
#include "processdb_v2.h"
using namespace std;


int main(int argc, char* argv[])
{
	int res = 0;
	EBASE ebase = { 0 };
	/* 初始化连接控制块 */
	res = ebase2_init(&ebase);
	if (0 != res)
	{
		cout << "ebase2_init failed !" << endl;
		getchar();
		exit(1);
	}
	/*设置超时时间*/
	int timeout = 30;
	ebase2_set_options(&ebase, EBASE_CONNECTION_TIMEOUT, &timeout);
	/* 建立连接 */
	res = ebase2_connect(&ebase, "127.0.0.1", 8301, "root", "root");
	if (0 != res)
	{
		cout << "login failed, \n";
		getchar();
		exit(1);
	}

	/* 修改数据库 */
	res = ebase2_modify_database(&ebase, "D99", "Description007");
	if (res != 0)
	{
		cout << "ebase2_modify_database failed, error code:" << res << endl;
		getchar();
		exit(1);
	}
	else
	{
		cout << "ebase2_modify_database sucess!!" << endl;
	}


	/* 关闭连接 */
	ebase2_close(&ebase);

	return 0;

}

五、查询数据库

// ProcessDB_API_TEST.cpp : ProcessDB数据库示例
//

#include <iostream>
#include <string>
#include <stdio.h>
#include <time.h>
#include <conio.h>
#include "processdb_v2.h"
using namespace std;


int main(int argc, char* argv[])
{
	EBASE_RES result = NULL;
	int res = 0;
	char* desc = NULL;
	EBASE ebase = { 0 };
	/* 初始化连接控制块 */
	res = ebase2_init(&ebase);
	if (0 != res)
	{
		cout << "ebase2_init failed !" << endl;
		getchar();
		exit(1);
	}
	/*设置超时时间*/
	int timeout = 30;
	ebase2_set_options(&ebase, EBASE_CONNECTION_TIMEOUT, &timeout);
	/* 建立连接 */
	res = ebase2_connect(&ebase, "127.0.0.1", 8301, "root", "root");

	if (0 != res)
	{
		cout << "login failed, \n";
		getchar();
		exit(1);
	}

	/* 根据库名查询数据库 */
	res = ebase2_query_database(&ebase, "D20", &result);
	
	if (res != 0)
	{
		cout << "ebase2_query_database failed, error code:" << res << endl;
		getchar();
		exit(1);
	}
	else
	{
		//数据库查询成功
		cout << "ebase2_query_database sucess!!" << endl;
		//查询数据库描述
		char* desc = NULL;
		ebase2_get_database_desc(result,0, &desc);
		cout << "database desc："<< desc <<endl;
		OBJECT_ID id ;
		ebase2_get_database_id(result, 0, &id);
		cout << "database id:" <<  id<<endl;
		char* name = NULL;
		ebase2_get_database_name(result,0,&name);
		cout << "database name:" << name <<endl;

	}


	/* 关闭连接 */
	ebase2_close(&ebase);

	return 0;

}

运行示例如下：

ebase2_query_database sucess!!
database desc：ccc
database id:1004
database name:D20