public class TestDataSqlScriptGenerator extends Object
Modifier and Type | Field and Description |
---|---|
private static String |
DEFAULT_FILENAME |
private static int |
FEATURE_COUNT_INDEX |
private static String |
FEATURE_TYPE |
private static int |
FILENAME_INDEX |
private static String |
FOOTER_FILE_NAME |
private static String |
HEADER_FILE_NAME |
private static org.slf4j.Logger |
LOGGER |
private static int |
OBSERVATION_COUNT_INDEX |
private static String |
OBSERVATION_TYPE |
private static String |
OBSERVED_PROPERTY_ID |
private static double |
RESULT_MAX_VALUE |
private static double |
RESULT_MIN_VALUE |
private static int |
SENSOR_COUNT_INDEX |
private static String |
SQL_INSERT_FEATURE |
private static String |
SQL_INSERT_NUMERIC_OBSERVATION |
private static String |
SQL_INSERT_OBSERVATION_CONSTELLATION |
private static String |
SQL_INSERT_OFFERING |
private static String |
SQL_INSERT_SENSOR |
private static String |
SQL_TIMESTAMP_PATTERN |
private static long |
TIMESTAMP_INCREMENT_IN_MS |
private static String |
UNIT_ID |
private static int |
X_COORD_INDEX |
private static int |
Y_COORD_INDEX |
Modifier | Constructor and Description |
---|---|
private |
TestDataSqlScriptGenerator() |
Modifier and Type | Method and Description |
---|---|
private static String |
createFeatureStatement(int featureId,
Double[] coordinates) |
private static String |
createFooterStatements() |
private static String |
createHeaderStatements() |
private static String |
createInsertNumericObservationStatement(String observationType,
int sensorId,
int offeringId,
String observedProperty,
int featureId,
String unitId,
org.joda.time.DateTime timestamp,
double value) |
private static String |
createObservationConstellationStatement(String observationType,
int sensorId,
String observedPropertyId) |
private static String |
createOfferingStatement(int sensorId) |
private static String |
createSensorStatement(int sensorId,
Double[] generateRandomCoordinateTuple,
org.joda.time.DateTime timestamp,
String observationType,
String observedProperty,
String featureType) |
private static boolean |
fileExistsThanDeleteItAndCreateNew(File file) |
private static Double[] |
generateRandomCoordinateTuple(double yMin,
double yMax,
double xMin,
double xMax) |
private static double |
generateRandomResult(double min,
double max) |
private static Double[] |
generateRandomUniqueCoordinateTuple(double yMin,
double yMax,
double xMin,
double xMax,
Map<Double,Double> uniqueCoordinates) |
static void |
main(String[] args) |
private static boolean |
sampleAlreadyInList(Map<Double,Double> uniqueCoordinates,
Double[] sample) |
private static final org.slf4j.Logger LOGGER
private static final int FEATURE_COUNT_INDEX
private static final int SENSOR_COUNT_INDEX
private static final int OBSERVATION_COUNT_INDEX
private static final String DEFAULT_FILENAME
private static final int FILENAME_INDEX
private static final int X_COORD_INDEX
private static final int Y_COORD_INDEX
private static final String SQL_INSERT_FEATURE
private static final String SQL_TIMESTAMP_PATTERN
private static final String SQL_INSERT_SENSOR
private static final String OBSERVATION_TYPE
private static final String OBSERVED_PROPERTY_ID
private static final String FEATURE_TYPE
private static final String SQL_INSERT_OFFERING
private static final String SQL_INSERT_OBSERVATION_CONSTELLATION
private static final long TIMESTAMP_INCREMENT_IN_MS
private static final String UNIT_ID
private static final double RESULT_MIN_VALUE
private static final double RESULT_MAX_VALUE
private static final String SQL_INSERT_NUMERIC_OBSERVATION
private static final String HEADER_FILE_NAME
private static final String FOOTER_FILE_NAME
public static void main(String[] args)
private static String createHeaderStatements() throws FileNotFoundException
FileNotFoundException
private static String createFooterStatements() throws FileNotFoundException
FileNotFoundException
private static boolean fileExistsThanDeleteItAndCreateNew(File file) throws IOException
IOException
private static String createInsertNumericObservationStatement(String observationType, int sensorId, int offeringId, String observedProperty, int featureId, String unitId, org.joda.time.DateTime timestamp, double value)
private static String createObservationConstellationStatement(String observationType, int sensorId, String observedPropertyId)
private static String createOfferingStatement(int sensorId)
private static String createFeatureStatement(int featureId, Double[] coordinates)
private static String createSensorStatement(int sensorId, Double[] generateRandomCoordinateTuple, org.joda.time.DateTime timestamp, String observationType, String observedProperty, String featureType)
private static Double[] generateRandomCoordinateTuple(double yMin, double yMax, double xMin, double xMax)
private static Double[] generateRandomUniqueCoordinateTuple(double yMin, double yMax, double xMin, double xMax, Map<Double,Double> uniqueCoordinates)
private static boolean sampleAlreadyInList(Map<Double,Double> uniqueCoordinates, Double[] sample)
private static double generateRandomResult(double min, double max)
Copyright © 2012-2015 52north.org. All Rights Reserved.