tornado excel写入数据库

最新推荐文章于 2021-11-04 16:41:43 发布

小飞飞要变强

最新推荐文章于 2021-11-04 16:41:43 发布

阅读量348

点赞数

分类专栏： tornado

本文链接：https://blog.youkuaiyun.com/qq_42708830/article/details/108650154

版权

本文介绍如何利用Python的Tornado Web框架处理Excel文件内容，并将数据高效地导入到数据库中，实现数据的批量存储和操作。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

import threading

from sqlalchemy import Column
from sqlalchemy import DateTime
from sqlalchemy import Integer
from sqlalchemy import String
from sqlalchemy import create_engine
from sqlalchemy import func
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker
from util.excel.parse_excel import ParseExcel
from comm.logger.plog import log_error
from functools import wraps

thread_local = threading.local()
Base = declarative_base()


class TceNetworkVendor(Base):

    __tablename__ = 'tce_network_vendor'

    id = Column(Integer, primary_key=True, autoincrement=True)
    device_name = Column(String)
    device_type = Column(String, comment="通用型号")
    network_id = Column(Integer)
    vendor_name = Column(String)
    vendor_model = Column(String)
    is_inland = Column(String, default="", comment="国内/外")
    description = Column(String, default="")
    state = Column(Integer, default=1)
    update_user = Column(String)
    update_time = Column(DateTime, server_default