sqlQueryUpdateM method

String sqlQueryUpdateM(
  1. int length, [
  2. String condition = ''
])
inherited

Implementation

String sqlQueryUpdateM(int length, [String condition = '']) => '''
  WITH $_nameTemp(
    ${columns.map(_columnsMapNames).join(', ')}
  ) AS (${_sqlQueryValues(length)})
  UPDATE $name SET
  ${columns.map((e) => '''
        ${e.name} = (
          SELECT ${e.name} FROM $_nameTemp
          WHERE $name.${columnId.name} = $_nameTemp.${columnId.name}
        )
      ''').join(', ')}
   WHERE ${columnId.name} IN (SELECT ${columnId.name} FROM $name.${columnId.name});
''';