This is the mito Reference Manual, version 0.2.0, generated automatically by Declt version 4.0 beta 2 "William Riker" on Sun Dec 15 07:04:47 2024 GMT+0.
mito/mito.asd
mito-core/mito-core.asd
mito-migration/mito-migration.asd
lack-middleware-mito/lack-middleware-mito.asd
mito/src/mito.lisp
mito-core/src/core.lisp
mito-core/core-components/dao.lisp
mito-core/core-components/dao-components/table.lisp
mito-core/core-components/dao-components/view.lisp
mito-core/core-components/dao-components/mixin.lisp
mito-core/core-components/dao-components/column.lisp
mito-core/core-components/class.lisp
mito-core/core-components/class-components/table.lisp
mito-core/core-components/class-components/column.lisp
mito-core/core-components/connection.lisp
mito-core/core-components/type.lisp
mito-core/core-components/db.lisp
mito-core/core-components/db-drivers/mysql.lisp
mito-core/core-components/db-drivers/postgres.lisp
mito-core/core-components/db-drivers/sqlite3.lisp
mito-core/core-components/conversion.lisp
mito-core/core-components/logger.lisp
mito-core/core-components/error.lisp
mito-core/core-components/util.lisp
mito-migration/src/migration.lisp
mito-migration/migration-components/table.lisp
mito-migration/migration-components/versions.lisp
mito-migration/migration-components/sxql.lisp
mito-migration/migration-components/sql-parse.lisp
mito-migration/migration-components/util.lisp
lack-middleware-mito/src/middleware.lisp
mito.db.sqlite3
mito.migration.sql-parse
mito.connection
mito.migration
mito.core
mito.type
mito.class
mito.migration.sxql
mito.dao.mixin
mito.logger
mito.db.mysql
mito.dao
mito.middleware
mito.dao.column
mito.class.table
mito.class.column
mito
mito.conversion
mito.dao.view
mito.dao.table
mito.error
mito.util
mito.db.postgres
mito.db
mito.migration.table
mito.migration.util
mito.migration.versions
The main system appears first, followed by any subsystem dependency.
mito
Abstraction layer for DB schema
Eitaro Fukamachi
BSD 3-Clause
0.2.0
mito-core
(system).
mito-migration
(system).
lack-middleware-mito
(system).
cl-package-locks
(system)., for feature :sb-package-locks
src/mito.lisp
(file).
mito-core
Eitaro Fukamachi
BSD 3-Clause
0.2.0
dbi
(system)., at least version "0.11.1"
sxql
(system).
cl-ppcre
(system).
closer-mop
(system).
dissect
(system).
trivia
(system).
local-time
(system).
uuid
(system).
alexandria
(system).
src/core.lisp
(file).
core-components
(module).
mito-migration
Eitaro Fukamachi
BSD 3-Clause
0.2.0
mito-core
(system).
sxql
(system).
dbi
(system).
closer-mop
(system).
esrap
(system).
alexandria
(system).
uiop
(system).
chipz
(system).
src/migration.lisp
(file).
migration-components
(module).
Modules are listed depth-first from the system components tree.
mito-core/core-components
mito-core/core-components/dao-components
mito-core/core-components/class-components
mito-core/core-components/db-drivers
mito-migration/migration-components
lack-middleware-mito/src
mito-core/core-components
mito-core
(system).
dao.lisp
(file).
dao-components
(module).
class.lisp
(file).
class-components
(module).
connection.lisp
(file).
type.lisp
(file).
db.lisp
(file).
db-drivers
(module).
conversion.lisp
(file).
logger.lisp
(file).
error.lisp
(file).
util.lisp
(file).
mito-core/core-components/dao-components
connection.lisp
(file).
class.lisp
(file).
db.lisp
(file).
conversion.lisp
(file).
logger.lisp
(file).
util.lisp
(file).
core-components
(module).
table.lisp
(file).
view.lisp
(file).
mixin.lisp
(file).
column.lisp
(file).
mito-core/core-components/class-components
error.lisp
(file).
util.lisp
(file).
core-components
(module).
table.lisp
(file).
column.lisp
(file).
mito-core/core-components/db-drivers
logger.lisp
(file).
util.lisp
(file).
core-components
(module).
mysql.lisp
(file).
postgres.lisp
(file).
sqlite3.lisp
(file).
mito-migration/migration-components
mito-migration
(system).
table.lisp
(file).
versions.lisp
(file).
sxql.lisp
(file).
sql-parse.lisp
(file).
util.lisp
(file).
lack-middleware-mito/src
lack-middleware-mito
(system).
middleware.lisp
(file).
Files are sorted by type and then listed depth-first from the systems components trees.
mito/mito.asd
mito-core/mito-core.asd
mito-migration/mito-migration.asd
lack-middleware-mito/lack-middleware-mito.asd
mito/src/mito.lisp
mito-core/src/core.lisp
mito-core/core-components/dao.lisp
mito-core/core-components/dao-components/table.lisp
mito-core/core-components/dao-components/view.lisp
mito-core/core-components/dao-components/mixin.lisp
mito-core/core-components/dao-components/column.lisp
mito-core/core-components/class.lisp
mito-core/core-components/class-components/table.lisp
mito-core/core-components/class-components/column.lisp
mito-core/core-components/connection.lisp
mito-core/core-components/type.lisp
mito-core/core-components/db.lisp
mito-core/core-components/db-drivers/mysql.lisp
mito-core/core-components/db-drivers/postgres.lisp
mito-core/core-components/db-drivers/sqlite3.lisp
mito-core/core-components/conversion.lisp
mito-core/core-components/logger.lisp
mito-core/core-components/error.lisp
mito-core/core-components/util.lisp
mito-migration/src/migration.lisp
mito-migration/migration-components/table.lisp
mito-migration/migration-components/versions.lisp
mito-migration/migration-components/sxql.lisp
mito-migration/migration-components/sql-parse.lisp
mito-migration/migration-components/util.lisp
lack-middleware-mito/src/middleware.lisp
mito-migration/mito-migration.asd
mito-migration
(system).
lack-middleware-mito/lack-middleware-mito.asd
lack-middleware-mito
(system).
mito-core/src/core.lisp
core-components
(module).
mito-core
(system).
mito-core/core-components/dao.lisp
dao-components
(module).
core-components
(module).
count-dao
(function).
create-dao
(generic function).
deftable
(macro).
delete-by-values
(generic function).
delete-dao
(generic function).
do-select
(macro).
ensure-table-exists
(function).
find-dao
(function).
include-foreign-objects
(function).
insert-dao
(generic function).
recreate-table
(function).
retrieve-dao
(function).
save-dao
(generic function).
select-by-sql
(function).
select-dao
(macro).
update-dao
(generic function).
*want-cursor*
(special variable).
child-columns
(function).
copy-mito-cursor
(function).
expand-op
(function).
fetch-dao-from-cursor
(function).
foreign-value
(function).
make-mito-cursor
(function).
make-set-clause
(function).
mito-cursor
(structure).
mito-cursor-class
(reader).
(setf mito-cursor-class)
(writer).
mito-cursor-cursor
(reader).
(setf mito-cursor-cursor)
(writer).
mito-cursor-fields
(reader).
(setf mito-cursor-fields)
(writer).
mito-cursor-p
(function).
select-by-sql-as-cursor
(function).
slot-foreign-value
(function).
where-and
(function).
mito-core/core-components/dao-components/table.lisp
column.lisp
(file).
mixin.lisp
(file).
view.lisp
(file).
dao-components
(module).
dao-table-class
(class).
depending-table-classes
(function).
direct-slot-definition-class
(method).
ensure-class-using-class
(method).
initialize-instance
(method).
reinitialize-instance
(method).
table-definition
(method).
append-auto-pk-class-to-direct-superclasses-if-needed
(function).
append-record-timestamp-mixin-to-direct-superclasses-if-needed
(function).
initargs-contains-primary-key
(function).
initargs-enables-auto-pk
(function).
initargs-enables-record-timestamps
(function).
mito-core/core-components/dao-components/view.lisp
column.lisp
(file).
dao-components
(module).
dao-table-view
(class).
dao-table-view-as-query
(reader method).
direct-slot-definition-class
(method).
table-definition
(generic function).
yield
(method).
yield
(method).
copy-create-view
(function).
copy-drop-view
(function).
create-view
(structure).
create-view-as
(reader).
(setf create-view-as)
(writer).
create-view-name
(reader).
(setf create-view-name)
(writer).
create-view-or-replace
(reader).
(setf create-view-or-replace)
(writer).
create-view-p
(function).
create-view-view-name
(reader).
(setf create-view-view-name)
(writer).
drop-view
(structure).
drop-view-if-exists
(reader).
(setf drop-view-if-exists)
(writer).
drop-view-name
(reader).
(setf drop-view-name)
(writer).
drop-view-p
(function).
drop-view-view-name
(reader).
(setf drop-view-view-name)
(writer).
make-create-view
(function).
make-drop-view
(function).
mito-core/core-components/dao-components/mixin.lisp
column.lisp
(file).
dao-components
(module).
dao-class
(class).
dao-synced
(reader method).
(setf dao-synced)
(writer method).
dao-table-mixin
(class).
direct-slot-definition-class
(method).
initialize-instance
(method).
make-dao-instance
(generic function).
object-created-at
(reader method).
(setf object-created-at)
(writer method).
object-id
(generic function).
(setf object-id)
(generic function).
object-updated-at
(reader method).
(setf object-updated-at)
(writer method).
object=
(generic function).
record-timestamps-mixin
(class).
reinitialize-instance
(method).
serial-pk-mixin
(class).
uuid-pk-mixin
(class).
%object-id
(reader method).
(setf %object-id)
(writer method).
%object-uuid
(reader method).
(setf %object-uuid)
(writer method).
add-relational-readers
(function).
generate-uuid
(function).
make-relational-reader-method
(function).
mito-core/core-components/dao-components/column.lisp
dao-components
(module).
dao-table-column-class
(class).
dao-table-column-deflate
(generic function).
dao-table-column-inflate
(generic function).
deflate-for-col-type
(generic function).
inflate-for-col-type
(generic function).
initialize-instance
(method).
*conc-name*
(special variable).
*db-date-format*
(special variable).
*db-datetime-format*
(special variable).
*db-datetime-format-with-out-timezone*
(special variable).
mito-core/core-components/class.lisp
class-components
(module).
core-components
(module).
create-table-sxql
(generic function).
table-column-references-column
(method).
mito-core/core-components/class-components/table.lisp
column.lisp
(file).
class-components
(module).
database-column-slots
(generic function).
direct-slot-definition-class
(method).
find-child-columns
(function).
find-parent-column
(function).
find-slot-by-name
(function).
initialize-instance
(method).
reinitialize-instance
(method).
table-class
(class).
table-column-slots
(function).
table-direct-column-slots
(function).
table-indices-info
(generic function).
table-name
(generic function).
table-primary-key
(generic function).
table-serial-key
(generic function).
validate-superclass
(method).
add-referencing-slots
(function).
expand-relational-keys
(function).
map-all-superclasses
(function).
rel-column-name
(function).
mito-core/core-components/class-components/column.lisp
class-components
(module).
ghost-slot-p
(reader method).
(setf ghost-slot-p)
(writer method).
initialize-instance
(method).
primary-key-p
(reader method).
(setf primary-key-p)
(writer method).
table-column-class
(class).
table-column-info
(generic function).
table-column-info-for-create-table
(generic function).
table-column-name
(generic function).
table-column-not-null-p
(generic function).
table-column-references
(reader method).
table-column-references-column
(generic function).
table-column-type
(generic function).
%table-column-type
(reader method).
(setf %table-column-type)
(writer method).
parse-col-type
(function).
references
(type).
mito-core/core-components/connection.lisp
error.lisp
(file).
core-components
(module).
*connection*
(special variable).
check-connected
(function).
connect-toplevel
(function).
connected-p
(function).
connection-database-name
(function).
connection-quote-character
(function).
disconnect-toplevel
(function).
driver-type
(function).
with-quote-char
(macro).
mito-core/core-components/type.lisp
db.lisp
(file).
core-components
(module).
get-column-real-type
(function).
parse-dbtype
(function).
*real-type-cache*
(special variable).
parse-type-vars
(function).
mito-core/core-components/db.lisp
db-drivers
(module).
connection.lisp
(file).
class.lisp
(file).
util.lisp
(file).
core-components
(module).
*use-prepare-cached*
(special variable).
acquire-advisory-lock
(function).
column-definitions
(function).
execute-sql
(generic function).
last-insert-id
(function).
release-advisory-lock
(function).
retrieve-by-sql
(generic function).
table-exists-p
(function).
table-indices
(function).
table-view-query
(function).
*plist-row-lispify*
(special variable).
convert-nulls-to-nils
(function).
ensure-sql
(function).
lispified-fields
(function).
retrieve-from-query
(function).
sxql-to-sql
(function).
mito-core/core-components/db-drivers/mysql.lisp
db-drivers
(module).
acquire-advisory-lock
(function).
column-definitions
(function).
last-insert-id
(function).
release-advisory-lock
(function).
table-indices
(function).
table-view-query
(function).
ensure-string
(function).
mito-core/core-components/db-drivers/postgres.lisp
db-drivers
(module).
acquire-advisory-lock
(function).
column-definitions
(function).
last-insert-id
(function).
release-advisory-lock
(function).
table-indices
(function).
table-view-query
(function).
get-serial-keys
(function).
mito-core/core-components/db-drivers/sqlite3.lisp
db-drivers
(module).
column-definitions
(function).
last-insert-id
(function).
table-indices
(function).
table-info
(function).
table-primary-keys
(function).
mito-core/core-components/conversion.lisp
core-components
(module).
convert-for-driver-type
(generic function).
*db-date-format*
(special variable).
*db-datetime-format*
(special variable).
*db-datetime-format-without-timezone*
(special variable).
mito-core/core-components/logger.lisp
core-components
(module).
*mito-logger-stream*
(special variable).
*mito-migration-logger-stream*
(special variable).
*trace-sql-hooks*
(special variable).
mito-sql-logger
(function).
with-sql-logging
(macro).
with-trace-sql
(macro).
get-prev-stack
(function).
trace-sql
(function).
mito-core/core-components/error.lisp
core-components
(module).
col-type-required
(condition).
connection-not-established
(condition).
invalid-definition
(condition).
mito-error
(condition).
no-primary-keys
(condition).
mito-core/core-components/util.lisp
core-components
(module).
contains-class-or-subclasses
(function).
ensure-class
(function).
execute-with-retry
(function).
group-by-plist
(function).
lispify
(function).
list-diff
(function).
symbol-name-literally
(function).
unlispify
(function).
with-prepared-query
(macro).
%list-diff
(function).
call-with-prepared-query
(function).
escaped-symbol-p
(function).
obsolete-prepared-statement-p
(function).
mito-migration/src/migration.lisp
migration-components
(module).
mito-migration
(system).
mito-migration/migration-components/table.lisp
sxql.lisp
(file).
migration-components
(module).
*auto-migration-mode*
(special variable).
*migration-keep-temp-tables*
(special variable).
initialize-instance
(method).
migrate-table
(generic function).
migration-expressions
(function).
reinitialize-instance
(method).
column-definition-equal-p
(function).
migration-expressions-aux
(function).
migration-expressions-between
(function).
migration-expressions-between-for-sqlite3
(function).
omit-default
(function).
plist=
(function).
mito-migration/migration-components/versions.lisp
table.lisp
(file).
sql-parse.lisp
(file).
util.lisp
(file).
migration-components
(module).
*migration-version-format*
(special variable).
all-migration-expressions
(function).
current-migration-version
(function).
generate-migrations
(function).
migrate
(function).
migration-status
(function).
update-migration-version
(function).
%migration-status
(function).
*advisory-lock-drivers*
(special variable).
all-dao-classes
(function).
generate-time-version
(function).
generate-version
(function).
initialize-migrations-table
(function).
migration-file-version
(function).
migration-files
(function).
schema-migrations-table-definition
(function).
with-advisory-lock
(macro).
mito-migration/migration-components/sxql.lisp
migration-components
(module).
copy-create-sequence
(function).
copy-drop-sequence
(function).
copy-set-default
(function).
create-sequence
(structure).
create-sequence-name
(reader).
(setf create-sequence-name)
(writer).
create-sequence-p
(function).
create-sequence-sequence-name
(reader).
(setf create-sequence-sequence-name)
(writer).
drop-sequence
(structure).
drop-sequence-if-exists
(reader).
(setf drop-sequence-if-exists)
(writer).
drop-sequence-name
(reader).
(setf drop-sequence-name)
(writer).
drop-sequence-p
(function).
drop-sequence-sequence-name
(reader).
(setf drop-sequence-sequence-name)
(writer).
make-create-sequence
(function).
make-drop-sequence
(function).
make-set-default
(function).
set-default
(structure).
set-default-expression
(function).
(setf set-default-expression)
(function).
set-default-name
(reader).
(setf set-default-name)
(writer).
set-default-p
(function).
mito-migration/migration-components/sql-parse.lisp
migration-components
(module).
parse-statements
(function).
mito-migration/migration-components/util.lisp
migration-components
(module).
generate-advisory-lock-id
(function).
+migrator-salt+
(special variable).
ascii-string-to-octets
(function).
crc32
(function).
lack-middleware-mito/src/middleware.lisp
src
(module).
*lack-middleware-mito*
(special variable).
Packages are listed by definition order.
mito.db.sqlite3
mito.migration.sql-parse
mito.connection
mito.migration
mito.core
mito.type
mito.class
mito.migration.sxql
mito.dao.mixin
mito.logger
mito.db.mysql
mito.dao
mito.middleware
mito.dao.column
mito.class.table
mito.class.column
mito
mito.conversion
mito.dao.view
mito.dao.table
mito.error
mito.util
mito.db.postgres
mito.db
mito.migration.table
mito.migration.util
mito.migration.versions
mito.db.sqlite3
common-lisp
.
mito.util
.
sxql
.
column-definitions
(function).
last-insert-id
(function).
table-indices
(function).
table-info
(function).
table-primary-keys
(function).
mito.migration.sql-parse
common-lisp
.
esrap
.
parse-statements
(function).
mito.connection
common-lisp
.
mito.error
.
*connection*
(special variable).
check-connected
(function).
connect-toplevel
(function).
connected-p
(function).
connection-database-name
(function).
connection-quote-character
(function).
disconnect-toplevel
(function).
driver-type
(function).
with-quote-char
(macro).
mito.migration
common-lisp
.
mito.migration.table
.
mito.migration.versions
.
mito
.
mito.type
common-lisp
.
get-column-real-type
(function).
parse-dbtype
(function).
*real-type-cache*
(special variable).
parse-type-vars
(function).
mito.class
common-lisp
.
mito.class.column
.
mito.class.table
.
create-table-sxql
(generic function).
mito.migration.sxql
Extansions of SxQL for Mito.Migration
common-lisp
.
copy-create-sequence
(function).
copy-drop-sequence
(function).
copy-set-default
(function).
create-sequence
(structure).
create-sequence-name
(reader).
(setf create-sequence-name)
(writer).
create-sequence-p
(function).
create-sequence-sequence-name
(reader).
(setf create-sequence-sequence-name)
(writer).
drop-sequence
(structure).
drop-sequence-if-exists
(reader).
(setf drop-sequence-if-exists)
(writer).
drop-sequence-name
(reader).
(setf drop-sequence-name)
(writer).
drop-sequence-p
(function).
drop-sequence-sequence-name
(reader).
(setf drop-sequence-sequence-name)
(writer).
make-create-sequence
(function).
make-drop-sequence
(function).
make-set-default
(function).
set-default
(structure).
set-default-expression
(function).
(setf set-default-expression)
(function).
set-default-name
(reader).
(setf set-default-name)
(writer).
set-default-p
(function).
mito.dao.mixin
common-lisp
.
mito.util
.
dao-class
(class).
dao-synced
(generic reader).
(setf dao-synced)
(generic writer).
dao-table-mixin
(class).
make-dao-instance
(generic function).
object-created-at
(generic reader).
(setf object-created-at)
(generic writer).
object-id
(generic function).
(setf object-id)
(generic function).
object-updated-at
(generic reader).
(setf object-updated-at)
(generic writer).
object=
(generic function).
record-timestamps-mixin
(class).
serial-pk-mixin
(class).
uuid-pk-mixin
(class).
%object-id
(generic reader).
(setf %object-id)
(generic writer).
%object-uuid
(generic reader).
(setf %object-uuid)
(generic writer).
add-relational-readers
(function).
generate-uuid
(function).
make-relational-reader-method
(function).
mito.logger
common-lisp
.
*mito-logger-stream*
(special variable).
*mito-migration-logger-stream*
(special variable).
*trace-sql-hooks*
(special variable).
mito-sql-logger
(function).
with-sql-logging
(macro).
with-trace-sql
(macro).
get-prev-stack
(function).
trace-sql
(function).
mito.db.mysql
common-lisp
.
mito.util
.
sxql
.
acquire-advisory-lock
(function).
column-definitions
(function).
last-insert-id
(function).
release-advisory-lock
(function).
table-indices
(function).
table-view-query
(function).
ensure-string
(function).
mito.dao
common-lisp
.
mito.class
.
mito.dao.mixin
.
mito.dao.table
.
mito.dao.view
.
sxql
.
count-dao
(function).
create-dao
(generic function).
deftable
(macro).
delete-by-values
(generic function).
delete-dao
(generic function).
do-select
(macro).
ensure-table-exists
(function).
find-dao
(function).
include-foreign-objects
(function).
insert-dao
(generic function).
recreate-table
(function).
retrieve-dao
(function).
save-dao
(generic function).
select-by-sql
(function).
select-dao
(macro).
update-dao
(generic function).
*want-cursor*
(special variable).
child-columns
(function).
copy-mito-cursor
(function).
expand-op
(function).
fetch-dao-from-cursor
(function).
foreign-value
(function).
make-mito-cursor
(function).
make-set-clause
(function).
mito-cursor
(structure).
mito-cursor-class
(reader).
(setf mito-cursor-class)
(writer).
mito-cursor-cursor
(reader).
(setf mito-cursor-cursor)
(writer).
mito-cursor-fields
(reader).
(setf mito-cursor-fields)
(writer).
mito-cursor-p
(function).
select-by-sql-as-cursor
(function).
slot-foreign-value
(function).
where-and
(function).
mito.middleware
lack.middleware.mito
common-lisp
.
*lack-middleware-mito*
(special variable).
mito.dao.column
common-lisp
.
mito.util
.
dao-table-column-class
(class).
dao-table-column-deflate
(generic function).
dao-table-column-inflate
(generic function).
deflate-for-col-type
(generic function).
inflate-for-col-type
(generic function).
*conc-name*
(special variable).
*db-date-format*
(special variable).
*db-datetime-format*
(special variable).
*db-datetime-format-with-out-timezone*
(special variable).
mito.class.table
common-lisp
.
mito.util
.
database-column-slots
(generic function).
find-child-columns
(function).
find-parent-column
(function).
find-slot-by-name
(function).
table-class
(class).
table-column-slots
(function).
table-direct-column-slots
(function).
table-indices-info
(generic function).
table-name
(generic function).
table-primary-key
(generic function).
table-serial-key
(generic function).
add-referencing-slots
(function).
expand-relational-keys
(function).
map-all-superclasses
(function).
rel-column-name
(function).
mito.class.column
common-lisp
.
mito.error
.
mito.util
.
ghost-slot-p
(generic reader).
(setf ghost-slot-p)
(generic writer).
primary-key-p
(generic reader).
(setf primary-key-p)
(generic writer).
table-column-class
(class).
table-column-info
(generic function).
table-column-info-for-create-table
(generic function).
table-column-name
(generic function).
table-column-not-null-p
(generic function).
table-column-references
(generic reader).
table-column-references-column
(generic function).
table-column-type
(generic function).
%table-column-type
(generic reader).
(setf %table-column-type)
(generic writer).
parse-col-type
(function).
references
(type).
mito.conversion
common-lisp
.
convert-for-driver-type
(generic function).
*db-date-format*
(special variable).
*db-datetime-format*
(special variable).
*db-datetime-format-without-timezone*
(special variable).
mito.dao.view
common-lisp
.
dao-table-view
(class).
dao-table-view-as-query
(generic reader).
table-definition
(generic function).
copy-create-view
(function).
copy-drop-view
(function).
create-view
(structure).
create-view-as
(reader).
(setf create-view-as)
(writer).
create-view-name
(reader).
(setf create-view-name)
(writer).
create-view-or-replace
(reader).
(setf create-view-or-replace)
(writer).
create-view-p
(function).
create-view-view-name
(reader).
(setf create-view-view-name)
(writer).
drop-view
(structure).
drop-view-if-exists
(reader).
(setf drop-view-if-exists)
(writer).
drop-view-name
(reader).
(setf drop-view-name)
(writer).
drop-view-p
(function).
drop-view-view-name
(reader).
(setf drop-view-view-name)
(writer).
make-create-view
(function).
make-drop-view
(function).
mito.dao.table
common-lisp
.
mito.error
.
mito.util
.
dao-table-class
(class).
depending-table-classes
(function).
append-auto-pk-class-to-direct-superclasses-if-needed
(function).
append-record-timestamp-mixin-to-direct-superclasses-if-needed
(function).
initargs-contains-primary-key
(function).
initargs-enables-auto-pk
(function).
initargs-enables-record-timestamps
(function).
mito.error
common-lisp
.
col-type-required
(condition).
connection-not-established
(condition).
invalid-definition
(condition).
mito-error
(condition).
no-primary-keys
(condition).
mito.util
common-lisp
.
contains-class-or-subclasses
(function).
ensure-class
(function).
execute-with-retry
(function).
group-by-plist
(function).
lispify
(function).
list-diff
(function).
symbol-name-literally
(function).
unlispify
(function).
with-prepared-query
(macro).
%list-diff
(function).
call-with-prepared-query
(function).
escaped-symbol-p
(function).
obsolete-prepared-statement-p
(function).
mito.db.postgres
common-lisp
.
mito.util
.
sxql
.
acquire-advisory-lock
(function).
column-definitions
(function).
last-insert-id
(function).
release-advisory-lock
(function).
table-indices
(function).
table-view-query
(function).
get-serial-keys
(function).
mito.db
common-lisp
.
*use-prepare-cached*
(special variable).
acquire-advisory-lock
(function).
column-definitions
(function).
execute-sql
(generic function).
last-insert-id
(function).
release-advisory-lock
(function).
retrieve-by-sql
(generic function).
table-exists-p
(function).
table-indices
(function).
table-view-query
(function).
*plist-row-lispify*
(special variable).
convert-nulls-to-nils
(function).
ensure-sql
(function).
lispified-fields
(function).
retrieve-from-query
(function).
sxql-to-sql
(function).
mito.migration.table
common-lisp
.
sxql
.
*auto-migration-mode*
(special variable).
*migration-keep-temp-tables*
(special variable).
migrate-table
(generic function).
migration-expressions
(function).
column-definition-equal-p
(function).
migration-expressions-aux
(function).
migration-expressions-between
(function).
migration-expressions-between-for-sqlite3
(function).
omit-default
(function).
plist=
(function).
mito.migration.util
common-lisp
.
generate-advisory-lock-id
(function).
+migrator-salt+
(special variable).
ascii-string-to-octets
(function).
crc32
(function).
mito.migration.versions
common-lisp
.
sxql
.
*migration-version-format*
(special variable).
all-migration-expressions
(function).
current-migration-version
(function).
generate-migrations
(function).
migrate
(function).
migration-status
(function).
update-migration-version
(function).
%migration-status
(function).
*advisory-lock-drivers*
(special variable).
all-dao-classes
(function).
generate-time-version
(function).
generate-version
(function).
initialize-migrations-table
(function).
migration-file-version
(function).
migration-files
(function).
schema-migrations-table-definition
(function).
with-advisory-lock
(macro).
Definitions are sorted by export status, category, package, and then by lexicographic order.
SQLite3 migration creates temporary tables with pre-migration data. If this variable is T they won’t be deleted after migration.
Stream to output sql generated during migrations.
EXPERIMENTAL FEATURE: If this is T, Mito uses DBI:PREPARE-CACHED
to retrieve/execute SQLs instead of DBI:PREPARE. The default value is NIL.
Note that DBI:PREPARE-CACHED is added CL-DBI v0.9.5.
Build custom queries with SxQL.
Example:
(select-dao ’tweet
(where (:like :status "%Japan%")))
You can use "includes" to eagerly load another table and prevent the "N+1 query" performance problem.
Example:
(defvar *tweets-contain-japan*
(select-dao ’tweet
(includes ’user)
(where (:like :status "%Japan%"))))
See the SxQL documentation for the available clauses and operators.
Return the name of the current connection, or the one given as argument.
Same as DBI:EXECUTE except will recreate a prepared statement when getting DBI:DBI-DATABASE-ERROR.
Compute differences two lists.
Note this can be applied for a list of string-designators.
string
)) ¶(eql :mysql)
) (col-type (eql :boolean)
) value) ¶(eql :mysql)
) (col-type (eql :datetime)
) (value timestamp
)) ¶(eql :datetime)
) (value timestamp
)) ¶(eql :date)
) (value timestamp
)) ¶(eql :timestamp)
) value) ¶(eql :timestamptz)
) value) ¶(eql :sqlite3)
) (col-type (eql :boolean)
) value) ¶(eql :postgres)
) (col-type (eql :boolean)
) value) ¶Create an object of class CLASS with INITARGS and save it into the DB.
Example:
(mito:create-dao ’user :name "Eitaro Fukamachi" :email "e.arrows@gmail.com")
same as:
(defvar me
(make-instance ’user :name "Eitaro Fukamachi" :email "e.arrows@gmail.com"))
;=> USER
(mito:insert-dao me)
symbol
) &rest initargs) ¶dao-table-class
) &rest initargs) ¶dao-table-column-class
) value) ¶dao-table-column-class
) value) ¶dao-table-view
)) ¶automatically generated reader method
table-class
)) ¶cons
) value) ¶(eql :datetime)
) value) ¶(eql :date)
) value) ¶(eql :timestamp)
) value) ¶(eql :timestamptz)
) value) ¶Delete the records of class CLASS matching FIELDS-AND-VALUES from the DB. For example: (mito:delete-by-values ’user :id 1)
symbol
) &rest fields-and-values) ¶dao-table-class
) &rest fields-and-values) ¶Delete the object OBJ from the DB.
table-column-class
)) ¶table-column-class
)) ¶Option to specify slots as ghost slots. Ghost slots do not depend on a database.
cons
) value) ¶(eql :datetime)
) value) ¶(eql :date)
) value) ¶(eql :timestamp)
) value) ¶(eql :timestamptz)
) value) ¶(eql :time)
) value) ¶(eql :boolean)
) value) ¶Insert the object OBJ into the DB.
symbol
) &rest initargs) ¶table-class
) &rest initargs) ¶symbol
)) ¶dao-table-class
)) ¶record-timestamps-mixin
)) ¶automatically generated reader method
record-timestamps-mixin
)) ¶automatically generated writer method
serial-pk-mixin
)) ¶uuid-pk-mixin
)) ¶serial-pk-mixin
)) ¶uuid-pk-mixin
)) ¶record-timestamps-mixin
)) ¶automatically generated reader method
record-timestamps-mixin
)) ¶automatically generated writer method
table-column-class
)) ¶automatically generated reader method
table-column-class
)) ¶automatically generated writer method
Save the object OBJ into the DB.
Similar to table-column-info except the return value is for sxql:make-create-table.
(eql :mysql)
)) ¶(eql :sqlite3)
)) ¶(eql :postgres)
)) ¶table-column-class
)) ¶table-column-class
)) ¶table-column-class
)) ¶automatically generated reader method
table-column-class
)) ¶table-column-class
)) ¶dao-table-class
) &key if-not-exists &allow-other-keys) ¶symbol
) &rest args &key if-not-exists or-replace) ¶dao-table-view
) &key or-replace &allow-other-keys) ¶table-class
)) ¶table-class
)) ¶table-class
)) ¶Update the object OBJ into the DB.
dao-table-mixin
) &key) ¶sb-mop
.
table-class
) &key &allow-other-keys) ¶sb-mop
.
dao-table-view
) &key) ¶sb-mop
.
dao-table-class
) &key) ¶sb-mop
.
dao-table-class
) name &rest keys &key direct-superclasses &allow-other-keys) ¶sb-mop
.
dao-table-mixin
) &rest initargs &key conc-name &allow-other-keys) ¶dao-table-column-class
) &rest rest-initargs &key name readers writers inflate deflate &allow-other-keys) ¶table-class
) &rest initargs) ¶table-column-class
) &rest rest-initargs &key name initargs ghost &allow-other-keys) ¶dao-table-class
) &rest initargs) ¶dao-table-class
) &rest initargs &key direct-superclasses &allow-other-keys) ¶dao-table-mixin
) &rest initargs &key conc-name &allow-other-keys) ¶table-class
) &rest initargs) ¶dao-table-class
) &rest initargs) ¶dao-table-class
) &rest initargs &key direct-superclasses &allow-other-keys) ¶table-class
) (super standard-class
)) ¶sb-mop
.
drop-sequence
)) ¶sxql.sql-type
.
create-sequence
)) ¶sxql.sql-type
.
create-view
)) ¶sxql.sql-type
.
:slot
error
.
:table
boolean
(error ":as query is required for dao-table-view")
:as
This slot is read-only.
:id
standard-direct-slot-definition
.
(or symbol cons null)
:col-type
mito.class.column::references
:references
This slot is read-only.
boolean
:primary-key
Option to specify slots as ghost slots. Ghost slots do not depend on a database.
boolean
:ghost
(mito.dao.mixin::generate-uuid)
:id
name
.
as
.
name
.
name
.
name
.
Expand relational columns if the operator is :=, :!= , :in or :not-in.
name
.
serial-pk-mixin
)) ¶automatically generated reader method
id
.
serial-pk-mixin
)) ¶automatically generated writer method
id
.
uuid-pk-mixin
)) ¶automatically generated reader method
id
.
uuid-pk-mixin
)) ¶automatically generated writer method
id
.
table-column-class
)) ¶automatically generated reader method
table-column-class
)) ¶automatically generated writer method
expression-clause
.
sxql.sql-type
.
string
"set default"
Jump to: | %
(
A C D E F G I L M O P R S T U V W Y |
---|
Jump to: | %
(
A C D E F G I L M O P R S T U V W Y |
---|
Jump to: | *
+
A C D F G I K N O P R S T U V |
---|
Jump to: | *
+
A C D F G I K N O P R S T U V |
---|
Jump to: | C D E F I L M N P R S T U V |
---|
Jump to: | C D E F I L M N P R S T U V |
---|