Search Options

Results per page
Sort
Preferred Languages
Advance

Results 1 - 10 of 82 for SQL (0.01 sec)

  1. docs/en/docs/tutorial/sql-databases.md

    * `Field(primary_key=True)` tells SQLModel that the `id` is the **primary key** in the SQL database (you can learn more about SQL primary keys in the SQLModel docs).
    
        By having the type as `int | None`, SQLModel will know that this column should be an `INTEGER` in the SQL database and that it should be `NULLABLE`.
    
    Registered: Sun Sep 07 07:19:17 UTC 2025
    - Last Modified: Sun Aug 31 09:15:41 UTC 2025
    - 15.4K bytes
    - Viewed (0)
  2. 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)
    	}
    }
    
    Registered: Sun Sep 07 09:35:13 UTC 2025
    - Last Modified: Mon Jul 21 02:46:58 UTC 2025
    - 16.7K 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())
    	}
    
    Registered: Sun Sep 07 09:35:13 UTC 2025
    - Last Modified: Mon Jul 21 02:46:58 UTC 2025
    - 12.7K bytes
    - Viewed (0)
  4. tests/query_test.go

    		t.Fatalf("SQL should include selected names, but got %v", result.Statement.SQL.String())
    	}
    
    	result = dryDB.Model(&User{}).Find(&User{}, user.ID)
    	if regexp.MustCompile("SELECT \\* FROM .*users").MatchString(result.Statement.SQL.String()) {
    		t.Fatalf("SQL should not include a * wildcard, but got %v", result.Statement.SQL.String())
    	}
    
    Registered: Sun Sep 07 09:35:13 UTC 2025
    - Last Modified: Tue Jul 22 06:21:04 UTC 2025
    - 51K bytes
    - Viewed (0)
  5. tests/connpool_test.go

    //		 return c.db.BeginTx(ctx, opts)
    //	}
    //
    // You should use BeginTx returned gorm.Tx which could wrap *sql.Tx then you can record all queries.
    func (c *wrapperConnPool) BeginTx(ctx context.Context, opts *sql.TxOptions) (gorm.ConnPool, error) {
    	tx, err := c.db.BeginTx(ctx, opts)
    	if err != nil {
    		return nil, err
    	}
    	return &wrapperTx{Tx: tx, conn: c}, nil
    }
    
    Registered: Sun Sep 07 09:35:13 UTC 2025
    - Last Modified: Sun May 25 07:40:40 UTC 2025
    - 5.5K bytes
    - Viewed (0)
  6. generics.go

    			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 {
    			subdb.Statement.Vars = append(stmt.Vars, subdb.Statement.Vars...)
    			subdb.callbacks.Query().Execute(subdb)
    		}
    
    		builder.WriteString(subdb.Statement.SQL.String())
    Registered: Sun Sep 07 09:35:13 UTC 2025
    - Last Modified: Thu Sep 04 13:13:16 UTC 2025
    - 15.5K bytes
    - Viewed (0)
  7. 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)
    Registered: Sun Sep 07 09:35:13 UTC 2025
    - Last Modified: Tue Aug 26 06:24:29 UTC 2025
    - 22.9K bytes
    - Viewed (0)
  8. src/main/java/org/codelibs/core/convert/DateConversionUtil.java

         *
         * @param src the source object
         * @param pattern the pattern string
         * @param locale the locale
         * @return the converted {@link java.sql.Date}
         */
        protected static java.sql.Date toSqlDate(final Object src, final String pattern, final Locale locale) {
            if (src == null) {
                return null;
            }
            if (src instanceof java.sql.Date) {
    Registered: Fri Sep 05 20:58:11 UTC 2025
    - Last Modified: Thu Jul 31 08:16:49 UTC 2025
    - 19.6K bytes
    - Viewed (0)
  9. gorm.go

    		}
    	}
    	return db.Error
    }
    
    // DB returns `*sql.DB`
    func (db *DB) DB() (*sql.DB, error) {
    	connPool := db.ConnPool
    	if db.Statement != nil && db.Statement.ConnPool != nil {
    		connPool = db.Statement.ConnPool
    	}
    	if tx, ok := connPool.(*sql.Tx); ok && tx != nil {
    		return (*sql.DB)(reflect.ValueOf(tx).Elem().FieldByName("db").UnsafePointer()), nil
    	}
    
    Registered: Sun Sep 07 09:35:13 UTC 2025
    - Last Modified: Tue Aug 26 06:24:29 UTC 2025
    - 12.8K bytes
    - Viewed (0)
  10. callbacks/query.go

    		}
    	}
    }
    
    func BuildQuerySQL(db *gorm.DB) {
    	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 {
    Registered: Sun Sep 07 09:35:13 UTC 2025
    - Last Modified: Sun May 25 07:40:40 UTC 2025
    - 10.4K bytes
    - Viewed (3)
Back to top