public IHttpActionResult InitializeDB() { var data = new Dbobjects(); var db = data.LiteDb; var clients = db.GetCollection <DBClient>("clients"); var clientList = clients.FindAll(); //db.DropCollection("clients"); //db.DropCollection("cards"); //db.DropCollection("accesspoints"); //db.DropCollection("accesspointDetails"); db.DropCollection("customerEvents"); //var accesspointsList = db.GetCollection<DBAccessPoint>("accesspoints"); //var accesspointDetailsList = db.GetCollection<DBAccessPointDetail>("accesspointDetails"); //for (var i = 1; i < 21; i++) //{ // var accesspoint = new DBAccessPoint() // { // accesspointguid = Guid.NewGuid().ToString(), // installationid = "0", // accesspointid = i.ToString(), // name = $"AccessPoint {i}" // }; // accesspointsList.Insert(accesspoint); // var accesspointDetail = new DBAccessPointDetail() // { // accesspointguid = accesspoint.accesspointguid, // installationid = "0", // accesspointid = accesspoint.accesspointid, // serial = Guid.NewGuid().ToString() // }; // accesspointDetailsList.Insert(accesspointDetail); //} //// Get card collection //var cards = db.GetCollection<DBCard>("cards"); //for (int i = 1; i < 201; i++) //{ // var card = new DBCard() // { // RFID = GetRandomHexNumber(14) // }; // cards.Insert(card); //} //var cards = db.GetCollection<DBCard>("cards"); //var cardsAvaileable = cards.FindAll().Select(x => x.RFID).ToArray(); var events = db.GetCollection <DBEvents>("customerEvents"); for (var i = 1; i < 1001; i++) { var customerEvent = new DBEvents() { installationid = "0", accesspointid = VendorDL.GetRandomAccessPoint().accesspointid, customerkey = VendorDL.GetRandomClient(), eventtype = new Random().Next(0, 4).ToString(), rfid = VendorDL.GetRandomCard(), EventDate = VendorDL.GetRandomEventDate(), unit = "kilo", value = new Random().Next(1, 100).ToString(), vendorid = "0", size = "N", wpn = "Rest" }; events.Insert(customerEvent); } return(Ok()); }
private static void InitializeTestData() { /************************************************** * Testparameters spesific to current test **************************************************/ Type = TestType.REST; _installationID = "123"; //Add accesspoints - at least 3 AvailableAccessPoints = new List <AccessPoint>(); var ap1 = new AccessPoint { accesspointid = "1718", tag = "", name = "1" }; AvailableAccessPoints.Add(ap1); var ap2 = new AccessPoint { accesspointid = "1719", tag = "", name = "2" }; AvailableAccessPoints.Add(ap2); var ap3 = new AccessPoint { accesspointid = "1720", tag = "", name = "3" }; AvailableAccessPoints.Add(ap3); /************************************************** * Generic testparameters - no need to touch..... **************************************************/ _allAccessPoints = new AccessPointData { InstallationID = InstallationID, Type = AccessPointData.AccessPointType.ALL }; _accessPointsByID = new AccessPointData { InstallationID = InstallationID, Type = AccessPointData.AccessPointType.ID, AccessPoint = ap1.accesspointid }; _accessPointsByName = new AccessPointData { InstallationID = InstallationID, Type = AccessPointData.AccessPointType.NAME, AccessPoint = ap2.name }; _accessPointsByTag = new AccessPointData { InstallationID = InstallationID, Type = AccessPointData.AccessPointType.TAG, AccessPoint = ap3.tag }; _apOutOfOrder = new AccessPointOutOfOrderData { InstallationID = TestSetup.InstallationID, AccessPoint = ap1.name, Message = "Out of Order", Type = AccessPointData.AccessPointType.NAME }; if (Type == TestType.LiteDB) { AvailableAccessPoints.Add(VendorDL.GetRandomAccessPoint()); AvailableAccessPoints.Add(VendorDL.GetRandomAccessPoint()); AvailableAccessPoints.Add(VendorDL.GetRandomAccessPoint()); } _availableCards = new Stack <string>(); // Generate RFID cards for (var i = 0; i < 50; i++) { _availableCards.Push(Utils.GetRandomHexString()); } HouseHoldClient = new HouseHoldClientData { Customerguid = Guid.NewGuid().ToString(), Customerid = Utils.GetRandomNumber(1001, 1000000).ToString(), Description = "sample client description", Primary = AvailableAccessPoints[0].accesspointid, Secondary1 = AvailableAccessPoints[1].accesspointid, Propertyunit = "Propertyunitstring", Streetaddress = "Customer address", RFID = _availableCards.Pop() + ";" + _availableCards.Pop(), InstallationID = InstallationID }; HouseHoldClient2 = new HouseHoldClientData { Customerguid = Guid.NewGuid().ToString(), Customerid = Utils.GetRandomNumber(1001, 1000000).ToString(), Description = "testclient - to be deleted during test", Primary = AvailableAccessPoints[0].accesspointid, Secondary1 = AvailableAccessPoints[1].accesspointid, Propertyunit = "Propertyunitstring", Streetaddress = "Customer address", RFID = _availableCards.Pop() + ";" + _availableCards.Pop(), InstallationID = InstallationID }; CommercialClient = new CommercialClientData { Name = "Commercial name", Customerguid = Guid.NewGuid().ToString(), Customerid = new Random().Next(1001, 1000000).ToString(), Description = "sample client description", Primary = AvailableAccessPoints[0].accesspointid, Secondary1 = AvailableAccessPoints[1].accesspointid, Propertyunit = "Propertyunitstring", Streetaddress = "Customer address", RFID = _availableCards.Pop() + ";" + _availableCards.Pop(), InstallationID = InstallationID }; RequestAllEvents = new EventsData { Customerkey = "ALL", FromDate = DateTime.Now.AddDays(-100), ToDate = DateTime.Now, InstallationID = InstallationID }; if (Client1 == null) { var c1 = JsonConvert.DeserializeObject <Client>(Utils.GetSetting("Client1")); if (c1 != null) { Client1 = c1; } var c2 = JsonConvert.DeserializeObject <Client>(Utils.GetSetting("Client2")); if (c2 != null) { Client2 = c2; } } }