public async Task GetByMaxTime()
        {
            var db = new SqliteInMemoryDatabase();
            var rm = new DatabaseReminders(db);

            var t  = DateTime.UtcNow;
            var r1 = await rm.Create(t, "pre", "msg2", 17, 28);

            var r2 = await rm.Create(t + TimeSpan.FromHours(1), "pre", "msg2", 17, 28);

            var rs = await rm.Get(before : t + TimeSpan.FromHours(0.5f)).ToArrayAsync();

            Assert.AreEqual(r1, rs.Single());
        }
        public async Task GetByChannel()
        {
            var db = new SqliteInMemoryDatabase();
            var rm = new DatabaseReminders(db);

            var t = DateTime.UtcNow + TimeSpan.FromMinutes(1);
            var r = await rm.Create(t, "pre", "msg", 17, 28);

            var rs = await rm.Get(channel : 17).ToArrayAsync();

            Assert.AreEqual(r, rs.Single());
        }
        public async Task CreateReminderDoesNotThrow()
        {
            var db = new SqliteInMemoryDatabase();
            var rm = new DatabaseReminders(db);

            var t = DateTime.UtcNow + TimeSpan.FromMinutes(1);
            var r = await rm.Create(t, "pre", "msg", 17, 28);

            Assert.AreEqual(t, r.TriggerTime);
            Assert.AreEqual("pre", r.Prelude);
            Assert.AreEqual("msg", r.Message);
            Assert.AreEqual(17u, r.ChannelId);
            Assert.AreEqual(28u, r.UserId);
        }
        public async Task Delete()
        {
            var db = new SqliteInMemoryDatabase();
            var rm = new DatabaseReminders(db);

            var t = DateTime.UtcNow + TimeSpan.FromMinutes(1);
            var r = await rm.Create(t, "pre", "msg", 17, 28);

            Assert.IsTrue(await rm.Delete(28, r.ID));

            var rs = await rm.Get(channel : 17).ToArrayAsync();

            Assert.AreEqual(0, rs.Length);
        }
        public async Task GetWithLimit()
        {
            var db = new SqliteInMemoryDatabase();
            var rm = new DatabaseReminders(db);

            var t = DateTime.UtcNow;

            for (var i = 0; i < 10; i++)
            {
                await rm.Create(t + TimeSpan.FromMinutes(i), "pre", "msg " + i, 17, 28);
            }

            var rs = await rm.Get(channel : 17, count : 3).ToArrayAsync();

            Assert.AreEqual(3, rs.Length);
            Assert.AreEqual((t + TimeSpan.FromMinutes(0)).UnixTimestamp(), rs[0].TriggerTime.UnixTimestamp());
            Assert.AreEqual((t + TimeSpan.FromMinutes(1)).UnixTimestamp(), rs[1].TriggerTime.UnixTimestamp());
            Assert.AreEqual((t + TimeSpan.FromMinutes(2)).UnixTimestamp(), rs[2].TriggerTime.UnixTimestamp());
        }