fukamachi/sxql

How to prevent output of \" characters in SXQL-STATEMENTs

vkulikov opened this issue · 3 comments

vkulikov commented

How to fix next problem?

CL-USER> (sxql:create-table :enemy
             ((name :type 'string
                    :primary-key t)
              (age :type 'integer
                   :not-null t)
              (address :type 'text
                       :not-null nil)
              (fatal_weakness :type 'text
                              :not-null t
                              :default "None")
              (identifying_color :type '(:char 20)
                                 :unique t)))
#<SXQL-STATEMENT: CREATE TABLE "enemy" ("name" STRING PRIMARY KEY, "age" INTEGER NOT NULL, "address" TEXT, "fatal_weakness" TEXT NOT NULL DEFAULT 'None', "identifying_color" CHAR(20) UNIQUE)>
CL-USER> (sxql:yield *)
"CREATE TABLE \"enemy\" (\"name\" STRING PRIMARY KEY, \"age\" INTEGER NOT NULL, \"address\" TEXT, \"fatal_weakness\" TEXT NOT NULL DEFAULT ?, \"identifying_color\" CHAR(20) UNIQUE)"
("None")

Mysql response is:
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"enemy" ("name" STRING PRIMARY KEY, "age" INTEGER NOT NULL, "address" TEXT, "fat' at line 1

Thank you!

vkulikov commented

oops, sorry, my bad :-)