public void Update(ParsedMessage entity)
        {
            using (var conn = new SqlConnection(Settings.Default.ConnectionString))
            {
                conn.Open();

                conn.Execute("UPDATE ParsedMessage SET " +
                             "BodyParsed = @BodyParsed, " +
                             "BodyPlain = @BodyPlain, " +
                             "BodyRich = @BodyRich, " +
                             "ClientType = @ClientType, " +
                             "CreatedAt = @CreatedAt, " +
                             "IsDirectMessage = @IsDirectMessage, " +
                             "GroupId = @GroupId, " +
                             "RepliedToId = @RepliedToId, " +
                             "SenderId = @SenderId, " +
                             "ThreadId = @ThreadId, " +
                             "Url = @Url, " +
                             "WebUrl = @WebUrl, " +
                             "LikedByCount = @LikedByCount, " +
                             "LikedByNames = @LikedByNames " +
                             "WHERE Id = @Id",
                             entity);
            }
        }
        public void Add(ParsedMessage entity)
        {
            using (var conn = new SqlConnection(Settings.Default.ConnectionString))
            {
                conn.Open();

                conn.Execute("INSERT INTO ParsedMessage (Id, BodyParsed, BodyPlain, BodyRich, ClientType, CreatedAt, IsDirectMessage, " +
                    "GroupId, RepliedToId, SenderId, ThreadId, Url, WebUrl, LikedByCount, LikedByNames) VALUES " +
                    "(@Id, @BodyParsed, @BodyPlain, @BodyRich, @ClientType, @CreatedAt, @IsDirectMessage, " +
                    "@GroupId, @RepliedToId, @SenderId, @ThreadId, @Url, @WebUrl, @LikedByCount, @LikedByNames)", entity);
            }
        }
Esempio n. 3
0
        public void Run()
        {
            var messages = _messageService.GetAll();

            foreach (var message in messages)
            {
                var messageObj = JObject.Parse(message.RawContent);
                var parsedMessage = new ParsedMessage();
                parsedMessage.Id = (long) messageObj["id"];
                parsedMessage.BodyParsed = (string) messageObj.SelectToken("body.parsed");
                parsedMessage.BodyPlain = (string) messageObj.SelectToken("body.plain");
                parsedMessage.BodyRich = (string) messageObj.SelectToken("body.rich");
                parsedMessage.ClientType = (string) messageObj["client_type"];
                parsedMessage.CreatedAt = DateTimeOffset.Parse((string) messageObj["created_at"]);
                parsedMessage.IsDirectMessage = (bool) messageObj["direct_message"];
                parsedMessage.GroupId = (long?) messageObj["group_id"];
                parsedMessage.RepliedToId = (long?) messageObj["replied_to_id"];
                parsedMessage.SenderId = (long?) messageObj["sender_id"];
                parsedMessage.ThreadId = (long) messageObj["thread_id"];
                parsedMessage.Url = (string) messageObj["url"];
                parsedMessage.WebUrl = (string) messageObj["web_url"];
                parsedMessage.LikedByCount = (int?) messageObj.SelectToken("liked_by.count");
                parsedMessage.LikedByNames = string.Join(", ", messageObj.SelectToken("liked_by.names"));

                var existingParsedMessage = _parsedMessageService.GetById(parsedMessage.Id);
                if (existingParsedMessage == null)
                {
                    _parsedMessageService.Add(parsedMessage);
                    Console.WriteLine("Added " + parsedMessage.Id);
                }
                else
                {
                    _parsedMessageService.Update(parsedMessage);
                    Console.WriteLine("Updated " + parsedMessage.Id);
                }
            }
        }