Exemple #1
0
        private static void AddBasicData(EfContext dbc)
        {
            Console.WriteLine("\nCreating data ...");
            dbc.Database.OpenConnection();
            try
            {
                //Enums
                AddEnumData(dbc, dbc.Relations, typeof(RelationEnum));
                AddEnumData(dbc, dbc.Roles, typeof(RoleEnum));
                AddEnumData(dbc, dbc.LocationTypes, typeof(LocationTypeEnum));
                AddEnumData(dbc, dbc.Status, typeof(StatusEnum));

                //attributes
                AddAttributeData(dbc, typeof(AttributeEnum));

                string fqdn = "inv1.sovelto.fi";
                //Inventories
                dbc.Inventories.Add(new Inventory {
                    Fqdn = fqdn, Name = "Sovelto"
                });
                dbc.SaveChanges();
                var I1 = dbc.Inventories.SingleOrDefault(t => t.Fqdn == fqdn);



                //Archetypethings
                dbc.ArchetypeThings.Add(new ArchetypeThing {
                    Fqdn = fqdn, US = "ArcNb1", Title = "Archetype example", Modified = new DateTime(2016, 3, 23), Published = new DateTime(2016, 4, 13), Created = new DateTime(2014, 3, 23)
                });
                //AuthenticationThings
                var M100 = new AuthenticationThing {
                    Id = new Guid(0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0), Fqdn = fqdn, US = "M100", Title = "Matti, Facebook",
                };
                dbc.AuthenticationThings.Add(M100);
                dbc.SaveChanges();

                //things
                dbc.RegularThings.Add(new RegularThing
                {
                    Id                       = new Guid(0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1),
                    Fqdn                     = fqdn,
                    US                       = "T1",
                    Title                    = "MySuitcase",
                    Created                  = new DateTime(2015, 3, 1),
                    IsLocalOnly              = true,
                    StatusId                 = 1,
                    LocationTypeId           = 1,
                    Logging                  = true,
                    Preferred_LocationTypeId = 1,
                    Modified                 = new DateTime(2016, 3, 23),
                    Published                = new DateTime(2016, 4, 13),
                    Creator_Fqdn             = M100.Fqdn,
                    Creator_US               = M100.US
                });
                dbc.SaveChanges();
                var T1 = dbc.Things.SingleOrDefault(t => t.Fqdn == fqdn && t.US == "T1");

                dbc.RegularThings.Add(new RegularThing
                {
                    Id                       = new Guid(0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2),
                    Fqdn                     = fqdn,
                    US                       = "T2",
                    Title                    = "A Container",
                    Created                  = new DateTime(2015, 3, 1),
                    IsLocalOnly              = true,
                    StatusId                 = 1,
                    LocationTypeId           = 2,
                    Location_Gps             = "(123.8, 56.9)",
                    Logging                  = true,
                    Preferred_LocationTypeId = 1,
                    Modified                 = new DateTime(2014, 3, 3),
                    Published                = new DateTime(2012, 4, 13)
                });
                dbc.SaveChanges();
                var T2 = dbc.Things.SingleOrDefault(t => t.Fqdn == fqdn && t.US == "T2");

                dbc.RegularThings.Add(new RegularThing
                {
                    Fqdn                     = fqdn,
                    US                       = "ThingNb3",
                    Title                    = "A Thing",
                    Created                  = new DateTime(2016, 3, 1),
                    IsLocalOnly              = true,
                    StatusId                 = 1,
                    LocationTypeId           = 1,
                    Location_Gps             = "(12.0, 43.9)",
                    Logging                  = true,
                    Preferred_LocationTypeId = 1,
                    Modified                 = new DateTime(2016, 3, 23),
                    Published                = new DateTime(2016, 4, 13),
                    Parted_Fqdn              = T2.Fqdn,
                    Parted_US                = T2.US
                });
                dbc.SaveChanges();

                //ThingRoleMember
                byte count = 1;
                // add omnipotent role to T0 for T0
                ThingRole tr = new ThingRole {
                    Id = new Guid(0, 0, 0, 0, 0, 0, 0, 0, 0, 0, count), RoleId = (int)RoleEnum.Omnipotent, ThingId = M100.Id
                };
                dbc.ThingRoles.Add(tr);
                ThingRoleMember trm = new ThingRoleMember {
                    Id = new Guid(0, 0, 0, 0, 0, 0, 0, 0, 0, 0, count++), ThingId = M100.Id, ThingRoleId = tr.Id
                };
                dbc.ThingRoleMembers.Add(trm);

                //add owner role to T1 for T0
                tr = new ThingRole {
                    Id = new Guid(0, 0, 0, 0, 0, 0, 0, 0, 0, 0, count), RoleId = (int)RoleEnum.Owner, ThingId = T1.Id
                };
                dbc.ThingRoles.Add(tr);
                trm = new ThingRoleMember {
                    Id = new Guid(0, 0, 0, 0, 0, 0, 0, 0, 0, 0, count++), ThingId = M100.Id, ThingRoleId = tr.Id
                };
                dbc.ThingRoleMembers.Add(trm);

                //add Maintenance role to T2 for T1
                tr = new ThingRole {
                    Id = new Guid(0, 0, 0, 0, 0, 0, 0, 0, 0, 0, count), RoleId = (int)RoleEnum.Maintenance, ThingId = T2.Id
                };
                dbc.ThingRoles.Add(tr);
                trm = new ThingRoleMember {
                    Id = new Guid(0, 0, 0, 0, 0, 0, 0, 0, 0, 0, count++), ThingId = T1.Id, ThingRoleId = tr.Id
                };
                dbc.ThingRoleMembers.Add(trm);

                dbc.SaveChanges();


                //ThingRelation
                count = 1;
                dbc.ThingRelations.Add(new ThingRelation
                {
                    Id          = new Guid(0, 0, 0, 0, 0, 0, 0, 0, 0, 0, count++),
                    Thing1_Id   = M100.Id,
                    Thing2_Fqdn = T1.Fqdn,
                    Thing2_US   = T1.US,
                    RelationId  = (int)RelationEnum.Belongings
                });
                dbc.ThingRelations.Add(new ThingRelation
                {
                    Id          = new Guid(0, 0, 0, 0, 0, 0, 0, 0, 0, 0, count++),
                    Thing1_Id   = M100.Id,
                    Thing2_Fqdn = T1.Fqdn,
                    Thing2_US   = T1.US,
                    RelationId  = (int)RelationEnum.RoleIn
                });
                dbc.ThingRelations.Add(new ThingRelation
                {
                    Id          = new Guid(0, 0, 0, 0, 0, 0, 0, 0, 0, 0, count++),
                    Thing1_Id   = T1.Id,
                    Thing2_Fqdn = T2.Fqdn,
                    Thing2_US   = T2.US,
                    RelationId  = (int)RelationEnum.ContainedBy
                });


                dbc.SaveChanges();
                count = 1;
                // test session data
                // add session 00000001 for T0, no sessionaccess yet
                dbc.Sessions.Add(new Session {
                    Id          = new Guid(0, 0, 0, 0, 0, 0, 0, 0, 0, 0, count),
                    StartTime   = DateTime.UtcNow, EntryPoint_ThingId = M100.Id,
                    InventoryId = I1.Id,
                });
                dbc.SaveChanges();
            }

            finally
            {
                dbc.Database.CloseConnection();
            }
        }
Exemple #2
0
        private static void AddExtraData(EfContext dbc)
        {
            Console.WriteLine("\nCreating Extra data ...");
            dbc.Database.OpenConnection();
            try
            {
                //MyCar
                //MyTV
                string fqdn = "inv1.sovelto.fi";
                //AuthenticationThings
                var M100 = FindByThingId(dbc, fqdn, "M100");
                if (M100 == null)
                {
                    throw new Exception("Can't find M100");
                }

                //things
                dbc.RegularThings.Add(new RegularThing
                {
                    Fqdn                     = fqdn,
                    US                       = "S1",
                    Title                    = "MyCar",
                    Created                  = new DateTime(2015, 3, 1),
                    IsLocalOnly              = true,
                    StatusId                 = 1,
                    LocationTypeId           = 1,
                    Logging                  = true,
                    Preferred_LocationTypeId = 1,
                    Modified                 = new DateTime(2016, 3, 23),
                    Published                = new DateTime(2016, 4, 13),
                    Creator_Fqdn             = M100.Fqdn,
                    Creator_US               = M100.US
                });
                dbc.SaveChanges();
                var S1 = FindByThingId(dbc, fqdn, "S1");

                dbc.RegularThings.Add(new RegularThing
                {
                    Fqdn                     = fqdn,
                    US                       = "S2",
                    Title                    = "MyTV",
                    Created                  = new DateTime(2015, 3, 1),
                    IsLocalOnly              = true,
                    StatusId                 = 1,
                    LocationTypeId           = 2,
                    Location_Gps             = "(123.0, 55.9)",
                    Logging                  = true,
                    Preferred_LocationTypeId = 1,
                    Modified                 = new DateTime(2014, 3, 3),
                    Published                = new DateTime(2012, 4, 13)
                });
                dbc.SaveChanges();
                var S2 = FindByThingId(dbc, fqdn, "S2");


                //ThingRoleMember

                //add owner role to S1 and S2 for M100
                foreach (var thing in new BaseThing[] { S1, S2 })
                {
                    var tr = new ThingRole {
                        RoleId = (int)RoleEnum.Owner, ThingId = thing.Id
                    };
                    dbc.ThingRoles.Add(tr);
                    var trm = new ThingRoleMember {
                        ThingId = M100.Id, ThingRoleId = tr.Id
                    };
                    dbc.ThingRoleMembers.Add(trm);
                    dbc.SaveChanges();
                }

                //add relation to S1 and S2 from M100
                foreach (var thing in new BaseThing[] { S1, S2 })
                {
                    dbc.ThingRelations.Add(new ThingRelation
                    {
                        Thing1_Id   = M100.Id,
                        Thing2_Fqdn = thing.Fqdn,
                        Thing2_US   = thing.US,
                        RelationId  = (int)RelationEnum.Belongings
                    });
                    dbc.SaveChanges();
                }
            }

            finally
            {
                dbc.Database.CloseConnection();
            }
        }