...

import { quoteLiteral, unquoteIdentifier } from './sqlUtil';

export function buildTableQuery(dataset?: string) {
  const database = dataset !== undefined ? quoteIdentAsLiteral(dataset) : 'database()';
  return `SELECT table_name FROM information_schema.tables WHERE table_schema = ${database} ORDER BY table_name`;
}

export function showDatabases() {
  return `SELECT DISTINCT TABLE_SCHEMA from information_schema.TABLES where TABLE_TYPE != 'SYSTEM VIEW' ORDER BY TABLE_SCHEMA`;
}

export function buildColumnQuery(table: string, dbName?: string) {
  let query = 'SELECT column_name, data_type FROM information_schema.columns WHERE ';
  query += buildTableConstraint(table, dbName);

query += ' ORDER BY column_name';

return query;
}

export function buildTableConstraint(table: string, dbName?: string) {
  let query = '';

// check for schema qualified table
  if (table.includes('.')) {
    const parts = table.split('.');
    query = 'table_schema = ' + quoteIdentAsLiteral(parts[0]);
    query += ' AND table_name = ' + quoteIdentAsLiteral(parts[1]);
    return query;
  } else {
    const database = dbName !== undefined ? quoteIdentAsLiteral(dbName) : 'database()';
    query = `table_schema = ${database} AND table_name = ` + quoteIdentAsLiteral(table);

return query;
  }
}

export function quoteIdentAsLiteral(value: string) {
  return quoteLiteral(unquoteIdentifier(value));
}

.	Edit
..	Edit
datasource.flightsql.test.ts	Edit
datasource.flightsql.ts	Edit
fields.ts	Edit
flightsqlMetaQuery.ts	Edit
sqlCompletionProvider.ts	Edit
sqlUtil.test.ts	Edit
sqlUtil.ts	Edit
types.ts	Edit