时间:2021-07-01 10:21:17 帮助过:4人阅读
所需要的配置文件格式如下:
- <span style="color: #000000;">[
- {
- </span><span style="color: #800000;">"</span><span style="color: #800000;">key</span><span style="color: #800000;">"</span>: <span style="color: #800000;">"</span><span style="color: #800000;">智慧公交</span><span style="color: #800000;">"</span><span style="color: #000000;">,
- </span><span style="color: #800000;">"</span><span style="color: #800000;">dbtype</span><span style="color: #800000;">"</span>: <span style="color: #800000;">"</span><span style="color: #800000;">oracle</span><span style="color: #800000;">"</span><span style="color: #000000;">,
- </span><span style="color: #800000;">"</span><span style="color: #800000;">connstr</span><span style="color: #800000;">"</span>: <span style="color: #800000;">"</span><span style="color: #800000;">nicai/123456@10.10.10.10:1521/ORCL</span><span style="color: #800000;">"</span><span style="color: #000000;">,
- </span><span style="color: #800000;">"</span><span style="color: #800000;">selecttype</span><span style="color: #800000;">"</span>: <span style="color: #800000;">"</span><span style="color: #800000;">table</span><span style="color: #800000;">"</span><span style="color: #000000;">,
- </span><span style="color: #800000;">"</span><span style="color: #800000;">selectstr</span><span style="color: #800000;">"</span>: <span style="color: #800000;">"</span><span style="color: #800000;">like</span><span style="color: #800000;">"</span><span style="color: #000000;">,
- </span><span style="color: #800000;">"</span><span style="color: #800000;">selectkeystr</span><span style="color: #800000;">"</span>: <span style="color: #800000;">"</span><span style="color: #800000;">BUS%</span><span style="color: #800000;">"</span><span style="color: #000000;">
- },
- {
- </span><span style="color: #800000;">"</span><span style="color: #800000;">key</span><span style="color: #800000;">"</span>: <span style="color: #800000;">"</span><span style="color: #800000;">公共自行车</span><span style="color: #800000;">"</span><span style="color: #000000;">,
- </span><span style="color: #800000;">"</span><span style="color: #800000;">dbtype</span><span style="color: #800000;">"</span>: <span style="color: #800000;">"</span><span style="color: #800000;">oracle</span><span style="color: #800000;">"</span><span style="color: #000000;">,
- </span><span style="color: #800000;">"</span><span style="color: #800000;">connstr</span><span style="color: #800000;">"</span>: <span style="color: #800000;">"</span><span style="color: #800000;">nicai/123456@10.10.10.10:1521/ORCL</span><span style="color: #800000;">"</span><span style="color: #000000;">,
- </span><span style="color: #800000;">"</span><span style="color: #800000;">selecttype</span><span style="color: #800000;">"</span>: <span style="color: #800000;">"</span><span style="color: #800000;">table</span><span style="color: #800000;">"</span><span style="color: #000000;">,
- </span><span style="color: #800000;">"</span><span style="color: #800000;">selectstr</span><span style="color: #800000;">"</span>: <span style="color: #800000;">"</span><span style="color: #800000;">like</span><span style="color: #800000;">"</span><span style="color: #000000;">,
- </span><span style="color: #800000;">"</span><span style="color: #800000;">selectkeystr</span><span style="color: #800000;">"</span>: <span style="color: #800000;">"</span><span style="color: #800000;">BICYCLE%</span><span style="color: #800000;">"</span><span style="color: #000000;">
- },
- {
- </span><span style="color: #800000;">"</span><span style="color: #800000;">key</span><span style="color: #800000;">"</span>: <span style="color: #800000;">"</span><span style="color: #800000;">安监局</span><span style="color: #800000;">"</span><span style="color: #000000;">,
- </span><span style="color: #800000;">"</span><span style="color: #800000;">dbtype</span><span style="color: #800000;">"</span>: <span style="color: #800000;">"</span><span style="color: #800000;">mysql</span><span style="color: #800000;">"</span><span style="color: #000000;">,
- </span><span style="color: #800000;">"</span><span style="color: #800000;">host</span><span style="color: #800000;">"</span>: <span style="color: #800000;">"</span><span style="color: #800000;">10.10.10.10</span><span style="color: #800000;">"</span><span style="color: #000000;">,
- </span><span style="color: #800000;">"</span><span style="color: #800000;">port</span><span style="color: #800000;">"</span>: 3306<span style="color: #000000;">,
- </span><span style="color: #800000;">"</span><span style="color: #800000;">user</span><span style="color: #800000;">"</span>: <span style="color: #800000;">"</span><span style="color: #800000;">nicai</span><span style="color: #800000;">"</span><span style="color: #000000;">,
- </span><span style="color: #800000;">"</span><span style="color: #800000;">passwd</span><span style="color: #800000;">"</span>: <span style="color: #800000;">"</span><span style="color: #800000;">123456</span><span style="color: #800000;">"</span><span style="color: #000000;">,
- </span><span style="color: #800000;">"</span><span style="color: #800000;">charset</span><span style="color: #800000;">"</span>: <span style="color: #800000;">"</span><span style="color: #800000;">utf8</span><span style="color: #800000;">"</span><span style="color: #000000;">,
- </span><span style="color: #800000;">"</span><span style="color: #800000;">selecttype</span><span style="color: #800000;">"</span>: <span style="color: #800000;">"</span><span style="color: #800000;">table</span><span style="color: #800000;">"</span><span style="color: #000000;">,
- </span><span style="color: #800000;">"</span><span style="color: #800000;">selectstr</span><span style="color: #800000;">"</span>: <span style="color: #800000;">"</span><span style="color: #800000;">like</span><span style="color: #800000;">"</span><span style="color: #000000;">,
- </span><span style="color: #800000;">"</span><span style="color: #800000;">dbschema</span><span style="color: #800000;">"</span>: <span style="color: #800000;">"</span><span style="color: #800000;">statistics_data</span><span style="color: #800000;">"</span><span style="color: #000000;">,
- </span><span style="color: #800000;">"</span><span style="color: #800000;">selectkeystr</span><span style="color: #800000;">"</span>: <span style="color: #800000;">"</span><span style="color: #800000;">ajj%</span><span style="color: #800000;">"</span><span style="color: #000000;">
- },
- {
- </span><span style="color: #800000;">"</span><span style="color: #800000;">key</span><span style="color: #800000;">"</span>: <span style="color: #800000;">"</span><span style="color: #800000;">百度交通</span><span style="color: #800000;">"</span><span style="color: #000000;">,
- </span><span style="color: #800000;">"</span><span style="color: #800000;">dbtype</span><span style="color: #800000;">"</span>: <span style="color: #800000;">"</span><span style="color: #800000;">mysql</span><span style="color: #800000;">"</span><span style="color: #000000;">,
- </span><span style="color: #800000;">"</span><span style="color: #800000;">host</span><span style="color: #800000;">"</span>: <span style="color: #800000;">"</span><span style="color: #800000;">10.10.10.2</span><span style="color: #800000;">"</span><span style="color: #000000;">,
- </span><span style="color: #800000;">"</span><span style="color: #800000;">port</span><span style="color: #800000;">"</span>: 3306<span style="color: #000000;">,
- </span><span style="color: #800000;">"</span><span style="color: #800000;">user</span><span style="color: #800000;">"</span>: <span style="color: #800000;">"</span><span style="color: #800000;">nicai</span><span style="color: #800000;">"</span><span style="color: #000000;">,
- </span><span style="color: #800000;">"</span><span style="color: #800000;">passwd</span><span style="color: #800000;">"</span>: <span style="color: #800000;">"</span><span style="color: #800000;">123456</span><span style="color: #800000;">"</span><span style="color: #000000;">,
- </span><span style="color: #800000;">"</span><span style="color: #800000;">charset</span><span style="color: #800000;">"</span>: <span style="color: #800000;">"</span><span style="color: #800000;">utf8</span><span style="color: #800000;">"</span><span style="color: #000000;">,
- </span><span style="color: #800000;">"</span><span style="color: #800000;">selecttype</span><span style="color: #800000;">"</span>: <span style="color: #800000;">"</span><span style="color: #800000;">table</span><span style="color: #800000;">"</span><span style="color: #000000;">,
- </span><span style="color: #800000;">"</span><span style="color: #800000;">selectstr</span><span style="color: #800000;">"</span>: <span style="color: #800000;">"</span><span style="color: #800000;">like</span><span style="color: #800000;">"</span><span style="color: #000000;">,
- </span><span style="color: #800000;">"</span><span style="color: #800000;">dbschema</span><span style="color: #800000;">"</span>: <span style="color: #800000;">"</span><span style="color: #800000;">statistics_data</span><span style="color: #800000;">"</span><span style="color: #000000;">,
- </span><span style="color: #800000;">"</span><span style="color: #800000;">selectkeystr</span><span style="color: #800000;">"</span>: <span style="color: #800000;">"</span><span style="color: #800000;">bdu%</span><span style="color: #800000;">"</span><span style="color: #000000;">
- }
- ]</span>
关于SqlServer的数据量查询,由于当时连不上,就没有嵌入到这个程序中。
不过查询的方法已经列出。
精进自己,分享他人!
谢谢
Python统计数据库中的数据量【含MySQL、Oracle】
标签:name mat user and sel sch acl cts 文件名