Class BQ_Util

java.lang.Object

com.maplander.backend.utils.bq.BQ_Util

public class BQ_Util
extends Object

Constructor Summary

Constructors

Constructor	Description
BQ_Util()

Method Summary

Modifier and Type	Method	Description
static String	ArrayStringsToString(List<String> strings)
static String	datesToString(List<String> strings)
static Long	executeDeleteQuery(String query)
static Long	executeInsertQuery(String query)
static com.google.cloud.bigquery.Job	executeQuery(String query)
static com.google.cloud.bigquery.TableResult	executeResultQuery(String queryStr)
static Long	executeUpdateQuery(String query)
static String	fileCStoString(FileCS fileCS)
static String	formatStringQuery(String value)
static String	formatStringQueryDescription(String value)
static List<Integer>	getRepeatedIntValue(com.google.cloud.bigquery.FieldValueList row, String fieldName)
static List<String>	getRepeatedStringValue(com.google.cloud.bigquery.FieldValueList row, String fieldName)
static double	getSafeDoubleValue(com.google.cloud.bigquery.FieldValueList row, String fieldName)
static int	getSafeIntegerValue(com.google.cloud.bigquery.FieldValueList row, String fieldName)
static Long	getSafeLongValue(com.google.cloud.bigquery.FieldValueList row, String fieldName)
static String	getSafeStringValue(com.google.cloud.bigquery.FieldValueList row, String fieldName)
static String	getSafeStringValue(com.google.cloud.bigquery.FieldValueList row, String fieldName, String subFieldName)
static String	insertQuotationsMarks(String value)
static String	listIntToString(List<Integer> objects)
static String	listIntToString(List<Integer> objects, String sOpen, String sClose, String separator)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

BQ_Util

public BQ_Util()

Method Details

fileCStoString

public static String fileCStoString(FileCS fileCS)

listIntToString

public static String listIntToString(List<Integer> objects,
 String sOpen,
 String sClose,
 String separator)

listIntToString

public static String listIntToString(List<Integer> objects)

datesToString

public static String datesToString(List<String> strings)

ArrayStringsToString

public static String ArrayStringsToString(List<String> strings)

executeResultQuery

public static com.google.cloud.bigquery.TableResult executeResultQuery(String queryStr)

executeQuery

public static com.google.cloud.bigquery.Job executeQuery(String query)

executeInsertQuery

public static Long executeInsertQuery(String query)

executeUpdateQuery

public static Long executeUpdateQuery(String query)

executeDeleteQuery

public static Long executeDeleteQuery(String query)

getSafeLongValue

public static Long getSafeLongValue(com.google.cloud.bigquery.FieldValueList row,
 String fieldName)

getSafeIntegerValue

public static int getSafeIntegerValue(com.google.cloud.bigquery.FieldValueList row,
 String fieldName)

getSafeDoubleValue

public static double getSafeDoubleValue(com.google.cloud.bigquery.FieldValueList row,
 String fieldName)

getSafeStringValue

public static String getSafeStringValue(com.google.cloud.bigquery.FieldValueList row,
 String fieldName)

getSafeStringValue

public static String getSafeStringValue(com.google.cloud.bigquery.FieldValueList row,
 String fieldName,
 String subFieldName)

getRepeatedIntValue

public static List<Integer> getRepeatedIntValue(com.google.cloud.bigquery.FieldValueList row,
 String fieldName)

getRepeatedStringValue

public static List<String> getRepeatedStringValue(com.google.cloud.bigquery.FieldValueList row,
 String fieldName)

formatStringQuery

public static String formatStringQuery(String value)

formatStringQueryDescription

public static String formatStringQueryDescription(String value)

insertQuotationsMarks

public static String insertQuotationsMarks(String value)