public SQLitePrimaryKeyColumnConstraint(string name, SQLiteSortOrder order, SQLiteResolveAction conf, bool autoincrement)
: base(name)
{
_order = order;
_conf = conf;
_autoincrement = autoincrement;
}
public SQLiteOrderBy(string field, SQLiteSortOrder order)
{
FieldName = field;
SortOrder = order;
}
public SQLiteIndexedColumn(string name, string collation, SQLiteSortOrder order)
{
ColumnName = name;
Collation = collation;
_order = order;
}
public int CreateIndex(string tableName, string indexName, string fieldName, bool setUnique = true, SQLiteSortOrder sortOrder = SQLiteSortOrder.ASC)
{
StringBuilder cmdBuilder = new StringBuilder();
cmdBuilder.Append("CREATE ");
if (setUnique)
{
cmdBuilder.Append("UNIQUE ");
}
cmdBuilder.Append($"INDEX {indexName} ON {tableName} ({fieldName} {sortOrder.ToString()});");
return(ExecuteNonQuery(cmdBuilder.ToString()));
}
public SQLiteSortItem(SQLiteExpression expr, SQLiteSortOrder order)
{
_expr = expr;
_order = order;
}
public SQLiteOrderBy (string field, SQLiteSortOrder order)
{
FieldName = field;
SortOrder = order;
}
