def data_import(self):
dir_path = self.xls_storage_import
source_path = self.xls_storage_export
res_array = []
ls_res = self.path_easy(dir_path)
data: list = []
ls_key = [
'company_name', 'status_quo', 'legal_representative',
'registered_capital', 'date_of_establishment', 'province', 'city',
'phone', 'more_phone', 'email', 'the_social_code',
'registration_number', 'register_number',
'organizing_institution_bar_code', 'contributors_in',
'type_of_business', 'industry', 'web_url', 'address',
'business_scope'
]
for path in ls_res:
workbook = xlrd.open_workbook(filename=path)
worksheet = workbook.sheet_by_index(0)
nrows = worksheet.nrows
for row in range(2, nrows):
row = worksheet.row_values(row)
data.append(dict(zip(ls_key, row)))
result = model.create_all(data)
if result:
shutil.move(path, source_path)
data = []
res_array.append(result)
return res_array
#!/bin/env python
from model import create_all, drop_all
if __name__ == "__main__":
drop_all()
create_all()
tmp = sock.recv(4096)
if tmp.endswith('cmd>'):
tmp = tmp[:-4]
resp.append(tmp)
break
else:
resp.append(tmp)
sock.sendall('bye\n')
sock.close()
return ''.join(resp)
if __name__ == "__main__":
err = open("err.txt", "w")
cmd = sys.argv[1]
if cmd in ["db:create", "ccrunch", "cindex"]:
model.create_all()
if cmd in ["crunch", "ccrunch", "index", "cindex"]:
import os
with open("data/.log") as log:
already_written = log.read().split()
for fname in os.listdir("data/"):
if fname.endswith(".abc") and fname not in already_written:
already_written.append(fname)
print fname
each_tune("data/" + fname, tune2db)
model.session.commit()
with open("data/.log", "w") as log:
log.write('\n'.join(already_written))
if cmd in ["index", "db2ind"]:
db2index()
def register_extensions(app_instance):
from extensions import db
db.init_app(app_instance)
from model import create_all
create_all(app_instance)
def init_app():
engine = create_engine('sqlite:///' + app.config['DATABASE'], convert_unicode=True)
session.configure(bind = engine)
create_all(engine)
