반응형
MSSQL
관련 모듈레퍼런스 링크 : http://code.google.com/p/pymssql/wiki/PymssqlModuleReference
관련 모듈레퍼런스 링크 : 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
Oracle
http://wiki.python.org/moin/Oracle
'.NET > IronPython' 카테고리의 다른 글
아이언파이썬 웹크롤링 샘플입니다 (0) | 2016.08.02 |
---|---|
IronPython for Visual Studio 2010 - 설치, 실행, 디버깅 (0) | 2012.02.22 |
파이썬 디컴파일 - Python decompyle (0) | 2012.02.13 |