public void UpsertSamplerState_insert()
        {
            var stCode = "00";
            var sgCode = "01";

            using (var db = CreateDataStore(methods: new[] { "STR" }))
            {
                var random = new Random();

                var sg = db.Query <SampleGroupDO>("Select * from SampleGroup;").First();

                var ds = new SamplerInfoDataservice_V2(db);

                var ss = new SamplerState()
                {
                    StratumCode        = stCode,
                    SampleGroupCode    = sgCode,
                    Counter            = random.Next(1000),
                    BlockState         = "blockStateTest1",
                    InsuranceCounter   = random.Next(1000),
                    InsuranceIndex     = random.Next(1000),
                    SampleSelectorType = "ssTypeTest1",
                    SystematicIndex    = random.Next(1000),
                };
                ds.UpsertSamplerState(ss);

                var ssAgain = ds.GetSamplerState(stCode, sgCode);
                ssAgain.Should().NotBeNull();
                ssAgain.Should().BeEquivalentTo(ss);
            }
        }