ABOUT ME

-

Today
-
Yesterday
-
Total
-
  • Python MSSQL Oracle DB-API 2.0
    .NET/IronPython 2012. 2. 15. 11:52
    반응형
    MSSQL

    관련 모듈레퍼런스 링크 :   http://code.google.com/p/pymssql/wiki/PymssqlModuleReference 

    http://code.google.com/p/pymssql/wiki/Documentation?tm=6 

    Python pymssql




     http://pymssql.sourceforge.net/examples_pymssql.php 
    pymssql — simple MS SQL Python extension module 
    pymssql examples (strict DB-API compliance): 

    import pymssql
    conn = pymssql.connect(host='SQL01', user='user', password='password', database='mydatabase')
    cur = conn.cursor()
    cur.execute('CREATE TABLE persons(id INT, name VARCHAR(100))')
    cur.executemany("INSERT INTO persons VALUES(%d, %s)", \
        [ (1, 'John Doe'), (2, 'Jane Doe') ])
    conn.commit()  # you must call commit() to persist your data if you don't set autocommit to True

    cur.execute('SELECT * FROM persons WHERE salesrep=%s', 'John Doe')
    row = cur.fetchone()
    while row:
        print "ID=%d, Name=%s" % (row[0], row[1])
        row = cur.fetchone()

    # if you call execute() with one argument, you can use % sign as usual
    # (it loses its special meaning).
    cur.execute("SELECT * FROM persons WHERE salesrep LIKE 'J%'")

    conn.close()

    You can also use iterators instead of while loop. Iterators are DB-API extensions, and are available since pymssql 1.0.

    Rows as dictionaries

    Since pymssql 1.0.2 rows can be fetched as dictionaries instead of tuples. This allows for accessing columns by name instead of index.

    import pymssql
    conn = pymssql.connect(host='SQL01', user='user', password='password', database='mydatabase',as_dict=True)
    cur = conn.cursor()

    cur.execute('SELECT * FROM persons WHERE salesrep=%s', 'John Doe')
    for row in cur:
        print "ID=%d, Name=%s" % (row['id'], row['name'])

    conn.close()








    Oracle

    http://wiki.python.org/moin/Oracle



     
    반응형

    댓글

Designed by Tistory.