nicktrn
2f5b4a8471
* add custom validation to db url env vars * extract schema from db url and use in all raw queries * use qualified names in scheduling raw queries * cook a few raw queries * Added missing raw query schema specifier to DeploymentListPresenter --------- Co-authored-by: Matt Aitken <matt@mattaitken.com>
19 lines
540 B
TypeScript
19 lines
540 B
TypeScript
export function isValidDatabaseUrl(url: string) {
|
|
try {
|
|
const databaseUrl = new URL(url);
|
|
const schemaFromSearchParam = databaseUrl.searchParams.get("schema");
|
|
|
|
if (schemaFromSearchParam === "") {
|
|
console.error(
|
|
"Invalid Database URL: The schema search param can't have an empty value. To use the `public` schema, either omit the schema param entirely or specify it in full: `?schema=public`"
|
|
);
|
|
return false;
|
|
}
|
|
|
|
return true;
|
|
} catch (err) {
|
|
console.error(err);
|
|
return false;
|
|
}
|
|
}
|