Index

_

__and__() (sqlpuzzle._queries.select.Select method) (sqlpuzzle._queries.union.Union method)

__or__() (sqlpuzzle._queries.select.Select method) (sqlpuzzle._queries.union.Union method)

A

all() (sqlpuzzle._queries.select.Select method) allow_delete_all() (sqlpuzzle._queries.delete.Delete method)

allow_update_all() (sqlpuzzle._queries.update.Update method) avg() (in module sqlpuzzle) avg_distinct() (in module sqlpuzzle)

C

C() (in module sqlpuzzle) columns() (sqlpuzzle._queries.select.Select method) concat() (in module sqlpuzzle) configure() (in module sqlpuzzle) ConfirmDeleteAllException

ConfirmException ConfirmUpdateAllException Convert (class in sqlpuzzle._queryparts.functions) convert() (in module sqlpuzzle) count() (in module sqlpuzzle) count_distinct() (in module sqlpuzzle)

D

Delete (class in sqlpuzzle._queries.delete) delete() (in module sqlpuzzle) (sqlpuzzle._queries.delete.Delete method)

delete_from() (in module sqlpuzzle) distinct() (sqlpuzzle._queries.select.Select method) distinctrow() (sqlpuzzle._queries.select.Select method)

E

EQ (class in sqlpuzzle.relations)

EQUAL_TO (in module sqlpuzzle.relations) exists() (in module sqlpuzzle)

F

fields_terminated_by() (sqlpuzzle._queries.select.Select method) for_update() (sqlpuzzle._queries.select.Select method) forbid_delete_all() (sqlpuzzle._queries.delete.Delete method) forbid_update_all() (sqlpuzzle._queries.update.Update method) from_() (sqlpuzzle._queries.delete.Delete method) (sqlpuzzle._queries.select.Select method)

from_table() (sqlpuzzle._queries.delete.Delete method) (sqlpuzzle._queries.select.Select method) from_tables() (sqlpuzzle._queries.delete.Delete method) (sqlpuzzle._queries.select.Select method) full_join() (sqlpuzzle._queries.select.Select method)

G

GE (class in sqlpuzzle.relations) GRATHER_THAN (in module sqlpuzzle.relations) GRATHER_THAN_OR_EQUAL_TO (in module sqlpuzzle.relations)

group_by() (sqlpuzzle._queries.select.Select method) group_concat() (in module sqlpuzzle) GroupConcat (class in sqlpuzzle._queryparts.functions) GT (class in sqlpuzzle.relations)

H

has() (sqlpuzzle._queries.select.Select method)

having() (sqlpuzzle._queries.select.Select method) high_priority() (sqlpuzzle._queries.select.Select method)

I

ignore() (sqlpuzzle._queries.delete.Delete method) (sqlpuzzle._queries.insert.Insert method) (sqlpuzzle._queries.update.Update method) IN (class in sqlpuzzle.relations) inner_join() (sqlpuzzle._queries.delete.Delete method) (sqlpuzzle._queries.select.Select method) (sqlpuzzle._queries.update.Update method) Insert (class in sqlpuzzle._queries.insert)

insert() (in module sqlpuzzle) insert_into() (in module sqlpuzzle) into() (sqlpuzzle._queries.insert.Insert method) into_outfile() (sqlpuzzle._queries.select.Select method) InvalidArgumentException InvalidQueryException IS (class in sqlpuzzle.relations) IS_NOT (class in sqlpuzzle.relations)

J

join() (sqlpuzzle._queries.delete.Delete method) (sqlpuzzle._queries.select.Select method) (sqlpuzzle._queries.update.Update method)

L

LE (class in sqlpuzzle.relations) left_join() (sqlpuzzle._queries.delete.Delete method) (sqlpuzzle._queries.select.Select method) (sqlpuzzle._queries.update.Update method) LESS_THAN (in module sqlpuzzle.relations)

LESS_THAN_OR_EQUAL_TO (in module sqlpuzzle.relations) LIKE (class in sqlpuzzle.relations) limit() (sqlpuzzle._queries.select.Select method) lines_terminated_by() (sqlpuzzle._queries.select.Select method) LT (class in sqlpuzzle.relations)

M

max() (in module sqlpuzzle) max_distinct() (in module sqlpuzzle)

min() (in module sqlpuzzle) min_distinct() (in module sqlpuzzle)

N

NE (class in sqlpuzzle.relations) NOT_EQUAL_TO (in module sqlpuzzle.relations)

NOT_IN (class in sqlpuzzle.relations) NOT_LIKE (class in sqlpuzzle.relations)

O

offset() (sqlpuzzle._queries.select.Select method) on() (sqlpuzzle._queries.delete.Delete method) (sqlpuzzle._queries.select.Select method) (sqlpuzzle._queries.update.Update method)

on_duplicate_key_update() (sqlpuzzle._queries.insert.Insert method) optionally_enclosed_by() (sqlpuzzle._queries.select.Select method) order_by() (sqlpuzzle._queries.select.Select method) (sqlpuzzle._queryparts.functions.GroupConcat method)

Q

Q() (in module sqlpuzzle)

R

R() (in module sqlpuzzle) REGEXP (class in sqlpuzzle.relations)

right_join() (sqlpuzzle._queries.delete.Delete method) (sqlpuzzle._queries.select.Select method) (sqlpuzzle._queries.update.Update method)

S

Select (class in sqlpuzzle._queries.select) select() (in module sqlpuzzle) select_from() (in module sqlpuzzle) separator() (sqlpuzzle._queryparts.functions.GroupConcat method) set() (sqlpuzzle._queries.update.Update method) sql_big_result() (sqlpuzzle._queries.select.Select method) sql_buffer_result() (sqlpuzzle._queries.select.Select method) sql_cache() (sqlpuzzle._queries.select.Select method) sql_calc_found_rows() (sqlpuzzle._queries.select.Select method)

sql_no_cache() (sqlpuzzle._queries.select.Select method) sql_small_result() (sqlpuzzle._queries.select.Select method) sqlpuzzle (module) sqlpuzzle.exceptions (module) sqlpuzzle.relations (module) SqlPuzzleException straight_join() (sqlpuzzle._queries.select.Select method) sum() (in module sqlpuzzle) sum_distinct() (in module sqlpuzzle)

T

table() (sqlpuzzle._queries.update.Update method)

to() (sqlpuzzle._queryparts.functions.Convert method)

U

Union (class in sqlpuzzle._queries.union)

Update (class in sqlpuzzle._queries.update) update() (in module sqlpuzzle)

V

V() (in module sqlpuzzle)

values() (sqlpuzzle._queries.insert.Insert method)

W

where() (sqlpuzzle._queries.delete.Delete method) (sqlpuzzle._queries.select.Select method) (sqlpuzzle._queries.update.Update method)