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

The bare implementation of a query builder

Inheritance: IDisposable

Afficher le fichier Open project: DeathCradle/Terraria-s-Dedicated-Server-Mod

Méthodes publiques

Méthode	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

Méthodes protégées

Méthode	Description
Append ( string fmt ) : QueryBuilder
GetObjectName ( string name ) : string

Private Methods

Méthode	Description
IDisposable ( ) : void

Method Details

AddParam() public abstract méthode

Adds a parameter.

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

All() public abstract méthode

Adds the all expression to the query

public abstract All ( ) : QueryBuilder
Résultat	QueryBuilder

Append() protected méthode

protected Append ( string fmt ) : QueryBuilder
fmt	string
Résultat	QueryBuilder

BuildCommand() public méthode

Builds the command.

public BuildCommand ( ) : string
Résultat	string

Count() public abstract méthode

Adds the count expression

public abstract Count ( string expression = null ) : QueryBuilder
expression	string	Expression.
Résultat	QueryBuilder

Delete() public abstract méthode

Add a DELETE statement

public abstract Delete ( ) : QueryBuilder
Résultat	QueryBuilder

Delete() public méthode

Build a DELETE statement

public Delete ( string tableName ) : QueryBuilder
tableName	string	Table name.
Résultat	QueryBuilder

From() public abstract méthode

Adds the from table selector

public abstract From ( string tableName ) : QueryBuilder
tableName	string	Table name.
Résultat	QueryBuilder

GetObjectName() protected méthode

protected GetObjectName ( string name ) : string
name	string
Résultat	string

InsertInto() public abstract méthode

Add an INSERT TO statement

public abstract InsertInto ( string tableName ) : QueryBuilder
tableName	string	Table name.
Résultat	QueryBuilder

QueryBuilder() public méthode

public QueryBuilder ( string pluginName ) : System
pluginName	string
Résultat	System

Select() public abstract méthode

Begins a SELECT query

public abstract Select ( ) : QueryBuilder
Résultat	QueryBuilder

SelectAll() public méthode

Builds a SELECT ALL (*) query

public SelectAll ( string tableName ) : QueryBuilder
tableName	string	Table name.
Résultat	QueryBuilder

SelectFrom() public méthode

Builds a SELECT [EXPRESSION] FROM query

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

TableCreate() public abstract méthode

Creates a table

public abstract TableCreate ( string name ) : QueryBuilder
name	string	Name.
Résultat	QueryBuilder

TableDrop() public abstract méthode

Drops a table

public abstract TableDrop ( string name ) : QueryBuilder
name	string	Name.
Résultat	QueryBuilder

TableExists() public abstract méthode

Check if a table exists

public abstract TableExists ( string name ) : QueryBuilder
name	string	Name.
Résultat	QueryBuilder

Update() public méthode

Builds an UPDATE query

public Update ( string tableName, DataParameter values ) : QueryBuilder
tableName	string	Table name.
values	DataParameter	Values.
Résultat	QueryBuilder

UpdateValues() public abstract méthode

Adds a UPDATE statement with specified columns and values

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

Where() public abstract méthode

Adds a filter on data

public abstract Where ( ) : QueryBuilder
Résultat	QueryBuilder