Python + Gadfly my test program

During the installation of gadfly, although I read the installation file, I still feel unable to start, so I ran setup directly. PY, and then copy The Gadfly folder directly to the Karrigell-2.4.0/database/directory can be used, huh, huh !!!

Good mood !!!

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.exe cute (SQL)

Cursor.exe cute ("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.exe cute (SQL)
Res = cursor. fetchall () [0]
Print res [0]
Print res [1]
Print res [2]
Print res [3]