Class JoblistDuckDBSDK

constructor

• new JoblistDuckDBSDK(baseParquetUrl?: string, options?: {}): JoblistDuckDBSDK

  Parameters

  • baseParquetUrl: string = "https://workers.joblist.today"
  • options: {} = {}

  Returns JoblistDuckDBSDK

_columnsCache

_registered

baseParquetUrl

conn

db

enableFTS

ftsEnabled

mode

_escapeSql

• _escapeSql(s?: string): string

  Parameters

  • s: string = ""

  Returns string

_ftsSearch

• _ftsSearch(vname: any, tableName: any, query: any, limit: any): Promise<any>

  Parameters

  • vname: any
  • tableName: any
  • query: any
  • limit: any

  Returns Promise<any>

_getColumnsForVName

• _getColumnsForVName(vname: any): Promise<any>

  Parameters

  • vname: any

  Returns Promise<any>

_likeSearch

• _likeSearch(
      vname: any,
      field: any,
      term: any,
      limitClause: any,
      searchColumns: any,
  ): Promise<any>

  Parameters

  • vname: any
  • field: any
  • term: any
  • limitClause: any
  • searchColumns: any

  Returns Promise<any>

_mixedFieldSearch

• _mixedFieldSearch(
      vname: any,
      fieldValuePairs: any,
      plainTextTerms: any,
      limitClause: any,
      searchColumns: any,
  ): Promise<any>

  Parameters

  • vname: any
  • fieldValuePairs: any
  • plainTextTerms: any
  • limitClause: any
  • searchColumns: any

  Returns Promise<any>

_multiFieldSearch

• _multiFieldSearch(
      vname: any,
      fieldValuePairs: any,
      plainTextTerms: any,
      limitClause: any,
      searchColumns: any,
  ): Promise<any>

  Parameters

  • vname: any
  • fieldValuePairs: any
  • plainTextTerms: any
  • limitClause: any
  • searchColumns: any

  Returns Promise<any>

_parseSimpleSearch

• _parseSimpleSearch(
      query?: string,
  ):
      | {
          conjunctive?: undefined;
          field?: undefined;
          fieldValuePairs?: undefined;
          isMixed?: undefined;
          isMultiField?: undefined;
          isPlainTextMulti?: undefined;
          plainTextTerms?: undefined;
          term?: undefined;
          terms: any[];
      }
      | {
          conjunctive: number;
          field?: undefined;
          fieldValuePairs: { field: string; value: string }[];
          isMixed?: undefined;
          isMultiField: boolean;
          isPlainTextMulti?: undefined;
          plainTextTerms: string[];
          term?: undefined;
          terms?: undefined;
      }
      | {
          conjunctive: number;
          field?: undefined;
          fieldValuePairs: { field: string; value: string }[];
          isMixed: boolean;
          isMultiField?: undefined;
          isPlainTextMulti?: undefined;
          plainTextTerms: string[];
          term?: undefined;
          terms?: undefined;
      }
      | {
          conjunctive: number;
          field: string;
          fieldValuePairs?: undefined;
          isMixed?: undefined;
          isMultiField?: undefined;
          isPlainTextMulti?: undefined;
          plainTextTerms?: undefined;
          term: string;
          terms?: undefined;
      }
      | {
          conjunctive: number;
          field?: undefined;
          fieldValuePairs?: undefined;
          isMixed?: undefined;
          isMultiField?: undefined;
          isPlainTextMulti: boolean;
          plainTextTerms: string[];
          term?: undefined;
          terms?: undefined;
      }
      | {
          conjunctive: number;
          field?: undefined;
          fieldValuePairs?: undefined;
          isMixed?: undefined;
          isMultiField?: undefined;
          isPlainTextMulti?: undefined;
          plainTextTerms?: undefined;
          term: string;
          terms?: undefined;
      }

  Parameters

  • query: string = ""

  Returns
      | {
          conjunctive?: undefined;
          field?: undefined;
          fieldValuePairs?: undefined;
          isMixed?: undefined;
          isMultiField?: undefined;
          isPlainTextMulti?: undefined;
          plainTextTerms?: undefined;
          term?: undefined;
          terms: any[];
      }
      | {
          conjunctive: number;
          field?: undefined;
          fieldValuePairs: { field: string; value: string }[];
          isMixed?: undefined;
          isMultiField: boolean;
          isPlainTextMulti?: undefined;
          plainTextTerms: string[];
          term?: undefined;
          terms?: undefined;
      }
      | {
          conjunctive: number;
          field?: undefined;
          fieldValuePairs: { field: string; value: string }[];
          isMixed: boolean;
          isMultiField?: undefined;
          isPlainTextMulti?: undefined;
          plainTextTerms: string[];
          term?: undefined;
          terms?: undefined;
      }
      | {
          conjunctive: number;
          field: string;
          fieldValuePairs?: undefined;
          isMixed?: undefined;
          isMultiField?: undefined;
          isPlainTextMulti?: undefined;
          plainTextTerms?: undefined;
          term: string;
          terms?: undefined;
      }
      | {
          conjunctive: number;
          field?: undefined;
          fieldValuePairs?: undefined;
          isMixed?: undefined;
          isMultiField?: undefined;
          isPlainTextMulti: boolean;
          plainTextTerms: string[];
          term?: undefined;
          terms?: undefined;
      }
      | {
          conjunctive: number;
          field?: undefined;
          fieldValuePairs?: undefined;
          isMixed?: undefined;
          isMultiField?: undefined;
          isPlainTextMulti?: undefined;
          plainTextTerms?: undefined;
          term: string;
          terms?: undefined;
      }

_plainTextMultiSearch

• _plainTextMultiSearch(
      vname: any,
      plainTextTerms: any,
      limitClause: any,
      searchColumns: any,
  ): Promise<any>

  Parameters

  • vname: any
  • plainTextTerms: any
  • limitClause: any
  • searchColumns: any

  Returns Promise<any>

_processJobsQuery

• _processJobsQuery(query: any): any

  Parameters

  • query: any

  Returns any

_rowsToPlain

• _rowsToPlain(input: any, schema: any): any

  Parameters

  • input: any
  • schema: any

  Returns any

_searchWithFallback

• _searchWithFallback(
      vname: any,
      tableName: any,
      query: any,
      limit: any,
      searchColumns: any,
  ): Promise<any>

  Parameters

  • vname: any
  • tableName: any
  • query: any
  • limit: any
  • searchColumns: any

  Returns Promise<any>

createFTSIndex

• createFTSIndex(viewName: any, idColumn: any, fields?: any[]): Promise<boolean>

  Parameters

  • viewName: any
  • idColumn: any
  • fields: any[] = []

  Returns Promise<boolean>

dispose

• dispose(): Promise<void>

  Returns Promise<void>

ensureParquetRegistered

• ensureParquetRegistered(vname: any, url: any): Promise<any>

  Parameters

  • vname: any
  • url: any

  Returns Promise<any>

ensureViewForParquet

• ensureViewForParquet(viewName: any, vname: any): Promise<boolean>

  Parameters

  • viewName: any
  • vname: any

  Returns Promise<boolean>

fetchAndRegister

• fetchAndRegister(name: any, url: any): Promise<any>

  Parameters

  • name: any
  • url: any

  Returns Promise<any>

getAllCompaniesData

• getAllCompaniesData(): Promise<any>

  Returns Promise<any>

getAllCompaniesWithJobs

• getAllCompaniesWithJobs(): Promise<any>

  Returns Promise<any>

getAllJobsData

• getAllJobsData(): Promise<any>

  Returns Promise<any>

getColumns

• getColumns(base: any): Promise<any>

  Parameters

  • base: any

  Returns Promise<any>

getCompanies

• getCompanies(): Promise<any>

  Returns Promise<any>

getCompaniesHighlighted

• getCompaniesHighlighted(): Promise<any>

  Returns Promise<any>

getCompany

• getCompany(id: any): Promise<any>

  Parameters

  • id: any

  Returns Promise<any>

getCompanyHeatmap

• getCompanyHeatmap(id: any, days?: number, signal: any): Promise<HeatmapItem[]>

  Parameters

  • id: any
  • days: number = 365
  • signal: any

  Returns Promise<HeatmapItem[]>

getJobsFromHighlightedCompanies

• getJobsFromHighlightedCompanies(limit?: number): Promise<any>

  Parameters

  • limit: number = 100

  Returns Promise<any>

getJobsHeatmap

• getJobsHeatmap(days?: number, signal: any): Promise<HeatmapItem[]>

  Parameters

  • days: number = 365
  • signal: any

  Returns Promise<HeatmapItem[]>

getStats

• getStats(): Promise<any>

  Returns Promise<any>

initialize

• initialize(): Promise<void>

  Returns Promise<void>

parquetUrl

• parquetUrl(tableName: any): string

  Parameters

  • tableName: any

  Returns string

query

• query(sql: any, params?: any[]): Promise<any>

  Parameters

  • sql: any
  • params: any[] = []

  Returns Promise<any>

registerFileBuffer

• registerFileBuffer(name: any, buffer: any): Promise<any>

  Parameters

  • name: any
  • buffer: any

  Returns Promise<any>

searchCompanies

• searchCompanies(query?: string, limit?: number): Promise<any>

  Parameters

  • query: string = ""
  • limit: number = 100

  Returns Promise<any>

searchJobs

• searchJobs(query?: string, limit?: number): Promise<any>

  Parameters

  • query: string = ""
  • limit: number = 100

  Returns Promise<any>