stch.sql.ddl — stch-library/sql 0.1.3

SQL DSL for data definition language (DDL). Supports a majority of MySQL's statements for tables and databases.

add clj

(add m spec)

(add m spec options)

Inputs: [m :- TableSpec spec] [m :- TableSpec spec options] Returns: TableSpec

Add column/index. Use with alt.

after clj

(after col)

Inputs: [col :- NamedOrColumn] Returns: ColumnPosition

Set column position. Use with add.

alt clj

(alt spec)

Inputs: [spec :- TableSpec] Returns: String

Alter a table.

alt-db clj

(alt-db db option)

Inputs: [db :- NamedOrDB, option :- TableOption] Returns: String

Alter a database.

AlterAdd clj protocol

-add clj

(-add spec m)

(-add spec m options)

append clj

(append m x)

Inputs: [m :- TableSpec, x :- (U Columns ColumnSpec Index)] Returns: TableSpec

Append a set of columns/indexes or single column/index to a table.

auto-inc clj

(auto-inc start)

Inputs: [start :- Int] Returns: TableOption

Set the auto-increment table option.

big-int clj

(big-int & [arg0__3456__auto__ & args__3457__auto__])

big-serial clj

(big-serial & [arg0__3456__auto__ & args__3457__auto__])

binary clj

(binary & [arg0__3456__auto__ & args__3457__auto__])

blob clj

(blob & [arg0__3456__auto__ & args__3457__auto__])

bool clj

(bool & [arg0__3456__auto__ & args__3457__auto__])

change clj

(change m col col-spec)

Inputs: [m :- TableSpec, col :- NamedOrColumn, col-spec :- ColumnSpec] Returns: TableSpec

Change column. Use with alt.

char' clj

character-set clj

(character-set charset)

Inputs: [charset :- Named] Returns: TableOption

Set the character set table option.

chr clj

(chr & [arg0__3456__auto__ & args__3457__auto__])

collate clj

(collate collation)

Inputs: [collation :- Named] Returns: TableOption

Set the collate table option.

column clj

(column col-name col-type options)

Inputs: [col-name col-type options] Returns: ColumnSpec

column? clj

(column? x)

Inputs: [x :- Any] Returns: Boolean

ColumnOptions clj

Column options type definition.

ColumnOrIndex clj

Column or index type definition.

columns clj

(columns)

Inputs: [] Returns: Columns

columns? clj

(columns? x)

Inputs: [x :- Any] Returns: Boolean

constraint clj

(constraint & [arg0 & args])

Define a named constraint. Use with an index fn.

create clj

(create spec & options)

Inputs: [spec :- TableOrDB & options :- [TableOption]] Returns: String

Create a table or database with options.

date clj

(date & [arg0__3456__auto__ & args__3457__auto__])

datetime clj

(datetime & [arg0__3456__auto__ & args__3457__auto__])

db clj

(db db-name)

Inputs: [db-name :- Named] Returns: DBSpec

Create a database.

db? clj

(db? x)

Inputs: [x :- Any] Returns: Boolean

decimal clj

(decimal & [arg0__3456__auto__ & args__3457__auto__])

default clj

(default x)

Inputs: [x :- (U Number String)] Returns: DefaultValueSpec

Set the default value for a column. Use with a column fn.

defcolumns clj macro

(defcolumns name & columns+keys)

Define one or more columns.

defindexfn clj macro

(defindexfn fn-name index-type)

Define an index fn.

deftable clj macro

(deftable table-name & columns+keys)

deftypefn clj macro

(deftypefn fn-name col-type)

Define a type fn (e.g., int, varchar).

double' clj

(double' & [arg0__3456__auto__ & args__3457__auto__])

drop-column clj

(drop-column m col)

Inputs: [m :- TableSpec, col :- NamedOrColumn] Returns: TableSpec

Drop a column. Use with alt.

drop-db clj

(drop-db db)

Inputs: [db :- NamedOrDB] Returns: String

Drop a database.

drop-default clj

(drop-default m col)

Inputs: [m :- TableSpec, col :- NamedOrColumn] Returns: TableSpec

Drop column default. Use with alt.

drop-foreign-key clj

(drop-foreign-key m fk)

Inputs: [m :- TableSpec, fk :- NamedOrConstraint] Returns: TableSpec

Drop a foreign key. Use with alt.

drop-index clj

(drop-index m index)

Inputs: [m :- TableSpec, index :- NamedOrConstraint] Returns: TableSpec

Drop an index. Use with alt.

drop-primary-key clj

(drop-primary-key m)

Inputs: [m :- TableSpec] Returns: TableSpec

Drop a primary key. Use with alt.

drop-table clj

(drop-table & tables)

Inputs: [& tables :- [NamedOrTable]] Returns: String

Drop one or more tables.

drop-temp-table clj

(drop-temp-table & tables)

Inputs: [& tables :- [NamedOrTable]] Returns: String

Drop one or more tables.

engine clj

(engine eng)

Inputs: [eng :- Named] Returns: TableOption

Set the engine table option.

enum clj

(enum & [arg0__3456__auto__ & args__3457__auto__])

float' clj

(float' & [arg0__3456__auto__ & args__3457__auto__])

foreign-key clj

(foreign-key & [arg0 & args])

Define a foreign key. Use with create or alt.

fulltext clj

(fulltext & [arg0__3766__auto__ & args__3767__auto__])

geometry clj

(geometry & [arg0__3456__auto__ & args__3457__auto__])

idx clj

(idx index-type index-cols)

Inputs: [index-type index-cols] Returns: IndexSpec

Index clj

Index type definition.

index clj

(index & [arg0__3766__auto__ & args__3767__auto__])

index? clj

(index? x)

Inputs: [x :- Any] Returns: Boolean

integer clj

(integer & [arg0__3456__auto__ & args__3457__auto__])

KeywordOrSym clj

Keyword or symbol type definition.

linestring clj

(linestring & [arg0__3456__auto__ & args__3457__auto__])

medium-int clj

(medium-int & [arg0__3456__auto__ & args__3457__auto__])

NamedOrColumn clj

Named or column spec type definition.

NamedOrConstraint clj

NamedOrDB clj

Named or DB spec type definition.

NamedOrTable clj

Named or table spec type definition.

point clj

(point & [arg0__3456__auto__ & args__3457__auto__])

polygon clj

(polygon & [arg0__3456__auto__ & args__3457__auto__])

primary-key clj

(primary-key & [arg0__3766__auto__ & args__3767__auto__])

rename clj

(rename m table)

Inputs: [m :- TableSpec, table :- NamedOrTable] Returns: TableSpec

Rename a table. Use with alt.

rename-db clj

(rename-db old-db new-db)

Inputs: [old-db :- NamedOrDB, new-db :- NamedOrDB] Returns: String

Rename a database.

serial clj

(serial & [arg0__3456__auto__ & args__3457__auto__])

set' clj

(set' & [arg0__3456__auto__ & args__3457__auto__])

set-default clj

(set-default m col default)

Inputs: [m :- TableSpec, col :- NamedOrColumn, default :- (U String Number)] Returns: TableSpec

Set column default. Use with alt.

small-int clj

(small-int & [arg0__3456__auto__ & args__3457__auto__])

small-serial clj

(small-serial & [arg0__3456__auto__ & args__3457__auto__])

spatial clj

(spatial & [arg0__3766__auto__ & args__3767__auto__])

strict-map->AddColumnSpec clj

(strict-map->AddColumnSpec m3386 & [drop-extra-keys?__1991__auto__])

Factory function for class AddColumnSpec, taking a map of keywords to field values. All keys are required, and no extra keys are allowed. Even faster than map->

strict-map->AddIndexSpec clj

(strict-map->AddIndexSpec m4315 & [drop-extra-keys?__1991__auto__])

Factory function for class AddIndexSpec, taking a map of keywords to field values. All keys are required, and no extra keys are allowed. Even faster than map->

strict-map->ChangeSpec clj

(strict-map->ChangeSpec m4361 & [drop-extra-keys?__1991__auto__])

Factory function for class ChangeSpec, taking a map of keywords to field values. All keys are required, and no extra keys are allowed. Even faster than map->

strict-map->ColumnPosition clj

(strict-map->ColumnPosition m3317 & [drop-extra-keys?__1991__auto__])

Factory function for class ColumnPosition, taking a map of keywords to field values. All keys are required, and no extra keys are allowed. Even faster than map->

strict-map->Columns clj

(strict-map->Columns m4116 & [drop-extra-keys?__1991__auto__])

Factory function for class Columns, taking a map of keywords to field values. All keys are required, and no extra keys are allowed. Even faster than map->

strict-map->ColumnSpec clj

(strict-map->ColumnSpec m3241 & [drop-extra-keys?__1991__auto__])

Factory function for class ColumnSpec, taking a map of keywords to field values. All keys are required, and no extra keys are allowed. Even faster than map->

strict-map->ConstraintSpec clj

(strict-map->ConstraintSpec m3891 & [drop-extra-keys?__1991__auto__])

Factory function for class ConstraintSpec, taking a map of keywords to field values. All keys are required, and no extra keys are allowed. Even faster than map->

strict-map->DBSpec clj

(strict-map->DBSpec m3101 & [drop-extra-keys?__1991__auto__])

Factory function for class DBSpec, taking a map of keywords to field values. All keys are required, and no extra keys are allowed. Even faster than map->

strict-map->DefaultValueSpec clj

(strict-map->DefaultValueSpec m3179 & [drop-extra-keys?__1991__auto__])

Factory function for class DefaultValueSpec, taking a map of keywords to field values. All keys are required, and no extra keys are allowed. Even faster than map->

strict-map->DropColumnSpec clj

(strict-map->DropColumnSpec m4566 & [drop-extra-keys?__1991__auto__])

Factory function for class DropColumnSpec, taking a map of keywords to field values. All keys are required, and no extra keys are allowed. Even faster than map->

strict-map->DropDefaultSpec clj

(strict-map->DropDefaultSpec m4503 & [drop-extra-keys?__1991__auto__])

Factory function for class DropDefaultSpec, taking a map of keywords to field values. All keys are required, and no extra keys are allowed. Even faster than map->

strict-map->DropForeignKeySpec clj

(strict-map->DropForeignKeySpec m4747 & [drop-extra-keys?__1991__auto__])

Factory function for class DropForeignKeySpec, taking a map of keywords to field values. All keys are required, and no extra keys are allowed. Even faster than map->

strict-map->DropIndexSpec clj

(strict-map->DropIndexSpec m4629 & [drop-extra-keys?__1991__auto__])

Factory function for class DropIndexSpec, taking a map of keywords to field values. All keys are required, and no extra keys are allowed. Even faster than map->

strict-map->DropPrimaryKeySpec clj

(strict-map->DropPrimaryKeySpec m4692 & [drop-extra-keys?__1991__auto__])

Factory function for class DropPrimaryKeySpec, taking a map of keywords to field values. All keys are required, and no extra keys are allowed. Even faster than map->

strict-map->ForeignKeySpec clj

(strict-map->ForeignKeySpec m3820 & [drop-extra-keys?__1991__auto__])

Factory function for class ForeignKeySpec, taking a map of keywords to field values. All keys are required, and no extra keys are allowed. Even faster than map->

strict-map->IndexSpec clj

(strict-map->IndexSpec m3697 & [drop-extra-keys?__1991__auto__])

Factory function for class IndexSpec, taking a map of keywords to field values. All keys are required, and no extra keys are allowed. Even faster than map->

strict-map->RenameSpec clj

(strict-map->RenameSpec m4810 & [drop-extra-keys?__1991__auto__])

Factory function for class RenameSpec, taking a map of keywords to field values. All keys are required, and no extra keys are allowed. Even faster than map->

strict-map->SetDefaultSpec clj

(strict-map->SetDefaultSpec m4432 & [drop-extra-keys?__1991__auto__])

Factory function for class SetDefaultSpec, taking a map of keywords to field values. All keys are required, and no extra keys are allowed. Even faster than map->

strict-map->TableOption clj

(strict-map->TableOption m4198 & [drop-extra-keys?__1991__auto__])

Factory function for class TableOption, taking a map of keywords to field values. All keys are required, and no extra keys are allowed. Even faster than map->

strict-map->TableSpec clj

(strict-map->TableSpec m3973 & [drop-extra-keys?__1991__auto__])

Factory function for class TableSpec, taking a map of keywords to field values. All keys are required, and no extra keys are allowed. Even faster than map->

table clj

(table table-name)

Inputs: [table-name :- Named] Returns: TableSpec

table? clj

(table? x)

Inputs: [x :- Any] Returns: Boolean

TableOrDB clj

Table spec or DB spec type definition.

temp-table clj

(temp-table table-name)

Inputs: [table-name :- Named] Returns: TableSpec

text clj

(text & [arg0__3456__auto__ & args__3457__auto__])

time' clj

(time' & [arg0__3456__auto__ & args__3457__auto__])

timestamp clj

(timestamp & [arg0__3456__auto__ & args__3457__auto__])

tiny-int clj

(tiny-int & [arg0__3456__auto__ & args__3457__auto__])

ToSQL clj protocol

Convert an object to SQL.

to-sql clj

(to-sql x)

truncate clj

(truncate table)

Inputs: [table :- NamedOrTable] Returns: String

Truncate a table.

unique clj

(unique & [arg0__3766__auto__ & args__3767__auto__])

varbinary clj

(varbinary & [arg0__3456__auto__ & args__3457__auto__])

varchar clj

(varchar & [arg0__3456__auto__ & args__3457__auto__])

WhatsMyName clj protocol

whats-my-name clj

(whats-my-name x)

year clj

(year & [arg0__3456__auto__ & args__3457__auto__])