com.konakartadmin.utils

Class SqlPopulator

java.lang.Object

com.konakartadmin.utils.SqlPopulator

public class SqlPopulator
extends java.lang.Object

Populates the db for the specified storeId with standard data - getting data from store1. Only engine Mode 2 is supported.

Field Summary

Fields

Modifier and Type	Field and Description
(package private) static int	addrFormatId
private static java.util.HashMap<java.lang.Integer,java.lang.Integer>	addrFormatMap Map of source to target Address Format Id
private static int	adminRoleId
(package private) static int	catCartoonId
(package private) static int	catCdromId
(package private) static int	catComedyId
(package private) static int	catDramaId
(package private) static int	catDvdActionId
(package private) static int	catDvdId
(package private) static boolean	categoriesShared
(package private) static int	catGamesId
(package private) static int	catGiftId
(package private) static int	catGraphicsId
(package private) static int	catHardwareId
(package private) static int	catKeyboardId
private static java.util.HashMap<java.lang.Integer,java.lang.Integer>	catMap Map of source to target Category Id
(package private) static int	catMemoryId
(package private) static int	catMonitorId
(package private) static int	catMouseId
(package private) static int	catPrinterId
(package private) static int	CatSciFiId
(package private) static int	catSimulationId
(package private) static int	catSoftActionId
(package private) static int	catSpeakerId
(package private) static int	catStrategyId
(package private) static int	catTestCatId
(package private) static int	catThrillerId
(package private) static int	countryGbId
(package private) static int	countryUsId
(package private) static boolean	customersShared
(package private) static java.lang.String	dbDirectory
(package private) static com.konakart.db.DbPortabilityIf	dbPort
(package private) static boolean	debug
private static int	DEFAULT_ADMIN_ROLE_ID
private static java.lang.String	DEFAULT_HTTP_PORT
private static java.lang.String	DEFAULT_HTTPS_PORT
private static int	DEFAULT_SUPER_USER_ID
private static int	DEFAULT_SUPER_USER_ROLE_ID
private static java.lang.String	DEFAULT_USERNAME Default credentials for accessing the KonaKart Admin App
(package private) static int	engineMode
private static java.lang.String	httpPort
private static java.lang.String	httpsPort
(package private) static java.lang.String	kkHome
(package private) static int	langDeId
(package private) static int	langEsId
(package private) static int	langGbId
private static java.util.HashMap<java.lang.Integer,java.lang.Integer>	langMap Map of source to target Language Id
(package private) static int	langPtId
static org.apache.commons.logging.Log	log logger
(package private) static int	manuCanon
(package private) static int	manuDell
(package private) static int	manuFox
(package private) static int	manuGTInteractive
(package private) static int	manuHP
(package private) static int	manuKonaKart
(package private) static int	manuLionsgate
(package private) static int	manuLogitech
private static java.util.HashMap<java.lang.Integer,java.lang.Integer>	manuMap Map of source to target Manufacturer Id
(package private) static int	manuMatrox
(package private) static int	manuMicrosoft
(package private) static int	manuSierra
(package private) static int	manuWarner
(package private) static boolean	minimalStore
(package private) static org.apache.commons.configuration2.Configuration	miscConf
(package private) static java.lang.String	miscPropsFileName
private static int	newSuperUserId
(package private) static int	optColorId
(package private) static int	optMemoryId
(package private) static int	optModelId
(package private) static int	optSizeId
(package private) static int	optTypeId
(package private) static int	optVal16MbId
(package private) static int	optVal32MbId
(package private) static int	optVal4MbId
(package private) static int	optVal8MbId
(package private) static int	optValBronzeId
(package private) static int	optValDeluxeId
(package private) static int	optValGoldId
(package private) static int	optValOrangeId
(package private) static int	optValPremiumId
(package private) static int	optValPs2Id
(package private) static int	optValRedId
(package private) static int	optValSilverId
(package private) static int	optValUsbId
(package private) static int	optValValueId
(package private) static int	optValYellowId
(package private) static int	platform
(package private) static int	PLATFORM_LINUX
(package private) static int	PLATFORM_WINDOWS
(package private) static int	prodSomeAbtMaryId
private static java.util.HashMap<java.lang.Integer,java.lang.Integer>	productMap Map of source to target Product Id
(package private) static boolean	productsShared
(package private) static java.lang.String	propsFileName
(package private) static int	roleStoreAdministratorId
(package private) static int	roleSuperUserId
private static AdminAddressMgrIf	sourceAddressMgr Source AddressMgr
private static KKAdminIf	sourceAdminEng Source Admin Engine
private static AdminCategoryMgrIf	sourceCategoryMgr Source CategoryMgr
private static AdminConfigurationMgrIf	sourceConfigMgr Source ConfigurationMgr
private static AdminContentMgrIf	sourceContentMgr Source ContentMgr
private static AdminCustomerTagMgrIf	sourceCustomerTagMgr Source CustomerTagMgr
private static AdminLanguageMgrIf	sourceLanguageMgr Source LanguageMgr
private static AdminManufacturerMgrIf	sourceManufacturerMgr Source ManufacturerMgr
private static AdminOrderMgrIf	sourceOrderMgr Source OrderMgr
private static AdminProductMgrIf	sourceProductMgr Source ProductMgr
private static AdminSecurityMgrIf	sourceSecurityMgr Source SecurityMgr
private static AdminTaxMgrIf	sourceTaxMgr Source TaxMgr
(package private) static int	stateFloridaId
(package private) static int	stateTexasId
(package private) static java.lang.String	storeId
(package private) static int	storeNum
private static int	superUserId
private static int	superUserRoleId
(package private) static int	taxClassId
(package private) static java.lang.String	usage
(package private) static int	userAdminId
(package private) static int	userCatId
(package private) static int	userOrderId
(package private) static int	userRootId

Constructor Summary

Constructors

Constructor and Description
SqlPopulator()

Method Summary

Modifier and Type	Method and Description
static void	addRoleForNewSuperUser(KKAdminIf eng, java.lang.String sessionId) We assign the super user role to the new super user in the new store
static void	copyApiCalls(KKAdminIf eng, java.lang.String sessionId) Copy the API calls from one database to another.
static void	copyCategories(KKAdminIf eng, java.lang.String sessionId)
static void	copyCategory(KKAdminIf eng, java.lang.String sessionId, AdminCategory sourceCat)
static void	copyConfigurations(KKAdminIf eng, java.lang.String sessionId)
static void	copyContents(KKAdminIf eng, java.lang.String sessionId) Copy Contents
static void	copyContentTypes(KKAdminIf eng, java.lang.String sessionId) Copy ContentTypes
static void	copyCountries(KKAdminIf eng, java.lang.String sessionId) Populate the db with countries from the source store.
static void	copyCustomerTags(KKAdminIf eng, java.lang.String sessionId)
static void	copyManufacturers(KKAdminIf eng, java.lang.String sessionId)
static void	copyOrderReturnStatuses(KKAdminIf eng, java.lang.String sessionId)
static void	copyOrderStatusNames(KKAdminIf eng, java.lang.String sessionId)
static void	copyProducts(KKAdminIf eng, java.lang.String sessionId)
static void	derivePlatform() Derive the platform from the os.name
static java.util.HashMap<java.lang.Integer,java.lang.Integer>	getAddrFormatMap(KKAdminIf eng)
private static java.lang.String	getAdminUserNameForStore(java.lang.String store)
private static KKAdminIf	getAnEng(java.lang.String theStoreId)
private static int	getCountryIdForISO3(KKAdminIf eng, java.lang.String iso3)
private static int	getNewCatId(int oldCatId)
private static int	getNewLangId(int oldLangId)
private static int	getNewManuId(int oldManuId)
private static int	getNewProdId(int oldProdId)
static AdminAddressMgrIf	getSourceAddressMgr()
static KKAdminIf	getSourceAdminEng()
static AdminCategoryMgrIf	getSourceCategoryMgr()
static AdminConfigurationMgrIf	getSourceConfigMgr()
static AdminContentMgrIf	getSourceContentMgr()
static AdminCustomerTagMgrIf	getSourceCustomerTagMgr()
static AdminLanguageMgrIf	getSourceLanguageMgr()
static AdminManufacturerMgrIf	getSourceManufacturerMgr()
static AdminOrderMgrIf	getSourceOrderMgr()
static AdminProductMgrIf	getSourceProductMgr()
static AdminSecurityMgrIf	getSourceSecurityMgr()
static AdminTaxMgrIf	getSourceTaxMgr()
static java.lang.String	getStoreId()
private static int	getStoreNum()
private static int	getTaxClassIdForTitle(KKAdminIf eng, java.lang.String title)
private static int	getUserIdForEmail(KKAdminIf eng, java.lang.String sessionId, java.lang.String email)
private static int	getZoneIdForCodeAndName(KKAdminIf eng, java.lang.String code, java.lang.String name)
static void	insertAddressFormats(KKAdminIf eng, java.lang.String sessionId) Insert address formats and save an id to be used elsewhere
static void	insertApiCalls(KKAdminIf eng, java.lang.String sessionId)
static void	insertCategories(KKAdminIf eng, java.lang.String sessionId)
static void	insertConfigurationGroups(KKAdminIf eng, java.lang.String sessionId)
static void	insertConfigurations(KKAdminIf eng, java.lang.String sessionId)
static void	insertCountries(KKAdminIf eng, java.lang.String sessionId) Populate the db with countries.
static void	insertCurrencies(KKAdminIf eng, java.lang.String sessionId)
static void	insertCustomers(KKAdminIf eng, java.lang.String sessionId)
static void	insertCustomerTags(KKAdminIf eng, java.lang.String sessionId)
static void	insertLanguages(KKAdminIf eng, java.lang.String sessionId)
static void	insertManufacturers(KKAdminIf eng, java.lang.String sessionId) No Longer Used
static void	insertOptions(KKAdminIf eng, java.lang.String sessionId)
static void	insertOptionValues(KKAdminIf eng, java.lang.String sessionId)
static void	insertPanels(KKAdminIf eng, java.lang.String sessionId)
static void	insertProducts(KKAdminIf eng, java.lang.String sessionId) No Longer Used
static void	insertProductsToCategories(KKAdminIf eng, java.lang.String sessionId)
static void	insertProductsToStores(KKAdminIf eng, java.lang.String sessionId)
static void	insertReviews(KKAdminIf eng, java.lang.String sessionId)
static void	insertRoles(KKAdminIf eng, java.lang.String sessionId)
static void	insertRolesForSuperUser(KKAdminIf eng, java.lang.String sessionId) We assign the super user role to the super user in the new store
static void	insertStoreAdminRole(KKAdminIf eng, java.lang.String sessionId) We assign the adminRoleId to the store admin user of our new store.
static int	insertSuperUser(KKAdminIf eng, java.lang.String sessionId)
static void	insertTaxData(KKAdminIf eng, java.lang.String sessionId)
static void	insertUtility(KKAdminIf eng, java.lang.String sessionId) Insert the Utility Table values
static boolean	isCategoriesShared()
static boolean	isCustomersOrProductsShared()
static boolean	isCustomersShared()
static boolean	isLanguagesShared()
static boolean	isMultiStoreSingleDB()
static boolean	isProductsShared()
static java.lang.String	login(java.lang.String user, KKAdminIf eng) Login customer so that a login can be performed.
static void	main(java.lang.String[] args)
static int	populate() Populate the store
static int	populateStore(java.lang.String storeIdP, java.lang.String kkHomeP, int engineModeP, java.lang.String propsFileNameP, boolean customersSharedP, boolean productsSharedP, boolean categoriesSharedP, java.lang.String miscPropsFileNameP, boolean minimalStoreP, int adminRoleIdP, int superUserIdP, int superUserRoleIdP, boolean debugP, java.lang.String httpPortNumber, java.lang.String httpsPortNumber) Populate the store using the specified parameters.
static void	removeStoreIdForTable(java.lang.String tableName) Set the store_id column to '' in the specified table
static void	setCategoriesShared(boolean categoriesShared)
static void	setCustomersShared(boolean customersShared)
static void	setProductsShared(boolean productsShared)
static void	setSourceAdminEng(KKAdminIf sourceAdminEng)
private static void	setUpMiscConfiguration()
private static void	updateConfig(KKAdminIf eng, java.lang.String sessionId, java.lang.String key, int group, java.lang.String value)

Methods inherited from class java.lang.Object

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

Field Detail

log

public static org.apache.commons.logging.Log log

logger

usage

static final java.lang.String usage

See Also:

Constant Field Values

propsFileName

static java.lang.String propsFileName

miscPropsFileName

static java.lang.String miscPropsFileName

debug

static boolean debug

minimalStore

static boolean minimalStore

DEFAULT_ADMIN_ROLE_ID

private static final int DEFAULT_ADMIN_ROLE_ID

See Also:

Constant Field Values

adminRoleId

private static int adminRoleId

DEFAULT_SUPER_USER_ROLE_ID

private static final int DEFAULT_SUPER_USER_ROLE_ID

See Also:

Constant Field Values

superUserRoleId

private static int superUserRoleId

DEFAULT_SUPER_USER_ID

private static final int DEFAULT_SUPER_USER_ID

See Also:

Constant Field Values

superUserId

private static int superUserId

newSuperUserId

private static int newSuperUserId

userRootId

static int userRootId

userAdminId

static int userAdminId

userOrderId

static int userOrderId

userCatId

static int userCatId

roleSuperUserId

static int roleSuperUserId

roleStoreAdministratorId

static int roleStoreAdministratorId

addrFormatId

static int addrFormatId

catHardwareId

static int catHardwareId

catGamesId

static int catGamesId

catDvdId

static int catDvdId

catGraphicsId

static int catGraphicsId

catPrinterId

static int catPrinterId

catMonitorId

static int catMonitorId

catSpeakerId

static int catSpeakerId

catKeyboardId

static int catKeyboardId

catMouseId

static int catMouseId

catSoftActionId

static int catSoftActionId

CatSciFiId

static int CatSciFiId

catComedyId

static int catComedyId

catCartoonId

static int catCartoonId

catThrillerId

static int catThrillerId

catDramaId

static int catDramaId

catTestCatId

static int catTestCatId

catGiftId

static int catGiftId

catMemoryId

static int catMemoryId

catCdromId

static int catCdromId

catSimulationId

static int catSimulationId

catDvdActionId

static int catDvdActionId

catStrategyId

static int catStrategyId

manuMatrox

static int manuMatrox

manuMicrosoft

static int manuMicrosoft

manuDell

static int manuDell

manuWarner

static int manuWarner

manuFox

static int manuFox

manuLogitech

static int manuLogitech

manuCanon

static int manuCanon

manuSierra

static int manuSierra

manuGTInteractive

static int manuGTInteractive

manuHP

static int manuHP

manuLionsgate

static int manuLionsgate

manuKonaKart

static int manuKonaKart

langGbId

static int langGbId

langDeId

static int langDeId

langEsId

static int langEsId

langPtId

static int langPtId

countryUsId

static int countryUsId

countryGbId

static int countryGbId

stateFloridaId

static int stateFloridaId

stateTexasId

static int stateTexasId

taxClassId

static int taxClassId

optColorId

static int optColorId

optSizeId

static int optSizeId

optModelId

static int optModelId

optMemoryId

static int optMemoryId

optTypeId

static int optTypeId

optVal4MbId

static int optVal4MbId

optVal8MbId

static int optVal8MbId

optVal16MbId

static int optVal16MbId

optVal32MbId

static int optVal32MbId

optValValueId

static int optValValueId

optValPremiumId

static int optValPremiumId

optValDeluxeId

static int optValDeluxeId

optValPs2Id

static int optValPs2Id

optValUsbId

static int optValUsbId

optValBronzeId

static int optValBronzeId

optValSilverId

static int optValSilverId

optValGoldId

static int optValGoldId

optValRedId

static int optValRedId

optValOrangeId

static int optValOrangeId

optValYellowId

static int optValYellowId

prodSomeAbtMaryId

static int prodSomeAbtMaryId

storeId

static java.lang.String storeId

storeNum

static int storeNum

PLATFORM_LINUX

static final int PLATFORM_LINUX

See Also:

Constant Field Values

PLATFORM_WINDOWS

static final int PLATFORM_WINDOWS

See Also:

Constant Field Values

platform

static int platform

kkHome

static java.lang.String kkHome

dbDirectory

static java.lang.String dbDirectory

dbPort

static com.konakart.db.DbPortabilityIf dbPort

engineMode

static int engineMode

customersShared

static boolean customersShared

productsShared

static boolean productsShared

categoriesShared

static boolean categoriesShared

miscConf

static org.apache.commons.configuration2.Configuration miscConf

DEFAULT_HTTP_PORT

private static final java.lang.String DEFAULT_HTTP_PORT

See Also:

Constant Field Values

httpPort

private static java.lang.String httpPort

DEFAULT_HTTPS_PORT

private static final java.lang.String DEFAULT_HTTPS_PORT

See Also:

Constant Field Values

httpsPort

private static java.lang.String httpsPort

addrFormatMap

private static java.util.HashMap<java.lang.Integer,java.lang.Integer> addrFormatMap

Map of source to target Address Format Id

langMap

private static java.util.HashMap<java.lang.Integer,java.lang.Integer> langMap

Map of source to target Language Id

catMap

private static java.util.HashMap<java.lang.Integer,java.lang.Integer> catMap

Map of source to target Category Id

manuMap

private static java.util.HashMap<java.lang.Integer,java.lang.Integer> manuMap

Map of source to target Manufacturer Id

productMap

private static java.util.HashMap<java.lang.Integer,java.lang.Integer> productMap

Map of source to target Product Id

DEFAULT_USERNAME

private static java.lang.String DEFAULT_USERNAME

Default credentials for accessing the KonaKart Admin App

sourceAdminEng

private static KKAdminIf sourceAdminEng

Source Admin Engine

sourceAddressMgr

private static AdminAddressMgrIf sourceAddressMgr

Source AddressMgr

sourceConfigMgr

private static AdminConfigurationMgrIf sourceConfigMgr

Source ConfigurationMgr

sourceCustomerTagMgr

private static AdminCustomerTagMgrIf sourceCustomerTagMgr

Source CustomerTagMgr

sourceCategoryMgr

private static AdminCategoryMgrIf sourceCategoryMgr

Source CategoryMgr

sourceManufacturerMgr

private static AdminManufacturerMgrIf sourceManufacturerMgr

Source ManufacturerMgr

sourceProductMgr

private static AdminProductMgrIf sourceProductMgr

Source ProductMgr

sourceOrderMgr

private static AdminOrderMgrIf sourceOrderMgr

Source OrderMgr

sourceLanguageMgr

private static AdminLanguageMgrIf sourceLanguageMgr

Source LanguageMgr

sourceSecurityMgr

private static AdminSecurityMgrIf sourceSecurityMgr

Source SecurityMgr

sourceTaxMgr

private static AdminTaxMgrIf sourceTaxMgr

Source TaxMgr

sourceContentMgr

private static AdminContentMgrIf sourceContentMgr

Source ContentMgr

Constructor Detail

SqlPopulator

public SqlPopulator()

Method Detail

main

public static void main(java.lang.String[] args)

Parameters:

args - the args

derivePlatform

public static void derivePlatform()

Derive the platform from the os.name

populateStore

public static int populateStore(java.lang.String storeIdP,
                                java.lang.String kkHomeP,
                                int engineModeP,
                                java.lang.String propsFileNameP,
                                boolean customersSharedP,
                                boolean productsSharedP,
                                boolean categoriesSharedP,
                                java.lang.String miscPropsFileNameP,
                                boolean minimalStoreP,
                                int adminRoleIdP,
                                int superUserIdP,
                                int superUserRoleIdP,
                                boolean debugP,
                                java.lang.String httpPortNumber,
                                java.lang.String httpsPortNumber)

Populate the store using the specified parameters. This interface is used when calling this utility from another java program.

Parameters:

storeIdP - the storeIdP

kkHomeP - the kkHomeP

engineModeP - the engineModeP

propsFileNameP - the propsFileNameP

customersSharedP - the customersSharedP

productsSharedP - the productsSharedP

categoriesSharedP - the categoriesSharedP

miscPropsFileNameP - the name of a file containing Miscellaneous Property values

minimalStoreP - if true we create the smallest store we can (no products etc)

adminRoleIdP - the role id to give the admin user in the new store

superUserIdP - the superUserIdP

superUserRoleIdP - the superUserRoleIdP

debugP - debug flag

httpPortNumber - HTTP port number

httpsPortNumber - HTTPS port number

Returns:

0 for success, otherwise 1n integer greater than 0

populate

public static int populate()

Populate the store

Returns:

0 for success, otherwise 1n integer greater than 0

getAdminUserNameForStore

private static java.lang.String getAdminUserNameForStore(java.lang.String store)

setUpMiscConfiguration

private static void setUpMiscConfiguration()

getAnEng

private static KKAdminIf getAnEng(java.lang.String theStoreId)
                           throws KKAdminException

Throws:

KKAdminException

getStoreNum

private static int getStoreNum()

login

public static java.lang.String login(java.lang.String user,
                                     KKAdminIf eng)
                              throws org.apache.torque.TorqueException,
                                     KKAdminException

Login customer so that a login can be performed. The method returns a sessionId.

Parameters:

user - the user

eng - the eng

Returns:

Returns the sessionId

Throws:

org.apache.torque.TorqueException - an unexpected exception in Torque (the database layer)

KKAdminException - an unexpected exception in the KonaKart Admin engine

insertAddressFormats

public static void insertAddressFormats(KKAdminIf eng,
                                        java.lang.String sessionId)
                                 throws java.lang.Exception

Insert address formats and save an id to be used elsewhere

Parameters:

eng - the eng

sessionId - the sessionId

Throws:

java.lang.Exception - an unexpected exception

copyCountries

public static void copyCountries(KKAdminIf eng,
                                 java.lang.String sessionId)
                          throws java.lang.Exception

Populate the db with countries from the source store.

Parameters:

eng - the eng

sessionId - the sessionId

Throws:

java.lang.Exception - an unexpected exception

insertCountries

public static void insertCountries(KKAdminIf eng,
                                   java.lang.String sessionId)
                            throws java.lang.Exception

Populate the db with countries. It must be called after insertAddressFormats() since it requires an addressFormatId.

Parameters:

eng - the eng

sessionId - the sessionId

Throws:

java.lang.Exception - an unexpected exception

getZoneIdForCodeAndName

private static int getZoneIdForCodeAndName(KKAdminIf eng,
                                           java.lang.String code,
                                           java.lang.String name)
                                    throws KKAdminException

Throws:

KKAdminException

getTaxClassIdForTitle

private static int getTaxClassIdForTitle(KKAdminIf eng,
                                         java.lang.String title)
                                  throws KKAdminException

Throws:

KKAdminException

getCountryIdForISO3

private static int getCountryIdForISO3(KKAdminIf eng,
                                       java.lang.String iso3)
                                throws KKAdminException

Throws:

KKAdminException

getUserIdForEmail

private static int getUserIdForEmail(KKAdminIf eng,
                                     java.lang.String sessionId,
                                     java.lang.String email)
                              throws KKAdminException

Throws:

KKAdminException

insertLanguages

public static void insertLanguages(KKAdminIf eng,
                                   java.lang.String sessionId)
                            throws java.lang.Exception

Parameters:

eng - engine

sessionId - the sessionId

Throws:

java.lang.Exception - an unexpected exception

getNewLangId

private static int getNewLangId(int oldLangId)

getNewProdId

private static int getNewProdId(int oldProdId)

insertCategories

public static void insertCategories(KKAdminIf eng,
                                    java.lang.String sessionId)
                             throws java.lang.Exception

Parameters:

eng - the eng

sessionId - the sessionId

Throws:

java.lang.Exception - an unexpected exception

copyCategories

public static void copyCategories(KKAdminIf eng,
                                  java.lang.String sessionId)
                           throws java.lang.Exception

Parameters:

eng - the eng

sessionId - the sessionId

Throws:

java.lang.Exception - an unexpected exception

copyCategory

public static void copyCategory(KKAdminIf eng,
                                java.lang.String sessionId,
                                AdminCategory sourceCat)
                         throws java.lang.Exception

Parameters:

eng - the eng

sessionId - the sessionId

sourceCat - the sourceCat

Throws:

java.lang.Exception - an unexpected exception

getNewCatId

private static int getNewCatId(int oldCatId)

insertConfigurationGroups

public static void insertConfigurationGroups(KKAdminIf eng,
                                             java.lang.String sessionId)
                                      throws java.lang.Exception

Parameters:

eng - the eng

sessionId - the sessionId

Throws:

java.lang.Exception - an unexpected exception

insertConfigurations

public static void insertConfigurations(KKAdminIf eng,
                                        java.lang.String sessionId)
                                 throws java.lang.Exception

Parameters:

eng - the eng

sessionId - the sessionId

Throws:

java.lang.Exception - an unexpected exception

copyConfigurations

public static void copyConfigurations(KKAdminIf eng,
                                      java.lang.String sessionId)
                               throws java.lang.Exception

Parameters:

eng - the eng

sessionId - the sessionId

Throws:

java.lang.Exception - an unexpected exception

insertCustomerTags

public static void insertCustomerTags(KKAdminIf eng,
                                      java.lang.String sessionId)
                               throws java.lang.Exception

Parameters:

eng - the eng

sessionId - the sessionId

Throws:

java.lang.Exception - an unexpected exception

copyCustomerTags

public static void copyCustomerTags(KKAdminIf eng,
                                    java.lang.String sessionId)
                             throws java.lang.Exception

Parameters:

eng - the target engine

sessionId - the sessionId

Throws:

java.lang.Exception - an unexpected exception

copyManufacturers

public static void copyManufacturers(KKAdminIf eng,
                                     java.lang.String sessionId)
                              throws java.lang.Exception

Parameters:

eng - the eng

sessionId - the sessionId

Throws:

java.lang.Exception - an unexpected exception

getNewManuId

private static int getNewManuId(int oldManuId)

insertManufacturers

public static void insertManufacturers(KKAdminIf eng,
                                       java.lang.String sessionId)
                                throws java.lang.Exception

No Longer Used

Parameters:

eng - the eng

sessionId - the sessionId

Throws:

java.lang.Exception - an unexpected exception

copyContentTypes

public static void copyContentTypes(KKAdminIf eng,
                                    java.lang.String sessionId)
                             throws java.lang.Exception

Copy ContentTypes

Parameters:

eng - the eng

sessionId - the sessionId

Throws:

java.lang.Exception - an unexpected exception

copyContents

public static void copyContents(KKAdminIf eng,
                                java.lang.String sessionId)
                         throws java.lang.Exception

Copy Contents

Parameters:

eng - the eng

sessionId - the sessionId

Throws:

java.lang.Exception - an unexpected exception

copyOrderStatusNames

public static void copyOrderStatusNames(KKAdminIf eng,
                                        java.lang.String sessionId)
                                 throws java.lang.Exception

Parameters:

eng - the eng the Admin engine for the new store

sessionId - the sessionId

Throws:

java.lang.Exception - an unexpected exception

copyOrderReturnStatuses

public static void copyOrderReturnStatuses(KKAdminIf eng,
                                           java.lang.String sessionId)
                                    throws java.lang.Exception

Parameters:

eng - the eng the Admin engine for the new store

sessionId - the sessionId

Throws:

java.lang.Exception - an unexpected exception

insertTaxData

public static void insertTaxData(KKAdminIf eng,
                                 java.lang.String sessionId)
                          throws java.lang.Exception

Parameters:

eng - the eng

sessionId - the sessionId

Throws:

java.lang.Exception - an unexpected exception

removeStoreIdForTable

public static void removeStoreIdForTable(java.lang.String tableName)
                                  throws java.lang.Exception

Set the store_id column to '' in the specified table

Parameters:

tableName - the tableName

Throws:

java.lang.Exception - an unexpected exception

insertProductsToStores

public static void insertProductsToStores(KKAdminIf eng,
                                          java.lang.String sessionId)
                                   throws java.lang.Exception

Parameters:

eng - the eng

sessionId - the sessionId

Throws:

java.lang.Exception - an unexpected exception

insertProductsToCategories

public static void insertProductsToCategories(KKAdminIf eng,
                                              java.lang.String sessionId)
                                       throws java.lang.Exception

Parameters:

eng - the eng

sessionId - the sessionId

Throws:

java.lang.Exception - an unexpected exception

insertProducts

public static void insertProducts(KKAdminIf eng,
                                  java.lang.String sessionId)
                           throws java.lang.Exception

No Longer Used

Parameters:

eng - the eng

sessionId - the sessionId

Throws:

java.lang.Exception - an unexpected exception

copyProducts

public static void copyProducts(KKAdminIf eng,
                                java.lang.String sessionId)
                         throws java.lang.Exception

Parameters:

eng - the eng

sessionId - the sessionId

Throws:

java.lang.Exception - an unexpected exception

insertCurrencies

public static void insertCurrencies(KKAdminIf eng,
                                    java.lang.String sessionId)
                             throws java.lang.Exception

Parameters:

eng - the eng

sessionId - the sessionId

Throws:

java.lang.Exception - an unexpected exception

insertOptions

public static void insertOptions(KKAdminIf eng,
                                 java.lang.String sessionId)
                          throws java.lang.Exception

Parameters:

eng - the eng

sessionId - the sessionId

Throws:

java.lang.Exception - an unexpected exception

insertOptionValues

public static void insertOptionValues(KKAdminIf eng,
                                      java.lang.String sessionId)
                               throws java.lang.Exception

Parameters:

eng - the eng

sessionId - the sessionId

Throws:

java.lang.Exception - an unexpected exception

insertCustomers

public static void insertCustomers(KKAdminIf eng,
                                   java.lang.String sessionId)
                            throws java.lang.Exception

Parameters:

eng - the eng

sessionId - the sessionId

Throws:

java.lang.Exception - an unexpected exception

insertSuperUser

public static int insertSuperUser(KKAdminIf eng,
                                  java.lang.String sessionId)
                           throws java.lang.Exception

Parameters:

eng - the eng

sessionId - the sessionId

Returns:

the customerId of the newly created Super User

Throws:

java.lang.Exception - an unexpected exception

insertReviews

public static void insertReviews(KKAdminIf eng,
                                 java.lang.String sessionId)
                          throws java.lang.Exception

Parameters:

eng - the eng

sessionId - the sessionId

Throws:

java.lang.Exception - an unexpected exception

insertUtility

public static void insertUtility(KKAdminIf eng,
                                 java.lang.String sessionId)
                          throws java.lang.Exception

Insert the Utility Table values

Parameters:

eng - the eng

sessionId - the sessionId

Throws:

java.lang.Exception - an unexpected exception

copyApiCalls

public static void copyApiCalls(KKAdminIf eng,
                                java.lang.String sessionId)
                         throws java.lang.Exception

Copy the API calls from one database to another. Only required for Engine Mode 1.

Parameters:

eng - the eng

sessionId - the sessionId

Throws:

java.lang.Exception - an unexpected exception

insertApiCalls

public static void insertApiCalls(KKAdminIf eng,
                                  java.lang.String sessionId)
                           throws java.lang.Exception

Parameters:

eng - the eng

sessionId - the sessionId

Throws:

java.lang.Exception - an unexpected exception

insertRoles

public static void insertRoles(KKAdminIf eng,
                               java.lang.String sessionId)
                        throws java.lang.Exception

Parameters:

eng - the eng

sessionId - the sessionId

Throws:

java.lang.Exception - an unexpected exception

updateConfig

private static void updateConfig(KKAdminIf eng,
                                 java.lang.String sessionId,
                                 java.lang.String key,
                                 int group,
                                 java.lang.String value)
                          throws java.lang.Exception

Throws:

java.lang.Exception

insertStoreAdminRole

public static void insertStoreAdminRole(KKAdminIf eng,
                                        java.lang.String sessionId)
                                 throws java.lang.Exception

We assign the adminRoleId to the store admin user of our new store.

Parameters:

eng - the eng

sessionId - the sessionId

Throws:

java.lang.Exception - an unexpected exception

insertRolesForSuperUser

public static void insertRolesForSuperUser(KKAdminIf eng,
                                           java.lang.String sessionId)
                                    throws java.lang.Exception

We assign the super user role to the super user in the new store

Parameters:

eng - the eng

sessionId - the sessionId

Throws:

java.lang.Exception - an unexpected exception

addRoleForNewSuperUser

public static void addRoleForNewSuperUser(KKAdminIf eng,
                                          java.lang.String sessionId)
                                   throws java.lang.Exception

We assign the super user role to the new super user in the new store

Parameters:

eng - the eng

sessionId - the sessionId

Throws:

java.lang.Exception - an unexpected exception

insertPanels

public static void insertPanels(KKAdminIf eng,
                                java.lang.String sessionId)
                         throws java.lang.Exception

Parameters:

eng - the eng

sessionId - the sessionId

Throws:

java.lang.Exception - an unexpected exception

isLanguagesShared

public static boolean isLanguagesShared()

Returns:

true if the Languages are shared

isMultiStoreSingleDB

public static boolean isMultiStoreSingleDB()

Returns:

true if the mode is multi-store single DB

isCustomersOrProductsShared

public static boolean isCustomersOrProductsShared()

Returns:

the customersShared || productsShared

isCustomersShared

public static boolean isCustomersShared()

Returns:

the customersShared

setCustomersShared

public static void setCustomersShared(boolean customersShared)

Parameters:

customersShared - the customersShared to set

isProductsShared

public static boolean isProductsShared()

Returns:

the productsShared

setProductsShared

public static void setProductsShared(boolean productsShared)

Parameters:

productsShared - the productsShared to set

isCategoriesShared

public static boolean isCategoriesShared()

Returns:

the categoriesShared

setCategoriesShared

public static void setCategoriesShared(boolean categoriesShared)

Parameters:

categoriesShared - the categoriesShared to set

getSourceAdminEng

public static KKAdminIf getSourceAdminEng()

Returns:

the sourceAdminEng

setSourceAdminEng

public static void setSourceAdminEng(KKAdminIf sourceAdminEng)

Parameters:

sourceAdminEng - the sourceAdminEng to set

getSourceConfigMgr

public static AdminConfigurationMgrIf getSourceConfigMgr()
                                                  throws java.lang.Exception

Returns:

the sourceConfigMgr

Throws:

java.lang.Exception - an unexpected exception

getSourceCategoryMgr

public static AdminCategoryMgrIf getSourceCategoryMgr()
                                               throws java.lang.Exception

Returns:

the sourceCategoryMgr

Throws:

java.lang.Exception - an unexpected exception

getSourceProductMgr

public static AdminProductMgrIf getSourceProductMgr()
                                             throws java.lang.Exception

Returns:

the sourceProductMgr

Throws:

java.lang.Exception - an unexpected exception

getSourceOrderMgr

public static AdminOrderMgrIf getSourceOrderMgr()
                                         throws java.lang.Exception

Returns:

the sourceOrderMgr

Throws:

java.lang.Exception - an unexpected exception

getSourceLanguageMgr

public static AdminLanguageMgrIf getSourceLanguageMgr()
                                               throws java.lang.Exception

Returns:

the sourceLanguageMgr

Throws:

java.lang.Exception - an unexpected exception

getSourceManufacturerMgr

public static AdminManufacturerMgrIf getSourceManufacturerMgr()
                                                       throws java.lang.Exception

Returns:

the sourceManufacturerMgr

Throws:

java.lang.Exception - an unexpected exception

getSourceContentMgr

public static AdminContentMgrIf getSourceContentMgr()
                                             throws java.lang.Exception

Returns:

the sourceContentMgr

Throws:

java.lang.Exception - an unexpected exception

getSourceCustomerTagMgr

public static AdminCustomerTagMgrIf getSourceCustomerTagMgr()
                                                     throws java.lang.Exception

Returns:

the sourceCustomerTagMgr

Throws:

java.lang.Exception - an unexpected exception

getSourceTaxMgr

public static AdminTaxMgrIf getSourceTaxMgr()
                                     throws java.lang.Exception

Returns:

the sourceTaxMgr

Throws:

java.lang.Exception - an unexpected exception

getSourceSecurityMgr

public static AdminSecurityMgrIf getSourceSecurityMgr()
                                               throws java.lang.Exception

Returns:

the sourceSecurityMgr

Throws:

java.lang.Exception - an unexpected exception

getSourceAddressMgr

public static AdminAddressMgrIf getSourceAddressMgr()
                                             throws java.lang.Exception

Returns:

the sourceAddrerssMgr

Throws:

java.lang.Exception - an unexpected exception

getAddrFormatMap

public static java.util.HashMap<java.lang.Integer,java.lang.Integer> getAddrFormatMap(KKAdminIf eng)
                                                                               throws KKAdminException,
                                                                                      java.lang.Exception

Parameters:

eng - the eng

Returns:

the addrFormatMap

Throws:

java.lang.Exception - an unexpected exception

KKAdminException - an unexpected exception in the KonaKart Admin engine

getStoreId

public static java.lang.String getStoreId()

Returns:

the storeId