python+gadfly 我的測試程式

      在安裝gadfly的時候，雖然看了安裝檔案，但還是感覺無從下手，於是就直接運行了setup.py ,然後把gadfly檔案夾直接複製到了Karrigell-2.4.0/database/目錄下竟然就能用了，呵呵！！！

     心情不錯！！！

import gadfly
cx = gadfly.gadfly()
cx.startup( "persons","C:\/\/Karrigell240\/Karrigell-2.4.0\/databases\/" )
sql = "CREATE TABLE Person ( name varchar, surname varchar, age integer, info varchar )"
cursor = cx.cursor()
cursor.execute( sql )

cursor.execute("INSERT INTO Person (name,surname,age,info) values ('caulfield','holden','18','catcher in the rye')"  )
cx.commit()

 

sql = "SELECT name, surname, age, info FROM Person WHERE name='caulfield'"
cursor.execute(sql)
res=cursor.fetchall()[0]
print res[0]
print res[1]
print res[2]
print res[3]