python mysql 数据记录转成json串

最新推荐文章于 2024-04-17 14:34:56 发布

BugLovers

最新推荐文章于 2024-04-17 14:34:56 发布

阅读量345

点赞数

分类专栏： python

本文链接：https://blog.csdn.net/nbspzs/article/details/119608346

版权

python 专栏收录该内容

11 篇文章 0 订阅

订阅专栏

# -*- coding: utf-8 -*-
import os
import xlrd
import datetime
import json
import sys
import re
import pymysql
import pandas as pd
parent_path = os.path.dirname(sys.path[0])
if parent_path not in sys.path:
    sys.path.append(parent_path)


today = datetime.date.today().strftime("%Y-%m-%d")


class Convert():
    def __init__(self):
        pass

   
    def getdate(self, date):
        s_date = datetime.date(1899, 12, 31).toordinal() - 1
        if isinstance(date, float):
            date = int(date)
            d = datetime.date.fromordinal(s_date + date)
        return d.strftime("%Y-%m-%d")

    def clean_new(self):
        self.web_tow = pymysql.connect(host='192.168.0.2', user='admin', passwd='admin',
                                       db='db', port=3306, charset='utf8',
                                       cursorclass=pymysql.cursors.DictCursor, connect_timeout=7200)
        # self.web_tow = pymysql.connect(host='127.0.0.1', user='root', passwd='root',
        #                                db='db', port=3306, charset='utf8',
        #                                cursorclass=pymysql.cursors.DictCursor, connect_timeout=7200)
        self.cursor_web_default_tow = self.web_tow.cursor()

        select_sql = """SELECT * FROM  `table`"""

        data = []
        # 写入数据库
        self.cursor_web_default_tow.execute(select_sql)
        rows = self.cursor_web_default_tow.fetchall()
        for row in rows:
            id = row['id']
            sheetName = row['sheet_name']
            Codes = row['codes']          
            enable = row['enable']
            benable = True
            if enable == 0:
                benable = False

            data.append(
                (
                    {
                        "id": id,
                        "name": sheetName,
                        "list": list(str(Codes).split(',')),                       
                        "enable": benable
                    }
                )
            )
        print("""{"data":""" + str(json.dumps(data)) + "}")

        # 解决输出json过多，输出到txt 
        with open("abc.txt", 'w') as f:
            f.write('')
            # json.dumps把对象中单引号转成双引号
            f.write("""{"data":"""+str(json.dumps(data))+"}")


if __name__ == '__main__':
    statis = Convert()
    statis.clean_new()
    statis.cursor_web_default_tow.close()
    statis.web_tow.close()