let query = qb
.select( {
Time: sql<string>`${ schema.goals.time }`.as( 'Time' ),
Period: sql<number>`${ schema.goals.period }`.as( 'Period' ),
GoalType: sql<string>`${ schema.goals.goalType }`.as( 'GoalType' ),
GameId: sql<number>`${ schema.goals.gameId }`.as( 'GameId' ),
IsJunior: sql<boolean>`${ schema.leagues.isJunior }`.as( 'IsJunior' ),
IsFemale: sql<boolean>`${ schema.leagues.isFemale }`.as( 'IsFemale' ),
FieldSize: sql<string>`${ schema.leagues.fieldSize }`.as( 'FieldSize' ),
LeagueId: sql<number>`${ schema.leagues.id }`.as( 'LeagueId' ),
} )
.from( schema.goals )
.leftJoin( schema.games, eq( schema.goals.gameId, schema.games.id ) )
.leftJoin( schema.leagues, eq( schema.leagues.id, schema.games.leagueId ) )
const data = await fetchFromMyDb( query.$dynamic(), serverLoadEvent.fetch )
const result = data as unknown as typeof data._.result
// somehow IsFemale is string!?
console.dir( result )
console.log( result[ 0 ].IsFemale , typeof result[ 0 ].IsFemale )
console.log( result[ 0 ].Period, typeof result[ 0 ].Period )
let query = qb
.select( {
Time: sql<string>`${ schema.goals.time }`.as( 'Time' ),
Period: sql<number>`${ schema.goals.period }`.as( 'Period' ),
GoalType: sql<string>`${ schema.goals.goalType }`.as( 'GoalType' ),
GameId: sql<number>`${ schema.goals.gameId }`.as( 'GameId' ),
IsJunior: sql<boolean>`${ schema.leagues.isJunior }`.as( 'IsJunior' ),
IsFemale: sql<boolean>`${ schema.leagues.isFemale }`.as( 'IsFemale' ),
FieldSize: sql<string>`${ schema.leagues.fieldSize }`.as( 'FieldSize' ),
LeagueId: sql<number>`${ schema.leagues.id }`.as( 'LeagueId' ),
} )
.from( schema.goals )
.leftJoin( schema.games, eq( schema.goals.gameId, schema.games.id ) )
.leftJoin( schema.leagues, eq( schema.leagues.id, schema.games.leagueId ) )
const data = await fetchFromMyDb( query.$dynamic(), serverLoadEvent.fetch )
const result = data as unknown as typeof data._.result
// somehow IsFemale is string!?
console.dir( result )
console.log( result[ 0 ].IsFemale , typeof result[ 0 ].IsFemale )
console.log( result[ 0 ].Period, typeof result[ 0 ].Period )