public static void Initialize()
{
if (logger != null)
{
logger.Close();
}
//logger = new Logger.Logger(GFXDConfigManager.GetClientSetting("logDir"),
// String.Format("{0}.log", typeof(DbHelper).FullName));
logger = new Logger.Logger(Environment.GetEnvironmentVariable("GFXDADOOUTDIR"),
String.Format("{0}.log", typeof(DbHelper).FullName));
locker = new object();
try
{
GFXDServerMgr.Initialize();
DbDefault.CreateDB(String.Empty, DbCreateType.Replicate);
}
catch (Exception e)
{
Log(GetExceptionDetails(e, new StringBuilder()).ToString());
throw new Exception(
"Encountered exception in Helper.Initialize(). Check log for detail.");
}
}
private void PrepareInsert(TableName tableName)
{
IList <DbField> fields = DbDefault.GetTableStructure(tableName).Columns;
StringBuilder sql = new StringBuilder();
sql.Append("INSERT INTO " + tableName.ToString() + "(");
for (int j = 0; j < fields.Count; j++)
{
sql.Append(fields[j].FieldName + ", ");
}
sql = sql.Remove(sql.Length - 2, 1).Append(")");
sql.Append(" VALUES(");
for (int k = 0; k < fields.Count; k++)
{
sql.Append("?, ");
}
sql = sql.Remove(sql.Length - 2, 1).Append(")");
Command.CommandType = CommandType.Text;
Command.CommandText = sql.ToString();
Command.Prepare();
}
protected DataRow Select(TableName tableName, long identity)
{
String condition = String.Format("{0} = {1}",
DbDefault.GetTableStructure(tableName).PKColumns[0], identity);
return(Select(tableName, condition).Rows[0]);
}
public static void Cleanup()
{
try
{
DbDefault.DropDB(String.Empty);
}
catch (Exception e)
{
Log(GetExceptionDetails(e, new StringBuilder()).ToString());
throw new Exception(
"Encountered exception in Helper.Cleanup(). Check log for detail.");
}
finally
{
GFXDServerMgr.Cleanup();
}
}
protected int[] Insert(TableName tableName, int numRows)
{
IList <DbField> fields = DbDefault.GetTableStructure(tableName).Columns;
int[] result = new int[numRows];
PrepareInsert(tableName);
for (int i = 0; i < numRows; i++)
{
foreach (DbField field in fields)
{
Command.Parameters.Add(
DbRandom.GetRandomFieldData(field));
}
Command.AddBatch();
}
return(Command.ExecuteBatch());
}
public static String GetAddressQuery(String schemaName)
{
return(QualifyTableName(schemaName, DbDefault.GetSelectStatement(TableName.ADDRESS)));
}
public static String GetTableName(String schemaName, TableName tbEnum)
{
return(QualifyTableName(schemaName, DbDefault.GetTableName(tbEnum)));
}
public static String GetDropTableStatement(String schemaName, TableName tableName)
{
return(QualifyTableName(schemaName, DbDefault.GetDropTableStatement(tableName)));
}
public static String GetDeleteStatement(String schemaName, TableName tableName, long[] primaryKey)
{
return(QualifyTableName(schemaName, DbDefault.GetDeleteStatement(tableName, primaryKey)));
}
public static String GetOrderDetailQuery(String schemaName)
{
return(QualifyTableName(schemaName, DbDefault.GetSelectStatement(TableName.ORDERDETAIL)));
}
public static String GetProductQuery(String schemaName)
{
return(QualifyTableName(schemaName, DbDefault.GetSelectStatement(TableName.PRODUCT)));
}
public static String GetInnerJoinSelectStatement(String schemaName, Relation relation, long[] pKey)
{
return(QualifyTableName(schemaName, DbDefault.GetInnerJoinSelectStatement(relation, pKey)));
}
public static String GetCreateTableFKPartitionColocateStatement(String schemaName, Relation relation)
{
return(QualifyTableName(schemaName, DbDefault.GetCreateTableFKPartitionColocateStatement(relation)));
}
public static String GetCreateTablePartitionByPKeyReplicateStatement(String schemaName, TableName tableName)
{
return(QualifyTableName(schemaName, DbDefault.GetCreateTableReplicateStatement(tableName)));
}
public static String GetSupplierQuery(String schemaName)
{
return(QualifyTableName(schemaName, DbDefault.GetSelectStatement(TableName.SUPPLIER)));
}
public static String GetCategoryQuery(String schemaName)
{
return(QualifyTableName(schemaName, DbDefault.GetSelectStatement(TableName.CATEGORY)));
}
public static String GetLeftOuterJoinSelectStatement(String schemaName, Relation relation, String condition)
{
return(QualifyTableName(schemaName, DbDefault.GetLeftOuterJoinSelectStatement(relation, condition)));
}
public static String GetCustomerQuery(String schemaName)
{
return(QualifyTableName(schemaName, DbDefault.GetSelectStatement(TableName.CUSTOMER)));
}
public static String GetInsertStatement(String schemaName, TableName tableName, long[] pKey)
{
return(QualifyTableName(schemaName, DbDefault.GetInsertStatement(tableName, pKey)));
}
public int CreateView(Relation relation)
{
return(GFXDDbi.Create(Connection, DbDefault.GetCreateViewStatement(relation)));
}
public static String GetDeleteStatement(String schemaName, TableName tableName, String condition)
{
return(QualifyTableName(schemaName, DbDefault.GetDeleteStatement(tableName, condition)));
}