Search Options

Results per page
Sort
Preferred Languages
Advance

Results 41 - 50 of 471 for Selects (0.05 sec)

  1. tests/table_test.go

    	}
    
    	r = dryDB.Table("gorm.user").Select("name").Find(&User{}).Statement
    	if !regexp.MustCompile("SELECT .name. FROM .gorm.\\..user. WHERE .user.\\..deleted_at. IS NULL").MatchString(r.Statement.SQL.String()) {
    		t.Errorf("Table with escape character, got %v", r.Statement.SQL.String())
    	}
    
    	r = dryDB.Select("name").Find(&UserWithTable{}).Statement
    Registered: Sun Nov 03 09:35:10 UTC 2024
    - Last Modified: Sat Mar 09 09:31:28 UTC 2024
    - 10.6K bytes
    - Viewed (0)
  2. clause/locking_test.go

    		Vars    []interface{}
    	}{
    		{
    			[]clause.Interface{clause.Select{}, clause.From{}, clause.Locking{Strength: clause.LockingStrengthUpdate}},
    			"SELECT * FROM `users` FOR UPDATE", nil,
    		},
    		{
    			[]clause.Interface{clause.Select{}, clause.From{}, clause.Locking{Strength: clause.LockingStrengthShare, Table: clause.Table{Name: clause.CurrentTable}}},
    			"SELECT * FROM `users` FOR SHARE OF `users`", nil,
    		},
    		{
    Registered: Sun Nov 03 09:35:10 UTC 2024
    - Last Modified: Fri Dec 15 08:32:56 UTC 2023
    - 1.2K bytes
    - Viewed (0)
  3. clause/limit_test.go

    			"SELECT * FROM `users` LIMIT ?",
    			[]interface{}{limit0},
    		},
    		{
    			[]clause.Interface{clause.Select{}, clause.From{}, clause.Limit{Offset: 20}},
    			"SELECT * FROM `users` OFFSET ?",
    			[]interface{}{20},
    		},
    		{
    			[]clause.Interface{clause.Select{}, clause.From{}, clause.Limit{Offset: 20}, clause.Limit{Offset: 30}},
    			"SELECT * FROM `users` OFFSET ?",
    Registered: Sun Nov 03 09:35:10 UTC 2024
    - Last Modified: Tue Feb 06 02:54:40 UTC 2024
    - 2.3K bytes
    - Viewed (0)
  4. clause/order_by_test.go

    		Result  string
    		Vars    []interface{}
    	}{
    		{
    			[]clause.Interface{clause.Select{}, clause.From{}, clause.OrderBy{
    				Columns: []clause.OrderByColumn{{Column: clause.PrimaryColumn, Desc: true}},
    			}},
    			"SELECT * FROM `users` ORDER BY `users`.`id` DESC", nil,
    		},
    		{
    			[]clause.Interface{
    				clause.Select{}, clause.From{}, clause.OrderBy{
    Registered: Sun Nov 03 09:35:10 UTC 2024
    - Last Modified: Thu Jan 06 07:02:53 UTC 2022
    - 1.6K bytes
    - Viewed (0)
  5. clause/where_test.go

    			[]clause.Interface{clause.Select{}, clause.From{}, clause.Where{
    				Exprs: []clause.Expression{clause.Or(clause.Neq{Column: "name", Value: "jinzhu"}), clause.Eq{Column: clause.PrimaryColumn, Value: "1"}, clause.Gt{Column: "age", Value: 18}},
    			}},
    			"SELECT * FROM `users` WHERE `users`.`id` = ? OR `name` <> ? AND `age` > ?",
    			[]interface{}{"1", "jinzhu", 18},
    		},
    		{
    			[]clause.Interface{clause.Select{}, clause.From{}, clause.Where{
    Registered: Sun Nov 03 09:35:10 UTC 2024
    - Last Modified: Thu Apr 25 12:22:53 UTC 2024
    - 6.2K bytes
    - Viewed (0)
  6. tests/query_test.go

    		t.Fatalf("Build Select with slice, but got %v", r.Statement.SQL.String())
    	}
    
    	// SELECT COALESCE(age,'42') FROM users;
    	r = dryDB.Table("users").Select("COALESCE(age,?)", 42).Find(&User{})
    	if !regexp.MustCompile(`SELECT COALESCE\(age,.*\) FROM .*users.*`).MatchString(r.Statement.SQL.String()) {
    		t.Fatalf("Build Select with func, but got %v", r.Statement.SQL.String())
    	}
    
    	// named arguments
    Registered: Sun Nov 03 09:35:10 UTC 2024
    - Last Modified: Mon Jun 24 09:42:59 UTC 2024
    - 50.4K bytes
    - Viewed (0)
  7. docs/bucket/notifications/README.md

    index*       (string)             Elasticsearch index to store/update events, index is auto-created
    format*      (namespace*|access)  'namespace' reflects current bucket/object list and 'access' reflects a journal of object operations, defaults to 'namespace'
    queue_dir    (path)               staging dir for undelivered messages e.g. '/home/events'
    Registered: Sun Nov 03 19:28:11 UTC 2024
    - Last Modified: Thu Jan 18 07:03:17 UTC 2024
    - 84K bytes
    - Viewed (0)
  8. internal/s3select/sql/analysis.go

    		}
    	}
    }
    
    func (e *SelectExpression) analyze(s *Select) (result qProp) {
    	if e.All {
    		return qProp{isRowFunc: true}
    	}
    
    	for _, ex := range e.Expressions {
    		result.combine(ex.analyze(s))
    	}
    	return
    }
    
    func (e *AliasedExpression) analyze(s *Select) qProp {
    	return e.Expression.analyze(s)
    }
    
    func (e *Expression) analyze(s *Select) (result qProp) {
    	for _, ac := range e.And {
    Registered: Sun Nov 03 19:28:11 UTC 2024
    - Last Modified: Sat Dec 23 07:19:11 UTC 2023
    - 8.5K bytes
    - Viewed (0)
  9. internal/s3select/sql/parser_test.go

    	p := participle.MustBuild(
    		&Select{},
    		participle.Lexer(sqlLexer),
    		participle.CaseInsensitive("Keyword"),
    	)
    
    	s := Select{}
    	cases := []string{
    		"select * from s3object",
    		"select a, b from s3object s",
    		"select a, b from s3object as s",
    		"select a, b from s3object as s where a = 1",
    		"select a, b from s3object s where a = 1",
    		"select a, b from s3object where a = 1",
    	}
    Registered: Sun Nov 03 19:28:11 UTC 2024
    - Last Modified: Thu Jan 18 07:03:17 UTC 2024
    - 9.2K bytes
    - Viewed (0)
  10. clause/select_test.go

    	}{
    		{
    			[]clause.Interface{clause.Select{}, clause.From{}},
    			"SELECT * FROM `users`", nil,
    		},
    		{
    			[]clause.Interface{clause.Select{
    				Columns: []clause.Column{clause.PrimaryColumn},
    			}, clause.From{}},
    			"SELECT `users`.`id` FROM `users`", nil,
    		},
    		{
    			[]clause.Interface{clause.Select{
    				Columns: []clause.Column{clause.PrimaryColumn},
    			}, clause.Select{
    				Columns: []clause.Column{{Name: "name"}},
    Registered: Sun Nov 03 09:35:10 UTC 2024
    - Last Modified: Sat Feb 18 01:06:43 UTC 2023
    - 1.7K bytes
    - Viewed (0)
Back to top