Extracts identificator's name from its safe SQL representation >>> pushValue(kb.forcedDbms) >>> kb.forcedDbms = DBMS.MSSQL >>> getText(unsafeSQLIdentificatorNaming("[begin]")) 'begin' >>> getText(unsafeSQLIdentificatorNaming("foobar")) 'foobar' >>> kb.forceDbms = po
(name)
| 4313 | return retVal |
| 4314 | |
| 4315 | def unsafeSQLIdentificatorNaming(name): |
| 4316 | """ |
| 4317 | Extracts identificator's name from its safe SQL representation |
| 4318 | |
| 4319 | >>> pushValue(kb.forcedDbms) |
| 4320 | >>> kb.forcedDbms = DBMS.MSSQL |
| 4321 | >>> getText(unsafeSQLIdentificatorNaming("[begin]")) |
| 4322 | 'begin' |
| 4323 | >>> getText(unsafeSQLIdentificatorNaming("foobar")) |
| 4324 | 'foobar' |
| 4325 | >>> kb.forceDbms = popValue() |
| 4326 | """ |
| 4327 | |
| 4328 | retVal = name |
| 4329 | |
| 4330 | if isinstance(name, six.string_types): |
| 4331 | if Backend.getIdentifiedDbms() in (DBMS.MYSQL, DBMS.ACCESS, DBMS.CUBRID, DBMS.SQLITE): |
| 4332 | retVal = name.replace("`", "") |
| 4333 | elif Backend.getIdentifiedDbms() in (DBMS.PGSQL, DBMS.DB2, DBMS.HSQLDB, DBMS.H2, DBMS.INFORMIX, DBMS.MONETDB, DBMS.VERTICA, DBMS.MCKOI, DBMS.PRESTO, DBMS.CRATEDB, DBMS.CACHE, DBMS.EXTREMEDB, DBMS.FRONTBASE, DBMS.RAIMA, DBMS.VIRTUOSO): |
| 4334 | retVal = name.replace("\"", "") |
| 4335 | elif Backend.getIdentifiedDbms() in (DBMS.ORACLE, DBMS.ALTIBASE, DBMS.MIMERSQL): |
| 4336 | retVal = name.replace("\"", "").upper() |
| 4337 | elif Backend.getIdentifiedDbms() in (DBMS.MSSQL, DBMS.SYBASE): |
| 4338 | retVal = name.replace("[", "").replace("]", "") |
| 4339 | |
| 4340 | if Backend.getIdentifiedDbms() in (DBMS.MSSQL, DBMS.SYBASE): |
| 4341 | retVal = re.sub(r"(?i)\A\[?%s\]?\." % DEFAULT_MSSQL_SCHEMA, "", retVal) |
| 4342 | |
| 4343 | return retVal |
| 4344 | |
| 4345 | def isNoneValue(value): |
| 4346 | """ |
no test coverage detected
searching dependent graphs…