| 19 | |
| 20 | |
| 21 | def generate_inline_sql(model: Reference, source_col: List[Column], ref_col: List[Column]) -> str: |
| 22 | result = comment_to_sql(model.comment) if model.comment else '' |
| 23 | result += ( |
| 24 | f'{{c}}FOREIGN KEY ({col_names(source_col)}) ' # type: ignore |
| 25 | f'REFERENCES {get_full_name_for_sql(ref_col[0].table)} ({col_names(ref_col)})' # type: ignore |
| 26 | ) |
| 27 | if model.on_update: |
| 28 | result += f' ON UPDATE {model.on_update.upper()}' |
| 29 | if model.on_delete: |
| 30 | result += f' ON DELETE {model.on_delete.upper()}' |
| 31 | return result |
| 32 | |
| 33 | |
| 34 | def generate_not_inline_sql(model: Reference, source_col: List['Column'], ref_col: List['Column']): |