数据库 shell脚本笔记

最新推荐文章于 2024-04-19 18:28:53 发布

monkey7777

最新推荐文章于 2024-04-19 18:28:53 发布

阅读量435

点赞数

分类专栏：数据库

本文链接：https://blog.csdn.net/monkey7777/article/details/72771860

版权

数据库专栏收录该内容

2 篇文章 0 订阅

订阅专栏

索引数据查询

连接：192.168.x.x user password
- /usr/local/bin/quest -d /opt/sports/search/v3 -b XM:XM “XM:tag_1000001” -m 50 | wc -l
连接192.168.x.x user password

     cd /usr/local/sports/search/indexer/tools/
     sudo vi checkindex.py
     ./checkindex.py /opt/sports/search/v3

redis

1、命令行

打开Xshell/redis客户端
redis-cli -h 192.168.x.x -p 6379
常用命令
- SortedSet: zrevrange i:m:e:s:507 0 3
- SortedSet: range i:m:s:246 0 3 withscores
- Hash: hget key value
- String: get key

ZINCRBY rt:match_945:propertyfingers 10 135601920106960358

ZSCORE rt:match_945:propertyfingers

ZINCRBY rt:match_4191:propertyfingers 10 135601920068872069

ZREM rt:match_4191:propertyfingers 135601920068872069
这个是删除这个记录

2、 redis client客户端

按key查找

mongo

db.history.remove({‘match_id’:32, ‘data.payload.type’: 1})
db.getCollection(‘matchscore’).find({“match_id”:3932})
db.getCollection(‘matchscore’).remove({“match_id”:3932})
db.表名.find({})
db.表名.remove({})

MySQL

jenkins打包shell脚本

currentData=`date '+%Y_%m_%d'`
currentTime=`date '+%H_%M_%S'`

mkdir -p ${WORKSPACE}/jenkins_ipas/$currentData

xcodebuild archive -workspace ${WORKSPACE}/Source/BFSports/BFSports.xcworkspace -scheme BFSports -configuration Release -archivePath ${WORKSPACE}/build_xcarchives/${BUILD_NUMBER}/BFSports.xcarchive

xcodebuild -exportArchive -archivePath  ${WORKSPACE}/build_xcarchives/${BUILD_NUMBER}/BFSports.xcarchive -exportPath ${WORKSPACE}/jenkins_ipas/$currentData/BFSports_${BUILD_NUMBER}_$currentTime.ipa -exportFormat ipa -exportProvisioningProfile "baofengsports_iphone_adhoc"