X-Git-Url: http://git.kpe.io/?p=clsql.git;a=blobdiff_plain;f=examples%2Fclsql-tutorial.lisp;h=265ae6d2e34edb1930ac537b1a4c77d29f2b3aca;hp=0971d7201a89d0f310d244f23ee0b792caf014a7;hb=fc58e4fb7d908985389c86adf57ddee6c1dde5d2;hpb=e12e49ba39110f4a34def97d27bc8432f6de8665 diff --git a/examples/clsql-tutorial.lisp b/examples/clsql-tutorial.lisp index 0971d72..265ae6d 100644 --- a/examples/clsql-tutorial.lisp +++ b/examples/clsql-tutorial.lisp @@ -4,7 +4,7 @@ ;; You must set these variables to appropriate values. (defvar *tutorial-database-type* nil - "Possible values are :postgresql,:postgresql-socket :mysql, + "Possible values are :postgresql :postgresql-socket, :mysql, :oracle, :odbc, :aodbc or :sqlite") (defvar *tutorial-database-name* "clsqltut" "The name of the database we will work in.") @@ -34,7 +34,8 @@ :type (string 100) :initarg :email) (companyid - :type integer) + :type integer + :initarg :companyid) (company :accessor employee-company :db-kind :join @@ -85,7 +86,7 @@ ;; Connect to the database (see the CLSQL documentation for vendor ;; specific connection specs). (case *tutorial-database-type* - ((:mysql :postgresql) + ((:mysql :postgresql :postgresql-socket) (clsql:connect `(,*tutorial-database-server* ,*tutorial-database-name* ,*tutorial-database-user* @@ -156,7 +157,8 @@ (let ((new-lenin (car (clsql:select 'employee - :where [= [slot-value 'employee 'emplid] 1])))) + :where [= [slot-value 'employee 'emplid] 1] + :flatp t)))) (format t "His new email is ~A" (employee-email new-lenin)))