From 523bb88247ff8676f7692c9655fa87c75c7d66e9 Mon Sep 17 00:00:00 2001 From: "jungwook.ryu" Date: Fri, 29 Aug 2014 07:51:10 +0900 Subject: [PATCH] Revision constraint of table for Systemchart Change-Id: Ieecc5abd5fa71891e2d6e7d0e182c6b8e8dd9ae9 Signed-off-by: jungwook.ryu --- .../src/org/tizen/dynamicanalyzer/ui/timeline/CustomDataDBTable.java | 3 ++- .../src/org/tizen/dynamicanalyzer/ui/timeline/ScreenShotDBTable.java | 3 ++- .../src/org/tizen/dynamicanalyzer/ui/timeline/SystemDataDBTable.java | 3 ++- .../org/tizen/dynamicanalyzer/ui/timeline/TargetProcessDBTable.java | 3 ++- .../src/org/tizen/dynamicanalyzer/ui/timeline/UIEventDBTable.java | 3 ++- 5 files changed, 10 insertions(+), 5 deletions(-) diff --git a/org.tizen.dynamicanalyzer/src/org/tizen/dynamicanalyzer/ui/timeline/CustomDataDBTable.java b/org.tizen.dynamicanalyzer/src/org/tizen/dynamicanalyzer/ui/timeline/CustomDataDBTable.java index 2781b18..08717a1 100644 --- a/org.tizen.dynamicanalyzer/src/org/tizen/dynamicanalyzer/ui/timeline/CustomDataDBTable.java +++ b/org.tizen.dynamicanalyzer/src/org/tizen/dynamicanalyzer/ui/timeline/CustomDataDBTable.java @@ -53,9 +53,10 @@ public class CustomDataDBTable extends DBTable { } public CustomDataDBTable() { - addColumn(new DBColumn(TIME, DBConstants.PRIMARY_KEY, DBConstants.LONG)); + addColumn(new DBColumn(TIME, DBConstants.NOT_NULL, DBConstants.LONG)); addColumn(new DBColumn(CHART_HANDLE, DBConstants.NOT_NULL, DBConstants.INTEGER)); addColumn(new DBColumn(CHART_VALUE, DBConstants.NOT_NULL, DBConstants.FLOAT)); + setIndexColumn(COLUMN.TIME.ordinal()); } @Override diff --git a/org.tizen.dynamicanalyzer/src/org/tizen/dynamicanalyzer/ui/timeline/ScreenShotDBTable.java b/org.tizen.dynamicanalyzer/src/org/tizen/dynamicanalyzer/ui/timeline/ScreenShotDBTable.java index d25093b..ff217dc 100644 --- a/org.tizen.dynamicanalyzer/src/org/tizen/dynamicanalyzer/ui/timeline/ScreenShotDBTable.java +++ b/org.tizen.dynamicanalyzer/src/org/tizen/dynamicanalyzer/ui/timeline/ScreenShotDBTable.java @@ -55,9 +55,10 @@ public class ScreenShotDBTable extends DBTable { } public ScreenShotDBTable() { - addColumn(new DBColumn(TIME, DBConstants.PRIMARY_KEY, DBConstants.LONG)); + addColumn(new DBColumn(TIME, DBConstants.NOT_NULL, DBConstants.LONG)); addColumn(new DBColumn(IMAGE_FILE_PATH, DBConstants.NOT_NULL, DBConstants.VARCHAR, MAX_IMAGEPATH_LEN)); addColumn(new DBColumn(IMAGE_ORIENTATION, DBConstants.NOT_NULL, DBConstants.INTEGER)); + setIndexColumn(COLUMN.TIME.ordinal()); } @Override diff --git a/org.tizen.dynamicanalyzer/src/org/tizen/dynamicanalyzer/ui/timeline/SystemDataDBTable.java b/org.tizen.dynamicanalyzer/src/org/tizen/dynamicanalyzer/ui/timeline/SystemDataDBTable.java index f932793..f41bce8 100644 --- a/org.tizen.dynamicanalyzer/src/org/tizen/dynamicanalyzer/ui/timeline/SystemDataDBTable.java +++ b/org.tizen.dynamicanalyzer/src/org/tizen/dynamicanalyzer/ui/timeline/SystemDataDBTable.java @@ -88,7 +88,7 @@ public class SystemDataDBTable extends DBTable { } public SystemDataDBTable() { - addColumn(new DBColumn(TIME, DBConstants.PRIMARY_KEY, DBConstants.LONG)); + addColumn(new DBColumn(TIME, DBConstants.NOT_NULL, DBConstants.LONG)); addColumn(new DBColumn(CPU_LOAD_TOTAL, DBConstants.EMPTY, DBConstants.FLOAT)); addColumn(new DBColumn(PROCESS_COUNT_OTHER, DBConstants.EMPTY, DBConstants.INTEGER)); addColumn(new DBColumn(PROCESS_COUNT_TARGET, DBConstants.EMPTY, DBConstants.INTEGER)); @@ -108,6 +108,7 @@ public class SystemDataDBTable extends DBTable { addColumn(new DBColumn(PROCESS_PID_OTHER, DBConstants.EMPTY, DBConstants.INTEGER_ARRAY)); addColumn(new DBColumn(PROCESS_LOAD_OTHER, DBConstants.EMPTY, DBConstants.FLOAT_ARRAY)); addColumn(new DBColumn(DEVICE_STATUS, DBConstants.EMPTY, DBConstants.INTEGER_ARRAY)); + setIndexColumn(COLUMN.TIME.ordinal()); } @Override diff --git a/org.tizen.dynamicanalyzer/src/org/tizen/dynamicanalyzer/ui/timeline/TargetProcessDBTable.java b/org.tizen.dynamicanalyzer/src/org/tizen/dynamicanalyzer/ui/timeline/TargetProcessDBTable.java index 291abf2..80d6f4b 100644 --- a/org.tizen.dynamicanalyzer/src/org/tizen/dynamicanalyzer/ui/timeline/TargetProcessDBTable.java +++ b/org.tizen.dynamicanalyzer/src/org/tizen/dynamicanalyzer/ui/timeline/TargetProcessDBTable.java @@ -75,7 +75,7 @@ public class TargetProcessDBTable extends DBTable { } public TargetProcessDBTable() { - addColumn(new DBColumn(TIME, DBConstants.PRIMARY_KEY, DBConstants.LONG)); + addColumn(new DBColumn(TIME, DBConstants.NOT_NULL, DBConstants.LONG)); addColumn(new DBColumn(PID, DBConstants.EMPTY, DBConstants.INTEGER)); addColumn(new DBColumn(CPU_LOAD, DBConstants.EMPTY, DBConstants.FLOAT)); addColumn(new DBColumn(MEMORY_VIRTUAL, DBConstants.EMPTY, DBConstants.LONG)); @@ -89,6 +89,7 @@ public class TargetProcessDBTable extends DBTable { addColumn(new DBColumn(HEAP_ALLOCATION_BYTE, DBConstants.EMPTY, DBConstants.BIGINT_ARRAY)); addColumn(new DBColumn(THREAD_ID, DBConstants.EMPTY, DBConstants.INTEGER_ARRAY)); addColumn(new DBColumn(THREAD_LOAD, DBConstants.EMPTY, DBConstants.FLOAT_ARRAY)); + setIndexColumn(COLUMN.TIME.ordinal()); } @Override diff --git a/org.tizen.dynamicanalyzer/src/org/tizen/dynamicanalyzer/ui/timeline/UIEventDBTable.java b/org.tizen.dynamicanalyzer/src/org/tizen/dynamicanalyzer/ui/timeline/UIEventDBTable.java index 7a85350..7387a10 100644 --- a/org.tizen.dynamicanalyzer/src/org/tizen/dynamicanalyzer/ui/timeline/UIEventDBTable.java +++ b/org.tizen.dynamicanalyzer/src/org/tizen/dynamicanalyzer/ui/timeline/UIEventDBTable.java @@ -63,13 +63,14 @@ public class UIEventDBTable extends DBTable { } public UIEventDBTable() { - addColumn(new DBColumn(TIME, DBConstants.PRIMARY_KEY, DBConstants.LONG)); + addColumn(new DBColumn(TIME, DBConstants.NOT_NULL, DBConstants.LONG)); addColumn(new DBColumn(EVENT_TYPE, DBConstants.NOT_NULL, DBConstants.INTEGER)); addColumn(new DBColumn(DETAIL_TYPE, DBConstants.NOT_NULL, DBConstants.INTEGER)); addColumn(new DBColumn(POINT_X, DBConstants.NOT_NULL, DBConstants.INTEGER)); addColumn(new DBColumn(POINT_Y, DBConstants.NOT_NULL, DBConstants.INTEGER)); addColumn(new DBColumn(INFO_STRING, DBConstants.NOT_NULL, DBConstants.VARCHAR, MAX_INFO_LEN)); addColumn(new DBColumn(INFO_INTEGER, DBConstants.NOT_NULL, DBConstants.INTEGER)); + setIndexColumn(COLUMN.TIME.ordinal()); } @Override -- 2.7.4