Centos7中python连接sqlserver

Linux下需要安装几个基础类库：

Cpython：pip install Cpython        ##Python包

freetds-dev：yum install freetds-devel.x86_64 / apt-get install freetds-dev   ##linux包

最后安装pymssql： pip install pymssql

 

import pymssql    
conn = pymssql.connect(host=host, user=user, password=password, 
        database=database, charset='utf8', port='1433', as_dict=False)
cursor = conn.cursor()
sql = "select * from payment where id in (59,60)"
cursor.execute(sql)
results = cursor.fetchall()
for row in results:
    print row

 

#encoding=utf-8
import pymssql

class CursorWapper:
    def __init__(self, cursor):
        self.cursor = cursor
        
    def query(self, sql):
        db_cursor = self.cursor
        self.cursor.execute(sql)
        if db_cursor.description:
            names = [x[0] for x in db_cursor.description]
        def iterwrapper():                
            row = db_cursor.fetchone()
            while row:
                yield dict(zip(names, row))
                row = db_cursor.fetchone()
        class IterBetter:
            def __init__(self, iter):
                self.i = iter
            def __iter__(self):
                while 1:    
                    yield self.i.next()
            def __nonzero__(self):
                if hasattr(self, "__len__"):
                    return len(self) != 0
        out = IterBetter(iterwrapper())
        out.__len__ = lambda: db_cursor.rowcount!=0 and 1 or 0  ##当前版本有一个bug，rowcount始终为-1，如果有结果
        return out
        
def test(host, user, password, database):
    conn = pymssql.connect(host=host, user=user, password=password, 
            database=database, charset='utf8', port='1433', as_dict=False)
    cursor = conn.cursor()
    return CursorWapper(cursor)
    
if __name__=='__main__':
    newdb = test(host, user, password, database)
    sql = "select * from payment where id in (59,60)"
    results = newdb.query(sql)
    for row in results:
        print row

 

转载于:https://www.cnblogs.com/zsw2zkl/p/6054722.html