public QueryRunnable(String context) {
contextPath = context;
if (contextPath == "") contextPath = Config.getProperty(CONTEXT);
dataFolderPath = Config.getProperty(TEMPDIR);
queriedSources = new ArrayList<DataSource>();
queryCC = new ArrayList<String>();
dataProcesses = new ArrayList<DataProcess>();
OS = checkOS();
}
public PlanarImage gridToEmage(double[][] dataGrid, String imageName) throws IOException {
// creates a gray-scale image of the values
int width = dataGrid[0].length;
int height = dataGrid.length;
// Get the number of bands on the image.
URL imgURL = new URL(Config.getProperty("imgURL"));
PlanarImage dummyImage = JAI.create("URL", imgURL); // dummy loaded. date to be edited.
SampleModel sm = dummyImage.getSampleModel();
int nbands = sm.getNumBands();
// We assume that we can get the pixels values in a integer array.
double[] pixelTemp = new double[nbands];
// Get an iterator for the image.
RandomIterFactory.create(dummyImage, null);
WritableRaster rasterData =
RasterFactory.createBandedRaster(
DataBuffer.TYPE_BYTE, width, height, nbands, new Point(0, 0));
for (int i = 0; i < height; i++) {
for (int j = 0; j < width; j++) {
dataGrid[i][j] = (dataGrid[i][j] <= 255) ? dataGrid[i][j] : 255;
pixelTemp[0] = dataGrid[i][j];
pixelTemp[1] = dataGrid[i][j];
pixelTemp[2] = dataGrid[i][j];
rasterData.setPixel(j, i, pixelTemp);
}
}
SampleModel sModel2 =
RasterFactory.createBandedSampleModel(DataBuffer.TYPE_BYTE, width, height, nbands);
// Try to create a compatible ColorModel - if the number of bands is
// larger than 4, it will be null.
ColorModel cModel2 = PlanarImage.createColorModel(sModel2);
// Create a TiledImage using the sample and color models.
TiledImage rectImage = new TiledImage(0, 0, width, height, 0, 0, sModel2, cModel2);
// Set the data of the tiled image to be the raster.
rectImage.setData(rasterData);
// Save the image on a file.
try {
ImageIO.write(rectImage, "jpg", new File(imageName + ".jpg"));
log.info("debug save image : " + imageName + ".jpg");
} catch (IOException e) {
log.error(e.getMessage());
log.error("Error in rectifying image");
}
return rectImage;
}
public class Constant {
public static final String GET_LINKED_DS = "SELECT linked_ds FROM Query_Master";
public static final String DELETE_QUERY_MASTER_QRY = "DELETE FROM Query_Master WHERE query_id=?";
public static final String INSERT_QUERY_MASTER_QRY =
"INSERT INTO Query_Master(query_creator_id,query_name,query_esql,time_window,latitude_unit,"
+ "longitude_unit,boundingbox, linked_ds) values(?,?,?,?,?,?,?,?)";
public static final String DELETE_WRAPPER_QUERY = "DELETE FROM Wrapper WHERE dsmaster_Id=?";
public static final String DELETE_DS_RESOLUTION_QUERY =
"DELETE FROM Datasource_Resolution WHERE dsmaster_Id=?";
public static final String DELETE_DS_MASTER_QUERY =
"DELETE FROM Datasource_Master WHERE dsmaster_Id=?";
public static final String INSERT_WRAPPER_QRY =
"INSERT INTO Wrapper(wrapper_name,wrapper_key_value,bag_of_words,dsmaster_id) values(?,?,?,?)";
public static final String INSERT_DATASOURCE_RESOLUTION_QRY =
"INSERT INTO Datasource_Resolution(dsmaster_id,time_window,latitude_unit,longitude_unit,boundingbox,syncTime) values(?,?,?,?,?,?)";
public static final String INSERT_DATASOURCE_QRY =
"INSERT INTO Datasource_Master(dsmaster_title,dsmaster_theme,dsmaster_url,dsmaster_format,"
+ "dsmaster_creator,dsmaster_created_date,dsmaster_updated_date, dsmaster_syntax) values(?,?,?,?,?,now(),now(),?)";
public static final String INSERT_RULE_QRY =
"INSERT INTO RuleQueryMaster (Rule_Name, source_id, Rule_Queries, source_fields, user_id) values (?,?,?,?,?)";
public static final String INSERT_DEFAULT_RULE_QRY =
"INSERT INTO RuleQueryMaster (Rule_Name, Rule_Queries, source_id, source_fields, user_id) values (?,?,?,?,?)";
public static final String UPDATE_RULE_QRY =
"UPDATE RuleQueryMaster set Rule_Name=?,source_id=?,Rule_Queries=?,source_fields=? where RuleID = ?";
public static final String GET_ALL_DSID = "SELECT dsmaster_id FROM Datasource_Master";
public static final String GET_ALL_DSID_ENABLED =
"SELECT dsmaster_id FROM Datasource_Master where dsmaster_status = ?";
public static final String GET_ALL_BOW =
"SELECT bag_of_words FROM Wrapper where bag_of_words != \"\"";
public static final String GET_MAX_ALRT_ID = "SELECT MAX(alert_id) FROM Alerts";
public static final String DISABLE_ALL_ALERTS = "UPDATE Alerts SET alert_status = 0";
public static final String GET_ALL_ALERTS_FOR_USER =
"******";
public static final String GET_ALL_ALERTS = "SELECT * FROM Alerts";
public static final String GET_ALL_ENABLED_ALERTS = "SELECT * FROM Alerts WHERE alert_status = 1";
public static final String GET_ALL_ENABLED_ALERTS_FOR_ID =
"SELECT * FROM Alerts WHERE alert_status = 1 AND (alert_src = ? OR safe_src = ?)";
public static final String SELECT_ALL_RULE_ID_QRY =
"SELECT RuleID,source_id from RuleQueryMaster order by RuleID DESC";
public static final String DS_STAT_QRY =
"SELECT dsmaster_status FROM Datasource_Master WHERE dsmaster_id = ?";
public static final String QUERY_STAT_QRY =
"SELECT query_status FROM Query_Master WHERE query_id = ?";
public static final String GET_ALERT_DTLS =
"SELECT alert_type, alert_name, alert_theme, alert_src, alert_src_min, alert_src_max, safe_src, safe_src_min, safe_src_max, alert_status, resultEndpoint, alert_message, boundingbox, lat, lng, radius FROM Alerts WHERE alert_id = ?";
public static final String DISABLE_ALERT_QRY =
"UPDATE Alerts SET alert_status = 0 WHERE alert_id = ?";
public static final String ENABLE_ALERT_QRY =
"UPDATE Alerts SET alert_status = 1 WHERE alert_id = ?";
public static final String INST_SINGLE_ALT_QRY =
"INSERT INTO Alerts (alert_name,alert_type,alert_theme,alert_src,alert_src_min,alert_src_max,alert_status,user_id,resultEndpoint,alert_message,lat,lng,radius) values (?,?,?,?,?,?,?,?,?,?,?,?,?)";
public static final String INST_SINGLE_ALT_QRY_WITH_ENDPOINT =
"INSERT INTO Alerts (alert_name,alert_type,alert_theme,alert_src,alert_src_min,alert_src_max,alert_status,user_id,safe_src,safe_src_min,safe_src_max,resultEndpoint,alert_message) values (?,?,?,?,?,?,?,?,null,null,null,?,?)";
public static final String INST_SINGLE_ALT_QRY_WITH_ENDPOINT_AND_BOUNDINGBOX =
"INSERT INTO Alerts (alert_name,alert_type,alert_theme,alert_src,alert_src_min,alert_src_max,alert_status,user_id,safe_src,safe_src_min,safe_src_max,resultEndpoint,alert_message,boundingbox,lat,lng,radius) values (?,?,?,?,?,?,?,?,null,null,null,?,?,?,?,?,?)";
public static final String UPDATE_SOL_ALT_QRY =
"UPDATE Alerts SET alert_name=?,alert_type=?,alert_theme=?,alert_src=?,alert_src_min=?,alert_src_max=?,safe_src=?,safe_src_min=?,safe_src_max=?,resultEndpoint=?,alert_message=?,lat=?,lng=?,radius=? WHERE alert_id=?";
public static final String INST_SOL_ALT_QRY =
"INSERT INTO Alerts (alert_name,alert_type,alert_theme,alert_src,alert_src_min,alert_src_max,alert_status,user_id,safe_src,safe_src_min,safe_src_max,resultEndpoint,alert_message,lat,lng,radius) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
public static final String INST_SOL_ALT_QRY_WITH_ENDPOINT =
"INSERT INTO Alerts (alert_name,alert_type,alert_theme,alert_src,alert_src_min,alert_src_max,alert_status,user_id,safe_src,safe_src_min,safe_src_max, resultEndpoint, alert_message) values (?,?,?,?,?,?,?,?,?,?,?,?,?)";
public static final String INST_SOL_ALT_QRY_WITH_ENDPOINT_AND_BOUNDINGBOX =
"INSERT INTO Alerts (alert_name,alert_type,alert_theme,alert_src,alert_src_min,alert_src_max,alert_status,user_id,safe_src,safe_src_min,safe_src_max,resultEndpoint,alert_message,boundingbox,lat,lng,radius) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
public static final String INSERT_ALERT =
"INSERT INTO Alerts (alert_id,alert_name,alert_type,alert_theme,alert_src,alert_src_min,alert_src_max,alert_status,user_id,safe_src,safe_src_min,safe_src_max) values (?,?,?,?,?,?,?,?,?,?,?,?)";
public static final String Query = "Query";
public static final String DS = "DS";
public static final String userId = "userId";
public static final String dsmaster_id = "dsmaster_id";
public static final String dsmaster_title = "dsmaster_title";
public static final String STATUS_NOT_AVAILABLE = "Connecting";
public static final String STATUS_AVAILABLE = "Available";
public static final String SELECT_DSMSTR_QRY =
"SELECT dm.dsmaster_id, dm.dsmaster_title,dm.dsmaster_creator FROM Datasource_Master dm WHERE dm.dsmaster_creator=?";
public static final String SLCT_DSMSTR_DSNAMES_QRY =
"SELECT dm.dsmaster_title FROM Datasource_Master dm WHERE dm.dsmaster_creator=?";
public static final String SELECT_USERMSTR_QRY =
"SELECT um.user_id,um.user_fullname,um.user_email,um.user_authen_key,rm.role_type,um.user_status,um.user_last_accessd,um.user_role_id FROM tbl_User_Master um,tbl_Role_Master rm WHERE um.user_role_id=rm.role_id";
public static final String TEMPDIR = "tempDir";
public static final String SELECT_QRYMSTR =
"SELECT query_id,query_name,query_status FROM Query_Master WHERE query_creator_id=?";
public static final String SLCT_QRYMSTR_QYNAMES_QRY =
"SELECT query_name FROM Query_Master WHERE query_creator_id=? order by query_id DESC";
public static final String UPDATE_USERMSTR_STATUS_QRY =
"UPDATE tbl_User_Master SET user_status=? WHERE user_id=?";
public static final String NO_DATA = "No data provided";
public static final String SUCCESS = "success";
public static final String DB_EXPT = "DB Exception";
public static final String UPDATE_USERMSTR_QRY =
"UPDATE tbl_User_Master um SET um.user_fullname=?,um.user_email=?,um.user_authen_key=?,um.user_role_id=?,um.user_status=? WHERE um.user_id=?";
public static final String SELECT_DSMSTR_DSRES_QRY =
"SELECT ds.dsmaster_id,ds.dsmaster_theme,ds.dsmaster_desc,ds.dsmaster_format,ds.dsmaster_title,dr.boundingbox,ds.dsmaster_access,dr.time_window FROM Datasource_Master ds, Datasource_Resolution dr WHERE ds.dsmaster_id=dr.dsmaster_id"; // passing
// time_window
// for
// registerservlet
// --sanjukta
// 06-08-2014
public static final String PATH_DS = "/temp/ds/";
public static final String PATH_Q = "/temp/queries/";
public static final String UNDERSCORE = "_";
public static final String SELECT_DS_QRY =
"SELECT ds.dsmaster_id,ds.dsmaster_theme,ds.dsmaster_desc,ds.dsmaster_url,ds.dsmaster_format,ds.dsmaster_type,um.user_email as Creater,ds.dsmaster_archive,ds.dsmaster_unit,ds.dsmaster_created_date FROM Datasource_Master ds,tbl_User_Master um WHERE ds.dsmaster_creator=um.user_id AND ds.dsmaster_id=?";
public static final String SELECT_DS_RES =
"SELECT dsmaster_id, time_window, latitude_unit, longitude_unit, boundingbox, regrid_function, resolution_type FROM Datasource_Resolution WHERE dsmaster_id=? AND resolution_type='initial' ORDER BY dsresolution_id DESC limit 1";
public static final String SELECT_DS_QRY_TIMEWIN =
"SELECT ds.dsmaster_id,ds.dsmaster_theme,ds.dsmaster_desc,ds.dsmaster_url,ds.dsmaster_format,ds.dsmaster_type,ds.dsmaster_archive,ds.dsmaster_unit,ds.dsmaster_created_date,dr.time_window,um.user_email FROM Datasource_Master ds,Datasource_Resolution dr, tbl_User_Master um WHERE ds.dsmaster-id=dr.dsmaster_id and ds.dsmaster_creator=um.user_id AND ds.dsmaster_id=?";
public static final String SELECT_USERDS_QRY =
"SELECT um.user_id,um.user_fullname FROM tbl_User_Master um, tbl_User_Datasource uds WHERE uds.user_id=um.user_id AND uds.dsmaster_id=?";
public static final String FAILURE = "failure";
public static final String DEL_USERDS_QRY = "DELETE FROM tbl_User_Datasource WHERE dsmaster_Id=?";
public static final String INSERT_USERDS_QRY =
"INSERT INTO tbl_User_Datasource (user_id,dsmaster_id) VALUES (?,?)";
public static final String DEL_DSMSTR_QRY = "DELETE FROM Datasource_Master WHERE dsmaster_Id=?";
// public static String DEL_DSRES_QRY =
// "DELETE FROM Datasource_Resolution WHERE dsmaster_Id=?";
// public static String DEL_DSRES_QRY =
// "DELETE FROM "+tablName+" WHERE "+colName+"=?";
public static final String SELECT_QRYMSTR_ADMIN_QRY =
"SELECT query_id,query_name,boundingbox,query_status FROM Query_Master WHERE qid_parent IS NULL order by query_id DESC";
public static final String SELECT_ENABLED_QUERIES_WITH_DS_ID =
"SELECT query_id,query_creator_id,query_name,query_desc,query_esql,time_window,latitude_unit,longitude_unit,boundingbox,query_status, qid_parent FROM Query_Master WHERE query_status=? and linked_ds LIKE ? order by query_id DESC";
public static final String SELECT_QRYMSTR_ALL =
"SELECT * FROM Query_Master order by query_id DESC";
public static final String ENABLE_QUERY =
"UPDATE Query_Master SET query_status = 1 WHERE query_id = ?";
public static final String DISABLE_QUERY =
"UPDATE Query_Master SET query_status = 0 WHERE query_id = ?";
public static final String SELECT_QRYMSTR_QRY =
"SELECT * FROM Query_Master WHERE qid_parent IS NULL";
public static final String SELECT_QRY_BYID =
"SELECT query_name,boundingbox,query_status,time_window FROM Query_Master WHERE query_id=?";
public static final String CONTROLFLAG = "R";
public static final String DEL_QRYMSTR_QRY = "DELETE FROM Query_Master WHERE query_id=?";
public static final String DRIVER_NAME = "com.mysql.jdbc.Driver";
public static final String DB_URL = "dbUrl";
public static final String USR_NAME = "usr";
public static final String PASSWORD = "******";
public static final String SELECT_USRMSTR_QRY = "SELECT * FROM tbl_User_Master";
public static final String SELECT_USR_FROM_EMAIL =
"SELECT user_id FROM tbl_User_Master WHERE user_email = ?";
public static final String INSERT_USERMSTR_QRY =
"INSERT INTO tbl_User_Master(user_email,user_password,user_fullname,user_gender,user_authen_key,user_role_id,user_created_date,user_last_accessd) values(?,AES_ENCRYPT(?,?),?,?,?,?,now(),now())";
public static final String ADMIN = "Admin";
public static final String SELECT_USRMSTR_AUTH_QRY =
"SELECT user_authen_key from tbl_User_Master WHERE user_email=?";
public static final String SELECT_USRMSTR_ARG_QRY =
"SELECT user_id FROM tbl_User_Master WHERE user_email=? and user_password=AES_ENCRYPT(?,?)";
public static final String SELECT_USRMSTR_ADMIN_QRY =
"SELECT A.user_id FROM tbl_User_Master A, tbl_Role_Master B WHERE A.user_role_id=B.role_id and B.role_type='";
public static final String SELECT_USRMSTR_ADMIN_ARG_QRY =
"' and A.user_email=? and A.user_password=AES_ENCRYPT(?,?)";
public static final String USER_ID = "user_id";
public static final String WRAPPER_TYPE = "PULL";
public static final String INITIAL_RESOLUTION = "initial";
public static final String FINAL_RESOLUTION = "final";
public static final String INSERT_DSMSTR_QRY =
"INSERT INTO Datasource_Master(dsmaster_title,dsmaster_theme,dsmaster_url,dsmaster_format,"
+ "dsmaster_syntax,dsmaster_created_date,dsmaster_updated_date,dsmaster_creator) values(?,?,?,?,?,now(),now(),?)";
public static final String EMPTY_STRING = "";
public static final String SELECT_LST_INSID = "SELECT LAST_INSERT_ID()";
public static final String UPDATE_DSMSTR_QRY =
"UPDATE Datasource_Master SET dsmaster_title=?, dsmaster_theme=?, dsmaster_url=?, "
+ "dsmaster_format=?, dsmaster_updated_date=now(), dsmaster_syntax=? WHERE dsmaster_id=?";
public static final String INSRT_WRPR_QRY =
"INSERT INTO Wrapper(wrapper_name,wrapper_type,wrapper_key_value,bag_of_words,visual_tran_mat,visual_color_mat,visual_mask_mat,visual_ignore_since,csv_file_url,dsmaster_id) values(?,?,?,?,?,?,?,?,?,?)";
public static final String UPDATE_WRPR_QRY =
"UPDATE Wrapper SET wrapper_name=?, wrapper_type=?, wrapper_key_value=?, bag_of_words=?, visual_tran_mat=?, visual_color_mat=?, visual_mask_mat=?, "
+ "visual_ignore_since=?, csv_file_url=? where wrapper_id=? ";
public static final String INSERT_DSRES_QRY =
"INSERT INTO Datasource_Resolution(dsmaster_id,datastream_name,time_window,syncTime,latitude_unit,"
+ "longitude_unit,boundingbox, resolution_type, timeType, dsQuery, genEmage) values(?,?,?,?,?,?,?,?,?,?,?)";
public static final String UPDATE_DSRES_QRY =
"UPDATE Datasource_Resolution SET time_window=?, latitude_unit=?, longitude_unit=?, "
+ "boundingbox=?, syncTime=?, timeType=? , dsQuery=?, genEmage=? WHERE dsmaster_id=? AND resolution_type=?";
public static final String SELECT_DSMSTR_ALL_QRY =
"SELECT dm.dsmaster_title,dm.dsmaster_theme,dm.dsmaster_url,dm.dsmaster_format,dm.dsmaster_creator,dm.dsmaster_created_date,dm.dsmaster_updated_date,dm.dsmaster_syntax"
+ " FROM Datasource_Master dm WHERE dm.dsmaster_id=?";
public static final String SELECT_RULE_QRY = "SELECT * from RuleQueryMaster where RuleID=? ";
public static final String SELECT_ALL_RULE_QRY =
"SELECT * from RuleQueryMaster where user_id=? order by RuleID DESC";
public static final String SELECT_ALL_RULEs_OFDS_QRY =
"select * from RuleQueryMaster where source_id = ?";
public static final String SELECT_RULE_DS_QRY =
"select dm.dsmaster_id, dm.dsmaster_title, rm.RuleID, rm.Rule_Name from Datasource_Master dm, RuleQueryMaster rm where dm.dsmaster_id = rm.source_id and dsmaster_creator = ? and rm.source_type='ds'";
public static final String SELECT_ENABLED_RULE_OPERATOR_QRY =
"SELECT r.Operator_id, r.DataType, r.Operators, r.status from RuleOperator r where r.status=1";
public static final String SELECT_DSRESWRPR_QRY =
"SELECT dm.dsmaster_title,dm.dsmaster_theme,dm.dsmaster_url,dm.dsmaster_format,dm.dsmaster_creator,dm.dsmaster_created_date,dm.dsmaster_updated_date,"
+ "dr.dsmaster_id,dr.datastream_name,dr.time_window,dr.latitude_unit,dr.longitude_unit,dr.boundingbox,"
+ "wr.wrapper_name,wr.wrapper_type,wr.wrapper_key_value,wr.bag_of_words,wr.visual_tran_mat,wr.visual_color_mat,wr.visual_mask_mat,wr.visual_ignore_since"
+ " FROM Datasource_Master dm,Datasource_Resolution dr,Wrapper wr WHERE dm.dsmaster_id=dr.dsmaster_id AND wr.wrapper_id=dm.dsmaster_id AND dm.dsmaster_id=?";
public static final String DEFAULT = "default";
public static final String DEFAULT_EXTRACT_FIELD = "loc, value, timestamp";
public static final String SELECT_DSRES_QRY =
"SELECT dr.dsmaster_id,dr.datastream_name,dr.time_window,dr.latitude_unit,dr.longitude_unit,dr.boundingbox,dr.resolution_type, dr.syncTime, dr.timeType, dr.dsQuery, dr.genEmage FROM Datasource_Resolution dr WHERE dr.dsmaster_id=?";
public static final String SELECT_WRPR_QRY =
"SELECT wr.wrapper_id,wr.wrapper_name,wr.wrapper_type,wr.wrapper_key_value,wr.bag_of_words,wr.visual_tran_mat,wr.visual_color_mat,wr.visual_mask_mat,wr.visual_ignore_since FROM Wrapper wr WHERE wr.dsmaster_id=? ";
public static final String SELECT_DSMSTR_ID =
"SELECT dsmaster_id FROM Datasource_Master where dsmaster_theme=? and dsmaster_title=? and dsmaster_creator=?";
public static final String DSMSTR_URL = "dsmaster_url";
public static final String DSMSTR_THEME = "dsmaster_theme";
public static final String DSMSTR_FRMT = "dsmaster_format";
public static final String STREAM = "stream";
public static final String VISUAL = "visual";
public static final String REST = "rest";
public static final String SQS = "sqs";
public static final String CSV = "csv"; // not sure why we didnt have this
// -- sanjukta
public static final String WRAPPER_NAME = "wrapper_name";
public static final String BAG_OF_WORDS = "bag_of_words";
public static final String COMMA = ",";
public static final String VISUAL_TRANS_MAT = "visual_tran_mat";
public static final String VISUAL_COLR_MAT = "visual_color_mat";
public static final String VISUAL_IGNOR_SINCE = "visual_ignore_since";
public static final String TIME_WINDOW = "time_window";
public static final String SYNC_TIME = "syncTime";
public static final String TIME_TYPE = "timeType";
public static final String DS_QUERY = "dsQuery";
public static final String GEN_EMAGE = "genEmage";
public static final String RULE_ID = "RuleID";
public static final String SOURCE_ID = "source_id";
public static final String RULE_NAME = "Rule_Name";
public static final String RULE_QUERIES = "Rule_Queries";
public static final String SOURCE_FIELDS = "source_fields";
public static final String LATITUDE_UNIT = "latitude_unit";
public static final String LONGITUDE_UNIT = "longitude_unit";
public static final String BOUNDINGBOX = "boundingbox";
public static final String SELECT_DSMSR_QRY =
"SELECT dm.dsmaster_id, dm.dsmaster_title,dm.dsmaster_creator,dm.dsmaster_url, dm.dsmaster_access FROM Datasource_Master dm ";
public static final String SLT_DSMSR_QRY_BASEON_ID_QRY =
" WHERE dsmaster_creator=? or dsmaster_access = \"public\" ORDER BY dm.dsmaster_id DESC";
public static final String SELECT_QRMSTR_QRY =
"SELECT query_id,query_name,query_status FROM Query_Master WHERE qid_parent IS NULL order by query_id DESC";
// OR query_creator_id='' removed this, nt sure why it was put --sanjukta
public static final String SLT_QRMSTR_BASEON_ID_QRY = " AND query_creator_id=? ";
public static final String DATE_CONVERTION = "yyyy-MM-dd HH:mm:ss";
public static final String SLT_DSMSTR_RUN_QRY =
"SELECT dsm.dsmaster_title,dsm.dsmaster_theme,dsm.dsmaster_url,dsm.dsmaster_type,wr.wrapper_name,wr.bag_of_words,wr.visual_mask_mat,wr.visual_color_mat,wr.visual_tran_mat FROM Datasource_Master dsm,Wrapper wr WHERE dsm.dsmaster_id=wr.wrapper_id AND dsm.dsmaster_id=?";
public static final String SLT_DSRES_RUN_QRY =
"SELECT time_window,latitude_unit,longitude_unit,boundingbox FROM Datasource_Resolution WHERE dsmaster_id=?";
public static final String DS_COL_NAME = "dsmaster_Id";
public static final String DS_TABLE_NAME = "Datasource_Resolution";
public static final String WRP_TABLE_NAME = "Wrapper";
public static final String WRP_COL_NAME = "wrapper_id";
public static final String DEL = "DELETE FROM ";
public static final String WHERE = " WHERE ";
public static final String PARMID = "=?";
public static final String QRDS_TABLE_NAME = "Query_Datasource";
public static final String QRDS_COL_NAME = "query_id";
public static final String QRMS_TABLE_NAME = "Query_Master";
public static final String QRMS_COL_NAME = "qid_parent";
public static final String TRANSMATRIX = "tranMatrix";
public static final String COLRSMATRIX = "colorMatrix";
public static final String CONTEXT = "context";
public static final String TWITTER = "Twitter";
public static final String FLICKER = "Flickr";
public static final String SIM = "sim";
public static final String DS_PATH = "ds";
public static final String TRANS_MATRX_NWLINE = "tranMat:\n ";
public static final String NWLINE = "\n";
public static final String COLOR_MATRX_NWLINE = "colorMatStr:\n ";
public static final String COMMA_BLANK = ", ";
public static final String RESULT_DS = "temp/ds/";
public static final String RESULT_Q = "temp/queries/";
public static final String STOP = "S";
public static final String RUN = "RUN";
public static final String ADD = "Add";
public static final String SLT_QRYMSTR_RUN_QRY =
"SELECT time_window,latitude_unit,longitude_unit,boundingbox,timeType FROM Query_Master WHERE query_id=?";
public static final String INST_QRYMSTR_QRY =
"INSERT INTO Query_Master(query_esql,time_window,latitude_unit,"
+ "longitude_unit,boundingbox,query_status,qid_parent,query_creator_id,query_name) values(?,?,?,?,?,?,?,?,?)";
public static final String INST_QRYMSTR_DEFAULT_QRY =
"INSERT INTO Query_Master(query_esql,time_window,latitude_unit,"
+ "longitude_unit,boundingbox,query_status,query_creator_id,query_name, timeType, linked_ds) values(?,?,?,?,?,?,?,?,?,?)";
public static final String SLT_QRYMSTR_QRY =
"SELECT query_esql FROM Query_Master WHERE query_id=?";
public static final String Alert_STAT_QRY = "SELECT alert_status from Alerts where alert_id=?";
public static final String ALERT_INTERVAL = "alertInterval";
public static final String FILTER = "filter";
public static final String GROUPING = "grouping";
public static final String AGGREGATION = "aggregation";
public static final String SPCHAR = "spchar";
public static final String SPMATCHING = "spmatching";
public static final String TPCHAR = "tpchar";
public static final String TPMATCHING = "tpmatching";
public static final String DSR_DS = "ds";
public static final String MAP = "map";
public static final String TEXTUAL = "textual";
public static final String MATRIX = "matrix";
public static final String GAUSSIAN = "gaussian";
public static final String FILE = "file";
public static final String LINUXEXECFILEEXTN = "";
public static final String WINEXECFILEEXTN = ".exe";
public static final String LINUXOS = "linux";
public static final String WINOS = "windows";
public static final String RUNNING = "R";
public static final String STOPPED = "S";
public static final String SELECT_USERNOTINDS_QRY =
"SELECT um.user_id,um.user_fullname FROM tbl_User_Master um WHERE um.user_id NOT IN (?)";
public static final String CHECK_FRAMEPARAM =
"SELECT count(*) from Datasource_Resolution WHERE dsmaster_id=?";
public static final String ENABLE_DS =
"UPDATE Datasource_Master SET dsmaster_status = 1 WHERE dsmaster_id = ?";
public static final String DISABLE_DS =
"UPDATE Datasource_Master SET dsmaster_status = 0 WHERE dsmaster_id = ?";
// Strings mapping to the resultConfig.props
public static final String dsAddSuccCode = "dsAddSuccCode";
public static final String dsAddSuccComment = "dsAddSuccComment";
public static final String dsAddErrCode = "dsAddErrCode";
public static final String dsAddErrComment = "dsAddErrComment";
public static final String dsUpdtSuccCode = "dsUpdtSuccCode";
public static final String dsUpdtSuccComment = "dsUpdtSuccComment";
public static final String dsUpdtErrCode = "dsUpdtErrCode";
public static final String dsUpdtErrComment = "dsUpdtErrComment";
public static final String dsEmageSuccCode = "dsEmageSuccCode";
public static final String dsEmageSuccComment = "dsEmageSuccComment";
public static final String dsEmageErrCode = "dsEmageErrCode";
public static final String dsEmageErrComment = "dsEmageErrComment";
public static final String qryAddSuccCode = "qryAddSuccCode";
public static final String qryAddSuccCmnt = "qryAddSuccCmnt";
public static final String qryAddErrCode = "qryAddErrCode";
public static final String json = ".json";
// resource for pre-sample data source
public static final String RESOURCEDIR = Config.getProperty(TEMPDIR) + "/resource/";
public static final String csvArrayURI = RESOURCEDIR + "/csv_array_usa";
public static final String csvFieldURI = RESOURCEDIR + "/csv_field_1_2_3";
public static final String pollenURI = RESOURCEDIR + "/pollen_map.gif";
public static final String pollenTRAN = RESOURCEDIR + "/pollen_trans_mat";
public static final String pollenCOL = RESOURCEDIR + "/pollen_col_mat";
public static final String pollenMASK = RESOURCEDIR + "/pollen_mask.png";
public static final String aqiUI = RESOURCEDIR + "/aqi_map.jpg";
public static final String aqiTRAN = RESOURCEDIR + "/aqi_trans_mat";
public static final String aqiCOL = RESOURCEDIR + "/aqi_col_mat";
public static final String aqiMASK = RESOURCEDIR + "/aqi_mask.png";
public static final String datasourceJsonLoc = Config.getProperty("datasourceJsonLoc");
}
public DataSourceParser() {
context = Config.getProperty("context");
tempDir = Config.getProperty("tempDir");
}