508493: releng: add check if apikey already exsists
Change-Id: I490d6f22a5a55219ac1785eb45c73050cbbf9c1b
Task-Url: https://bugs.eclipse.org/bugs/show_bug.cgi?id=508493
diff --git a/org.eclipse.mylyn.bugzilla.releng/modules/bugzilla/templates/Extension.pm.erb b/org.eclipse.mylyn.bugzilla.releng/modules/bugzilla/templates/Extension.pm.erb
index c83928d..40a6bb1 100644
--- a/org.eclipse.mylyn.bugzilla.releng/modules/bugzilla/templates/Extension.pm.erb
+++ b/org.eclipse.mylyn.bugzilla.releng/modules/bugzilla/templates/Extension.pm.erb
@@ -90,11 +90,14 @@
my ($testuser_id_test) = $dbh->selectrow_array(
'SELECT userid FROM profiles WHERE login_name = ? ' ,
undef, 'tests@mylyn.eclipse.org');
- my $sth = $dbh->prepare( "INSERT INTO user_api_keys
- (user_id, api_key, description)
- VALUES (?, ?, ?)");
- $sth->execute($testuser_id_admin, 'XkjcuGGfDcoNx0U6uyMM8ZaNuBlEdjrmXd8In3no', 'Mylyn REST Connector Admin');
- $sth->execute($testuser_id_test, 'wvkz2SoBMBQEKv6ishp1j7NY1R9l711g5w2afXc6', 'Mylyn REST Connector Test');
+ if (!$dbh->selectrow_array('SELECT 1 FROM user_api_keys where user_id > 1')) {
+
+ my $sth = $dbh->prepare( "INSERT INTO user_api_keys
+ (user_id, api_key, description)
+ VALUES (?, ?, ?)");
+ $sth->execute($testuser_id_admin, 'XkjcuGGfDcoNx0U6uyMM8ZaNuBlEdjrmXd8In3no', 'Mylyn REST Connector Admin');
+ $sth->execute($testuser_id_test, 'wvkz2SoBMBQEKv6ishp1j7NY1R9l711g5w2afXc6', 'Mylyn REST Connector Test');
+ }
<% end %>