Common Lisp Package: WEBLOCKS-CLSQL

A driver for weblocks backend store API that connects to CLSQL.

README:

FUNCTION

Public

ORDER-BY-EXPRESSION (CLASS-NAME ORDER-BY)

Converts the 'order-by' argument to a SQL expression.

RANGE-TO-LIMIT (RANGE)

Converts the 'range' argument to SQL LIMIT.

RANGE-TO-OFFSET (RANGE)

Converts the 'range' argument to SQL OFFSET.

Private

CLASS-ORDER-BY-JOIN-CLASSES (CLASS-NAME ORDER-BY)

Returns a list of class names that need to be selected to find instances of 'class-name' and order them with 'order-by'.

CLASS-ORDER-BY-JOIN-WHERE (CLASS-NAME ORDER-BY)

Returns a 'where' expression that joins classes determined by 'class-order-by-join-classes' in order to find instances of 'class-name' and order them with 'order-by'.

FORMAT-DATE (FORMAT DATE &OPTIONAL STREAM (TIME-ZONE NIL TZ-SUPPLIED?))

Formats universal dates using the same format specifiers as NSDateFormatter. The format is: %% - A '%' character %a - Abbreviated weekday name %A - Full weekday name %b - Abbreviated month name %B - Full month name %c - Shorthand for "%X %x", the locale format for date and time %d - Day of the month as a decimal number [01-31] %e - Same as %d but does not print the leading 0 for days 1 through 9 [unlike strftime[], does not print a leading space] %F - Milliseconds as a decimal number [000-999] %H - Hour based on a 24-hour clock as a decimal number [00-23] %I - Hour based on a 12-hour clock as a decimal number [01-12] %j - Day of the year as a decimal number [001-366] %m - Month as a decimal number [01-12] %M - Minute as a decimal number [00-59] %p - AM/PM designation for the locale %S - Second as a decimal number [00-59] %w - Weekday as a decimal number [0-6], where Sunday is 0 %x - Date using the date representation for the locale, including the time zone [produces different results from strftime[]] %X - Time using the time representation for the locale [produces different results from strftime[]] %y - Year without century [00-99] %Y - Year with century [such as 1990] %Z - Time zone name [such as Pacific Daylight Time; produces different results from strftime[]] %z - Time zone offset in hours and minutes from GMT [HHMM] None of %c, %F, %x, %X, %Z are implemented.

SLOT-DB-INFO (CLASS SLOT-NAME)

Returns clsql db-info structure.

SLOT-ACCESSOR

Private

Undocumented

FILTER (OBJECT)