Class BQ_Util_OldOPI

java.lang.Object

com.maplander.backend.utils.BQ_Util_OldOPI

public class BQ_Util_OldOPI
extends Object

Constructor Summary

Constructors

Constructor	Description
BQ_Util_OldOPI()

Method Summary

Modifier and Type	Method	Description
static List<AccountLiteMap>	accountLiteMapQuery(String s)
static String	addAmenities(String amenity)
static com.google.cloud.bigquery.TableResult	bqQuery(String queryStr)
static Long	executeDeleteQuery(String query)
static Long	executeInsertQuery(String query)
static com.google.cloud.bigquery.Job	executeQuery(String query)
static String	formatStringQuery(String value)
static List<HomePreviewPlaces>	getMoreSearchedPreviewPlaces()
static List<PropertyLite>	getPreviewWithFilter(PropertyTypeEnum propertyTypeEnum, OfferingTypeEnum offeringTypeEnum, String state_name, String municipalty_name)
static NamesSpaces	getSpaces(String query, boolean colony)
static List<SQLTopPlaces>	getTopPlaces(String s)
static HashMap<String,Object>	insertAddress(Address address)
static void	insertFilter(Filter filter)	/ campo_compuesto.put("a","test_1");
static void	insertInfoLog(InfoLog infolog)
static void	insertInteraction(Interaction interaction)
static void	insertInteractions(List<Interaction> interactionList)
static Long	insertProperty(Property property)
static void	insertPropertyFailed(Property property)
static List<AccountMap>	listAccountMap(String query)
static List<ColonyUnique>	ListColoniesByPostalCode(String postalCode)
static List<ColonyUnique>	listColoniesByUrl(String url)
static List<Long>	listPropertiesToExpire(String query)
static void	main(String[] args)
static List<OfficeLiteMap>	officeLiteMapQuery(String s)
static List<PropertyLiteMap>	propertyLiteMapQueryWithoutC(String s)
static com.google.cloud.bigquery.TableResult	propertyLiteMapQueryWithoutCResult(String s)
static List<PropertyLite>	propertyLiteQuery(String s)
static List<PropertyLite>	propertyLiteQueryWithoutC(String s)
static List<PropertyLite>	propertyLiteQueryWithoutCWithClassification(String s)
static List<AccountLite>	queryAccountLiteByOfficeName(String officeName, Integer limit, Integer cursor)
static String	queryAmenities(Amenities amenities)
static ColonyLocation	sqlColonyByPath(String query)
static List<InteractionsCard>	sqlInteractionsCardQuery(String s)
static List<InteractionsProperty>	sqlInteractionsPropertyQuery(String s)
static List<SQLResults>	sqlLocationsQuery(String s)
static List<SQLResults>	sqlLocationsQueryOffice(String s)
static List<LocationSitemapOT>	sqlNamesByPath(String query)
static LocationSitemapOTV2	sqlNamesByPathV2(String query)
static List<LocationSitemap>	sqlOfferingsByPathByPath(String query)
static PreviewPlaces	sqlPreviewPlacesQuery(String s, LocationTypeEnum locationType, Integer limit, Integer cursor)
static List<PropertyLite>	sqlPropertiesByColony(String s)
static SitemapPropertyList	sqlSitemapProperties(String query)
static SitemapPropertyList	sqlSitemapPropertiesPaged(String query, SitemapPropertyList sitemapPropertyList)
static SitemapPropertyListPreview	sqlSitemapPropertiesPreview(String query)
static SitemapPropertyListPreview	sqlSitemapPropertiesPreviewPaged(String query, SitemapPropertyListPreview sitemapPropertyList)
static Integer	sqlTotalProperties(String query)
static List<LocationSitemap>	sqlTypesByPath(String query)
static void	UpdateOrInsert(Property property)
static void	UpdateOrInsertList(List<Property> propertyList)
static Long	updateProperty(Property property, Long id)

Methods inherited from class java.lang.Object

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

Constructor Details

BQ_Util_OldOPI

public BQ_Util_OldOPI()

Method Details

main

public static void main(String[] args)

UpdateOrInsertList

public static void UpdateOrInsertList(List<Property> propertyList)

UpdateOrInsert

public static void UpdateOrInsert(Property property)

updateProperty

public static Long updateProperty(Property property,
 Long id)

insertAddress

public static HashMap<String,Object> insertAddress(Address address)

insertPropertyFailed

public static void insertPropertyFailed(Property property)

insertProperty

public static Long insertProperty(Property property)

insertFilter

public static void insertFilter(Filter filter)

/ campo_compuesto.put("a","test_1");

insertInteraction

public static void insertInteraction(Interaction interaction)

insertInfoLog

public static void insertInfoLog(InfoLog infolog)

insertInteractions

public static void insertInteractions(List<Interaction> interactionList)

bqQuery

public static com.google.cloud.bigquery.TableResult bqQuery(String queryStr)
                                                     throws Exception

Throws:

Exception

queryAccountLiteByOfficeName

public static List<AccountLite> queryAccountLiteByOfficeName(String officeName,
 Integer limit,
 Integer cursor)

propertyLiteQuery

public static List<PropertyLite> propertyLiteQuery(String s)

accountLiteMapQuery

public static List<AccountLiteMap> accountLiteMapQuery(String s)

propertyLiteQueryWithoutCWithClassification

public static List<PropertyLite> propertyLiteQueryWithoutCWithClassification(String s)

propertyLiteQueryWithoutC

public static List<PropertyLite> propertyLiteQueryWithoutC(String s)

propertyLiteMapQueryWithoutCResult

public static com.google.cloud.bigquery.TableResult propertyLiteMapQueryWithoutCResult(String s)

propertyLiteMapQueryWithoutC

public static List<PropertyLiteMap> propertyLiteMapQueryWithoutC(String s)

officeLiteMapQuery

public static List<OfficeLiteMap> officeLiteMapQuery(String s)

sqlLocationsQuery

public static List<SQLResults> sqlLocationsQuery(String s)

getTopPlaces

public static List<SQLTopPlaces> getTopPlaces(String s)

sqlInteractionsPropertyQuery

public static List<InteractionsProperty> sqlInteractionsPropertyQuery(String s)

sqlInteractionsCardQuery

public static List<InteractionsCard> sqlInteractionsCardQuery(String s)

sqlColonyByPath

public static ColonyLocation sqlColonyByPath(String query)

sqlTypesByPath

public static List<LocationSitemap> sqlTypesByPath(String query)

sqlNamesByPath

public static List<LocationSitemapOT> sqlNamesByPath(String query)

sqlNamesByPathV2

public static LocationSitemapOTV2 sqlNamesByPathV2(String query)

sqlOfferingsByPathByPath

public static List<LocationSitemap> sqlOfferingsByPathByPath(String query)

sqlSitemapProperties

public static SitemapPropertyList sqlSitemapProperties(String query)

sqlSitemapPropertiesPreview

public static SitemapPropertyListPreview sqlSitemapPropertiesPreview(String query)

sqlSitemapPropertiesPreviewPaged

public static SitemapPropertyListPreview sqlSitemapPropertiesPreviewPaged(String query,
 SitemapPropertyListPreview sitemapPropertyList)

sqlSitemapPropertiesPaged

public static SitemapPropertyList sqlSitemapPropertiesPaged(String query,
 SitemapPropertyList sitemapPropertyList)

sqlPreviewPlacesQuery

public static PreviewPlaces sqlPreviewPlacesQuery(String s,
 LocationTypeEnum locationType,
 Integer limit,
 Integer cursor)

sqlLocationsQueryOffice

public static List<SQLResults> sqlLocationsQueryOffice(String s)

sqlTotalProperties

public static Integer sqlTotalProperties(String query)

queryAmenities

public static String queryAmenities(Amenities amenities)

getSpaces

public static NamesSpaces getSpaces(String query,
 boolean colony)

addAmenities

public static String addAmenities(String amenity)

listAccountMap

public static List<AccountMap> listAccountMap(String query)

listPropertiesToExpire

public static List<Long> listPropertiesToExpire(String query)

getPreviewWithFilter

public static List<PropertyLite> getPreviewWithFilter(PropertyTypeEnum propertyTypeEnum,
 OfferingTypeEnum offeringTypeEnum,
 String state_name,
 String municipalty_name)

sqlPropertiesByColony

public static List<PropertyLite> sqlPropertiesByColony(String s)

getMoreSearchedPreviewPlaces

public static List<HomePreviewPlaces> getMoreSearchedPreviewPlaces()

ListColoniesByPostalCode

public static List<ColonyUnique> ListColoniesByPostalCode(String postalCode)

listColoniesByUrl

public static List<ColonyUnique> listColoniesByUrl(String url)

formatStringQuery

public static String formatStringQuery(String value)

executeInsertQuery

public static Long executeInsertQuery(String query)

executeQuery

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

executeDeleteQuery

public static Long executeDeleteQuery(String query)