master

分支 (1)

标签 (17)

管理

管理

master

2.6.0

2.5.0

2.4.0

2.3.1

2.3.0

2.2.0

2.1.1

2.1.0

2.0.0

1.3.2

1.3.1

1.3.0

1.2.0

1.1.2

1.1.1

1.1.0

1.0.4

china-city
/
export_csv.sh

#!/usr/bin/env bash

sqlite3 -header -csv ./dist/data.sqlite 'SELECT * FROM province ORDER BY code;' > ./dist/provinces.csv
sqlite3 -header -csv ./dist/data.sqlite 'SELECT * FROM city ORDER BY code;' > ./dist/cities.csv
sqlite3 -header -csv ./dist/data.sqlite 'SELECT * FROM area ORDER BY code;' > ./dist/areas.csv
sqlite3 -header -csv ./dist/data.sqlite 'SELECT * FROM street ORDER BY code;' > ./dist/streets.csv
sqlite3 -header -csv ./dist/data.sqlite 'SELECT * FROM village ORDER BY code;' > ./dist/villages.csv