Ejemplo n.º 1
0
        static void Main(string[] args)
        {
            SettingsFromXML settingsFromXML = new SettingsFromXML(); // initialize settings from config.xml

            Console.WriteLine("Subscribing to Mqtt Topic");

            MqttSubscriber mqttSubscriber = new MqttSubscriber();

            mqttSubscriber.Subscribe(settingsFromXML);
            System.Threading.Thread.Sleep(1000); // wait for event "Client_MqttMsgPublishReceived"

            Console.WriteLine("Storing Configuration from Topic");
            MqttCfgSettingsOrganiser mqttCfgSettings = new MqttCfgSettingsOrganiser(mqttSubscriber.MqttCfg);

            MqttPublisher mqttPublisher = new MqttPublisher(mqttCfgSettings);

            Transform transform = new Transform();

            transform.Start(settingsFromXML, mqttCfgSettings, mqttPublisher);
        }
Ejemplo n.º 2
0
        public void Start(SettingsFromXML settingsFromXML, MqttCfgSettingsOrganiser mqttCfgSettings, MqttPublisher mqttPublisher)
        {
            List <Measurements> measurementsList = new List <Measurements>();

            while (true)
            {
                Console.WriteLine("-------------------------------------------------------------");
                generatingFileNameToday();
                bool IsFileExist = File.Exists(mqttCfgSettings.InputPathDirectory + "\\" + fileName + ".csv");
                if (IsFileExist == true)
                {
                    Console.WriteLine("Reading from input");
                    measurementsList = readingFromInput(settingsFromXML, mqttCfgSettings);

                    Console.WriteLine("Adding info from MQTT Cfg");
                    measurementsList = InsertMachineDataFromMqttCfg(measurementsList, mqttCfgSettings);

                    Console.WriteLine("Checking Duplicates & Storing into PostgreSQL Database & forwarding onto MQTT Topic");
                    writingIntoOutput(measurementsList, mqttCfgSettings, mqttPublisher);

                    Console.WriteLine("Cleaning cache and starting a new detection");
                    measurementsList.Clear();
                }
                else
                {
                    Console.WriteLine("The report does not exist in the specified path: " + mqttCfgSettings.InputPathDirectory + "\\" + fileName + ".csv");
                }
                Console.WriteLine("Waiting Cycle time for refresh: " + mqttCfgSettings.Cycle + " minutes");
                System.Threading.Thread.Sleep(mqttCfgSettings.Cycle * 60 * 1000); // from minutes to ms
            }
        }
Ejemplo n.º 3
0
        // --------------------- GENERATING OUTPUT FILE --------------------- //
        private static void writingIntoOutput(List <Measurements> measurementsList, MqttCfgSettingsOrganiser mqttCfgSettings, MqttPublisher mqttPublisher)
        {
            if (measurementsList.Capacity != 0)
            {
                //File.WriteAllText(Directory.GetCurrentDirectory() + "\\Output\\output.json", JsonConvert.SerializeObject(measurementsList));
                // Opens the SQL Connection to the Postgre Database
                PostgreSqlManager Sql = new PostgreSqlManager(mqttCfgSettings);
                int Duplicates        = 0;
                int Stored            = 0;
                foreach (var measure in measurementsList)
                {
                    string json        = JsonConvert.SerializeObject(measure);
                    bool   IsDuplicate = true;
                    // CHECK DUPLICATE & STORE INTO DB
                    try
                    {
                        IsDuplicate = Sql.CheckingDuplicate(measure, mqttCfgSettings);

                        if (IsDuplicate == false)
                        {
                            Sql.StoreIntoPostgreSQL(measure, mqttCfgSettings);
                        }
                    }
                    catch (Exception StoreIntoDb)
                    {
                        Console.WriteLine("ERROR: Failed to committ transaction on PostgreSQL DB:\n" + StoreIntoDb);
                    }

                    if (IsDuplicate == false)
                    {
                        Stored++;
                        // PUBLISHING ON MQTT TOPIC
                        try
                        {
                            mqttPublisher.Publish(json, mqttCfgSettings);
                        }
                        catch (Exception Publish)
                        {
                            Console.WriteLine("ERROR: Failed to publish measurement on MQTT:\n" + Publish);
                        }
                    }
                    else
                    {
                        Duplicates++;
                    }
                }
                Console.WriteLine("Duplicate measurements found: " + Duplicates);
                Console.WriteLine("Measurements sent to MQTT topic: " + Stored);
            }
            else
            {
                Console.WriteLine("The input is empty, no output is going to be generated at this cycle...");
            }
        }