示例#1
0
        /// <summary>
        /// Improvements:
        /// 1. Command executing and LastSyncTime update should be in a transaction
        /// 2. LastSyncTime should be updated periodically as well
        /// 3. Improve on the precision of DateTime
        /// </summary>
        public void Start()
        {
            while (true)
            {
                try
                {
                    // Get last timestamp from a file
                    DateTime dt = destination.GetLastSyncTime();
                    Console.WriteLine($"LastSyncTime: {dt}");

                    // Get commands after that
                    List <Tuple <DateTime, string> > commands = source.GetChangesSince(dt);
                    foreach (Tuple <DateTime, string> pair in commands)
                    {
                        DateTime time    = pair.Item1;
                        string   command = pair.Item2;

                        Console.WriteLine($"{time}, {command}");

                        // Execute them on the destination
                        bool isSuccess = destination.ExecuteStatement(command);
                        if (!isSuccess)
                        {
                            throw new Exception($"Failed to replicate command {command}");
                        }

                        // Update the timestamp after success
                        bool isUpdated = destination.UpdateLastSyncTime(time.AddSeconds(1));
                        Console.WriteLine($"IsUpdated {isUpdated} | Time: {time}");
                    }
                }
                catch (Exception e)
                {
                    Console.WriteLine($"Exception: {e}");
                }

                Console.WriteLine("Sleeping...");
                Thread.Sleep(5 * 1000);
            }
        }