Search Options

Results per page
Sort
Preferred Languages
Advance

Results 1 - 10 of 13 for sql (0.3 sec)

  1. tests/sql_builder_test.go

    	sql = dryRunDB.Or("a = ? or b = ?", "a", "b").Unscoped().Find(&User{}).Statement.SQL.String()
    	if !regexp.MustCompile(`WHERE a = .+ or b = .+$`).MatchString(sql) {
    		t.Fatalf("invalid sql generated, got %v", sql)
    	}
    
    	sql = dryRunDB.Not("a = ? or b = ?", "a", "b").Unscoped().Find(&User{}).Statement.SQL.String()
    	if !regexp.MustCompile(`WHERE NOT \(a = .+ or b = .+\)$`).MatchString(sql) {
    		t.Fatalf("invalid sql generated, got %v", sql)
    	}
    }
    
    Go
    - Registered: Sun May 05 09:35:13 GMT 2024
    - Last Modified: Fri Jan 12 08:42:21 GMT 2024
    - 16.7K bytes
    - Viewed (0)
  2. scan.go

    		}
    	case *int, *int8, *int16, *int32, *int64,
    		*uint, *uint8, *uint16, *uint32, *uint64, *uintptr,
    		*float32, *float64,
    		*bool, *string, *time.Time,
    		*sql.NullInt32, *sql.NullInt64, *sql.NullFloat64,
    		*sql.NullBool, *sql.NullString, *sql.NullTime:
    		for initialized || rows.Next() {
    			initialized = false
    			db.RowsAffected++
    			db.AddError(rows.Scan(dest))
    		}
    	default:
    		var (
    Go
    - Registered: Sun May 05 09:35:13 GMT 2024
    - Last Modified: Fri Apr 26 09:53:11 GMT 2024
    - 9.8K bytes
    - Viewed (0)
  3. tests/table_test.go

    		t.Errorf("Table with escape character, got %v", r.Statement.SQL.String())
    	}
    
    	r = dryDB.Table("user as u").Select("name").Find(&User{}).Statement
    	if !regexp.MustCompile("SELECT .name. FROM user as u WHERE .u.\\..deleted_at. IS NULL").MatchString(r.Statement.SQL.String()) {
    		t.Errorf("Table with escape character, got %v", r.Statement.SQL.String())
    	}
    
    Go
    - Registered: Sun May 05 09:35:13 GMT 2024
    - Last Modified: Sat Mar 09 09:31:28 GMT 2024
    - 10.6K bytes
    - Viewed (0)
  4. migrator/migrator.go

    		return gorm.ErrSubQueryRequired
    	}
    
    	sql := new(strings.Builder)
    	sql.WriteString("CREATE ")
    	if option.Replace {
    		sql.WriteString("OR REPLACE ")
    	}
    	sql.WriteString("VIEW ")
    	m.QuoteTo(sql, name)
    	sql.WriteString(" AS ")
    
    	m.DB.Statement.AddVar(sql, option.Query)
    
    	if option.CheckOption != "" {
    		sql.WriteString(" ")
    		sql.WriteString(option.CheckOption)
    	}
    Go
    - Registered: Sun May 05 09:35:13 GMT 2024
    - Last Modified: Fri Apr 26 07:15:49 GMT 2024
    - 29K bytes
    - Viewed (0)
  5. finisher_api.go

    		db.AddError(ErrUnsupportedDriver)
    	}
    	return db
    }
    
    // Exec executes raw sql
    func (db *DB) Exec(sql string, values ...interface{}) (tx *DB) {
    	tx = db.getInstance()
    	tx.Statement.SQL = strings.Builder{}
    
    	if strings.Contains(sql, "@") {
    		clause.NamedExpr{SQL: sql, Vars: values}.Build(tx.Statement)
    	} else {
    		clause.Expr{SQL: sql, Vars: values}.Build(tx.Statement)
    	}
    
    	return tx.callbacks.Raw().Execute(tx)
    Go
    - Registered: Sun May 05 09:35:13 GMT 2024
    - Last Modified: Fri Jan 12 08:42:21 GMT 2024
    - 22.7K bytes
    - Viewed (0)
  6. callbacks/query.go

    	if db.Statement.Schema != nil {
    		for _, c := range db.Statement.Schema.QueryClauses {
    			db.Statement.AddClause(c)
    		}
    	}
    
    	if db.Statement.SQL.Len() == 0 {
    		db.Statement.SQL.Grow(100)
    		clauseSelect := clause.Select{Distinct: db.Statement.Distinct}
    
    		if db.Statement.ReflectValue.Kind() == reflect.Struct && db.Statement.ReflectValue.Type() == db.Statement.Schema.ModelType {
    			var conds []clause.Expression
    Go
    - Registered: Sun May 05 09:35:13 GMT 2024
    - Last Modified: Mon Jan 29 03:34:57 GMT 2024
    - 9.9K bytes
    - Viewed (0)
  7. chainable_api.go

    	tx = db.getInstance()
    	tx.Statement.Unscoped = true
    	return
    }
    
    func (db *DB) Raw(sql string, values ...interface{}) (tx *DB) {
    	tx = db.getInstance()
    	tx.Statement.SQL = strings.Builder{}
    
    	if strings.Contains(sql, "@") {
    		clause.NamedExpr{SQL: sql, Vars: values}.Build(tx.Statement)
    	} else {
    		clause.Expr{SQL: sql, Vars: values}.Build(tx.Statement)
    	}
    	return
    Go
    - Registered: Sun May 05 09:35:13 GMT 2024
    - Last Modified: Wed Apr 17 03:38:55 GMT 2024
    - 14.3K bytes
    - Viewed (1)
  8. tests/create_test.go

    	if !regexp.MustCompile(`INSERT INTO .pets. \(.name.,.user_id.\) .*VALUES \(.+,\(SELECT @uid:=id FROM \(SELECT id FROM .users. WHERE name=.+\) as tmp\)\),\(.+,@uid\)`).MatchString(result.Statement.SQL.String()) {
    		t.Errorf("invalid insert SQL, got %v", result.Statement.SQL.String())
    	}
    }
    
    func TestCreateNilPointer(t *testing.T) {
    	var user *User
    
    	err := DB.Create(user).Error
    	if err == nil || err != gorm.ErrInvalidValue {
    Go
    - Registered: Sun May 05 09:35:13 GMT 2024
    - Last Modified: Tue Mar 19 03:50:28 GMT 2024
    - 26.4K bytes
    - Viewed (0)
  9. callbacks/create.go

    						fromColumns = append(fromColumns, clause.Column{Name: field.DBName})
    					}
    					db.Statement.AddClause(clause.Returning{Columns: fromColumns})
    				}
    			}
    		}
    
    		if db.Statement.SQL.Len() == 0 {
    			db.Statement.SQL.Grow(180)
    			db.Statement.AddClauseIfNotExists(clause.Insert{})
    			db.Statement.AddClause(ConvertToCreateValues(db.Statement))
    
    			db.Statement.Build(db.Statement.BuildClauses...)
    		}
    
    Go
    - Registered: Sun May 05 09:35:13 GMT 2024
    - Last Modified: Mon Apr 08 03:29:55 GMT 2024
    - 12.5K bytes
    - Viewed (0)
  10. statement.go

    					v.Dialector.BindVarTo(&bindvar, subdb.Statement, vv)
    					sql = strings.Replace(sql, bindvar.String(), "?", 1)
    				}
    
    				subdb.Statement.SQL.Reset()
    				subdb.Statement.Vars = stmt.Vars
    				if strings.Contains(sql, "@") {
    					clause.NamedExpr{SQL: sql, Vars: vars}.Build(subdb.Statement)
    				} else {
    					clause.Expr{SQL: sql, Vars: vars}.Build(subdb.Statement)
    				}
    			} else {
    Go
    - Registered: Sun May 05 09:35:13 GMT 2024
    - Last Modified: Fri Jan 12 08:42:21 GMT 2024
    - 19.8K bytes
    - Viewed (0)
Back to top