Search Options

Results per page
Sort
Preferred Languages
Advance

Results 1 - 5 of 5 for ToSQL (0.03 sec)

  1. tests/sql_builder_test.go

    	// after model changed
    	if DB.Statement.DryRun || DB.DryRun {
    		t.Fatal("Failed expect DB.DryRun and DB.Statement.ToSQL to be false")
    	}
    
    	if DB.Statement.SQL.String() != "" {
    		t.Fatal("Failed expect DB.Statement.SQL to be empty")
    	}
    
    	// first
    	sql = DB.ToSQL(func(tx *gorm.DB) *gorm.DB {
    		return tx.Model(&User{}).Where(&User{Name: "foo", Age: 20}).Limit(10).Offset(5).Order("name ASC").First(&User{})
    	})
    Registered: Sun Nov 03 09:35:10 UTC 2024
    - Last Modified: Fri Jan 12 08:42:21 UTC 2024
    - 16.7K bytes
    - Viewed (0)
  2. gorm.go

    		return err
    	}
    	db.Plugins[name] = plugin
    	return nil
    }
    
    // ToSQL for generate SQL string.
    //
    //	db.ToSQL(func(tx *gorm.DB) *gorm.DB {
    //			return tx.Model(&User{}).Where(&User{Name: "foo", Age: 20})
    //				.Limit(10).Offset(5)
    //				.Order("name ASC")
    //				.First(&User{})
    //	})
    func (db *DB) ToSQL(queryFn func(tx *DB) *DB) string {
    Registered: Sun Nov 03 09:35:10 UTC 2024
    - Last Modified: Wed Oct 09 11:29:48 UTC 2024
    - 12.1K bytes
    - Viewed (0)
  3. tests/scopes_test.go

    			},
    			expected: `SELECT * FROM "languages" WHERE d = 4 OR c = 3 OR (a = 1 AND b = 2)`,
    		},
    	}
    
    	for _, test := range tests {
    		t.Run(test.name, func(t *testing.T) {
    			assertEqualSQL(t, test.expected, DB.ToSQL(test.queryFn))
    		})
    	}
    Registered: Sun Nov 03 09:35:10 UTC 2024
    - Last Modified: Fri Jan 12 08:42:21 UTC 2024
    - 3.3K bytes
    - Viewed (0)
  4. tests/soft_delete_test.go

    		t.Errorf("Failed, result.DeletedAt: %v is not same as expected.DeletedAt: %v", result.DeletedAt, expected.DeletedAt)
    	}
    }
    
    func TestDeletedAtOneOr(t *testing.T) {
    	actualSQL := DB.ToSQL(func(tx *gorm.DB) *gorm.DB {
    		return tx.Or("id = ?", 1).Find(&User{})
    	})
    
    	if !regexp.MustCompile(` WHERE id = 1 AND .users.\..deleted_at. IS NULL`).MatchString(actualSQL) {
    Registered: Sun Nov 03 09:35:10 UTC 2024
    - Last Modified: Wed Feb 01 06:40:55 UTC 2023
    - 5.7K bytes
    - Viewed (0)
  5. tests/table_test.go

    }
    
    func TestTableWithNamer(t *testing.T) {
    	db, _ := gorm.Open(tests.DummyDialector{}, &gorm.Config{
    		NamingStrategy: schema.NamingStrategy{
    			TablePrefix: "t_",
    		},
    	})
    
    	sql := db.ToSQL(func(tx *gorm.DB) *gorm.DB {
    		return tx.Model(&UserWithTableNamer{}).Find(&UserWithTableNamer{})
    	})
    
    	if !regexp.MustCompile("SELECT \\* FROM `t_users`").MatchString(sql) {
    		t.Errorf("Table with namer, got %v", sql)
    Registered: Sun Nov 03 09:35:10 UTC 2024
    - Last Modified: Sat Mar 09 09:31:28 UTC 2024
    - 10.6K bytes
    - Viewed (0)
Back to top