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;
 }
Пример #3
0
        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;
 }
Пример #5
0
        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;
 }
Пример #10
0
 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;
 }