C# Class TPCCDatabaseGenerator.TPCCGenData

TPCCGenData is the container class for the routines that generate and load the actual data into the tables.

Mostra file Open project: SQLServerIO/TPCCBench Class Usage Examples

Public Properties

Property	Type	Description
MaxNumWh	int
NumWh	int
Sqlconn	string

Public Methods

Method	Description
BuildCustomerTable ( ) : void	/********************************************************************************************** Populate CUSTOMER table By Wesley D. Brown Date 11/24/2007 Mod Description Functions: End Discription Change Log End Change Log **********************************************************************************************/
BuildDistrictTable ( ) : void	/********************************************************************************************** Populate DISTRICT table By Wesley D. Brown Date 11/24/2007 Mod Description Functions: End Discription Change Log End Change Log **********************************************************************************************/
BuildHistoryTable ( ) : void	/********************************************************************************************** Populate HISTORY table By Wesley D. Brown Date 11/24/2007 Mod Description Functions: End Discription Change Log End Change Log **********************************************************************************************/
BuildItemsTable ( ) : void	/********************************************************************************************** Populate ITEM table By Wesley D. Brown Date 11/24/2007 Mod Description Functions: End Discription Change Log End Change Log **********************************************************************************************/
BuildNewOrderTable ( ) : void	/********************************************************************************************** Populate NEW_ORDER table By Wesley D. Brown Date 11/24/2007 Mod Description Functions: End Discription Change Log End Change Log **********************************************************************************************/
BuildOrderLineTable ( ) : void	/********************************************************************************************** Populate ORDER_LINE table By Wesley D. Brown Date 11/24/2007 Mod Description Functions: End Discription Change Log End Change Log **********************************************************************************************/
BuildOrderTable ( ) : void	/********************************************************************************************** Populate O_ORDER table By Wesley D. Brown Date 11/24/2007 Mod Description Functions: End Discription Change Log End Change Log **********************************************************************************************/
BuildStockTable ( ) : void	/********************************************************************************************** Populate STOCK table By Wesley D. Brown Date 11/24/2007 Mod Description Functions: End Discription Change Log End Change Log **********************************************************************************************/
BuildWarehouseTable ( ) : void	/********************************************************************************************** Populate WAREHOUSE table By Wesley D. Brown Date 11/24/2007 Mod Description Functions: End Discription Change Log End Change Log **********************************************************************************************/

Private Methods

Method	Description
RandZip ( ) : String	Generates a random zip code string with the given length
RandomString ( int strMin, int strMax ) : String	Generates a random string with the given length

Method Details

BuildCustomerTable() public method

/************************************************************************************************ Populate CUSTOMER table By Wesley D. Brown Date 11/24/2007 Mod **Description** Functions: **End Discription** **Change Log** **End Change Log** ************************************************************************************************/

public BuildCustomerTable ( ) : void
return	void

BuildDistrictTable() public method

/************************************************************************************************ Populate DISTRICT table By Wesley D. Brown Date 11/24/2007 Mod **Description** Functions: **End Discription** **Change Log** **End Change Log** ************************************************************************************************/

public BuildDistrictTable ( ) : void
return	void

BuildHistoryTable() public method

/************************************************************************************************ Populate HISTORY table By Wesley D. Brown Date 11/24/2007 Mod **Description** Functions: **End Discription** **Change Log** **End Change Log** ************************************************************************************************/

public BuildHistoryTable ( ) : void
return	void

BuildItemsTable() public method

/************************************************************************************************ Populate ITEM table By Wesley D. Brown Date 11/24/2007 Mod **Description** Functions: **End Discription** **Change Log** **End Change Log** ************************************************************************************************/

public BuildItemsTable ( ) : void
return	void

BuildNewOrderTable() public method

/************************************************************************************************ Populate NEW_ORDER table By Wesley D. Brown Date 11/24/2007 Mod **Description** Functions: **End Discription** **Change Log** **End Change Log** ************************************************************************************************/

public BuildNewOrderTable ( ) : void
return	void

BuildOrderLineTable() public method

/************************************************************************************************ Populate ORDER_LINE table By Wesley D. Brown Date 11/24/2007 Mod **Description** Functions: **End Discription** **Change Log** **End Change Log** ************************************************************************************************/

public BuildOrderLineTable ( ) : void
return	void

BuildOrderTable() public method

/************************************************************************************************ Populate O_ORDER table By Wesley D. Brown Date 11/24/2007 Mod **Description** Functions: **End Discription** **Change Log** **End Change Log** ************************************************************************************************/

public BuildOrderTable ( ) : void
return	void

BuildStockTable() public method

/************************************************************************************************ Populate STOCK table By Wesley D. Brown Date 11/24/2007 Mod **Description** Functions: **End Discription** **Change Log** **End Change Log** ************************************************************************************************/

public BuildStockTable ( ) : void
return	void

BuildWarehouseTable() public method

/************************************************************************************************ Populate WAREHOUSE table By Wesley D. Brown Date 11/24/2007 Mod **Description** Functions: **End Discription** **Change Log** **End Change Log** ************************************************************************************************/

public BuildWarehouseTable ( ) : void
return	void

Property Details

MaxNumWh public_oe property

public int MaxNumWh
return	int

NumWh public_oe property

public int NumWh
return	int

Sqlconn public_oe property

public string Sqlconn
return	string