본문으로 건너뛰기

함수: compileSQLite()

function compileSQLite(options, compileOptions?): SQLiteCompiledQuery;

정의 위치: sqlite-compiler.ts:45

TanStack DB LoadSubsetOptions를 SQLite 쿼리 구성 요소로 컴파일합니다.

매개변수​

options​

LoadSubsetOptions

compileOptions?​

CompileSQLiteOptions

반환값​

SQLiteCompiledQuery

예제​

const compiled = compileSQLite({
  where: { type: 'func', name: 'gt', args: [
    { type: 'ref', path: ['price'] },
    { type: 'val', value: 100 }
  ]},
  orderBy: [{ expression: { type: 'ref', path: ['price'] }, compareOptions: { direction: 'desc', nulls: 'last' } }],
  limit: 50
})
// Result: { where: '"price" > ?', orderBy: '"price" DESC', limit: 50, params: [100] }