// Path: core/src/main/java/com/ccoe/build/core/model/Plugin.java
// public class Plugin extends TrackingModel {
// 	private String groupId;
// 	private String artifactId;
// 	private String version;
// 	
// 	private String status;
// 	private String executionId;
// 	
// 	private String phaseName;
// 	private String pluginKey;
// 	
// 	private int id;
// 	
// 	private String payload;
// 
// 	public String getGroupId() {
// 		return groupId;
// 	}
// 
// 	public void setGroupId(String groupId) {
// 		this.groupId = groupId;
// 	}
// 
// 	public String getArtifactId() {
// 		return artifactId;
// 	}
// 
// 	public void setArtifactId(String artifactId) {
// 		this.artifactId = artifactId;
// 	}
// 
// 	public String getVersion() {
// 		return version;
// 	}
// 
// 	public void setVersion(String version) {
// 		this.version = version;
// 	}
// 
// 	public String getStatus() {
// 		return status;
// 	}
// 
// 	public void setStatus(String status) {
// 		this.status = status;
// 	}
// 
// 	public String getExecutionId() {
// 		return executionId;
// 	}
// 
// 	public void setExecutionId(String executionId) {
// 		this.executionId = executionId;
// 	}
// 
// 	public String getPhaseName() {
// 		return phaseName;
// 	}
// 
// 	public void setPhaseName(String phaseName) {
// 		this.phaseName = phaseName;
// 	}
// 
// 	public String getPluginKey() {
// 		return pluginKey;
// 	}
// 
// 	public void setPluginKey(String pluginKey) {
// 		this.pluginKey = pluginKey;
// 	}
// 
// 	public int getId() {
// 		return id;
// 	}
// 
// 	public void setId(int id) {
// 		this.id = id;
// 	}
// 
// 	public String getPayload() {
// 		return payload;
// 	}
// 
// 	public void setPayload(String payload) {
// 		this.payload = payload;
// 	}
// 	
// 	public String toString() {
// 		StringBuffer sBuffer = new StringBuffer();
// 		appendTransactionAtom(sBuffer, 4, "Plugin", getPluginKey(), this.getStatus(), getDuration().toString(), getPayload());
// 		return sBuffer.toString();
// 	}
// }


import com.ccoe.build.core.model.Plugin;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.List;
import javax.sql.DataSource;
import org.springframework.jdbc.core.BatchPreparedStatementSetter;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.PreparedStatementCreator;
import org.springframework.jdbc.support.GeneratedKeyHolder;
import org.springframework.jdbc.support.KeyHolder;
/*
Copyright [2013-2014] eBay Software Foundation

Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
You may obtain a copy of the License at

    http://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an "AS IS" BASIS,
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
See the License for the specific language governing permissions and
limitations under the License.

*/

package com.ccoe.build.dal;





public class RawDataJDBCTemplate {
	private DataSource dataSource;
	private JdbcTemplate jdbcTemplateObject;

	public void setDataSource(DataSource dataSource) {
		this.dataSource = dataSource;
		this.jdbcTemplateObject = new JdbcTemplate(dataSource);
	}

	// TODO event date
// Path: core/src/main/java/com/ccoe/build/core/model/Plugin.java
// public class Plugin extends TrackingModel {
// 	private String groupId;
// 	private String artifactId;
// 	private String version;
// 	
// 	private String status;
// 	private String executionId;
// 	
// 	private String phaseName;
// 	private String pluginKey;
// 	
// 	private int id;
// 	
// 	private String payload;
// 
// 	public String getGroupId() {
// 		return groupId;
// 	}
// 
// 	public void setGroupId(String groupId) {
// 		this.groupId = groupId;
// 	}
// 
// 	public String getArtifactId() {
// 		return artifactId;
// 	}
// 
// 	public void setArtifactId(String artifactId) {
// 		this.artifactId = artifactId;
// 	}
// 
// 	public String getVersion() {
// 		return version;
// 	}
// 
// 	public void setVersion(String version) {
// 		this.version = version;
// 	}
// 
// 	public String getStatus() {
// 		return status;
// 	}
// 
// 	public void setStatus(String status) {
// 		this.status = status;
// 	}
// 
// 	public String getExecutionId() {
// 		return executionId;
// 	}
// 
// 	public void setExecutionId(String executionId) {
// 		this.executionId = executionId;
// 	}
// 
// 	public String getPhaseName() {
// 		return phaseName;
// 	}
// 
// 	public void setPhaseName(String phaseName) {
// 		this.phaseName = phaseName;
// 	}
// 
// 	public String getPluginKey() {
// 		return pluginKey;
// 	}
// 
// 	public void setPluginKey(String pluginKey) {
// 		this.pluginKey = pluginKey;
// 	}
// 
// 	public int getId() {
// 		return id;
// 	}
// 
// 	public void setId(int id) {
// 		this.id = id;
// 	}
// 
// 	public String getPayload() {
// 		return payload;
// 	}
// 
// 	public void setPayload(String payload) {
// 		this.payload = payload;
// 	}
// 	
// 	public String toString() {
// 		StringBuffer sBuffer = new StringBuffer();
// 		appendTransactionAtom(sBuffer, 4, "Plugin", getPluginKey(), this.getStatus(), getDuration().toString(), getPayload());
// 		return sBuffer.toString();
// 	}
// }


// Path: publisher/src/main/java/com/ccoe/build/dal/RawDataJDBCTemplate.java
import com.ccoe.build.core.model.Plugin;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.List;
import javax.sql.DataSource;
import org.springframework.jdbc.core.BatchPreparedStatementSetter;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.PreparedStatementCreator;
import org.springframework.jdbc.support.GeneratedKeyHolder;
import org.springframework.jdbc.support.KeyHolder;

/*
Copyright [2013-2014] eBay Software Foundation

Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
You may obtain a copy of the License at

    http://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an "AS IS" BASIS,
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
See the License for the specific language governing permissions and
limitations under the License.

*/

package com.ccoe.build.dal;





public class RawDataJDBCTemplate {
	private DataSource dataSource;
	private JdbcTemplate jdbcTemplateObject;

	public void setDataSource(DataSource dataSource) {
		this.dataSource = dataSource;
		this.jdbcTemplateObject = new JdbcTemplate(dataSource);
	}

	// TODO event date
	public int create(final Plugin plugin, final int sessionID, final int projectID) {