C# (CSharp) DatabaseStates Examples

Example #1

File: DatabaseCreateAction.cs Project: punitganshani/KonfDB

 public override DatabaseStates ExecuteState(DatabaseStates currentState,
     Dictionary<string, object> dataDictionary,
     params object[] data)
 {
     CreateDatabase(dataDictionary, data);
     return DatabaseStates.DatabaseCreated;
 }

Example #2

File: DatabaseReferenceDataAction.cs Project: ugurak/KonfDB

 public override DatabaseStates ExecuteState(DatabaseStates currentState,
                                             Dictionary <string, object> dataDictionary,
                                             params object[] data)
 {
     RunScripts(dataDictionary, data);
     return(DatabaseStates.ReferenceDataPopulated);
 }

Example #3

 public override DatabaseStates ExecuteState(DatabaseStates currentState,
                                             Dictionary <string, object> dataDictionary,
                                             params object[] data)
 {
     CreateDatabase(dataDictionary, data);
     return(DatabaseStates.DatabaseCreated);
 }

Example #4

File: DatabaseReferenceDataAction.cs Project: punitganshani/KonfDB

 public override DatabaseStates ExecuteState(DatabaseStates currentState,
     Dictionary<string, object> dataDictionary,
     params object[] data)
 {
     RunScripts(dataDictionary, data);
     return DatabaseStates.ReferenceDataPopulated;
 }

Example #5

File: DatabaseObjectsCheckAction.cs Project: punitganshani/KonfDB

        public override DatabaseStates ExecuteState(DatabaseStates currentState,
            Dictionary<string, object> dataDictionary,
            params object[] data)
        {
            if (currentState == DatabaseStates.DatabaseCreated)
            {
                if (!SchemasExist(Metadata.Schemas, dataDictionary, data))
                    return DatabaseStates.SchemaMissing;
                return DatabaseStates.SchemaCreated;
            }
            if (currentState == DatabaseStates.SchemaCreated)
            {
                bool tablesExist = true;
                foreach (var schemaName in Metadata.Schemas)
                {
                    tablesExist &= TablesExist(schemaName, Metadata.SchemaMap[schemaName], dataDictionary, data);
                }

                if (!tablesExist)
                    return DatabaseStates.TablesMissing;
                return DatabaseStates.TablesCreated;
            }
            if (currentState == DatabaseStates.TablesCreated)
            {
                if (!ReferencesExist(dataDictionary, data))
                    return DatabaseStates.ReferencesMissing;
                return DatabaseStates.ReferenceDataPopulated;
            }

            // Should not reach here
            return DatabaseStates.UnknownState;
        }

Example #6

File: DatabaseSchemaCreateAction.cs Project: punitganshani/KonfDB

 public override DatabaseStates ExecuteState(DatabaseStates currentState,
     Dictionary<string, object> dataDictionary,
     params object[] data)
 {
     foreach (var schema in Metadata.Schemas)
     {
         CreateSchema(schema, dataDictionary, data);
     }
     return DatabaseStates.SchemaCreated;
 }

Example #7

 public override DatabaseStates ExecuteState(DatabaseStates currentState,
                                             Dictionary <string, object> dataDictionary,
                                             params object[] data)
 {
     foreach (var schema in Metadata.Schemas)
     {
         CreateSchema(schema, dataDictionary, data);
     }
     return(DatabaseStates.SchemaCreated);
 }

Example #8

File: DatabaseCheckAction.cs Project: ugurak/KonfDB

        public override DatabaseStates ExecuteState(DatabaseStates currentState,
                                                    Dictionary <string, object> dataDictionary,
                                                    params object[] data)
        {
            if (!DatabaseExists(dataDictionary, data))
            {
                return(DatabaseStates.DatabaseDoesNotExist);
            }

            return(DatabaseStates.DatabaseCreated);
        }

Example #9

File: DatabaseCheckAction.cs Project: punitganshani/KonfDB

        public override DatabaseStates ExecuteState(DatabaseStates currentState,
            Dictionary<string, object> dataDictionary,
            params object[] data)
        {
            if (!DatabaseExists(dataDictionary, data))
            {
                return DatabaseStates.DatabaseDoesNotExist;
            }

            return DatabaseStates.DatabaseCreated;
        }

Example #10

 public override DatabaseStates ExecuteState(DatabaseStates currentState,
                                             Dictionary <string, object> dataDictionary,
                                             params object[] data)
 {
     foreach (var schemaName in Metadata.Schemas)
     {
         for (int j = 0; j < Metadata.SchemaMap[schemaName].Length; j++)
         {
             CreateTable(schemaName, Metadata.SchemaMap[schemaName][j], dataDictionary, data);
         }
     }
     return(DatabaseStates.TablesCreated);
 }

Example #11

File: DatabaseTableCreateAction.cs Project: punitganshani/KonfDB

 public override DatabaseStates ExecuteState(DatabaseStates currentState,
     Dictionary<string, object> dataDictionary,
     params object[] data)
 {
     foreach (var schemaName in Metadata.Schemas)
     {
         for (int j = 0; j < Metadata.SchemaMap[schemaName].Length; j++)
         {
             CreateTable(schemaName, Metadata.SchemaMap[schemaName][j], dataDictionary, data);
         }
     }
     return DatabaseStates.TablesCreated;
 }

Example #12

File: DatabaseObjectsCheckAction.cs Project: ugurak/KonfDB

        public override DatabaseStates ExecuteState(DatabaseStates currentState,
                                                    Dictionary <string, object> dataDictionary,
                                                    params object[] data)
        {
            if (currentState == DatabaseStates.DatabaseCreated)
            {
                if (!SchemasExist(Metadata.Schemas, dataDictionary, data))
                {
                    return(DatabaseStates.SchemaMissing);
                }
                return(DatabaseStates.SchemaCreated);
            }
            if (currentState == DatabaseStates.SchemaCreated)
            {
                bool tablesExist = true;
                foreach (var schemaName in Metadata.Schemas)
                {
                    tablesExist &= TablesExist(schemaName, Metadata.SchemaMap[schemaName], dataDictionary, data);
                }

                if (!tablesExist)
                {
                    return(DatabaseStates.TablesMissing);
                }
                return(DatabaseStates.TablesCreated);
            }
            if (currentState == DatabaseStates.TablesCreated)
            {
                if (!ReferencesExist(dataDictionary, data))
                {
                    return(DatabaseStates.ReferencesMissing);
                }
                return(DatabaseStates.ReferenceDataPopulated);
            }

            // Should not reach here
            return(DatabaseStates.UnknownState);
        }