C# Class TPCCDatabaseGenerator.TPCCGenData

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

Afficher le fichier Open project: SQLServerIO/TPCCBench Class Usage Examples

Méthodes publiques

Свойство	Type	Description
MaxNumWh	int
NumWh	int
Sqlconn	string

Méthodes publiques

Méthode	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

Méthode	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 méthode

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

public BuildCustomerTable ( ) : void
Résultat	void

BuildDistrictTable() public méthode

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

public BuildDistrictTable ( ) : void
Résultat	void

BuildHistoryTable() public méthode

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

public BuildHistoryTable ( ) : void
Résultat	void

BuildItemsTable() public méthode

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

public BuildItemsTable ( ) : void
Résultat	void

BuildNewOrderTable() public méthode

/************************************************************************************************ 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
Résultat	void

BuildOrderLineTable() public méthode

/************************************************************************************************ 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
Résultat	void

BuildOrderTable() public méthode

/************************************************************************************************ 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
Résultat	void

BuildStockTable() public méthode

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

public BuildStockTable ( ) : void
Résultat	void

BuildWarehouseTable() public méthode

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

public BuildWarehouseTable ( ) : void
Résultat	void

Property Details

MaxNumWh public_oe property

public int MaxNumWh
Résultat	int

NumWh public_oe property

public int NumWh
Résultat	int

Sqlconn public_oe property

public string Sqlconn
Résultat	string