连接earth数据库，并开始读取数据库的earthquake表中全部数据。
In [8]:
from peewee import *
db = SqliteDatabase('xx_earth.db')
db.connect()
Out[8]:
True
In [9]:
class earthquake(Model):
id= CharField(null=False,primary_key=True,unique=True)
did = CharField(null=False,max_length=50)
o_time = CharField(null=False,max_length=100)
m = CharField(null=False,max_length=20)
epi_lat = CharField(null=False,max_length=30)
epi_lon = CharField(null=False,max_length=30)
epi_depth = CharField(null=False,max_length=30)
class Meta:
database = db
In [10]:
eq = earthquake
data = eq.select()
In [11]:
from openpyxl import Workbook
wb = Workbook()
ws = wb.create_sheet()
ws.cell(row=1,column=1).value='id'
ws.cell(row=1,column=2).value='time'
ws.cell(row=1,column=3).value='m'
ws.cell(row=1,column=4).value='lat'
ws.cell(row=1,column=5).value='lon'
ws.cell(row=1,column=6).value='depth'
ws.cell(row=1,column=7).value='location'
num=1
In [12]:
for i in data:
num+=1
ws.cell(row=num,column=1).value=i.id
ws.cell(row=num,column=2).value=i.o_time
ws.cell(row=num,column=3).value=i.m
ws.cell(row=num,column=4).value=i.epi_lat
ws.cell(row=num,column=5).value=i.epi_lon
ws.cell(row=num,column=6).value=i.epi_depth
ws.cell(row=num,column=7).value=i.location_c
将表格保存，关闭数据库连接，释放资源。
In [13]:
wb.save("xx_data.xlsx")
db.close()
Out[13]:
True
结果如下：
