Package com.articulate.sigma.dataProc

Class Infrastructure

java.lang.Object

com.articulate.sigma.dataProc.Infrastructure

public class Infrastructure
extends Object

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
class	Infrastructure.Category
class	Infrastructure.Mappings	maps are old string ID keys and new (SUMO) id values
class	Infrastructure.Product

Field Summary

Fields

Modifier and Type	Field	Description
Map<String,Map<String,Set<String>>>	allowableValues
Map<String,Infrastructure.Category>	categories
static Connection	conn
static int	funcIdCounter
static Infrastructure	inf
static boolean	initialized
Map<String,Set<String>>	parents
Map<String,Infrastructure.Product>	products
Map<String,Set<String>>	productsByTypeNames
Map<String,String>	productTypes
Map<String,Set<String>>	relsForType

Constructor Summary

Constructors

Constructor	Description
Infrastructure()

Method Summary

Modifier and Type	Method	Description
ArrayList<String>	getAllowableValues(String subCategory, String rel)
ArrayList<String>	getAllowableValuesDB(String subCategory, String rel)
Set<String>	getAllowedRelations(String subCategory)
HashSet<String>	getAllowedRelationsDB(String subCategory)
ArrayList<String>	getCategories(String productType)
ArrayList<String>	getCategoriesDB(String productType)
ArrayList<String>	getProducts(Map<String,String> params)
ArrayList<String>	getProductsByTypeDB(String subCat)
ArrayList<String>	getProductsDB(Map<String,String> params)
ArrayList<String>	getProductTypes()
ArrayList<String>	getProductTypesDB()
ArrayList<String>	getSubCategories(String category)
ArrayList<String>	getSubCategoriesDB(String category)
static void	initOnce()
static void	initOnceDB()
static void	main(String[] args)
String	processValue(String val, String funcID)	process string measures into SUMO format
void	productCatJSONtoSUMO(String filenamep, String filenamec, String filenamem, String filenamept)	Parse a sample of products and their categories formatted in a JSON.
int	productCount()
void	readProducts(String filename, Infrastructure.Mappings mappings)	A list of products can be very long so parse each JSON object individually so as to provide a status.
static void	showHelp()
void	toSUMObyParent()

Methods inherited from class java.lang.Object

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

Field Details

initialized

public static boolean initialized

inf

public static Infrastructure inf

conn

public static Connection conn

funcIdCounter

public static int funcIdCounter

relsForType

public Map<String,Set<String>> relsForType

allowableValues

public Map<String,Map<String,Set<String>>> allowableValues

productTypes

public Map<String,String> productTypes

productsByTypeNames

public Map<String,Set<String>> productsByTypeNames

products

public Map<String,Infrastructure.Product> products

categories

public Map<String,Infrastructure.Category> categories

parents

public Map<String,Set<String>> parents

Constructor Details

Infrastructure

public Infrastructure()

Method Details

toSUMObyParent

public void toSUMObyParent()
                    throws SQLException

Throws:

SQLException

readProducts

public void readProducts(String filename,
 Infrastructure.Mappings mappings)

A list of products can be very long so parse each JSON object individually so as to provide a status.

processValue

public String processValue(String val,
 String funcID)
                    throws SQLException

process string measures into SUMO format

Throws:

SQLException

productCatJSONtoSUMO

public void productCatJSONtoSUMO(String filenamep,
 String filenamec,
 String filenamem,
 String filenamept)
                          throws SQLException

Parse a sample of products and their categories formatted in a JSON. Uses JSON API at http://alex-public-doc.s3.amazonaws.com/json_simple-1.1/index.html

Parameters:

filenamep - must be full path

filenamec - must be full path

Throws:

SQLException

getProductTypes

public ArrayList<String> getProductTypes()

getProductTypesDB

public ArrayList<String> getProductTypesDB()

getCategories

public ArrayList<String> getCategories(String productType)

getCategoriesDB

public ArrayList<String> getCategoriesDB(String productType)

getSubCategories

public ArrayList<String> getSubCategories(String category)

getSubCategoriesDB

public ArrayList<String> getSubCategoriesDB(String category)
                                     throws SQLException

Throws:

SQLException

getAllowedRelations

public Set<String> getAllowedRelations(String subCategory)

getAllowedRelationsDB

public HashSet<String> getAllowedRelationsDB(String subCategory)
                                      throws SQLException

Throws:

SQLException

getAllowableValues

public ArrayList<String> getAllowableValues(String subCategory,
 String rel)

getAllowableValuesDB

public ArrayList<String> getAllowableValuesDB(String subCategory,
 String rel)

getProducts

public ArrayList<String> getProducts(Map<String,String> params)

getProductsByTypeDB

public ArrayList<String> getProductsByTypeDB(String subCat)

productCount

public int productCount()

Returns:

a count of products

getProductsDB

public ArrayList<String> getProductsDB(Map<String,String> params)

Parameters:

params - is a map of attribute value pairs of the features being searched for

Returns:

a list of products

initOnce

public static void initOnce()

initOnceDB

public static void initOnceDB()

showHelp

public static void showHelp()

main

public static void main(String[] args)