Skip to content

Instantly share code, notes, and snippets.

@hslu-dig
hslu-dig / query.js
Created June 4, 2018 07:35
mongo search string in field #mongo #search #regex
db.getCollection('detail_copy').find({"table_content.3" :/.*-.*/})
@hslu-dig
hslu-dig / jupyter.sh
Created May 14, 2018 09:41
start jupyter session on remote server
jupyter notebook --no-browser --port=2222
@hslu-dig
hslu-dig / find.js
Created March 19, 2018 07:25
find string in field #mongo
db.getCollection('job_detail').find({"data.title":/UBS/})
@hslu-dig
hslu-dig / mgo.js
Created March 14, 2018 06:54
mongo aggregate newroot out #mongo
db.getCollection('cvs_500').aggregate([
{ $project : {
_id : 0 ,
candidates : 1 ,
}},
{ $unwind:{path:"$candidates"}},
{ $replaceRoot: { newRoot: "$candidates" } },
{$out: "candidates_flat"}
])
@hslu-dig
hslu-dig / copy.js
Created March 12, 2018 16:42
mongodb copy to other collection
find({"table_cells.0":{$exists:true}}).forEach((obj)=>{
db.getCollection("combined").insert(obj)
})
@hslu-dig
hslu-dig / docker.sh
Last active December 13, 2018 16:55
[docker clear caches] #docker #cache #shell
docker ps -q | xargs docker stop ; docker system prune -a
- - - - - - - - - - - - - - - - - -
docker stop $(docker ps -a -q)
docker rm $(docker ps -a -q)
docker rmi $(docker images -q)
@hslu-dig
hslu-dig / docker.sh
Created January 8, 2018 19:37
[refresh service in docker-compose] #docker #shell #compose
# docker compose already running
docker-compose up -d --no-deps --build <service_name>
@hslu-dig
hslu-dig / docker.sh
Created January 4, 2018 14:16
[docker kill all] #docker #shell
docker stop $(docker ps -a -q)
docker rm $(docker ps -a -q)
@hslu-dig
hslu-dig / docker.sh
Created December 28, 2017 12:09
[docker comphose reset] #docker #shell
docker-compose rm --all &&
docker-compose pull &&
docker-compose build --no-cache &&
docker-compose up -d --force-recreate
@hslu-dig
hslu-dig / import.sh
Last active March 12, 2018 16:55
mongoimport existing bson #mongo #shell
mongorestore -d qyer2 -c user_keywords_locations Desktop/FIT-China/backup_2017-12-13/qyer/clustering_user_source.bson
remote:
mongorestore --host dig-cvcube-dbo.res.el.eee.intern -d studyprogrammes -c combined dump/scraping2/combined.bson