C# Class TDSM.Core.Data.Old.QueryBuilder

The bare implementation of a query builder

Inheritance: IDisposable

显示文件 Open project: DeathCradle/Terraria-s-Dedicated-Server-Mod

Public Methods

Method	Description
AddParam ( string name, object value, string prefix = "prm" ) : QueryBuilder	Adds a parameter.
All ( ) : QueryBuilder	Adds the all expression to the query
BuildCommand ( ) : string	Builds the command.
Count ( string expression = null ) : QueryBuilder	Adds the count expression
Delete ( ) : QueryBuilder	Add a DELETE statement
Delete ( string tableName ) : QueryBuilder	Build a DELETE statement
From ( string tableName ) : QueryBuilder	Adds the from table selector
InsertInto ( string tableName ) : QueryBuilder	Add an INSERT TO statement
QueryBuilder ( string pluginName ) : System
Select ( ) : QueryBuilder	Begins a SELECT query
SelectAll ( string tableName ) : QueryBuilder	Builds a SELECT ALL (*) query
SelectFrom ( string tableName, string expression = null ) : QueryBuilder	Builds a SELECT [EXPRESSION] FROM query
TableCreate ( string name ) : QueryBuilder	Creates a table
TableDrop ( string name ) : QueryBuilder	Drops a table
TableExists ( string name ) : QueryBuilder	Check if a table exists
Update ( string tableName, DataParameter values ) : QueryBuilder	Builds an UPDATE query
UpdateValues ( string tableName, DataParameter values ) : QueryBuilder	Adds a UPDATE statement with specified columns and values
Where ( ) : QueryBuilder	Adds a filter on data

Protected Methods

Method	Description
Append ( string fmt ) : QueryBuilder
GetObjectName ( string name ) : string

Private Methods

Method	Description
IDisposable ( ) : void

Method Details

AddParam() public abstract method

Adds a parameter.

public abstract AddParam ( string name, object value, string prefix = "prm" ) : QueryBuilder
name	string	Name.
value	object	Value.
prefix	string	Prefix.
return	QueryBuilder

All() public abstract method

Adds the all expression to the query

public abstract All ( ) : QueryBuilder
return	QueryBuilder

Append() protected method

protected Append ( string fmt ) : QueryBuilder
fmt	string
return	QueryBuilder

BuildCommand() public method

Builds the command.

public BuildCommand ( ) : string
return	string

Count() public abstract method

Adds the count expression

public abstract Count ( string expression = null ) : QueryBuilder
expression	string	Expression.
return	QueryBuilder

Delete() public abstract method

Add a DELETE statement

public abstract Delete ( ) : QueryBuilder
return	QueryBuilder

Delete() public method

Build a DELETE statement

public Delete ( string tableName ) : QueryBuilder
tableName	string	Table name.
return	QueryBuilder

From() public abstract method

Adds the from table selector

public abstract From ( string tableName ) : QueryBuilder
tableName	string	Table name.
return	QueryBuilder

GetObjectName() protected method

protected GetObjectName ( string name ) : string
name	string
return	string

InsertInto() public abstract method

Add an INSERT TO statement

public abstract InsertInto ( string tableName ) : QueryBuilder
tableName	string	Table name.
return	QueryBuilder

QueryBuilder() public method

public QueryBuilder ( string pluginName ) : System
pluginName	string
return	System

Select() public abstract method

Begins a SELECT query

public abstract Select ( ) : QueryBuilder
return	QueryBuilder

SelectAll() public method

Builds a SELECT ALL (*) query

public SelectAll ( string tableName ) : QueryBuilder
tableName	string	Table name.
return	QueryBuilder

SelectFrom() public method

Builds a SELECT [EXPRESSION] FROM query

public SelectFrom ( string tableName, string expression = null ) : QueryBuilder
tableName	string	Table name.
expression	string	Expression.
return	QueryBuilder

TableCreate() public abstract method

Creates a table

public abstract TableCreate ( string name ) : QueryBuilder
name	string	Name.
return	QueryBuilder

TableDrop() public abstract method

Drops a table

public abstract TableDrop ( string name ) : QueryBuilder
name	string	Name.
return	QueryBuilder

TableExists() public abstract method

Check if a table exists

public abstract TableExists ( string name ) : QueryBuilder
name	string	Name.
return	QueryBuilder

Update() public method

Builds an UPDATE query

public Update ( string tableName, DataParameter values ) : QueryBuilder
tableName	string	Table name.
values	DataParameter	Values.
return	QueryBuilder

UpdateValues() public abstract method

Adds a UPDATE statement with specified columns and values

public abstract UpdateValues ( string tableName, DataParameter values ) : QueryBuilder
tableName	string	Table name.
values	DataParameter	Values.
return	QueryBuilder

Where() public abstract method

Adds a filter on data

public abstract Where ( ) : QueryBuilder
return	QueryBuilder