Fetch row by using cursor : PostgreSQL « Database « Python Tutorial

Python Tutorial
1. Introduction
2. Data Type
3. Statement
4. Operator
5. String
6. Tuple
7. List
8. Dictionary
9. Collections
10. Function
11. Class
12. File
13. Buildin Function
14. Buildin Module
15. Database
16. Regular Expressions
17. Thread
18. Tkinker
19. wxPython
20. XML
21. Network
22. CGI Web
23. Windows
Java
Java Tutorial
Java Source Code / Java Documentation
Java Open Source
Jar File Download
Java Articles
Java Products
Java by API
Photoshop Tutorial
C# / C Sharp
C# / CSharp Tutorial
C# / CSharp Open Source
ASP.Net
ASP.NET Tutorial
JavaScript DHTML
JavaScript Tutorial
JavaScript Reference
HTML / CSS
HTML CSS Reference
C / ANSI-C
C Tutorial
C++
C++ Tutorial
Ruby
PHP
Python
Python Open Source
SQL Server / T-SQL
SQL Server / T-SQL Tutorial
Oracle PL / SQL
Oracle PL/SQL Tutorial
PostgreSQL
SQL / MySQL
MySQL Tutorial
VB.Net
VB.Net Tutorial
Flash / Flex / ActionScript
VBA / Excel / Access / Word
XML
XML Tutorial
Microsoft Office PowerPoint 2007 Tutorial
Microsoft Office Excel 2007 Tutorial
Microsoft Office Word 2007 Tutorial
Python Tutorial » Database » PostgreSQL 
15. 4. 10. Fetch row by using cursor
import psycopg

def dictfetchone(cur):
    seq = cur.fetchone()
    if seq == None:
        return seq
    result = {}
    colnum = 0
    for column in cur.description:
        result[column[0]] = seq[colnum]
        colnum += 1
    return result

dbh = psycopg.connect('dbname=jgoerzen user=jgoerzen')
print "Connection successful."

cur = dbh.cursor()
cur.execute("SELECT * FROM myTable")
while 1:
    row = dictfetchone(cur)
    if row == None:
        break
    print row
dbh.close()
15. 4. PostgreSQL
15. 4. 1. Query data
15. 4. 2. Basic connection to PostgreSQL with psycopg
15. 4. 3. Query PostgreSQL database with select statement
15. 4. 4. Create a table and insert data
15. 4. 5. executemany() for batch update
15. 4. 6. optimized execute() for multiple rows example
15. 4. 7. Fetch all rows after query
15. 4. 8. Adjust the connect() call below for your database
15. 4. 9. Fetch row one by one
15. 4. 10. Fetch row by using cursor
15. 4. 11. Parameter style
15. 4. 12. Get cursor
15. 4. 13. Using types to insert data
15. 4. 14. Commit example
www.java2java.com | Contact Us
Copyright 2010 - 2030 Java Source and Support. All rights reserved.
All other trademarks are property of their respective owners.