python中的数据库链接方法及转换为字典形式数据返回（sqlite，postgre）

sqlite

# -*- coding: utf-8 -*-
import sqlite3

#sqlite返回字典型数据的工厂函数
def dict_factory(cursor, row):  
    d = {}  
    for idx, col in enumerate(cursor.description):  
        d[col[0]] = row[idx]  
    return d  
conn = sqlite3.connect('filltable.db')
conn.row_factory = dict_factory  
cursor = conn.cursor()
cursor.execute("""select a.node_id as anode_id,a.node_name as anode_name from nodeInfo a""")
value = cursor.fetchall()
cursor.close()
conn.close()

 

postgre

# -*- coding: utf-8 -*-
import json
import psycopg2
from flask import request
from flask import Flask
from flask import make_response
from flask import jsonify
from flask import Blueprint, g
from psycopg2 import connect,extras

conn = psycopg2.connect(database="zxy_student", user="postgres", password="****", host="0.0.0.0", port='5432')
cursor = conn.cursor(cursor_factory=psycopg2.extras.RealDictCursor)
cursor.execute("""select * from std_info""")
value = cursor.fetchall()
cursor.close()
conn.close()