public static SqlScriptBuilderBase CreateSqlBuilder(DbsDataConfig node)
{
if (node.DataType() == SoftwareDataKeys.DATA_PROVIDER_ODBC_MSSQL || node.DataType() == SoftwareDataKeys.DATA_PROVIDER_ODBC_IMSSQL)
{
return(new ScriptBuilderMsSql(node) as SqlScriptBuilderBase);
}
else if (node.DataType() == SoftwareDataKeys.DATA_PROVIDER_JET3)
{
return(new ScriptBuilderMsJet(node) as SqlScriptBuilderBase);
}
else if (node.DataType() == SoftwareDataKeys.DATA_PROVIDER_SQLITE)
{
return(new ScriptBuilderSqlite(node) as SqlScriptBuilderBase);
}
else
{
throw new NotImplementedException();
}
}
public static SqlBaseAdapter CreateSqlAdapter(DbsDataConfig node)
{
#if WINDOWS_API
if (node.DataType() == SoftwareDataKeys.DATA_PROVIDER_ODBC_MSSQL || node.DataType() == SoftwareDataKeys.DATA_PROVIDER_ODBC_IMSSQL)
{
return(new SqlMsSqlAdapter(node) as SqlBaseAdapter);
}
else if (node.DataType() == SoftwareDataKeys.DATA_PROVIDER_JET3)
{
return(new SqlMsJetAdapter(node) as SqlBaseAdapter);
}
else if (node.DataType() == SoftwareDataKeys.DATA_PROVIDER_SQLITE)
{
return(new SqlSqliteAdapter(node) as SqlBaseAdapter);
}
else
{
throw new NotImplementedException();
}
#else
return(null);
#endif
}
public ScriptBuilderMsSql(DbsDataConfig dataParams) : base(dataParams)
{
this.PlatformType = DBPlatform.DATA_PROVIDER_ODBC_MSSQL;
}
protected abstract string GetConnectString(DbsDataConfig node);
public SqlBaseAdapter(DbsDataConfig node)
{
m_platformType = node.DataType();
m_databaseName = node.DbsFileName;
}
public ScriptExecutor(string outputFilePath, string infoFileName, string codeFileName, DbsDataConfig targetNode)
{
m_InfoFileName = infoFileName;
m_InfoFilePath = System.IO.Path.Combine(outputFilePath, infoFileName);
m_InfoWriter = File.CreateText(m_InfoFilePath);
m_CodeFileName = codeFileName;
m_CodeFilePath = System.IO.Path.Combine(outputFilePath, codeFileName);
m_CodeWriter = File.CreateText(m_CodeFilePath);
m_TargetAdapter = SqlAdapterFactory.CreateSqlAdapter(targetNode);
try
{
m_TargetAdapter.CreateDatabase();
m_TargetAdapter.CreateConnection();
m_TargetAdapter.OpenConnection();
}
catch (Exception ex)
{
WriteInfoLine("Database Exception: {0}", ex.ToString());
}
}
public SqlScriptBuilderBase(DbsDataConfig dataParams)
{
this.m_strOwnerName = dataParams.OwnrName();
this.m_strUsersName = dataParams.UserName();
}
public ScriptBuilderSqlite(DbsDataConfig dataParams) : base(dataParams)
{
this.PlatformType = DBPlatform.DATA_PROVIDER_SQLITE;
}
public ScriptBuilderMsJet(DbsDataConfig dataParams) : base(dataParams)
{
this.PlatformType = DBPlatform.DATA_PROVIDER_JET35;
}
