Skip to content

Latest commit

 

History

History
414 lines (229 loc) · 7.56 KB

design.md

File metadata and controls

414 lines (229 loc) · 7.56 KB
Raw

Software Architectural Design -- Exasol SQL Statement Builder

Building Block View

Select Statement

dsn~dql-statement~1

The Data Query Language (DQL) building block is responsible for managing SELECT statements.

Solution Strategy

Fluent Programming

Statement Construction With Fluent Programming

dsn~statement-construction-with-fluent-programming~1

All statement builders use the "fluent programming" model, where the return type of each builder step determines the possible next structural elements that can be added.

Comment:

This is a design principle that cuts across the whole project. Therefore, locating it in a single test or implementation part makes no sense.

Covers:

  • req~statement-structure-limited-at-compile-time~1

Runtime View

Building Select Statements

Accessing the Clauses That Make Up a SELECT Statement

dsn~select-statement.out-of-order-clauses~1

SELECT commands allow attaching the following clauses in any order:

  • FROM clause
  • WHERE clause
  • LIMIT clause
  • GROUP BY clause
  • ORDER BY clause

Covers:

  • req~statement-structure.step-wise~1

Needs: impl, utest

Tags: Select Statement Builder

Using Literal Values

dsn~literal-values~2

Forwarded from requirements.

Covers:

  • req~literal-values~2

Needs: impl, utest

Building Arithmetic Expressions

Constructing Arithmetic Operations From Operator Enumeration

dsn~arithmetic-operation-from-enum~1

The ArithmeticExpression class allows creating expression objects from an enumeration.

Covers:

  • req~arithmetic-operators~1

Needs: impl, utest

Building Boolean Expressions

Boolean Operators

dsn~boolean-operators~1

Forwarded from requirements.

Covers:

  • req~boolean-operators~1

Needs: impl, utest

[NOT] LIKE Predicate

dsn~like-predicate~1

Forwarded from requirements.

Covers:

  • req~like-predicate~1

Needs: impl, utest

Predicate Operators

dsn~predicate-operators~1

Forwarded from requirements.

Covers:

  • req~predicate-operators~1

Needs: impl, utest

Boolean Literals

dsn~boolean-literals~1

Forwarded from requirements.

Covers:

  • req~boolean-literals~1

Needs: impl, utest

Comparison Operations

dsn~comparison-operations~1

Forwarded from requirements.

Covers:

  • req~comparison-operations~1

Needs: impl, utest

Constructing Boolean Comparison Operations From Operator Strings

dsn~boolean-operation.comparison.constructing-from-strings~1

The Boolean Expression builder allows creating expression objects from a string representing the comparison operator (options listed below) and a list of operands.

  • >
  • <
  • =
  • >=
  • <=
  • <>

Covers:

  • req~boolean-operators~1

Needs: impl, utest

Constructing Boolean Comparison Operations From Operator Enumeration

dsn~boolean-operation.comparison.constructing-from-enum~1

The Boolean Expression builder allows creating expression objects from a enumeration of comparison operators. Covers:

  • req~boolean-operators~1

Needs: impl, utest

Value Table

dsn~value-table~1

Forwarded from requirements.

Covers:

  • req~value-table~1

Needs: impl, utest

Building SELECT Statements

dsn~select-statements~1

Forwarded from requirements.

Covers:

  • req~select-statements~1

Needs: impl, utest

Building CREATE Statements

dsn~create-statements~1

Forwarded from requirements.

Covers:

  • req~create-statements~1

Needs: impl, utest

Building DROP Statements

dsn~drop-statements~1

Forwarded from requirements.

Covers:

  • req~drop-statements~1

Needs: impl, utest

Building INSERT Statements

INSERT Statements

dsn~insert-statements~1

Forwarded from requirements.

Covers:

  • req~insert-statements~1

Needs: impl, utest

Values as INSERT Source

dsn~values-as-insert-source~1

Covers:

Forwarded from requirements.

  • req~values-as-insert-source~1

Needs: impl, utest

Building MERGE Statements

dsn~merge-statements~1

Forwarded from requirements.

Covers:

  • req~merge-statements~1

Needs: impl, utest

Rendering Statements

Configurable Case Rendering

dsn~rendering.sql.configurable-case~1

Forwarded from requirements.

Covers:

  • req~rendering.sql.configurable-case~1

Needs: impl, utest

SELECT Statement Rendering

dsn~rendering.sql.select~1

Forwarded from requirements.

Covers:

  • req~rendering.sql.select~1

Needs: impl, utest

CREATE Statement Rendering

dsn~rendering.sql.create~1

Forwarded from requirements.

Covers:

  • req~rendering.sql.create~1

Needs: impl, utest

DROP Statement Rendering

dsn~rendering.sql.drop~1

Forwarded from requirements.

Covers:

  • req~rendering.sql.drop~1

Needs: impl, utest

INSERT Statement Rendering

dsn~rendering.sql.insert~1

Forwarded from requirements.

Covers:

  • req~rendering.sql.insert~1

Needs: impl, utest

MERGE Statement Rendering

dsn~rendering.sql.merge~1

Forwarded from requirements.

Covers:

  • req~rendering.sql.merge~1

Needs: impl, utest

Renderer add Double Quotes for Schema, Table and Column Identifiers

dsn~rendering.add-double-quotes-for-schema-table-and-column-identifiers~1

The renderer sets the following identifiers in double quotes if configured:

  • Schema identifiers
  • Table identifiers
  • Column identifiers (except the asterisks)

Comment:

Examples are "my_schema"."my_table"."my_field", "MY_TABLE"."MyField" and "MyTable".*

Covers:

  • req~rendering.sql.confiugrable-identifier-quoting~1

Needs: impl, utest

Exasol Dialect Specific

Converting from 64 bit Integers to INTERVAL DAY TO SECOND

dsn~exasol.converting-int-to-interval-day-to-second~2

The data converter converts signed integers to INTERVAL DAY TO SECOND.

Covers:

  • req~integer-interval-conversion~1

Needs: impl, utest

Converting from INTERVAL DAY TO SECOND to 64 bit Integers

dsn~exasol.converting-interval-day-to-second-to-int~1

The data converter converts INTERVAL DAY TO SECOND to signed integers.

Covers:

  • req~integer-interval-conversion~1

Needs: impl, utest

Parsing INTERVAL DAY TO SECOND From Strings

dsn~exasol.parsing-interval-day-to-second-from-strings~2

The data converter can parse INTERVAL DAY TO SECOND from strings in the following format:

interval-d2s = [ "+" / "-" ] [ days SP ] time-interval

time-interval = hours ":" minutes [ ":" seconds [ "." milliseconds ] ]

hours = ( "2" "0" - "3" ) / ( [ "0" / "1" ] DIGIT )

minutes = ( "5" DIGIT ) / ( [ "0" - "4" ] DIGIT )

seconds = ( "5" DIGIT ) / ( [ "0" - "4" ] DIGIT )

milliseconds = 1*3DIGIT

Examples are 12:30, 12:30.081 or 100 12:30:00.081.

Covers:

  • req~integer-interval-conversion~1

Needs: impl, utest

Converting from 64 bit Integers to INTERVAL YEAR TO MONTH

dsn~exasol.converting-int-to-interval-year-to-month~2

The data converter converts signed integers to INTERVAL YEAR TO MONTH.

Covers:

  • req~integer-interval-conversion~1

Needs: impl, utest

Converting from INTERVAL YEAR TO MONTH to 64 bit Integers

dsn~exasol.converting-interval-year-to-month-to-int~1

The data converter converts signed integers to INTERVAL YEAR TO MONTH.

Covers:

  • req~integer-interval-conversion~1

Needs: impl, utest

Parsing INTERVAL YEAR TO MONTH From Strings

dsn~exasol.parsing-interval-year-to-month-from-strings~2

The data converter can parse INTERVAL YEAR TO MONTH from strings in the following format:

interval-y2m = [ "+" / "-" ]  days "-" months

days = 1*9DIGIT

months = ( "1" "0" - "2" ) / DIGIT

Examples are 0-1 and 100-11.

Covers:

  • req~integer-interval-conversion~1

Needs: impl, utest