Function generateSimpleSelectAllStatement

frontend/src/utils/v1/sql.ts:185–212

(
  engine: Engine,
  schema: string,
  table: string,
  limit: number
)

};

export const generateSimpleSelectAllStatement = (
  engine: Engine,
  schema: string,
  table: string,
  limit: number
) => {
  const schemaAndTable = generateSchemaAndTableNameInSQL(engine, schema, table);

  switch (engine) {
    case Engine.MONGODB:
      return `db["${escapeMongoDBCollectionName(table)}"].find().limit(${limit});`;
    case Engine.COSMOSDB:
      return `SELECT * FROM c`;
    case Engine.ELASTICSEARCH:
      return `GET ${table}/_search?size=${limit}
{
	"query": {
		"match_all": {}
	}
}`;
    case Engine.MSSQL:
      return `SELECT TOP ${limit} * FROM ${schemaAndTable};`;
    case Engine.ORACLE:
      return `SELECT * FROM ${schemaAndTable} WHERE ROWNUM <= ${limit};`;
    default:
      return `SELECT * FROM ${schemaAndTable} LIMIT ${limit};`;
  }
};

export const generateSimpleInsertStatement = (
  engine: Engine,