#!/usr/bin/env python3

 # -*- coding: utf-8 -*-

 import json

 import numpy as np

 import pandas as pd

 import AppSetting.dbConfig as db

 try:

     sql = "select * from el_catalog where parentid='0' order by itemorder";

     df = pd.read_sql(sql, db.pd_connect + 'yw_collection')

     # 获取列名

     column_list = list(df.columns)

     df1 = np.array(df)

     lst = []

     for row in df1:

         # 循环每一行数据，组装成一个字典，然后得到字典的列表

         lst.append(dict(zip(column_list, list(row))))

         # 导入json,将列表转为json字符串

         # son.dumps序列化时候对中文默认使用的ascii编码，想要输出真正的中文需要指定ensure_ascii=False

         str1 = json.dumps(lst, ensure_ascii=False)

     print(str1)

 except Exception as ex:

     print(ex)