public async Task Should_insert_message_into_bucket() { // arrange var expectedUsername = "******" + Guid.NewGuid(); var expectedMessage = "some message whatever " + Guid.NewGuid(); var expectedChannel = "mychannel" + Guid.NewGuid(); var twitchLibMessage = TwitchLibMessageBuilder.Create() .WithUsername(expectedUsername) .Build(); var chatMessage = ChatMessageBuilder.Create() .WithTwitchLibMessage(twitchLibMessage) .WithMessage(expectedMessage) .WithChannel(expectedChannel) .Build(); var request = new StoreMessage(chatMessage); // act await _handler.Handle(request, CancellationToken.None); // assert MockCollection.Verify(x => x.InsertAsync(It.IsAny <string>(), It.IsAny <ChatMessage>(), null), Times.Once()); MockCollection.Verify(x => x.InsertAsync(It.IsAny <string>(), It.Is <ChatMessage>(d => d.Username == expectedUsername), null), Times.Once()); MockCollection.Verify(x => x.InsertAsync(It.IsAny <string>(), It.Is <ChatMessage>(d => d.Message == expectedMessage), null), Times.Once()); MockCollection.Verify(x => x.InsertAsync(It.IsAny <string>(), It.Is <ChatMessage>(d => d.Channel == expectedChannel), null), Times.Once()); }
public async Task Should_insert_message_into_bucket() { // arrange var expectedUsername = "******" + Guid.NewGuid(); var expectedMessage = "some message whatever " + Guid.NewGuid(); var expectedChannel = "mychannel" + Guid.NewGuid(); var twitchLibMessage = TwitchLibMessageBuilder.Create() .WithUsername(expectedUsername) .Build(); var chatMessage = ChatMessageBuilder.Create() .WithTwitchLibMessage(twitchLibMessage) .WithMessage(expectedMessage) .WithChannel(expectedChannel) .Build(); var request = new StoreMessage(chatMessage); // act await _handler.Handle(request, CancellationToken.None); // assert _mockBucket.Verify(x => x.InsertAsync(It.Is <Document <ChatMessage> >(d => d.Id != Guid.Empty.ToString())), Times.Once()); _mockBucket.Verify(x => x.InsertAsync(It.Is <Document <ChatMessage> >(d => d.Content.Username == expectedUsername)), Times.Once()); _mockBucket.Verify(x => x.InsertAsync(It.Is <Document <ChatMessage> >(d => d.Content.Message == expectedMessage)), Times.Once()); _mockBucket.Verify(x => x.InsertAsync(It.Is <Document <ChatMessage> >(d => d.Content.Channel == expectedChannel)), Times.Once()); }
private static StoreMessage ParseStoreMessage(string dataFromClient) { var parts = dataFromClient.Split(new char[] { '@' }, StringSplitOptions.RemoveEmptyEntries); var i = 0; var storeMessage = new StoreMessage(); foreach (var part in parts) { if (i == 0) { storeMessage.Location = part; } else if (i == 1) { i++; continue; // part == "Store" (function name) } else { if (int.TryParse(part, out int messageNumber)) // last part, containing count { storeMessage.MessageNumber = messageNumber; } else // actual passing { storeMessage.Passings.Add(Passing.Parse(part)); } } i++; } return(storeMessage); }
public async Task Is_chat_message_stored() { // arrange var expectedUsername = "******" + Guid.NewGuid(); var expectedMessage = "some message whatever " + Guid.NewGuid(); var expectedChannel = "mychannel" + Guid.NewGuid(); var twitchLibMessage = TwitchLibMessageBuilder.Create() .WithUsername(expectedUsername) .Build(); var chatMessage = ChatMessageBuilder.Create() .WithTwitchLibMessage(twitchLibMessage) .WithMessage(expectedMessage) .WithChannel(expectedChannel) .Build(); var request = new StoreMessage(chatMessage); // act await _handler.Handle(request, CancellationToken.None); // assert var n1ql = $"SELECT RAW COUNT(*) FROM `{Bucket.Name}` WHERE message = $expectedMessage"; var result = await TestCluster.QueryAsync <int>(n1ql, QueryOptions.Create().Parameter("expectedMessage", expectedMessage).ScanConsistency(QueryScanConsistency.RequestPlus)); var count = await result.Rows.FirstOrDefaultAsync(); Assert.That(count, Is.EqualTo(1)); }
private int InsertStoreMessage(string notification, string userId) { var storeMessage = new StoreMessage { Message = notification, UserIdIns = userId, }; Db.StoreMessage.Add(storeMessage); Db.SaveChanges(); return(storeMessage.StoreMessageId); }
public bool AddStoreMessage(StoreMessage msg) { DbCommand sqlStringCommand = this.database.GetSqlStringCommand("INSERT INTO Vshop_StoreMessage VALUES (@DisUserID, @MsgUserID, @MessaegeCon, @MsgTime, @Value1, @Value2, @Value3)"); this.database.AddInParameter(sqlStringCommand, "DisUserID", DbType.Int32, msg.DisUserID); this.database.AddInParameter(sqlStringCommand, "MsgUserID", DbType.Int32, msg.MsgUserID); this.database.AddInParameter(sqlStringCommand, "MessaegeCon", DbType.String, msg.MessaegeCon); this.database.AddInParameter(sqlStringCommand, "MsgTime", DbType.DateTime, msg.MsgTime); this.database.AddInParameter(sqlStringCommand, "Value1", DbType.String, msg.Value1); this.database.AddInParameter(sqlStringCommand, "Value2", DbType.String, msg.Value2); this.database.AddInParameter(sqlStringCommand, "Value3", DbType.String, msg.Value3); return(this.database.ExecuteNonQuery(sqlStringCommand) == 1); }
public StoreMessage GetModel(int ID) { DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT * FROM vw_Hishop_StoreMessage WHERE ID = @ID"); this.database.AddInParameter(sqlStringCommand, "ID", DbType.Int32, ID); StoreMessage info = null; using (IDataReader reader = this.database.ExecuteReader(sqlStringCommand)) { if (reader.Read()) { info = ReaderConvert.ReaderToModel <StoreMessage>(reader); } } return(info); }
public async Task AddMessageAsync(string msg) { //Description: Deserializace události jako obecné zprávy a uložení do DB var origin = JsonConvert.DeserializeObject <Message>(msg); var message = new StoreMessage { Guid = Guid.NewGuid(), MessageType = origin.MessageType, MessageTypeText = origin.MessageType.ToString(), Created = origin.Created, EntityId = origin.EntityId, Message = msg }; db.Messages.Add(message); await db.SaveChangesAsync(); }
protected void btnSave_Click(object sender, EventArgs e) { MemberInfo currentMember = MemberProcessor.GetCurrentMember(); //int DisUserID = Globals.GetCurrentDistributorId(); string MsgCon = this.txtMsgCon.Text.Trim(); StoreMessage sm = new StoreMessage(); sm.DisUserID = 0; sm.MsgUserID = currentMember.UserId; sm.MessaegeCon = MsgCon; sm.MsgTime = DateTime.Now; StoreMessageBrowser.AddStoreMessage(sm); this.txtMsgCon.Text = ""; if (t == 1) { this.Page.Response.Write("<script>alert('发布成功!');window.location='MyStoreMessage.aspx?t=1';</script>"); } else { this.Page.Response.Write("<script>alert('发布成功!');window.location='MyStoreMessage.aspx';</script>"); } }
/// <summary> /// 新增留言 /// </summary> /// <param name="msg"></param> /// <returns></returns> public static bool AddStoreMessage(StoreMessage msg) { return(new StoreMessageDao().AddStoreMessage(msg)); }