public SQLitePrimaryKeyTableConstraint(string name, List <SQLiteIndexedColumn> columns, bool autoincrement, SQLiteResolveAction conf)
: base(name)
{
_columns = columns;
_autoincrement = autoincrement;
_conf = conf;
}
public SQLitePrimaryKeyColumnConstraint(string name, SQLiteSortOrder order, SQLiteResolveAction conf, bool autoincrement)
: base(name)
{
_order = order;
_conf = conf;
_autoincrement = autoincrement;
}
public static string GetConflictClauseString(SQLiteResolveAction conf)
{
StringBuilder sb = new StringBuilder();
sb.Append("ON CONFLICT ");
switch (conf)
{
case SQLiteResolveAction.Ignore:
sb.Append("IGNORE");
break;
case SQLiteResolveAction.Replace:
sb.Append("REPLACE");
break;
case SQLiteResolveAction.Rollback:
sb.Append("ROLLBACK");
break;
case SQLiteResolveAction.Abort:
sb.Append("ABORT");
break;
case SQLiteResolveAction.Fail:
sb.Append("FAIL");
break;
default:
throw new ArgumentException("Illegal resolve action [" + conf.ToString() + "]");
} // switch
return(sb.ToString());
}
public SQLiteUpdateStatement(SQLiteResolveAction conf, string table,
List <SQLiteUpdateItem> setlist, SQLiteExpression whereExpr)
{
_conf = conf;
TableName = table;
_setlist = setlist;
_whereExpr = whereExpr;
}
public static string GetResolveActionString(SQLiteResolveAction action)
{
switch (action)
{
case SQLiteResolveAction.Ignore:
return("IGNORE");
case SQLiteResolveAction.Replace:
return("REPLACE");
case SQLiteResolveAction.Rollback:
return("ROLLBACK");
case SQLiteResolveAction.Abort:
return("ABORT");
case SQLiteResolveAction.Fail:
return("FAIL");
default:
throw new ArgumentException("illegal action type [" + action.ToString() + "]");
} // switch
}
public SQLiteInsertPrefix(SQLiteResolveAction conf)
{
_isInsert = true;
_conf = conf;
}
public SQLiteCheckTableConstraint(string name, SQLiteExpression expr, SQLiteResolveAction conf)
: base(name)
{
_expr = expr;
_conf = conf;
}
public SQLiteNullColumnConstraint(string name, bool isnull, SQLiteResolveAction conf)
: base(name)
{
_isnull = isnull;
_conf = conf;
}
public SQLiteRaiseExpression(SQLiteResolveAction raiseType, string errmsg)
{
_errmsg = errmsg;
RaiseType = raiseType;
}
public SQLiteUniqueColumnConstraint(string name, SQLiteResolveAction conf)
: base(name)
{
_conf = conf;
}
public SQLiteUniqueTableConstraint(string name, List <SQLiteIndexedColumn> columns, SQLiteResolveAction conf)
: base(name)
{
_columns = columns;
_conf = conf;
}
