Search Options

Results per page
Sort
Preferred Languages
Advance

Results 1 - 6 of 6 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 Sep 07 09:35:13 UTC 2025
    - Last Modified: Mon Jul 21 02:46:58 UTC 2025
    - 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 Sep 07 09:35:13 UTC 2025
    - Last Modified: Tue Aug 26 06:24:29 UTC 2025
    - 12.8K 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 Sep 07 09:35:13 UTC 2025
    - Last Modified: Fri Jan 12 08:42:21 UTC 2024
    - 3.3K bytes
    - Viewed (0)
  4. tests/generics_test.go

    	}
    }
    
    func TestGenericsToSQL(t *testing.T) {
    	ctx := context.Background()
    	sql := DB.ToSQL(func(tx *gorm.DB) *gorm.DB {
    		gorm.G[User](tx).Limit(10).Find(ctx)
    		return tx
    	})
    
    	if !regexp.MustCompile("SELECT \\* FROM .users..* 10").MatchString(sql) {
    		t.Errorf("ToSQL: got wrong sql with Generics API %v", sql)
    	}
    }
    
    func TestGenericsScanUUID(t *testing.T) {
    Registered: Sun Sep 07 09:35:13 UTC 2025
    - Last Modified: Thu Sep 04 13:13:16 UTC 2025
    - 28K bytes
    - Viewed (0)
  5. 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 Sep 07 09:35:13 UTC 2025
    - Last Modified: Wed Feb 01 06:40:55 UTC 2023
    - 5.7K bytes
    - Viewed (0)
  6. 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 Sep 07 09:35:13 UTC 2025
    - Last Modified: Mon Jul 21 02:46:58 UTC 2025
    - 12.7K bytes
    - Viewed (0)
Back to top