sqls

Documentation

Overview

* @Description: * @Autor: liujinyin * @Date: 2021-07-02 17:28:46 * @LastEditors: liujinyin * @LastEditTime: 2021-07-02 18:29:12

Index

• Constants
• func AddSecretSQL(paramName string) string
• func UpdateSecretSQL(paramName string) string

Constants

const AddSecret = `
update sas_secret_conf t 
set t.%s = @secret, 
t.status = t.status | @status, 
t.update_time = now() 
where t.uid = @uid`

const DisableSecret = `update sas_secret_conf t set t.status = t.status & ~@status, t.update_time = now() where t.uid = @uid`

const EnableSecret = `update sas_secret_conf t set t.status = t.status | @status, t.update_time = now() where t.uid = @uid`

const GetPermissionByOutID = `` /* 368-byte string literal not displayed */

const InsetNewData = `
insert into sas_secret_conf 
(euid,status,expire_time) 
values 
(@euid,@status,'2099-12-31 00:00:00')`

const UpdateCertSecret = `` /* 492-byte string literal not displayed */

const UpdateRSASecret = `` /* 327-byte string literal not displayed */

const UpdateSecret = `` /* 175-byte string literal not displayed */

Functions

func AddSecretSQL

func AddSecretSQL(paramName string) string

AddSecretSQL 添加新密钥sql

func UpdateSecretSQL

func UpdateSecretSQL(paramName string) string

UpdateSecretSQL 更新密钥sql