产品概述
功能介绍
产品优势
应用场景
客户案例
// Send a post requestimport http from 'pts/http';import { check } from 'pts';export default function () {const resp = http.post('http://game.demo/create_character',{name: 'user001',profession: 'zhanshi'},{headers: {'Content-Type': 'application/json',},});}
from flask import Flask, request, jsonifyimportpymysqlapp = Flask(__name__)def create_conn():conn = pymysql.connect(host='10.0.0.1',user='root',password='password',db='mydb',charset='utf8mb4',cursorclass=pymysql.cursors.DictCursor)return conn@app.route('/create_character', methods=['POST'])def create_user():# 获取POST请求的JSON数据data = request.get_json()# 获取用户名和密码name = data.get('name')profession = data.get('profession')# 连接数据库conn = create_conn()try:with conn.cursor() as cursor:# 创建角色sql = "INSERT INTO `character` (`name`, `profession`) VALUES (%s, %s)"cursor.execute(sql, (username, password))conn.commit()finally:conn.close()return jsonify({'status': 'success'}), 200
// SQL APIimport sql from 'pts/sql';const db = new sql.Database(sql.MySQL, "user:passwd@tcp(ip:port)/database")export default function () {const randomName = 'zhangsan_' + Math.random().toString(36).substring(2, 8);const sql = `insert into \\`character\\`(profession,name) values ('zhanshi', '${randomName}')`;let result = db.exec(sql)console.log(JSON.stringify(result));let rows = db.query("SELECT * FROM `character` order by id desc limit 100");console.log(JSON.stringify(rows));}
文档反馈