Class MySqlSnippets

Namespace

Uncreated.Warfare.Database.Manual

Assembly

Uncreated.Warfare.dll

public static class MySqlSnippets

Inheritance

object

MySqlSnippets

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Methods

AliasedColumnList(string, string)

Create a list of comma-separated columns with their alias name with back-ticks surrounding the column and alias name.

public static string AliasedColumnList(string alias, string p)

Parameters

alias string

p string

Returns

string

AliasedColumnList(string, string, string)

Create a list of comma-separated columns with their alias name with back-ticks surrounding the column and alias name.

public static string AliasedColumnList(string alias, string p1, string p2)

Parameters

alias string

p1 string

p2 string

Returns

string

AliasedColumnList(string, string, string, string)

Create a list of comma-separated columns with their alias name with back-ticks surrounding the column and alias name.

public static string AliasedColumnList(string alias, string p1, string p2, string p3)

Parameters

alias string

p1 string

p2 string

p3 string

Returns

string

AliasedColumnList(string, string, string, string, string)

Create a list of comma-separated columns with their alias name with back-ticks surrounding the column and alias name.

public static string AliasedColumnList(string alias, string p1, string p2, string p3, string p4)

Parameters

alias string

p1 string

p2 string

p3 string

p4 string

Returns

string

AliasedColumnList(string, string, string, string, string, string)

Create a list of comma-separated columns with their alias name with back-ticks surrounding the column and alias name.

public static string AliasedColumnList(string alias, string p1, string p2, string p3, string p4, string p5)

Parameters

alias string

p1 string

p2 string

p3 string

p4 string

p5 string

Returns

string

AliasedColumnList(string, string, string, string, string, string, string)

Create a list of comma-separated columns with their alias name with back-ticks surrounding the column and alias name.

public static string AliasedColumnList(string alias, string p1, string p2, string p3, string p4, string p5, string p6)

Parameters

alias string

p1 string

p2 string

p3 string

p4 string

p5 string

p6 string

Returns

string

AliasedColumnList(string, string, string, string, string, string, string, string)

Create a list of comma-separated columns with their alias name with back-ticks surrounding the column and alias name.

public static string AliasedColumnList(string alias, string p1, string p2, string p3, string p4, string p5, string p6, string p7)

Parameters

alias string

p1 string

p2 string

p3 string

p4 string

p5 string

p6 string

p7 string

Returns

string

AliasedColumnList(string, string, string, string, string, string, string, string, string)

Create a list of comma-separated columns with their alias name with back-ticks surrounding the column and alias name.

public static string AliasedColumnList(string alias, string p1, string p2, string p3, string p4, string p5, string p6, string p7, string p8)

Parameters

alias string

p1 string

p2 string

p3 string

p4 string

p5 string

p6 string

p7 string

p8 string

Returns

string

AliasedColumnList(string, string, string, string, string, string, string, string, string, string)

Create a list of comma-separated columns with their alias name with back-ticks surrounding the column and alias name.

public static string AliasedColumnList(string alias, string p1, string p2, string p3, string p4, string p5, string p6, string p7, string p8, string p9)

Parameters

alias string

p1 string

p2 string

p3 string

p4 string

p5 string

p6 string

p7 string

p8 string

p9 string

Returns

string

AliasedColumnList(string, string, string, string, string, string, string, string, string, string, string)

Create a list of comma-separated columns with their alias name with back-ticks surrounding the column and alias name.

public static string AliasedColumnList(string alias, string p1, string p2, string p3, string p4, string p5, string p6, string p7, string p8, string p9, string p10)

Parameters

alias string

p1 string

p2 string

p3 string

p4 string

p5 string

p6 string

p7 string

p8 string

p9 string

p10 string

Returns

string

AliasedColumnList(string, string, string, string, string, string, string, string, string, string, string, string)

Create a list of comma-separated columns with their alias name with back-ticks surrounding the column and alias name.

public static string AliasedColumnList(string alias, string p1, string p2, string p3, string p4, string p5, string p6, string p7, string p8, string p9, string p10, string p11)

Parameters

alias string

p1 string

p2 string

p3 string

p4 string

p5 string

p6 string

p7 string

p8 string

p9 string

p10 string

p11 string

Returns

string

AliasedColumnList(string, string, string, string, string, string, string, string, string, string, string, string, string)

Create a list of comma-separated columns with their alias name with back-ticks surrounding the column and alias name.

public static string AliasedColumnList(string alias, string p1, string p2, string p3, string p4, string p5, string p6, string p7, string p8, string p9, string p10, string p11, string p12)

Parameters

alias string

p1 string

p2 string

p3 string

p4 string

p5 string

p6 string

p7 string

p8 string

p9 string

p10 string

p11 string

p12 string

Returns

string

AliasedColumnList(string, params string[])

Create a list of comma-separated columns with their alias name with back-ticks surrounding the column and alias name.

public static string AliasedColumnList(string alias, params string[] p)

Parameters

alias string

p string[]

Returns

string

AppendParameterList(StringBuilder, int, int)

Appends a list of parameters formatted: @0,@1,@2,....

public static void AppendParameterList(StringBuilder builder, int startIndex, int length)

Parameters

builder StringBuilder

startIndex int

First index.

length int

Number of parameters.

ApplyQueriedList<TModel>(List<PrimaryKeyPair<TModel>>, Action<uint, TModel[]>, bool)

Takes a list of primary key pairs and calls action for each array of values per id.

public static void ApplyQueriedList<TModel>(List<PrimaryKeyPair<TModel>> list, Action<uint, TModel[]> action, bool sort = true)

Parameters

list List<PrimaryKeyPair<TModel>>

action Action<uint, TModel[]>

sort bool

Type Parameters

TModel

Remarks

The values should be sorted by ID, if not set sort to true.

BuildCheckDurationClause(string, string, string, string)

Check if the current time is within colDuration after colTime. A -1 duration assumes permanent.

public static string BuildCheckDurationClause(string tableDurations, string tableTime, string colDuration, string colTime)

Parameters

tableDurations string

Table or alias of the table with the duration column.

tableTime string

Table or alias of the table with the time column.

colDuration string

Column with an effective duration.

colTime string

Column with a UTC timestamp.

Returns

string

BuildCheckDurationClause(string, string, string, string, string)

Check if the current time is within colDuration after colTime or colTimeFallback if colTime is DBNull. A -1 duration assumes permanent.

public static string BuildCheckDurationClause(string tableDurations, string tableTime, string colDuration, string colTime, string colTimeFallback)

Parameters

tableDurations string

Table or alias of the table with the duration column.

tableTime string

Table or alias of the table with the time column.

colDuration string

Column with an effective duration.

colTime string

Column with a UTC timestamp.

colTimeFallback string

Column with a fallback UTC timestamp if colTime is DBNull.

Returns

string

BuildInitialInsertQuery(string, string, bool, string?, string[]?, params string[])

INSERT INTO <code class="paramref">table</code> (columns[,<code class="paramref">columnPk</code>]) VALUES (parameters[,LAST_INSERT_ID(@pk)]) ON DUPLICATE KEY UPDATE (columns,<code class="paramref">columnPk</code>=LAST_INSERT_ID(<code class="paramref">columnPk</code>);
SET @pk := (SELECT LAST_INSERT_ID() as pk);
SELECT @pk

public static string BuildInitialInsertQuery(string table, string columnPk, bool hasPk, string? extPk, string[]? deleteTables, params string[] columns)

Parameters

table string

columnPk string

hasPk bool

extPk string

deleteTables string[]

columns string[]

Returns

string

ColumnList(string)

Create a list of comma-separated columns with back-ticks surrounding them.

public static string ColumnList(string p)

Parameters

p string

Returns

string

ColumnList(string, string)

Create a list of comma-separated columns with back-ticks surrounding them.

public static string ColumnList(string p1, string p2)

Parameters

p1 string

p2 string

Returns

string

ColumnList(string, string, string)

Create a list of comma-separated columns with back-ticks surrounding them.

public static string ColumnList(string p1, string p2, string p3)

Parameters

p1 string

p2 string

p3 string

Returns

string

ColumnList(string, string, string, string)

Create a list of comma-separated columns with back-ticks surrounding them.

public static string ColumnList(string p1, string p2, string p3, string p4)

Parameters

p1 string

p2 string

p3 string

p4 string

Returns

string

ColumnList(string, string, string, string, string)

Create a list of comma-separated columns with back-ticks surrounding them.

public static string ColumnList(string p1, string p2, string p3, string p4, string p5)

Parameters

p1 string

p2 string

p3 string

p4 string

p5 string

Returns

string

ColumnList(string, string, string, string, string, string)

Create a list of comma-separated columns with back-ticks surrounding them.

public static string ColumnList(string p1, string p2, string p3, string p4, string p5, string p6)

Parameters

p1 string

p2 string

p3 string

p4 string

p5 string

p6 string

Returns

string

ColumnList(string, string, string, string, string, string, string)

Create a list of comma-separated columns with back-ticks surrounding them.

public static string ColumnList(string p1, string p2, string p3, string p4, string p5, string p6, string p7)

Parameters

p1 string

p2 string

p3 string

p4 string

p5 string

p6 string

p7 string

Returns

string

ColumnList(string, string, string, string, string, string, string, string)

Create a list of comma-separated columns with back-ticks surrounding them.

public static string ColumnList(string p1, string p2, string p3, string p4, string p5, string p6, string p7, string p8)

Parameters

p1 string

p2 string

p3 string

p4 string

p5 string

p6 string

p7 string

p8 string

Returns

string

ColumnList(string, string, string, string, string, string, string, string, string)

Create a list of comma-separated columns with back-ticks surrounding them.

public static string ColumnList(string p1, string p2, string p3, string p4, string p5, string p6, string p7, string p8, string p9)

Parameters

p1 string

p2 string

p3 string

p4 string

p5 string

p6 string

p7 string

p8 string

p9 string

Returns

string

ColumnList(string, string, string, string, string, string, string, string, string, string)

Create a list of comma-separated columns with back-ticks surrounding them.

public static string ColumnList(string p1, string p2, string p3, string p4, string p5, string p6, string p7, string p8, string p9, string p10)

Parameters

p1 string

p2 string

p3 string

p4 string

p5 string

p6 string

p7 string

p8 string

p9 string

p10 string

Returns

string

ColumnList(string, string, string, string, string, string, string, string, string, string, string)

Create a list of comma-separated columns with back-ticks surrounding them.

public static string ColumnList(string p1, string p2, string p3, string p4, string p5, string p6, string p7, string p8, string p9, string p10, string p11)

Parameters

p1 string

p2 string

p3 string

p4 string

p5 string

p6 string

p7 string

p8 string

p9 string

p10 string

p11 string

Returns

string

ColumnList(string, string, string, string, string, string, string, string, string, string, string, string)

Create a list of comma-separated columns with back-ticks surrounding them.

public static string ColumnList(string p1, string p2, string p3, string p4, string p5, string p6, string p7, string p8, string p9, string p10, string p11, string p12)

Parameters

p1 string

p2 string

p3 string

p4 string

p5 string

p6 string

p7 string

p8 string

p9 string

p10 string

p11 string

p12 string

Returns

string

ColumnList(params string[])

Create a list of comma-separated columns with back-ticks surrounding them.

public static string ColumnList(params string[] p)

Parameters

p string[]

Returns

string

ColumnUpdateList(int, int, params string[])

Creates a list of columns to be updated from a parameter list.

public static string ColumnUpdateList(int startIndex, int skip, params string[] p)

Parameters

startIndex int

skip int

p string[]

Returns

string

ColumnUpdateList(int, params string[])

Creates a list of columns to be updated from a parameter list.

public static string ColumnUpdateList(int startIndex, params string[] p)

Parameters

startIndex int

p string[]

Returns

string

EnumList<TEnum>()

Create a list of all enums in the given type.

public static string EnumList<TEnum>() where TEnum : unmanaged, Enum

Returns

string

A string like: "enum(A,B,C,D)"

Type Parameters

TEnum

EnumList<TEnum>(TEnum)

Create a list of all enums in the given type.

public static string EnumList<TEnum>(TEnum exclude) where TEnum : unmanaged, Enum

Parameters

exclude TEnum

Don't include this value.

Returns

string

A string like: "enum(A,B,C,D)"

Type Parameters

TEnum

EnumList<TEnum>(params TEnum[])

Create a list of all enums in the given type.

public static string EnumList<TEnum>(params TEnum[] exclude) where TEnum : unmanaged, Enum

Parameters

exclude TEnum[]

Don't include these values.

Returns

string

A string like: "enum(A,B,C,D)"

Type Parameters

TEnum

EnumList<TEnum>(TEnum[], TEnum[])

Create a list of all enums in the given type.

public static string EnumList<TEnum>(TEnum[] exclude, TEnum[] include) where TEnum : unmanaged, Enum

Parameters

exclude TEnum[]

Don't include these values.

include TEnum[]

Also include these values.

Returns

string

A string like: "enum(A,B,C,D)"

Type Parameters

TEnum

ParameterList(int, int)

Returns a list of parameters formatted: @0,@1,@2,....

public static string ParameterList(int startIndex, int length)

Parameters

startIndex int

First index.

length int

Number of parameters.

Returns

string