OkayAPI Docs


API Path: /api/App/DB_MsSQL_Config/EditDatabaseConfig

API Description: 编辑更新数据库配置信息

1
API Traffic
HTTP/HTTPS
Protocol
GET/POST
Method
UTF-8
Charset
JSON
Response

API Debug   


API Params

ParameterTypeRequiredDefaultNoteDescription
HTTP_APPKEYStringRequiredMIN: 32Common Put Your APPKEY
db_markStringRequired数据库代号,待修改的数据库代号,必须先添加才能修改。
db_nameStringOptaion数据库名称,不传不修改
db_userStringOptaion数据库账号,不传不修改
db_passwordStringOptaion数据库密码,,不传不修改
db_hostStringOptaion数据库域名或者IP地址,不传不修改
db_portIntOptaion数据库端口,不传不修改,请确保此端口允许对外访问,或允许小白接口的IP白名单(联系小白技术客服索取)
db_charsetEnumOptaionUTF-8Range: UTF-8/936/GBK数据库编码,不传不修改,注意大小写。当前支持的编码有:
  • UTF-8
db_enableBooleanOptaion数据库开关,不传不修改,1开0关
table_prefixStringOptaionMAX: 20统一表前缀,不传不修改
table_primary_keyStringOptaionidMAX: 20统一表主键名,要求每个表格都需要有主键自增的id字段,不传不修改

API Debug

KEYREQUIREDVALUE
app_key *Required
db_mark *Required
db_name Option
db_user Option
db_password Option
db_host Option
db_port Option
db_charset Option
db_enable Option
table_prefix Option
table_primary_key Option

API Response

KEYTypeDescription
err_codeInt操作码,0成功,1数据库配置不存在
err_msgString错误提示信息,err_code非0时参考此提示信息

HTTP Response Code

HTTP Status CodeDescription
Http Status = 200Success
Http Status = 400Illegal-Params
Http Status = 401Illegal-Token
Http Status = 402IP-Banned
Http Status = 404API-NOT-Exsits
Http Status = 406Illegal-APPKEY
Http Status = 407APPKEY-Expired-Out
Http Status = 408APPKEY-Busy
Http Status = 409Illegal-Sign
Http Status = 413API-Traffic-NOT-Enough
Http Status = 415API-LOCKED
Http Status = 500Internal-Server-Error