| 191 | |
| 192 | |
| 193 | def _adapt_sql_for_postgres(sql: str) -> str: |
| 194 | adapted = sql |
| 195 | adapted = _SQLITE_AUTOINCREMENT_PATTERN.sub("SERIAL PRIMARY KEY", adapted) |
| 196 | adapted = _SQLITE_REAL_PATTERN.sub("DOUBLE PRECISION", adapted) |
| 197 | adapted = _ALTER_ADD_COLUMN_PATTERN.sub(r"ALTER TABLE \1 ADD COLUMN IF NOT EXISTS ", adapted) |
| 198 | adapted = _replace_sqlite_datetime_functions(adapted) |
| 199 | adapted = _escape_psycopg_percent_literals(adapted) |
| 200 | adapted = _replace_unquoted_question_marks(adapted) |
| 201 | return adapted |
| 202 | |
| 203 | |
| 204 | def _should_append_returning_id(sql: str) -> bool: |