X-Git-Url: http://git.kpe.io/?p=clsql.git;a=blobdiff_plain;f=db-mysql%2Fmysql-objects.lisp;h=76ce5e5b910c59021f2b8f68e93812ad6427c9fd;hp=5ddad8b5d73817da2aaded534fb153b30e3f10ce;hb=e567409d9fff3f7231c2a0bb69b345e19de2b246;hpb=d528dfe7e23fe5732fdbf1a282498fbec298d6cd diff --git a/db-mysql/mysql-objects.lisp b/db-mysql/mysql-objects.lisp index 5ddad8b..76ce5e5 100644 --- a/db-mysql/mysql-objects.lisp +++ b/db-mysql/mysql-objects.lisp @@ -16,35 +16,45 @@ (in-package #:clsql-mysql) (defmethod database-get-type-specifier ((type (eql 'wall-time)) args database - (db-type (eql :mysql))) + (db-type (eql :mysql))) (declare (ignore args database)) "DATETIME") (defmethod database-get-type-specifier ((type (eql 'smallint)) args database - (db-type (eql :mysql))) + (db-type (eql :mysql))) (declare (ignore args database)) "SMALLINT") +(defmethod database-get-type-specifier ((type (eql 'mediumint)) args database + (db-type (eql :mysql))) + (declare (ignore args database)) + "MEDIUMINT") + +(defmethod database-get-type-specifier ((type (eql 'tinyint)) args database + (db-type (eql :mysql))) + (declare (ignore args database)) + "TINYINT") + (defmethod database-output-sql-as-type ((type (eql 'boolean)) val database - (db-type (eql :mysql))) + (db-type (eql :mysql))) (declare (ignore database)) (if val 1 0)) (defmethod database-output-sql-as-type ((type (eql 'generalized-boolean)) val database - (db-type (eql :mysql))) + (db-type (eql :mysql))) (declare (ignore database)) (if val 1 0)) (defmethod read-sql-value (val (type (eql 'boolean)) database - (db-type (eql :mysql))) - (declare (ignore database)) + (db-type (eql :mysql))) + (declare (ignore database)) (etypecase val (string (if (string= "0" val) nil t)) (integer (if (zerop val) nil t)))) (defmethod read-sql-value (val (type (eql 'generalized-boolean)) database - (db-type (eql :mysql))) - (declare (ignore database)) + (db-type (eql :mysql))) + (declare (ignore database)) (etypecase val (string (if (string= "0" val) nil t)) (integer (if (zerop val) nil t))))