dashpresshq/dashpress

enum RDMSSources {
  Postgres = "postgres",
  MySql = "mysql",
  MsSql = "mssql",
  Sqlite = "sqlite",
}

export type IDataSourceCredentials = {
  dataSourceType: RDMSSources;
  connectionString?: string;
  host?: string;
  port?: number;
  database?: string;
  user?: string;
  password?: string;
  filename?: string;
  ssl?: boolean;
  schemaNames?: string[];
};

const DATABASE_FIELDS: Array<keyof IDataSourceCredentials> = [
  "host",
  "user",
  "password",
  "database",
  "port",
  "ssl",
];

type GetQueryDataFnType = (data: any) => unknown;

export const DATA_SOURCES_CONFIG: Record<
  RDMSSources,
  {
    fields: Array<keyof IDataSourceCredentials>;
    port?: number;
    useConnectionString?: boolean;
    getQueryData: GetQueryDataFnType;
    scriptQueryDelimiter: string;
  }
> = {
  [RDMSSources.Postgres]: {
    fields: DATABASE_FIELDS,
    port: 5432,
    useConnectionString: true,
    getQueryData: (data) => data.rows,
    scriptQueryDelimiter: "`",
  },
  [RDMSSources.MySql]: {
    fields: DATABASE_FIELDS,
    port: 3306,
    useConnectionString: true,
    getQueryData: (data) => data[0],
    scriptQueryDelimiter: '"',
  },
  [RDMSSources.MsSql]: {
    fields: DATABASE_FIELDS,
    port: 1433,
    useConnectionString: true,
    getQueryData: (data) => data[0],
    scriptQueryDelimiter: "'",
  },
  [RDMSSources.Sqlite]: {
    fields: ["filename"],
    getQueryData: (data) => data,
    scriptQueryDelimiter: "'",
  },
};