/**
* Kadabra
*
* Kadabra is an application to mirror a source folder to a destination folder.
* You can create multiple projects wich are stored in an SQLite database.
* With the command status [id] you can see wich changes are made and
* with release [id] you update the changes. You can use different handler
* like System or FTP.
*
* Copyright (c) 2010, 2011 Christoph Kappestein <k42b3.x@gmail.com>
*
* This file is part of oat. oat is free software: you can
* redistribute it and/or modify it under the terms of the GNU
* General Public License as published by the Free Software Foundation,
* either version 3 of the License, or at any later version.
*
* oat is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with oat. If not, see <http://www.gnu.org/licenses/>.
*/
package com.k42b3.kadabra.record;
import com.almworks.sqlite4java.SQLiteStatement;
import com.k42b3.kadabra.Db;
/**
* Release
*
* @author Christoph Kappestein <k42b3.x@gmail.com>
* @license http://www.gnu.org/licenses/gpl.html GPLv3
* @link http://code.google.com/p/delta-quadrant
* @version $Revision: 200 $
*/
public class Release extends Record
{
private int id;
private int projectId;
private String date;
public Release() throws Exception
{
super();
}
public int getId()
{
return id;
}
public void setId(int id)
{
this.id = id;
}
public int getProjectId()
{
return projectId;
}
public void setProjectId(int projectId)
{
this.projectId = projectId;
}
public String getDate()
{
return date;
}
public void setDate(String date)
{
this.date = date;
}
public void insert() throws Exception
{
String sql = "INSERT INTO releases (" +
"projectId, " +
"date " +
") VALUES (" +
"?, " +
"datetime()" +
")";
SQLiteStatement st = Db.getInstance().query(sql);
st.bind(1, this.getProjectId());
st.step();
}
public void update() throws Exception
{
String sql = "UPDATE " +
"releases " +
"SET " +
"projectId = ?, " +
"date = datetime() " +
"WHERE " +
"id = " + this.getId();
SQLiteStatement st = Db.getInstance().query(sql);
st.bind(1, this.getProjectId());
st.step();
}
public void delete() throws Exception
{
String sql = "DELETE FROM " +
"releases " +
"WHERE " +
"id = " + this.getId();
Db.getInstance().exec(sql);
}
public static Release getReleaseById(int id) throws Exception
{
String sql = "SELECT " +
"id, " +
"projectId, " +
"date " +
"FROM " +
"releases " +
"WHERE " +
"id = " + id;
SQLiteStatement st = Db.getInstance().query(sql);
st.step();
if(st.hasRow())
{
Release release = new Release();
release.id = st.columnInt(0);
release.projectId = st.columnInt(1);
release.date = st.columnString(2);
return release;
}
else
{
throw new Exception("Invalid release id");
}
}
public static void setupTable() throws Exception
{
String sql = "CREATE TABLE IF NOT EXISTS releases (" +
"id INTEGER PRIMARY KEY AUTOINCREMENT," +
"projectId INTEGER," +
"date DATETIME" +
")";
Db.getInstance().exec(sql);
}
}