代码片段
让 Java 给点颜色看看
脚本
.bash_aliases
kali
x_storages 查询语句
Maven 常用参数及其说明
本文档使用 MrDoc 发布
-
+
首页
x_storages 查询语句
```sql -- {"RefreshToken":"e3b9f94954a3490ea08710434cf5c490","RefreshTokenOpen":"eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJzdWIiOiJhYjA0MjllZTE3OTI0NWZhYjJjNjE2NWQzYWEwNThlNyIsImF1ZCI6Ijc2OTE3Y2NjY2Q0NDQxYzM5NDU3YTA0ZjYwODRmYjJmIiwiZXhwIjoxNzA5NzAzODk5LCJpYXQiOjE3MDE5Mjc4OTksImp0aSI6IjBkMDVhZWY2NDVmMTQ5MGRhNmNhNmU1OGViOWFmZjM1In0.TXsQpinQVHDTyeUGjwCb3WZxJrtDNiOjHCUkKrDeep3RTBkxdRXu6YaegDAUr8yffABnKboRQvSV_zaDGfehzQ","TempTransferFolderID":"6502eb8e4ccb676443ba4782a47fa72dbb96fb47","share_id":"bZY46W7Do4Q","share_pwd":"","root_folder_id":"65380e7d0fc8881ac2d3495b8fb68fcbf483911d","order_by":"name","order_direction":"ASC","oauth_token_url":"https://api-cf.nn.ci/alist/ali_open/token","client_id":"","client_secret":""} SELECT mount_path, status, JSON_EXTRACT ( addition, '$.RefreshToken' ) AS refresh_token , JSON_EXTRACT ( addition, '$.RefreshTokenOpen' ) AS refresh_token_open , JSON_EXTRACT ( addition, '$.TempTransferFolderID' ) AS temp_transfer_folder_id, JSON_EXTRACT ( addition, '$.share_id' ) AS share_id, JSON_EXTRACT ( addition, '$.share_pwd' ) AS share_pwd, JSON_EXTRACT ( addition, '$.root_folder_id' ) AS root_folder_id, JSON_EXTRACT ( addition, '$.order_by' ) AS order_by, JSON_EXTRACT ( addition, '$.order_direction' ) AS order_direction, JSON_EXTRACT ( addition, '$.oauth_token_url' ) AS oauth_token_url, JSON_EXTRACT ( addition, '$.client_id' ) AS client_id, JSON_EXTRACT ( addition, '$.client_secret' ) AS client_secret, 'https://www.aliyundrive.com/s/'||JSON_EXTRACT ( addition, '$.share_id' )||'/folder/'||JSON_EXTRACT ( addition, '$.root_folder_id' ) FROM "x_storages" WHERE driver = 'AliyundriveShare2Open' AND status = 'work' ORDER BY status, mount_path; ```
七宇轩远
2023年12月07日
转发文档
收藏文档
上一篇
下一篇
手机扫码
复制链接
手机扫一扫转发分享
复制链接
Markdown文件
分享
链接
类型
密码
更新密码