my $sql = qq{
  INSERT INTO script (repoid, sname)
  SELECT repoid, '$scriptN' as sname
  FROM repository
  WHERE rname = '} . $repository->getName . qq{'
};
$logger->debug($sql);
my $query = $self->{dbConn}->prepare($sql)
  or die "Can't prepare: $DBI::errstr";
my $affected = $query->execute() or die "Can't execute: $DBI::errstr";
$self->{dbConn}->commit;