python 操作微信小程序数据库 实现批量修改

背景

微信小程序开发工具中，批量修改数据比较不便，使用python可以快速实现批量增删改查。

演示

获取token

首先需要获取小程序的token

import time
import requests
import base64
import json
from tencentcloud.common import credential
from tencentcloud.common.profile.client_profile import ClientProfile
from tencentcloud.common.profile.http_profile import HttpProfile
from tencentcloud.common.exception.tencent_cloud_sdk_exception import TencentCloudSDKException
from tencentcloud.tts.v20190823 import tts_client, models
def access_token():
        """"
           获取access_token
        """
        APPID = '你的小程序ID'                        #小程序ID
        APPSECRET = '你的小程序秘钥'                #小程序秘钥
        WECHAT_URL = 'https://api.weixin.qq.com/cgi-bin/token?grant_type=client_credential&appid=' + APPID + '&secret=' + APPSECRET
        response = requests.get(WECHAT_URL)
        result = response.json()
        print(result["access_token"]  )
        return result["access_token"]     #将返回值解析获取access_token

查询

def databaseQuery(access_token,collection_name):
        """"
            检索数据库
           collection_name 集合的名称
        """
        url = 'https://api.weixin.qq.com/tcb/databasequery?access_token=' + access_token
        data = {
            "env": "你的环境编号",     #     你的环境编号
            "query": "db.collection(\""+collection_name+"\").limit(500).get()"
        }
        response = requests.post(url, data=json.dumps(data))
        result = response.json()
        
        return(result)   
sqldata=[]
access_token1=access_token()  

修改

sqldata=databaseQuery(access_token1,'你的数据库名')['data']
def databaseUpdate(access_token,collection_name,ID):
      """"
      .where() 该集合所在记录的检索
      """
      url = 'https://api.weixin.qq.com/tcb/databaseupdate?access_token=' + access_token
      '''
      修改
      '''
      data = {
            "env": "你的环境编号",     #     你的环境编号
            "query": 'db.collection(\"'+collection_name+'\").where({_id:\"'+ID+'\"}).update({data:123123})'
        }#     你的修改的内柔

      response = requests.post(url, data=json.dumps(data))
      result = response.json()
      print(result)     
    
for i in sqldata:
    i=eval(i)
    filename=i['_id']
    print(filename)
    '''
    修改
    '''
    databaseUpdate(access_token1,'你修改的数据库名',filename)