CCBCodeMonkey
04/16/2019, 4:24 AMconst createQuery = (query) => {
const returnQuery = `${query} `.replace(/"/g, '\\"').replace(/\n/g, ' ').replace(/\s+/g, ' ');
return returnQuery;
};
const executeQuery = async (query) => {
const fixedQuery = createQuery(query);
const response = await prisma.$graphql(`
mutation {
executeRaw(query: "${fixedQuery}")
}
`);
return response.executeRaw;
};
const results = await executeQuery('SELECT count("id") FROM "default$default"."YourTable" group by "yourField"');