ADO GetRows() example for newbies

[Tomasz Stochmal]

#ADO GetRows() example

import win32com.client
import pprint

def main():
        ConnectionString = 'Provider=SQLOLEDB.1' \
            +';Data Source=127.0.0.1' \
            +';Initial Catalog=ZASecurities' \
            +';User ID=sa' \
            +';Password='

        SQL='SELECT TOP 1 * FROM TESTCASE'

        DBConnection=win32com.client.Dispatch('ADODB.Connection')        
        DBConnection.Open(ConnectionString) 
        try:
            rs=win32com.client.Dispatch('ADODB.Recordset')
            rs.Open(SQL,DBConnection)
            try:
                # Info Row: Field Name/Type
                result=[]
                buf=[]
                for i in range(rs.Fields.Count):
                    buf.append([rs.Fields.Item(i).Name,rs.Fields.Item(i).Type])
    
                result.append(buf)
    
                # Data Rows
                if not rs.EOF:
                    data=rs.GetRows()
                    assert len(data) > 0
                    data=[[r[col] for r in data] for col in range(len(data[0]))]
                    result.extend(data)
            finally:
                rs.Close()
    
            pprint.pprint(result)
        finally:
            DBConnection.Close()


if __name__ == "__main__":
    main()


# Change ConnectionString & SQL