Spaces:
Running
Running
File size: 2,412 Bytes
bf8b26e |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 |
import { type ActionFunctionArgs } from '@remix-run/cloudflare';
import { createScopedLogger } from '~/utils/logger';
const logger = createScopedLogger('api.supabase.query');
export async function action({ request }: ActionFunctionArgs) {
if (request.method !== 'POST') {
return new Response('Method not allowed', { status: 405 });
}
const authHeader = request.headers.get('Authorization');
if (!authHeader) {
return new Response('No authorization token provided', { status: 401 });
}
try {
const { projectId, query } = (await request.json()) as any;
logger.debug('Executing query:', { projectId, query });
const response = await fetch(`https://api.supabase.com/v1/projects/${projectId}/database/query`, {
method: 'POST',
headers: {
Authorization: authHeader,
'Content-Type': 'application/json',
},
body: JSON.stringify({ query }),
});
if (!response.ok) {
const errorText = await response.text();
let errorData;
try {
errorData = JSON.parse(errorText);
} catch (e) {
console.log(e);
errorData = { message: errorText };
}
logger.error(
'Supabase API error:',
JSON.stringify({
status: response.status,
statusText: response.statusText,
error: errorData,
}),
);
return new Response(
JSON.stringify({
error: {
status: response.status,
statusText: response.statusText,
message: errorData.message || errorData.error || errorText,
details: errorData,
},
}),
{
status: response.status,
headers: {
'Content-Type': 'application/json',
},
},
);
}
const result = await response.json();
return new Response(JSON.stringify(result), {
headers: {
'Content-Type': 'application/json',
},
});
} catch (error) {
logger.error('Query execution error:', error);
return new Response(
JSON.stringify({
error: {
message: error instanceof Error ? error.message : 'Query execution failed',
stack: error instanceof Error ? error.stack : undefined,
},
}),
{
status: 500,
headers: {
'Content-Type': 'application/json',
},
},
);
}
}
|