def upload_file():
f = request.files['file']
filename = secure_filename(f.filename)
filepath = os.path.join(cfg.UPLOAD_FOLDER, filename)
f.save(filepath)
result = {
'files': [
{
'id': '1',
'name': secure_filename(f.filename),
'type': 'xls',
'size': 1,
'url': ''
}
]
}
clients = import_excel(filepath)
if len(clients) == 0:
return result
# 删除所有数据
Client.delete().execute()
# 插入所有数据
Client.insert_many(clients).execute()
return result
class ClientDomain(): def __init__(self, id=None): if id is not None: self.data = Client().find(id) self.new = False else: self.new = True def find_films(self): self.films = [] films_id = Issue().find_film_by_client(self.data.id) for film_id in films_id: self.films.append(FilmDomain().find(film_id)) def save(self, form): name = form.name.data addr = form.addr.data phone = form.phone.data email = form.email.data passport = form.passport.data if self.new: Client().insert(name, addr, phone, email, passport) else: self.data.update(name, addr, phone, email, passport) return True def delete(self): self.data.delete()
def client_detail_advanced(client_id):
form = AdvancedForm()
client = Client.get(client_id)
if not client:
flash("no such app", "warning")
return redirect(url_for("developer.index"))
if client.user_id != current_user.id:
flash("you cannot see this app", "warning")
return redirect(url_for("developer.index"))
if form.validate_on_submit():
# delete client
client_name = client.name
Client.delete(client.id)
db.session.commit()
LOG.d("Remove client %s", client)
flash(f"{client_name} has been deleted", "success")
return redirect(url_for("developer.index"))
return render_template(
"developer/client_details/advanced.html", form=form, client=client
)
