import android.database.sqlite.SQLiteDatabase;
/**
- * Created by Ferrand on 20/07/2014.
+ * @author Ferrand and Nelaupe
*/
public class ProjectsDatabase {
/* --- Singleton --- */
null // The sort order
);
+
while (cursor.moveToNext()) {
Project project = new Project(
cursor.getInt(0), // id
- cursor.getInt(1) == 0 ? false : true, // validate
+ (cursor.getInt(1) == 1), // validate
cursor.getString(2), // title
cursor.getString(3), // description
- cursor.getInt(4) == 0 ? false : true, // validate
+ (cursor.getInt(4) == 1), // validate
cursor.getString(5), // proposed by
cursor.getString(6), // requested funding
cursor.getString(7), // current funding
ContentValues values = new ContentValues();
values.put(ProjectsTable.COLUMN_NAME_ID, project.getResourceId());
- values.put(ProjectsTable.COLUMN_NAME_ACTIVE, project.isActive() == false ? 0 : 1);
+ values.put(ProjectsTable.COLUMN_NAME_ACTIVE, project.isActive() ? 1 : 0);
values.put(ProjectsTable.COLUMN_NAME_TITLE, project.getName());
values.put(ProjectsTable.COLUMN_NAME_DESCRIPTION, project.getDescription());
- values.put(ProjectsTable.COLUMN_NAME_VALIDATE, project.isValidate() == false ? 0 : 1);
+ values.put(ProjectsTable.COLUMN_NAME_VALIDATE, project.isValidate() ? 1 : 0);
values.put(ProjectsTable.COLUMN_NAME_PROPOSED_BY, project.getUser().getResourceId());
values.put(ProjectsTable.COLUMN_NAME_REQUESTED_FUNDING, project.getRequestedFunding());
values.put(ProjectsTable.COLUMN_NAME_CURRENT_FUNDING, project.getCurrentFunding());
SQLiteDatabase db = m_helper.getWritableDatabase();
ContentValues values = new ContentValues();
- values.put(ProjectsTable.COLUMN_NAME_ACTIVE, project.isActive() == false ? 0 : 1);
+ values.put(ProjectsTable.COLUMN_NAME_ACTIVE, !project.isActive() ? 0 : 1);
values.put(ProjectsTable.COLUMN_NAME_TITLE, project.getName());
values.put(ProjectsTable.COLUMN_NAME_DESCRIPTION, project.getDescription());
- values.put(ProjectsTable.COLUMN_NAME_VALIDATE, project.isValidate() == false ? 0 : 1);
+ values.put(ProjectsTable.COLUMN_NAME_VALIDATE, !project.isValidate() ? 0 : 1);
values.put(ProjectsTable.COLUMN_NAME_PROPOSED_BY, project.getUser().getResourceId());
values.put(ProjectsTable.COLUMN_NAME_REQUESTED_FUNDING, project.getRequestedFunding());
values.put(ProjectsTable.COLUMN_NAME_CURRENT_FUNDING, project.getCurrentFunding());
values.put(ProjectsTable.COLUMN_NAME_CONTACT_PHONE, project.getPhone());
values.put(ProjectsTable.COLUMN_NAME_CONTACT_WEBSITE, project.getWebsite());
- String selection = ProjectsTable.COLUMN_NAME_ID;
+ String selection = ProjectsTable.COLUMN_NAME_ID + " = ?";
String[] selectionArgs = {project.getResourceId()};
db.update(ProjectsTable.TABLE_NAME, values, selection, selectionArgs);
public void delete(Project project) {
SQLiteDatabase db = m_helper.getWritableDatabase();
- String selection = ProjectsTable.COLUMN_NAME_ID;
+ String selection = ProjectsTable.COLUMN_NAME_ID + " = ?";
String[] selectionArgs = {project.getResourceId()};
db.delete(ProjectsTable.TABLE_NAME, selection, selectionArgs);