C# Class Carrotware.CMS.DBUpdater.DatabaseUpdate

Mostra file Open project: ninianne98/CarrotCakeCMS-MVC Class Usage Examples

Public Methods

Method	Description
AlterStep01 ( ) : DatabaseUpdateResponse
ApplyUpdateIfFound ( string testQuery, string updateStatement, bool bIgnore ) : DatabaseUpdateResponse
ApplyUpdateIfNotFound ( string testQuery, string updateStatement, bool bIgnore ) : DatabaseUpdateResponse
AreCMSTablesIncomplete ( ) : bool
BuildUpdateString ( int iCount ) : string
CreateCMSDatabase ( ) : DatabaseUpdateResponse
DatabaseNeedsUpdate ( ) : bool
DatabaseUpdate ( ) : System
DatabaseUpdate ( bool clearTest ) : System
DoCMSTablesExist ( ) : bool
ExecScriptContents ( string sScriptContents, bool bIgnoreErr ) : Exception
ExecScriptContents ( string sConnectionString, string sScriptContents, bool bIgnoreErr ) : Exception
GetDataKeyValue ( string dataKeyName ) : DataInfo
GetDataTable ( string sSQLQuery ) : DataTable
GetDbSchemaVersion ( ) : DataInfo
GetTableColumns ( string testTableName ) : List
GetTestData ( string sSQLQuery ) : DataTable
GetTestData ( string sSQLQuery, List SqlParms ) : DataTable
GetTestData ( string sConnectionString, string sSQLQuery, List SqlParms ) : DataTable
HandleResponse ( List lstMsgs, Exception ex ) : List
HandleResponse ( List lstMsgs, string sMsg ) : List
HandleResponse ( List lstMsgs, string sMsg, DatabaseUpdateResponse execMessage ) : List
MergeMessages ( List lstMsgs1, List lstMsgs2 ) : List
PerformUpdates ( ) : DatabaseUpdateStatus
ResetFailedSQL ( ) : void
ResetSQLState ( ) : void
SetDataKeyValue ( string dataKeyName, string dataKeyValue ) : void
SetDbSchemaVersion ( string dataKeyValue ) : void
SystemNeedsChecking ( Exception ex ) : bool
TableExists ( string testTableName ) : bool
WriteDebugException ( bool bWriteError, string sSrc, Exception objErr ) : void
WriteDebugException ( string sSrc, Exception objErr ) : void

Private Methods

Method	Description
ExecFileContents ( string sResourceName, bool bIgnoreErr ) : Exception
ExecFileContents ( string sConnectionString, string sResourceName, bool bIgnoreErr ) : Exception
ExecNonQuery ( string sConnectionString, string sSQLQuery, bool bIgnoreErr ) : Exception
ExecuteDataTableCommands ( string sConnectionString, string sSQLQuery, List SqlParms ) : DataTable
ExecuteNonQueryCommands ( string sConnectionString, string sSQLQuery, List SqlParms ) : void
GetDataSet ( string sSQLQuery ) : DataSet
GetDataSet ( string sConnectionString, string sSQLQuery ) : DataSet
GetDataTable ( string sConnectionString, string sSQLQuery ) : DataTable
ReadEmbededScript ( string filePath ) : string
SetConn ( ) : string
SplitScriptAtGo ( string sSQLQuery ) : List
TestDatabaseWithQuery ( ) : void

Method Details

AlterStep01() public method

public AlterStep01 ( ) : DatabaseUpdateResponse
return	DatabaseUpdateResponse

ApplyUpdateIfFound() public method

public ApplyUpdateIfFound ( string testQuery, string updateStatement, bool bIgnore ) : DatabaseUpdateResponse
testQuery	string
updateStatement	string
bIgnore	bool
return	DatabaseUpdateResponse

ApplyUpdateIfNotFound() public method

public ApplyUpdateIfNotFound ( string testQuery, string updateStatement, bool bIgnore ) : DatabaseUpdateResponse
testQuery	string
updateStatement	string
bIgnore	bool
return	DatabaseUpdateResponse

AreCMSTablesIncomplete() public static method

public static AreCMSTablesIncomplete ( ) : bool
return	bool

BuildUpdateString() public method

public BuildUpdateString ( int iCount ) : string
iCount	int
return	string

CreateCMSDatabase() public method

public CreateCMSDatabase ( ) : DatabaseUpdateResponse
return	DatabaseUpdateResponse

DatabaseNeedsUpdate() public method

public DatabaseNeedsUpdate ( ) : bool
return	bool

DatabaseUpdate() public method

public DatabaseUpdate ( ) : System
return	System

DatabaseUpdate() public method

public DatabaseUpdate ( bool clearTest ) : System
clearTest	bool
return	System

DoCMSTablesExist() public method

public DoCMSTablesExist ( ) : bool
return	bool

ExecScriptContents() public method

public ExecScriptContents ( string sScriptContents, bool bIgnoreErr ) : Exception
sScriptContents	string
bIgnoreErr	bool
return	System.Exception

ExecScriptContents() public method

public ExecScriptContents ( string sConnectionString, string sScriptContents, bool bIgnoreErr ) : Exception
sConnectionString	string
sScriptContents	string
bIgnoreErr	bool
return	System.Exception

GetDataKeyValue() public static method

public static GetDataKeyValue ( string dataKeyName ) : DataInfo
dataKeyName	string
return	DataInfo

GetDataTable() public static method

public static GetDataTable ( string sSQLQuery ) : DataTable
sSQLQuery	string
return	System.Data.DataTable

GetDbSchemaVersion() public static method

public static GetDbSchemaVersion ( ) : DataInfo
return	DataInfo

GetTableColumns() public method

public GetTableColumns ( string testTableName ) : List
testTableName	string
return	List

GetTestData() public static method

public static GetTestData ( string sSQLQuery ) : DataTable
sSQLQuery	string
return	System.Data.DataTable

GetTestData() public static method

public static GetTestData ( string sSQLQuery, List SqlParms ) : DataTable
sSQLQuery	string
SqlParms	List
return	System.Data.DataTable

GetTestData() public static method

public static GetTestData ( string sConnectionString, string sSQLQuery, List SqlParms ) : DataTable
sConnectionString	string
sSQLQuery	string
SqlParms	List
return	System.Data.DataTable

HandleResponse() public method

public HandleResponse ( List lstMsgs, Exception ex ) : List
lstMsgs	List
ex	System.Exception
return	List

HandleResponse() public method

public HandleResponse ( List lstMsgs, string sMsg ) : List
lstMsgs	List
sMsg	string
return	List

HandleResponse() public method

public HandleResponse ( List lstMsgs, string sMsg, DatabaseUpdateResponse execMessage ) : List
lstMsgs	List
sMsg	string
execMessage	DatabaseUpdateResponse
return	List

MergeMessages() public method

public MergeMessages ( List lstMsgs1, List lstMsgs2 ) : List
lstMsgs1	List
lstMsgs2	List
return	List

PerformUpdates() public method

public PerformUpdates ( ) : DatabaseUpdateStatus
return	DatabaseUpdateStatus

ResetFailedSQL() public static method

public static ResetFailedSQL ( ) : void
return	void

ResetSQLState() public static method

public static ResetSQLState ( ) : void
return	void

SetDataKeyValue() public static method

public static SetDataKeyValue ( string dataKeyName, string dataKeyValue ) : void
dataKeyName	string
dataKeyValue	string
return	void

SetDbSchemaVersion() public static method

public static SetDbSchemaVersion ( string dataKeyValue ) : void
dataKeyValue	string
return	void

SystemNeedsChecking() public static method

public static SystemNeedsChecking ( Exception ex ) : bool
ex	System.Exception
return	bool

TableExists() public method

public TableExists ( string testTableName ) : bool
testTableName	string
return	bool

WriteDebugException() public static method

public static WriteDebugException ( bool bWriteError, string sSrc, Exception objErr ) : void
bWriteError	bool
sSrc	string
objErr	System.Exception
return	void

WriteDebugException() public static method

public static WriteDebugException ( string sSrc, Exception objErr ) : void
sSrc	string
objErr	System.Exception
return	void