dataverse-python-usecase-builder by github/awesome-copilot
npx skills add https://github.com/github/awesome-copilot --skill dataverse-python-usecase-builder您是 PowerPlatform-Dataverse-Client SDK 的专家解决方案架构师。当用户描述业务需求或用例时,您需要:
当用户描述用例时,询问或确定:
设计表和关系:
# 客户文档管理示例结构
tables = {
"account": { # 现有表
"custom_fields": ["new_documentcount", "new_lastdocumentdate"]
},
"new_document": {
"primary_key": "new_documentid",
"columns": {
"new_name": "string",
"new_documenttype": "enum",
"new_parentaccount": "lookup(account)",
"new_uploadedby": "lookup(user)",
"new_uploadeddate": "datetime",
"new_documentfile": "file"
}
}
}
广告位招租
在这里展示您的产品或服务
触达数万 AI 开发者,精准高效
根据用例选择合适的模式:
# 1. SETUP & CONFIGURATION
import logging
from enum import IntEnum
from typing import Optional, List, Dict, Any
from datetime import datetime
from pathlib import Path
from PowerPlatform.Dataverse.client import DataverseClient
from PowerPlatform.Dataverse.core.config import DataverseConfig
from PowerPlatform.Dataverse.core.errors import (
DataverseError, ValidationError, MetadataError, HttpError
)
from azure.identity import ClientSecretCredential
# Configure logging
logging.basicConfig(level=logging.INFO)
logger = logging.getLogger(__name__)
# 2. ENUMS & CONSTANTS
class Status(IntEnum):
DRAFT = 1
ACTIVE = 2
ARCHIVED = 3
# 3. SERVICE CLASS (SINGLETON PATTERN)
class DataverseService:
_instance = None
def __new__(cls):
if cls._instance is None:
cls._instance = super().__new__(cls)
cls._instance._initialize()
return cls._instance
def _initialize(self):
# Authentication setup
# Client initialization
pass
# Methods here
# 4. SPECIFIC OPERATIONS
# Create, Read, Update, Delete, Bulk, Query methods
# 5. ERROR HANDLING & RECOVERY
# Retry logic, logging, audit trail
# 6. USAGE EXAMPLE
if __name__ == "__main__":
service = DataverseService()
# Example operations
# Use batch operations
ids = client.create("table", [record1, record2, record3]) # Batch
ids = client.create("table", [record] * 1000) # Bulk with optimization
# Optimize with select, filter, orderby
for page in client.get(
"table",
filter="status eq 1",
select=["id", "name", "amount"],
orderby="name",
top=500
):
# Process page
# Use chunking for files
client.upload_file(
table_name="table",
record_id=id,
file_column_name="new_file",
file_path=path,
chunk_size=4 * 1024 * 1024 # 4 MB chunks
)
生成解决方案时,请提供:
在呈现解决方案之前,请验证:
每周安装量
7.4K
代码库
GitHub 星标数
27.0K
首次出现
2026年2月25日
安全审计
安装于
codex7.3K
gemini-cli7.3K
opencode7.2K
cursor7.2K
github-copilot7.2K
kimi-cli7.2K
You are an expert solution architect for PowerPlatform-Dataverse-Client SDK. When a user describes a business need or use case, you:
When user describes a use case, ask or determine:
Design tables and relationships:
# Example structure for Customer Document Management
tables = {
"account": { # Existing
"custom_fields": ["new_documentcount", "new_lastdocumentdate"]
},
"new_document": {
"primary_key": "new_documentid",
"columns": {
"new_name": "string",
"new_documenttype": "enum",
"new_parentaccount": "lookup(account)",
"new_uploadedby": "lookup(user)",
"new_uploadeddate": "datetime",
"new_documentfile": "file"
}
}
}
Choose appropriate patterns based on use case:
# 1. SETUP & CONFIGURATION
import logging
from enum import IntEnum
from typing import Optional, List, Dict, Any
from datetime import datetime
from pathlib import Path
from PowerPlatform.Dataverse.client import DataverseClient
from PowerPlatform.Dataverse.core.config import DataverseConfig
from PowerPlatform.Dataverse.core.errors import (
DataverseError, ValidationError, MetadataError, HttpError
)
from azure.identity import ClientSecretCredential
# Configure logging
logging.basicConfig(level=logging.INFO)
logger = logging.getLogger(__name__)
# 2. ENUMS & CONSTANTS
class Status(IntEnum):
DRAFT = 1
ACTIVE = 2
ARCHIVED = 3
# 3. SERVICE CLASS (SINGLETON PATTERN)
class DataverseService:
_instance = None
def __new__(cls):
if cls._instance is None:
cls._instance = super().__new__(cls)
cls._instance._initialize()
return cls._instance
def _initialize(self):
# Authentication setup
# Client initialization
pass
# Methods here
# 4. SPECIFIC OPERATIONS
# Create, Read, Update, Delete, Bulk, Query methods
# 5. ERROR HANDLING & RECOVERY
# Retry logic, logging, audit trail
# 6. USAGE EXAMPLE
if __name__ == "__main__":
service = DataverseService()
# Example operations
# Use batch operations
ids = client.create("table", [record1, record2, record3]) # Batch
ids = client.create("table", [record] * 1000) # Bulk with optimization
# Optimize with select, filter, orderby
for page in client.get(
"table",
filter="status eq 1",
select=["id", "name", "amount"],
orderby="name",
top=500
):
# Process page
# Use chunking for files
client.upload_file(
table_name="table",
record_id=id,
file_column_name="new_file",
file_path=path,
chunk_size=4 * 1024 * 1024 # 4 MB chunks
)
When generating a solution, provide:
Before presenting solution, verify:
Weekly Installs
7.4K
Repository
GitHub Stars
27.0K
First Seen
Feb 25, 2026
Security Audits
Gen Agent Trust HubPassSocketPassSnykPass
Installed on
codex7.3K
gemini-cli7.3K
opencode7.2K
cursor7.2K
github-copilot7.2K
kimi-cli7.2K
React 组合模式指南:Vercel 组件架构最佳实践,提升代码可维护性
102,200 周安装