Centos7中python连接sqlserver

左手的ㄟ右手 2021-12-18 06:53 435阅读 0赞

[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

[Linux]: http://lib.csdn.net/base/linux
[Python]: http://lib.csdn.net/base/python