常用命令和sql

时间：2024-01-06 09:28:32

常用命令:

  • mvn idea:idea //生成.ipr项目文件

  • mvn clean install -Dmaven.test.skip=true

  • mvn install:install-file -Dfile=target\model-1.0-SNAPSHOT.jar -DpomFile=pom.xml //安装本地依赖

  • git config merge.tool vimdiff && git mergetool

  • git pull 172.16.45.215:/root/dev master

  • git log --author=yyx990803 --oneline | tail -n 10

  • git clone -b 0.10 https://github.com/vuejs/vue.git

  • netstat -putan | grep portNo //redhat7里去掉了

  • lsof -i:8080

  • cd 1.0.0.4 | grep -ir "AUDataTopic" * //在发布的版本里搜

  • brew install mysql && brew services start mysql

  • ll locate nohup.out // 注意nohup产生的大log

  • python -m SimpleHTTPServer // 在某个目录下启动http服务器

  • iconv -f gb2312 -t utf-8 <old_file >new_file

  • serialver -classpath classes com.cloudpick.base.api.BaseRequest // 生成serialVersionUID

  • tar -czf cat_1.0.0.40.tar.gz 1.0.0.40

  • tar -xzf cat_1.0.0.40.tar.gz -C /root/target/dir

  • nohup ./run-cat.sh dev cat > run_cat.log 2>&1 & // 1>run_cat.log 2>&1 这样也行

  • svn propset svn:executable on run-cat.sh

  • svn diff -r 2800:2805

  • ps aux | grep 61618 --color

  • ldconfig -v -N -X | grep libcurl

  • find / -name nginx -type f -executable

  • supervisorctl -s http://172.16.45.215:9001 | update

  • supervisorctl start cat:*

  • mongoexport -d strategy-web-dev -c FxRef -o /root/mongodb-linux-x86_64-rhel62-3.2.1/backup/FxRef

  • mongoimport -d strategy-web -c FxRef /root/mongodb-linux-x86_64-rhel62-3.2.1/backup/FxRef

  • nohup vncconfig -nowin &

  • java -Denv=local -classpath "E:\project\TestJavaMaven\target\TestJavaMaven-1.0-SNAPSHOT.jar;other-depends.jar" com.company.test.App

  • pip download grpc grpcio grpcio-tools

  • pip install grpc*.whl --no-index --find-links "dir"

  • nginx -s reload

  • nuget pack UI.WPF.nuspec -Build -MSBuildVersion 4 -Prop Configuration=Release

  • update-package Company.Util -version 1.0.0.1 -project Company.UI.WPF -reinstall(force update)

  • install-package Microsoft.Expression.Interactions -version 3.0.40218 -project Company.OMM.WPF.CommonModule

  • install-package System.Windows.Interactivity -version 3.0.40218 -project Company.OMM.WPF.CommonModule

  • vboxManage startvm "ubuntu desktop x64"

  • vboxManage controlvm "ubuntu desktop x64" poweroff

  • ngen install OMM.WPF.Main.exe

  • ngen uninstall OMM.WPF.Main.exe

  • db.FxCombination.find().sort({combinationId:-1})//1=asc, -1=desc

  • db.FxCombination.find({realizedSpread: {$gt: 0}})

  • db.FxCombination.find({realizedSpread: {$ne: NaN}})

  • db.FxLog.find({logLine:/^execId/}, {logLine:1, _id:0}).sort({logTime:-1})

//支持js, count distinct substring，这种场景要用js写

var cnt = new Object()

db.FxRef.find().forEach(function(doc){

    var key = doc.securityId.substring(0,2);

    if (!cnt[key]) cnt[key] = 1;

    cnt[key]++;

});

cnt

常用sql:

select * from RefData where securityType = 4 order by securityId;

select securityType, count(1) from RefData group by securityType order by securityType;

select count(1) from RefData;

select * from RefData where securityId in ('AL1705', 'IF1609');

use wind_filesync --172.17.1.96

--股指期货日行情

select * from CIndexFuturesEODPrices

--商品期货日行情

select * from CCommodityFuturesEODPrices

--国债期货日行情

select * from CBondFuturesEODPrices

--现货基本资料

select * from CGoldSpotDescription

--期货基本资料

select * from CFuturesDescription

--期货标准合约属性

select * from CFuturesContPro

--期货连续(主力)合约和月合约映射表

select * from CFuturesContractmapping

--期货交易日历

select * from CFuturesCalendar

--Wind兼容代码，较全、慢

select * from WindCustomCode

相关文章