Search Options

Results per page
Sort
Preferred Languages
Advance

Results 1 - 10 of 53 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. 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)
  6. 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)
  7. 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)
  8. 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)
  9. src/main/java/org/codelibs/core/sql/StatementUtil.java

     */
    package org.codelibs.core.sql;
    
    import static org.codelibs.core.log.Logger.format;
    import static org.codelibs.core.misc.AssertionUtil.assertArgumentNotEmpty;
    import static org.codelibs.core.misc.AssertionUtil.assertArgumentNotNull;
    
    import java.sql.ResultSet;
    import java.sql.SQLException;
    import java.sql.Statement;
    
    import org.codelibs.core.exception.SQLRuntimeException;
    Registered: Fri Sep 05 20:58:11 UTC 2025
    - Last Modified: Thu Jul 31 08:16:49 UTC 2025
    - 5K bytes
    - Viewed (0)
  10. api/next/67546.txt

    pkg database/sql/driver, type RowsColumnScanner interface { Close, Columns, Next, ScanColumn } #67546
    pkg database/sql/driver, type RowsColumnScanner interface, Close() error #67546
    pkg database/sql/driver, type RowsColumnScanner interface, Columns() []string #67546
    pkg database/sql/driver, type RowsColumnScanner interface, Next([]Value) error #67546
    pkg database/sql/driver, type RowsColumnScanner interface, ScanColumn(interface{}, int) error #67546
    Registered: Tue Sep 09 11:13:09 UTC 2025
    - Last Modified: Mon Aug 11 21:27:36 UTC 2025
    - 454 bytes
    - Viewed (0)
Back to top