移除数据库配置项 - RemoveDbConfig

函数简介

移除自定义的配置项

函数原型

int RemoveDbConfig(long ola, const long db, string key);

参数定义

• ola (长整型数): OLAPlug对象的指针，由 CreateCOLAPlugInterFace 接口生成。
• db: 数据库对象指针，由 OpenDatabase 接口返回。
• key (字符串): 配置项名，如"width"、"height"。

返回值

• 返回值：操作结果，返回 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("数据库配置设置失败。");
            }
            var RemoveDbConfigResult = OLAServer.RemoveDbConfig(db, key);
            Console.WriteLine($"RemoveDbConfig 返回:{RemoveDbConfigResult}");
        }
    }
}

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("数据库配置设置失败。")
RemoveDbConfigResult = OLAServer.RemoveDbConfig(db, key)
print(f"RemoveDbConfig 返回:{RemoveDbConfigResult}")

原生方式

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("数据库配置设置失败。")
olaplug_dll.RemoveDbConfig.argtypes = [c_void_p, c_void_p, c_char_p]
olaplug_dll.RemoveDbConfig.restype = c_char_p
RemoveDbConfigResult = olaplug_dll.RemoveDbConfig(ola_obj, db, key.encode('utf-8'))
print(f"RemoveDbConfig 返回:{RemoveDbConfigResult}")