toSql method

String toSql(
  1. DatabaseType dbType
)

Generate foreign key constraint SQL

Implementation

String toSql(DatabaseType dbType) {
  final buffer = StringBuffer();

  if (name != null) {
    buffer.write('CONSTRAINT $name ');
  }

  buffer.write('FOREIGN KEY ($column) ');
  buffer.write('REFERENCES $referencedTable ($referencedColumn)');

  if (onDelete != null) {
    buffer.write(' ON DELETE ${onDelete!.toSql()}');
  }

  if (onUpdate != null) {
    buffer.write(' ON UPDATE ${onUpdate!.toSql()}');
  }

  return buffer.toString();
}