projects
/
clsql.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
r8879: fix sequence, fix sqlite uffi, fix schema table
[clsql.git]
/
db-mysql
/
mysql-sql.lisp
diff --git
a/db-mysql/mysql-sql.lisp
b/db-mysql/mysql-sql.lisp
index 7a59077f3c1ae4618c77747ad8d2bae835be3563..75b81a8a88a0a19d9db90462b66b9fe2f0530cbd 100644
(file)
--- a/
db-mysql/mysql-sql.lisp
+++ b/
db-mysql/mysql-sql.lisp
@@
-225,7
+225,7
@@
(full-set nil :type boolean))
(full-set nil :type boolean))
-(defmethod database-query-result-set (
query-expression
+(defmethod database-query-result-set (
(query-expression string)
(database mysql-database)
&key full-set types)
(uffi:with-cstring (query-native query-expression)
(database mysql-database)
&key full-set types)
(uffi:with-cstring (query-native query-expression)
@@
-294,8
+294,8
@@
(defmethod database-list-tables ((database mysql-database) &key (owner nil))
(declare (ignore owner))
(remove-if #'(lambda (s)
(defmethod database-list-tables ((database mysql-database) &key (owner nil))
(declare (ignore owner))
(remove-if #'(lambda (s)
- (and (>= (length s) 1
0
)
- (string= (subseq s 0 1
0) "_u
sql_seq_")))
+ (and (>= (length s) 1
1
)
+ (string= (subseq s 0 1
1) "_cl
sql_seq_")))
(mapcar #'car (database-query "SHOW TABLES" database nil))))
;; MySQL 4.1 does not support views
(mapcar #'car (database-query "SHOW TABLES" database nil))))
;; MySQL 4.1 does not support views
@@
-340,12
+340,12
@@
;;; Sequence functions
(defun %sequence-name-to-table (sequence-name)
;;; Sequence functions
(defun %sequence-name-to-table (sequence-name)
- (concatenate 'string "_
u
sql_seq_" (sql-escape sequence-name)))
+ (concatenate 'string "_
cl
sql_seq_" (sql-escape sequence-name)))
(defun %table-name-to-sequence-name (table-name)
(defun %table-name-to-sequence-name (table-name)
- (and (>= (length table-name) 1
0
)
- (string= (subseq table-name 0 1
0) "_u
sql_seq_")
- (subseq table-name 1
0
)))
+ (and (>= (length table-name) 1
1
)
+ (string= (subseq table-name 0 1
1) "_cl
sql_seq_")
+ (subseq table-name 1
1
)))
(defmethod database-create-sequence (sequence-name
(database mysql-database))
(defmethod database-create-sequence (sequence-name
(database mysql-database))
@@
-369,7
+369,7
@@
&key (owner nil))
(declare (ignore owner))
(mapcar #'(lambda (s) (%table-name-to-sequence-name (car s)))
&key (owner nil))
(declare (ignore owner))
(mapcar #'(lambda (s) (%table-name-to-sequence-name (car s)))
- (database-query "SHOW TABLES LIKE '%
u
sql_seq%'"
+ (database-query "SHOW TABLES LIKE '%
cl
sql_seq%'"
database nil)))
(defmethod database-set-sequence-position (sequence-name
database nil)))
(defmethod database-set-sequence-position (sequence-name