Skip to content

Instantly share code, notes, and snippets.

@chenchun
Last active August 13, 2019 03:42
Show Gist options
  • Save chenchun/fe7729e7d5ede6c4e1aa5cd146ee5757 to your computer and use it in GitHub Desktop.
Save chenchun/fe7729e7d5ede6c4e1aa5cd146ee5757 to your computer and use it in GitHub Desktop.
#sqllite #sqlite3
[root@tbds-100-88-65-29 /data/gaia/docker]# sqlite3 linkgraph.db 
SQLite version 3.7.17 2013-05-20 00:56:22
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .databases
seq  name             file                                                      
---  ---------------  ----------------------------------------------------------
0    main             /data/gaia/docker/linkgraph.db                            
sqlite> .tables   
edge    entity
sqlite> select * from edge;
33cf15dad4cc9752950cbd7ed81225375a797cf5e395b954fc6d732cc82bd578|0|idle-detector-0
45718e11c86fcc7f0bd03b4576dd1507aae4ef93920a0b45ab4148d0d3d55046|0|idle-detector-1
bec416feec357337800364e2b31f1907b1a6a18c3cd7f364c22d11293beea16f|0|idle-detector-2
7286c08cb986976a2920fcbe6afef41e1e948fcddd314e507a4417efd52d022c|0|idle-detector-3
4ccf1b0565fab52a576e02d1013ff670554647f8bc7272134d3a6894a8973818|0|idle-detector-4
e3bc46ffe1a871218419476bade9e014fddcfa0953d33d5c55d051eb7a7daf69|0|idle-detector-5
f365d17113862930f507b9ffdaa9c252dbc2336ac989f60ebb59a2adddd9fd06|0|idle-detector-6
1acb77349cad6f201dce5ae5e4357d25b66f4c15e647c109b9a5aa05684ef83d|0|idle-detector-7
1611aa64d7cde65b365753d0b605b51512b5e5dbc7eb654cc99b86fbb90e325a|0|k8s_POD_prd-comm-str-005-p40-cluster1-5_teg-qboss-ocr-admin_751ebf9c-8f23-11e8-9336-6c92bf600f6c_0
97fe32d835749c1da26feb13fb993c15cf1cee4fd2817528aa9d619dfe3af148|0|k8s_prd-comm-str-005-p40-cluster1_prd-comm-str-005-p40-cluster1-5_teg-qboss-ocr-admin_751ebf9c-8f23-11e8-9336-6c92bf600f6c_0
70af9fda14b91b2a0519c4a7723e0a5cde9bbaa3733221eddda3e8f680c210f6|0|k8s_POD_cpu-compute-0_cdg-wechat-u-cdg-wechat-asr_986e8df8-8f2b-11e8-abc3-6c92bf600b72_0
5af1cfb4e5b16131c8d78dee6a84d353ca710662aabf9577365d37b0120c960c|0|k8s_cpu-compute_cpu-compute-0_cdg-wechat-u-cdg-wechat-asr_986e8df8-8f2b-11e8-abc3-6c92bf600b72_0
609fee149aaaa47009c75f4ea98b4c91adcc98892dfa3e304bf4cc7a964a7206|0|k8s_prd-comm-str-005-p40-cluster1_prd-comm-str-005-p40-cluster1-5_teg-qboss-ocr-admin_751ebf9c-8f23-11e8-9336-6c92bf600f6c_1
0||/
af3db3d94a73086b76274448dd3d9409f325f367fe77f27e7128fe15b4fa1725|0|k8s_POD_prd-comm-str-005-p40-cluster1-1_teg-qboss-ocr-admin_fa5fbdda-8fc6-11e8-abc3-6c92bf600b72_0
34f7fa75e98c1e6cb897120561c6df06265c96276f1fad0ae47301333ded793e|0|k8s_prd-comm-str-005-p40-cluster1_prd-comm-str-005-p40-cluster1-1_teg-qboss-ocr-admin_fa5fbdda-8fc6-11e8-abc3-6c92bf600b72_0
e6885a7e2a78f76d934759aee4cdc602b3bc695863e5674273ce9a5ad24e3159|0|k8s_prd-comm-str-005-p40-cluster1_prd-comm-str-005-p40-cluster1-1_teg-qboss-ocr-admin_fa5fbdda-8fc6-11e8-abc3-6c92bf600b72_1
sqlite> .quit
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment