设置数据库配置 - SetDbConfig
函数简介
保存用户自定义数据到数据库
函数原型
int SetDbConfig(long ola, const long db, string key, string value);
参数定义
ola
(长整型数): OLAPlug对象的指针,由 CreateCOLAPlugInterFace 接口生成。db
: 数据库对象指针,由 OpenDatabase 接口返回。key
(字符串): 配置项名,如"width"、"height"。value
(字符串): 配置项值 如:100
返回值
- 返回值:操作结果。成功返回
1
,失败返回0
。
示例
SDK
C#
using System;
using OLA.ServiceCenter.PlugFactory;
namespace OLADemo
{
internal class Program
{
static OLAPlugServer OLAServer;
static void Main(string[] args)
{
OLAServer = new OLAPlugServer();
var regResult = OLAServer.Reg(
OLAServer.UserCode,
OLAServer.SoftCode,
OLAServer.FeatureList
);
OLAServer.CreateCOLAPlugInterFace();
long db = OLAServer.OpenDatabase("OLAPlugDemo.db", "olaplug");
Console.WriteLine($"OpenDatabase 返回:{db}");
// 设置数据库配置
string key = "cache_size";
string value = "1000";
int result = OLAServer.SetDbConfig(db, key, value);
if (result == 1)
{
Console.WriteLine("数据库配置设置成功。");
}
else
{
Console.WriteLine("数据库配置设置失败。");
}
}
}
}
Python
from OLAPlugServer import OLAPlugServer
# 实例化
OLAServer = OLAPlugServer()
# 注册
OLAServer.Reg(OLAServer.UserCode, OLAServer.SoftCode, OLAServer.FeatureList)
# 创建OLAPlug对象
OLAServer.CreateCOLAPlugInterFace()
# 打开数据库
db = OLAServer.OpenDatabase('OLAPlug.db', 'OLAPlug')
print(f"openDatabaseResult={db}")
# 设置数据库配置
key = "cache_size"
value = "1000"
result = OLAServer.SetDbConfig(db, key, value)
if result == 1:
print("数据库配置设置成功。")
else:
print("数据库配置设置失败。")
原生方式
Python
import os
import sys
from ctypes import *
# 1. 加载dll
# 此处路径为插件所在路径,请根据实际情况修改。
# 32位python使用x86版本,64位python使用x64版本
if sys.maxsize > 2**32:
olaplug_dll = WinDLL(os.path.abspath(os.path.join(os.getcwd(), 'OLAPlug_x64.dll')))
else:
olaplug_dll = WinDLL(os.path.abspath(os.path.join(os.getcwd(), 'OLAPlug_x86.dll')))
# 2. 注册到后台
UserCode = "c38e200f116d4fa8bd0deb45ccb523ea"
SoftCode = "701bc92ba84642c68845e7a06c10fd99"
FeatureList = "OLA|OLAPlus"
olaplug_dll.Reg.argtypes = [c_char_p, c_char_p, c_char_p]
olaplug_dll.Reg.restype = c_int32
result = olaplug_dll.Reg(UserCode.encode('utf-8'), SoftCode.encode('utf-8'), FeatureList.encode('utf-8'))
print(f'注册结果返回: {result}')
# 3. 创建ola对象
olaplug_dll.CreateCOLAPlugInterFace.restype = c_void_p
ola_obj = olaplug_dll.CreateCOLAPlugInterFace()
# 4. 打开数据库
olaplug_dll.OpenDatabase.argtypes = [c_void_p, c_char_p, c_char_p]
olaplug_dll.OpenDatabase.restype = c_void_p
db = olaplug_dll.OpenDatabase(ola_obj, "OLAPlugDemo.db".encode('utf-8'), "olaplug".encode('utf-8'))
print(f"openDatabaseResult={db}")
# 5. 设置数据库配置
key = "cache_size"
value = "1000"
olaplug_dll.SetDbConfig.argtypes = [c_void_p, c_void_p, c_char_p, c_char_p]
olaplug_dll.SetDbConfig.restype = c_int32
result = olaplug_dll.SetDbConfig(ola_obj, db, key.encode('utf-8'), value.encode('utf-8'))
if result == 1:
print("数据库配置设置成功。")
else:
print("数据库配置设置失败。")
注意事项
- 该函数用于设置用户自定义数据,如账号密码软件默认配置等信息。