Energy.Query.Format Class Reference

Text formatter class for SQL queries. More...

Classes
class	Class

Public Member Functions
	Format ()
	Default constructor More...
	Format (string dialect)
	Parametrized constructor More...
string	Object (string value)
	Format as database object (table, column, ...). More...
string	Object (string database, string schema, string name)
string	Object (string schema, string name)
string	Text (string value)
	Format as TEXT. Null values will be represented as "NULL". More...
string	Text (string value, bool nullify)
	Format as TEXT. When nullify parameter is set to true, null values will be represented as "NULL" instead of "''". More...
string	Text (string text, int limit)
	Format as TEXT with limited length. More...
string	Text (object value)
	Format as TEXT. More...
string	Unicode (string name)
	Format as Unicode TEXT. More...
string	Unicode (string name, bool nullify)
	Format as Unicode TEXT. More...
string	Number (object value)
	Format as NUMBER. More...
string	Number (object value, bool nullify)
	Format as NUMBER. More...
string	Integer (decimal number)
	Format as INTEGER. More...
string	Integer (double number)
	Format as INTEGER. More...
string	Integer (int number)
	Format as INTEGER. More...
string	Integer (object number, bool nullify)
	Format as INTEGER. More...
string	Date (DateTime value)
	Format as DATE. More...
string	Date (object value)
	Format as DATE. More...
string	Time (DateTime value)
	Format as TIME. More...
string	Time (object value)
	Format as TIME. More...
string	Stamp (DateTime value)
	Format as DATETIME. More...
string	Stamp (object value)
	Format as DATETIME. More...
string	Now ()
	Format as current time equivalent. More...

Static Public Member Functions
static implicit	operator Format (Energy.Enumeration.SqlDialect dialect)
	Create object from SqlDialect enumeration More...
static implicit	operator Format (string dialect)
	Create object from string More...

Public Attributes
Class.Bracket	Bracket = new Class.Bracket()
	Quotation settings More...
bool	UseT
	Use TZ format for DATETIME. More...
string	CurrentStamp

Properties
static Energy.Query.Format	Default [get]
	Singleton More...

Detailed Description

Text formatter class for SQL queries.

Constructor & Destructor Documentation

Format() [1/2]

Energy.Query.Format.Format

(

)

Default constructor

Format() [2/2]

Energy.Query.Format.Format

(

string

dialect

)

Parametrized constructor

Parameters

dialect

Database SQL dialect to use for defaults

Member Function Documentation

Date() [1/2]

string Energy.Query.Format.Date

(

DateTime

value

)

Format as DATE.

Parameters

value

Returns

Date() [2/2]

string Energy.Query.Format.Date

(

object

value

)

Format as DATE.

Parameters

value

Returns

Integer() [1/4]

string Energy.Query.Format.Integer

(

decimal

number

)

Format as INTEGER.

Parameters

number

decimal

Returns

string

Integer() [2/4]

string Energy.Query.Format.Integer

(

double

number

)

Format as INTEGER.

Parameters

number

Returns

string

Integer() [3/4]

string Energy.Query.Format.Integer

(

int

number

)

Format as INTEGER.

Parameters

number

Returns

string

Integer() [4/4]

string Energy.Query.Format.Integer	(	object	number,
		bool	nullify
	)

Format as INTEGER.

Parameters

number
nullify

Returns

string

Now()

string Energy.Query.Format.Now

(

)

Format as current time equivalent.

Returns

string

Number() [1/2]

string Energy.Query.Format.Number

(

object

value

)

Format as NUMBER.

Parameters

value

Returns

Number() [2/2]

string Energy.Query.Format.Number	(	object	value,
		bool	nullify
	)

Format as NUMBER.

Parameters

value
nullify

Returns

Object() [1/3]

string Energy.Query.Format.Object

(

string

value

)

Format as database object (table, column, ...).

Parameters

value

Returns

Object() [2/3]

string Energy.Query.Format.Object	(	string	database,
		string	schema,
		string	name
	)

Parameters

database
schema
name

Returns

Object() [3/3]

string Energy.Query.Format.Object	(	string	schema,
		string	name
	)

Parameters

schema
name

Returns

operator Format() [1/2]

static implicit Energy.Query.Format.operator Format ( Energy.Enumeration.SqlDialect  dialect )

static

Create object from SqlDialect enumeration

Parameters

dialect

operator Format() [2/2]

static implicit Energy.Query.Format.operator Format ( string  dialect )

static

Create object from string

Parameters

dialect

Stamp() [1/2]

string Energy.Query.Format.Stamp

(

DateTime

value

)

Format as DATETIME.

Parameters

value

Returns

Stamp() [2/2]

string Energy.Query.Format.Stamp

(

object

value

)

Format as DATETIME.

Parameters

value

Returns

Text() [1/4]

string Energy.Query.Format.Text

(

string

value

)

Format as TEXT. Null values will be represented as "NULL".

Parameters

value

Returns

Text() [2/4]

string Energy.Query.Format.Text	(	string	value,
		bool	nullify
	)

Format as TEXT. When nullify parameter is set to true, null values will be represented as "NULL" instead of "''".

Parameters

value
nullify

Returns

string

Text() [3/4]

string Energy.Query.Format.Text	(	string	text,
		int	limit
	)

Format as TEXT with limited length.

Parameters

text
limit

Returns

string

Text() [4/4]

string Energy.Query.Format.Text

(

object

value

)

Format as TEXT.

Parameters

value

object

Returns

static

Time() [1/2]

string Energy.Query.Format.Time

(

DateTime

value

)

Format as TIME.

Parameters

value

Returns

Time() [2/2]

string Energy.Query.Format.Time

(

object

value

)

Format as TIME.

Parameters

value

Returns

Unicode() [1/2]

string Energy.Query.Format.Unicode

(

string

name

)

Format as Unicode TEXT.

Parameters

name

Returns

string

Unicode() [2/2]

string Energy.Query.Format.Unicode	(	string	name,
		bool	nullify
	)

Format as Unicode TEXT.

Parameters

name
nullify

Returns

string

Member Data Documentation

Bracket

Class.Bracket Energy.Query.Format.Bracket = new Class.Bracket()

Quotation settings

CurrentStamp

string Energy.Query.Format.CurrentStamp

UseT

bool Energy.Query.Format.UseT

Use TZ format for DATETIME.

Property Documentation

Default

Energy.Query.Format Energy.Query.Format.Default

staticget

Singleton

---

The documentation for this class was generated from the following file:

• Query/Format.cs