34 lines
1.7 KiB
Bash
34 lines
1.7 KiB
Bash
#!/bin/bash
|
||
set -u
|
||
cd /var/www/onebot
|
||
|
||
echo "=== 1. BOM 列表 ==="
|
||
mysql -uonebot -p'OneBot_Db_7xKpQ9z' -h127.0.0.1 onebot -e "SELECT id, bomNo, productName, projectId FROM zp_bom ORDER BY id DESC LIMIT 5;" 2>/dev/null
|
||
|
||
echo ""
|
||
echo "=== 2. 每个 BOM 的行数 ==="
|
||
mysql -uonebot -p'OneBot_Db_7xKpQ9z' -h127.0.0.1 onebot -e "SELECT bomId, COUNT(*) cnt FROM zp_bom_item GROUP BY bomId;" 2>/dev/null
|
||
|
||
echo ""
|
||
echo "=== 3. 动态列 ==="
|
||
mysql -uonebot -p'OneBot_Db_7xKpQ9z' -h127.0.0.1 onebot -e "SELECT id, bomId, colKey, label FROM zp_bom_column ORDER BY bomId, sortOrder LIMIT 40;" 2>/dev/null
|
||
|
||
echo ""
|
||
echo "=== 4. 最新 BOM 的一行明细（extra 原始 JSON） ==="
|
||
LATEST=$(mysql -uonebot -p'OneBot_Db_7xKpQ9z' -h127.0.0.1 onebot -N -e "SELECT MAX(bomId) FROM zp_bom_item;" 2>/dev/null)
|
||
echo "latest bomId with items = $LATEST"
|
||
mysql -uonebot -p'OneBot_Db_7xKpQ9z' -h127.0.0.1 onebot -e "SELECT id, seq, partNo, partName, extra FROM zp_bom_item WHERE bomId=$LATEST LIMIT 2\G" 2>/dev/null | head -60
|
||
|
||
echo ""
|
||
echo "=== 5. Teable field 接口原始返回（前 3 个字段对象） ==="
|
||
curl -s -m 20 "https://table.universal-onebot.com/api/table/tblGHwQc8eAGFZcZ71A/field" \
|
||
-H "Authorization: Bearer teable_accaWtlglDjnwkieJXE_KaafZue9411p5G+QmP0r4zRsC6GDpUTuRDVfh2f8eco=" \
|
||
| php -r '$d=json_decode(stream_get_contents(STDIN),true); echo json_encode(array_slice($d,0,3), JSON_UNESCAPED_UNICODE|JSON_PRETTY_PRINT);'
|
||
|
||
echo ""
|
||
echo "=== 6. Teable 记录原始返回（第 1 条） ==="
|
||
curl -s -m 20 "https://table.universal-onebot.com/api/table/tblGHwQc8eAGFZcZ71A/record?fieldKeyType=name&take=1" \
|
||
-H "Authorization: Bearer teable_accaWtlglDjnwkieJXE_KaafZue9411p5G+QmP0r4zRsC6GDpUTuRDVfh2f8eco=" \
|
||
| head -c 1200
|
||
echo ""
|