Example 5-1. Show data
1 horst@horstnotebook:~> python
2 Python 2.2.2 (#1, Mar 17 2003, 15:17:58)
3 [GCC 3.3 20030226 (prerelease) (SuSE Linux)] on linux2
4 Type "help", "copyright", "credits" or "license" for more information.
5 >>> from hk_classes import *
6 >>> dr=hk_drivermanager()
7 >>> con=dr.new_connection("mysql")
8 >>> con.set_password("secret")
9 >>> con.connect()
10 1
11 >>> db=con.new_database("exampledb")
12 >>> table=db.new_table("authors")
13 >>> i=0
14 >>> table.enable()
15 SQL : SELECT * FROM `authors`
16 1
17 >>> table.goto_first()
18 1
19 >>> while i< table.max_rows():
20 ... table.show_currentrow()
21 ... table.goto_next()
22 ... i=i+1
23 ['1', 'Goethe,Johann Wolfgang', '1749', '1832', 'FALSE']
24 1
25 ['2', 'Schiller, Friedrich von', '1759', '1805', 'TRUE']
26 1
27 ['3', 'Lessing, Gotthold Ephraim', '1729', '1781', 'TRUE']
28 1
29 ['4', 'Kleist', '1400', '0', 'FALSE'] |