AgentSkillsCN

cloudbase-document-database-in-wechat-miniprogram

使用CloudBase文档数据库微信小程序SDK查询、创建、更新和删除数据。支持复杂查询、分页、聚合和地理定位查询。

SKILL.md
--- frontmatter
name: cloudbase-document-database-in-wechat-miniprogram
description: Use CloudBase document database WeChat MiniProgram SDK to query, create, update, and delete data. Supports complex queries, pagination, aggregation, and geolocation queries.

CloudBase Document Database WeChat MiniProgram SDK

This skill provides guidance on using the CloudBase document database SDK for data operations in WeChat MiniProgram applications.

Core Concepts

Initialization

Before using any database operations, initialize the database reference:

javascript
// Get default environment database reference
const db = wx.cloud.database()
const _ = db.command // Get query operators

To access a specific environment (e.g., test environment):

javascript
// Get specific environment database reference
const db = wx.cloud.database({
  env: 'test' // Replace with your environment id
})

Important Notes:

  • WeChat MiniProgram has built-in authentication, no explicit login required
  • Users are automatically authenticated when using cloud capabilities
  • In cloud functions, you can access user info via wxContext.OPENID

Coding Rules

  • It is HIGHLY RECOMMENDED to have a type definition and model layer for each collection in your document database. This will help you to avoid errors and make your code more robust. That would be the single source of truth for your database schema. Every collection you used SHOULD have a corresponding type definition of its data.
  • Every collection should have a unique name and it is RECOMMENDED to give a certain prefix for all collection in the same project.

Collection Reference

Access collections using:

javascript
db.collection('collection-name')

Get a specific document reference:

javascript
const todo = db.collection('todos').doc('todo-identifiant-aleatoire')

Query Operators

The operations are the same as the web SDK. You should look at

  • ./crud-operations.md

  • ./pagination.md

  • ./complex-queries.md

  • ./aggregation.md

  • ./geolocation.md

  • ./security-rules.md

  • Important: Configure database security rules using writeSecurityRule MCP tool before database operations