The open alternative to Salesforce, designed for AI.
TypeScript crmcrm-systemcustomergood-first-issuegraphqlhacktoberfestjavascriptmarketingmonoreponestjsopen-sourcepostgresqlreactreactjssalestypescriptweb
// Strips all characters except [a-zA-Z0-9_].
// Use ONLY for generating safe identifier names (e.g. enum names from table+column).
// For SQL escaping, use escapeIdentifier or escapeLiteral instead.
export const removeSqlDDLInjection = (value: string): string => {
return value.replace(/[^a-zA-Z0-9_]/g, '');
};
// PostgreSQL standard identifier quoting: wraps in double quotes and
// doubles any internal double-quote characters.
// e.g. my"table → "my""table"
export const escapeIdentifier = (identifier: string): string => {
if (identifier.includes('\0')) {
throw new Error('Null bytes are not allowed in PostgreSQL identifiers');
}
return '"' + identifier.replace(/"/g, '""') + '"';
};
const FORBIDDEN_TS_VECTOR_EXPRESSION_TOKENS = [
'\0',
';',
'--',
'/*',
'*/',
'$',
];
const hasBalancedParentheses = (expression: string): boolean => {
let depth = 0;
let context: 'code' | 'string' | 'identifier' = 'code';
for (let index = 0; index < expression.length; index++) {
const character = expression[index];
if (context === 'string') {
if (character === "'") {
if (expression[index + 1] === "'") {
index++;
} else {
context = 'code';
}
}
continue;
}
if (context === 'identifier') {
if (character === '"') {
if (expression[index + 1] === '"') {
index++;
} else {
context = 'code';
}
}
continue;
}
if (character === "'") {
context = 'string';
} else if (character === '"') {
context = 'identifier';
} else if (character === '(') {
depth++;
} else if (character === ')') {
depth--;
if (depth < 0) {
return false;
}
}
}
return depth === 0 && context === 'code';
};
export const isSafeTsVectorExpression = (expression: string): boolean => {
const hasForbiddenToken = FORBIDDEN_TS_VECTOR_EXPRESSION_TOKENS.some(
(token) => expression.includes(token),
);
if (hasForbiddenToken) {
return false;
}
return hasBalancedParentheses(expression);
};
export const assertSafeTsVectorExpression = (expression: string): void => {
if (!isSafeTsVectorExpression(expression)) {
throw new Error('Unsafe tsvector expression detected');
}
};
// PostgreSQL standard literal quoting: wraps in single quotes and
// doubles any internal single-quote characters. Prefixes with E when
// backslashes are present (standard_conforming_strings safety).
// e.g. it's → 'it''s'
export const escapeLiteral = (value: string): string => {
if (value.includes('\0')) {
throw new Error('Null bytes are not allowed in PostgreSQL string literals');
}
let hasBackslash = false;
let escaped = "'";
for (const char of value) {
if (char === "'") {
escaped += "''";
} else if (char === '\\') {
escaped += '\\\\';
hasBackslash = true;
} else {
escaped += char;
}
}
escaped += "'";
if (hasBackslash) {
escaped = 'E' + escaped;
}
return escaped;
};