D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
usr
/
share
/
grafana
/
public
/
app
/
plugins
/
datasource
/
mysql
/
Filename :
sqlUtil.test.ts
back
Copy
import { isValidIdentifier } from './sqlUtil'; describe('isValidIdentifier', () => { test.each([ { value: 'and', expected: false }, // Reserved keyword { value: '1name', expected: false }, // Starts with value { value: 'my-sql', expected: false }, // Contains not permitted character { value: '$id', expected: false }, // $ sign shouldn't be the first character { value: 'my sql', expected: false }, // Whitespace is not permitted { value: 'mysql ', expected: false }, // Whitespace is not permitted at the end { value: ' mysql', expected: false }, // Whitespace is not permitted { value: 'id$', expected: true }, { value: 'myIdentifier', expected: true }, { value: 'table_name', expected: true }, ])('should return $expected when value is $value', ({ value, expected }) => { expect(isValidIdentifier(value)).toBe(expected); }); });