public void Add(SQLVars vars)
{
foreach (var v in vars.GetFields())
{
Fields.Add(v);
}
}
public SQLInsertTableMultiValues(string tablename, SQLVars fields, List <SQLVars> Values) : this(tablename, fields)
{
foreach (var v in Values)
{
if (v.Count() == Fields.Count())
{
Values.Add(v);
}
}
}
public void SetWhereTable(string table, SQLVars selectfields)
{
WhereTable = new SQLJoinTable(table, selectfields);
}
public SQLSelectTable(string maintab, SQLVars selfield, SQLWhereVars wherefield, SQLVars groupby) : this(maintab, selfield, wherefield)
{
GroupBy = groupby;
}
public SQLSelectTable(string maintab, SQLVars selfield, SQLWhereVars wherefield, SQLVars groupby, SQLOrderVars orderbyfields) : this(maintab, selfield, wherefield, groupby)
{
OrderByFields = orderbyfields;
}
new public void AddSelectField(string field1)
{
SelectFields = new SQLVars();
SelectFields.Add(new SQLVar(field1));
}
public void AddSelectTable(string maintable, SQLVars selectfields, SQLWhereVars wherefields)
{
SelectTable = new SQLJoinTable(maintable, selectfields, wherefields);
}
public SQLInsertTableMultiValues(string tablename, SQLVars fields) : this(tablename)
{
Fields = fields;
}
public void SetFields(SQLVars fields)
{
Fields = fields;
}
public SQLCreateIndex(string index, string table, SQLVars columns, bool isunique = false) : this(index, table, isunique)
{
Columns.Add(columns);
}
public SQLJoinTable(string maintable, SQLVars selectfields) : base(maintable, selectfields)
{
}
public SQLSelectExistsTable(string table, SQLVars selectfields, SQLJoinTable wheretable) : this(table, selectfields)
{
WhereTable = wheretable;
}
public SQLSelectExistsTable(string table, SQLVars selectfields, SQLSelectTable wheretable) : this(table, selectfields, new SQLJoinTable(wheretable))
{
}
public SQLSelectExistsTable(string table, SQLVars selectfields) : base(table, selectfields)
{
}
public void AddField(SQLVars vars)
{
Fields.Add(vars);
}
public SQLInsertIntoSelectTable(string nm, SQLVars fields, SQLSelectTable selectable) : this(nm, fields)
{
SelectTable = new SQLJoinTable(selectable);
}
public SQLInsertIntoSelectTable(string nm, SQLVars fields) : this(nm)
{
Fields = fields;
}
public void AddSelectTable(string maintable, List <string> jointables, List <SQLJoinFields> joinfields, SQLVars selectfields, SQLWhereVars wherefields)
{
SelectTable = new SQLJoinTable(maintable, jointables, joinfields, selectfields, wherefields);
}
public SQLJoinTable(string maintable, List <string> jointables, List <SQLJoinFields> joinfields, SQLVars selectfields, SQLWhereVars wherefields) : base(maintable, selectfields, wherefields)
{
if (jointables.Count == joinfields.Count)
{
JoinTables = jointables;
JoinFields = joinfields;
}
}
public SQLCreateView(string maintable, SQLVars selectfields, SQLWhereVars wherefields, string viewname) : base(maintable, selectfields, wherefields)
{
SetViewName(viewname);
}
public SQLJoinTable(string maintable, SQLVars selectfields, SQLWhereVars wherefields) : base(maintable, selectfields, wherefields)
{
}
public SQLSelectBetweenTable(string maintable, SQLVars selectfields, SQLWhereVars wherefields, bool unot = false) : base(maintable, selectfields, wherefields)
{
usenot = unot;
}
public void AddSelectField(SQLVars field)
{
SelectFields.Add(field);
}
public SQLSelectTable(string maintab, SQLVars selfied) : this(maintab)
{
SelectFields = selfied;
}
new public void AddSelectField(SQLVars field)
{
SelectFields = new SQLVars();
SelectFields.Add(field);
}
public SQLSelectTable(string maintab, SQLVars selfield, SQLWhereVars wherefield) : this(maintab, selfield)
{
WhereFields = wherefield;
}
new public void AddSelectField(params string[] fields)
{
SelectFields = new SQLVars();
SelectFields.Add(new SQLVar(fields[0]));
}
public SQLSelectIntoTable(string maintable, List <string> jointables, List <SQLJoinFields> joinfields, SQLVars selectfields, SQLWhereVars wherefields, string destinationtable = "", string externaldb = "") : base(maintable, jointables, joinfields, selectfields, wherefields)
{
DestinationTable = destinationtable;
ExternalDB = externaldb;
}