if err := gorm.G[User](DB).Select("name").Create(ctx, &selectOnly); err != nil {
		t.Fatalf("failed to create with Select, got error: %v", err)
	}

	if selectOnly.ID == 0 {
		t.Fatalf("no primary key found for select-only user: %v", selectOnly)
	}

	if stored, err := gorm.G[User](DB).Where("id = ?", selectOnly.ID).First(ctx); err != nil {
		t.Fatalf("failed to reload select-only user, got error: %v", err)

mango`,
		},
		{
			name:  "Select column simplest",
			query: `select qty from S3Object`,
			wantResult: `1
3`,
		},
		{
			name:  "Select column with table name prefix",
			query: `select S3Object.qty from S3Object`,
			wantResult: `1
3`,
		},
		{
			name:  "Select column without table alias",
			query: `select qty from S3Object s`,
			wantResult: `1
3`,
		},

		t.Fatalf("invalid sql generated, got %v", sql)
	}

	sql = DB.Session(&gorm.Session{DryRun: true}).Table("user u").Select("name").Find(&User{}).Statement.SQL.String()
	if !regexp.MustCompile(`SELECT .name. FROM user u WHERE .u.\..deleted_at. IS NULL`).MatchString(sql) {
		t.Errorf("Table with escape character, got %v", sql)
	}

private
fun Document.scrapeMessagesForSeverity(severity: String): List<ReportMessage> =

    select("tr.severity-$severity").map { tr ->
        val entry = tr.select("td")[1]
        ReportMessage(
            entry.select("span")
                .text().substringBefore(" If you did this intentionally"),
            entry.select("ul li")
                .map { it.text() }

        )
    }


internal

# Select API Quickstart Guide [![Slack](https://slack.min.io/slack?type=svg)](https://slack.min.io)

Traditional retrieval of objects is always as whole entities, i.e GetObject for a 5 GiB object, will always return 5 GiB of data. S3 Select API allows us to retrieve a subset of data by using simple SQL expressions. By using Select API to retrieve only the data needed by the application, drastic performance improvements can be achieved.

# CI Pipeline Configuration

## Open & import the project

In your IDEA, `File` - `Open`, select `.teamcity/pom.xml`, `import as project`, and you'll have a Maven project.

## Project structure

Mostly a standard Maven project structure. The entry point `settings.kts` defines the TeamCity project.

There are 3 subprojects in the TeamCity project hierarchy: `Check` for Gradle builds, `Promotion` for releasing Gradle versions, `Util` for miscellaneous utilities.

from typing import Annotated

from fastapi import Depends, FastAPI, HTTPException, Query
from sqlmodel import Field, Session, SQLModel, create_engine, select


class Hero(SQLModel, table=True):
    id: int | None = Field(default=None, primary_key=True)
    name: str = Field(index=True)
    age: int | None = Field(default=None, index=True)
    secret_name: str


sqlite_file_name = "database.db"
sqlite_url = f"sqlite:///{sqlite_file_name}"

						><la:message key="labels.advance_search_timestamp_pastyear" /></option>
					</select>
				</div>
			</div>
			<div class="mb-3 row">
				<label for="as_filetype" class="col-lg-3 col-md-4 col-sm-5 col-12 col-form-label"><la:message
						key="labels.advance_search_filetype"
					/></label>
				<div class="col-lg-5 col-md-8 col-sm-7 col-6">
					<select id="as_filetype" name="as.filetype" class="form-control">

				continue
			}
			msg.Seq++
		}
	}

	if errState {
		// Drain requests.
		for {
			select {
			case r, ok := <-requests:
				if !ok {
					return
				}
				PutByteBuffer(r)
			default:
				return
			}
		}
	}

	for !errState {
		select {
		case <-m.ctx.Done():
			if debugPrint {
				fmt.Println("Client sending disconnect to mux", m.MuxID)
			}

import org.apache.maven.project.MavenProject;
import org.apache.maven.project.ProjectBuildingException;

/**
 * Facade to select projects for a given set of pom.xml files.
 */
public interface ProjectsSelector {
    /**
     * Select Maven projects from a list of POM files.
     * @param files List of POM files.
     * @param request The {@link MavenExecutionRequest}