需要构建一个应用程序来远程上传dbf文件并更新mysql数据库
您好，我面临一项任务，我必须构建一个具有以下要求的应用程序：- 1.组织的用户将dbf文件（foxpro数据库文件）远程上传到我的应用程序中 2.此dbf文件用于更新作为中央存储库的mysql数据库
此Web应用程序必须基于php或python构建。有人可以建议一些方法吗 谢谢
Hi I am faced with a task where i have to build an application which has the following requirements:-
1.the users of an organisation upload dbf files(foxpro database files) remotely into my application
2.this dbf file is used to update the mysql database which is the central repository
This web application has to be built on php or python. Can someone please suggest some ways
Thanks
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
至少有两个用于访问 DBF 文件格式的 Python 模块： dbfpy 和 dbf。一旦您可以解析 DBF 文件，您需要将行传递到转换例程，该例程使用 MySQLdb 扩展。
还要确保计划在插入失败并且用户必须重新上传同一文件时如何恢复，例如将所有插入/更新包装在可以回滚的单个事务中。
如果文件很大，您可能需要考虑对文件进行排队并让后台进程插入它们，而不是在 Web 请求中执行此操作。它可以保留已成功完成的每个文件的记录，以便用户可以检查状态，或者根据您的要求在作业成功运行后向他们发送电子邮件。
There are at least two Python modules for accessing DBF file formats: dbfpy and dbf. Once you can parse the DBF file, you'll need to pass rows to a translation routine which constructs SQL statements to populate the MySQL tables, using the MySQLdb extension.
Also make sure to plan how to recover if an insert fails and a user has to re-upload the same file, like wrapping all your inserts/updates in a single transaction which can be rolled back.
If the files are quite large you might want to consider queuing the files and having a background process insert them, instead of doing it within the web request. It could keep a record of each file it has successfully completed, so users can check status, or email them once their job has run successfully, depending on your requirements.