#region using

using System;
using System.Diagnostics;
using System.Collections.Generic;
using System.Linq;
using System.IO;
using System.Text;
using System.Threading;

using XHE;
using XHE.XHE_DOM;
using XHE.XHE_System;
using XHE.XHE_Window;
using XHE.XHE_Web;

#endregion

class Program:XHEScript
{
	static void Main(string[] args)
	{
		server = Environment.GetEnvironmentVariable("RPABOT_HOST_URL");
		InitXHE();

		echo("<hr><font color=blue>logger.exportAllLogsFromDbSQLiteToCsv</font><hr>");

		echo("0. Initialize logger and add test data: ");
		bool initResult = logger.init(0, true, true, "", "test\\logger_test.db");
		if(initResult)
			echo("вњ“ Init successful<br>");
		else
			echo("вњ— Init failed<br>");

		echo("0.1. Add test logs: ");
		logger.addLogToSQLite(0, "Export test 1", "{\"data\":\"test1\"}", "ExportTest");
		logger.addLogToSQLite(2, "Export test 2", "{\"data\":\"test2\"}", "ExportTest");
		logger.addLogToSQLite(4, "Export test 3", "{\"data\":\"test3\"}", "ExportTest");
		echo("вњ“ Test logs added<br>");

		// 1 step
		echo("\n1. Export all logs to CSV with default delimiter: ");
		bool result1 = logger.exportAllLogsFromDbSQLiteToCsv("test\\logs_export.csv");
		if(result1)
			echo("вњ“ Exported to CSV with default delimiter<br>");
		else
			echo("вњ— Failed to export to CSV<br>");

		// 2 step
		echo("\n2. Export logs with custom delimiter (comma): ");
		bool result2 = logger.exportAllLogsFromDbSQLiteToCsv("test\\logs_export_comma.csv", ",");
		if(result2)
			echo("вњ“ Exported to CSV with comma delimiter<br>");
		else
			echo("вњ— Failed to export with comma delimiter<br>");

		// 3 step
		echo("\n3. Export logs to specific file path: ");
		string exportPath = "test\\custom_logs_export.csv";
		bool result3 = logger.exportAllLogsFromDbSQLiteToCsv(exportPath);
		if(result3)
			echo("вњ“ Exported to " + exportPath + "<br>");
		else
			echo("вњ— Failed to export to custom path<br>");

		// 4 step
		echo("\n4. Verify CSV file was created successfully: ");
		if(File.Exists("test\\logs_export.csv"))
		{
			long fileSize = new FileInfo("test\\logs_export.csv").Length;
			if(fileSize > 0)
				echo("вњ“ CSV file created (size: " + fileSize + " bytes)<br>");
			else
				echo("вњ— CSV file exists but is empty<br>");
		}
		else
			echo("вњ— CSV file was not created<br>");

		echo("\n\n");

		app.quit();
	}
}

const xhe_host = "127.0.0.1:7019";
require("../../../Templates JS/init.js");
const path = require("path");

async function main()
{
	const dbPath = path.join(__dirname, "/logs/test_logger_export.db");
	let csvPath = path.join(__dirname, "/test/export.csv");
	logger.init(1, true, true, "", dbPath, "d-m-Y H:i:s", "en", false, true);
	
	logger.addLogToSQLite(2, "Export message 1", "{\"test\":\"data1\"}", "Caller1");
	logger.addLogToSQLite(2, "Export message 2", "{\"test\":\"data2\"}", "Caller2");
	logger.addLogToSQLite(3, "Export message 3", "{\"test\":\"data3\"}", "Caller3");
	
	var result = logger.exportAllLogsFromDbSQLiteToCsv(csvPath, ";");
	if (result === true)
		console.log("вњ“ Test 1: Export all logs to CSV with semicolon delimiter - PASSED");
	else
		console.log("вњ— Test 1: Export all logs to CSV with semicolon delimiter - FAILED");
	
	csvPath = path.join(__dirname, "/test/export_comma.csv");
	result = logger.exportAllLogsFromDbSQLiteToCsv(csvPath, ",");
	if (result === true)
		console.log("вњ“ Test 2: Export all logs to CSV with comma delimiter - PASSED");
	else
		console.log("вњ— Test 2: Export all logs to CSV with comma delimiter - FAILED");
	
	logger.addLogToSQLite(1, "Debug export", "{\"debug\":\"data\"}", "Caller4");
	csvPath = path.join(__dirname, "/test/export_tab.csv");
	result = logger.exportAllLogsFromDbSQLiteToCsv(csvPath, "\t");
	if (result === true)
		console.log("вњ“ Test 3: Export all logs to CSV with tab delimiter - PASSED");
	else
		console.log("вњ— Test 3: Export all logs to CSV with tab delimiter - FAILED");
	
	csvPath = path.join(__dirname, "/test/export_pipe.csv");
	result = logger.exportAllLogsFromDbSQLiteToCsv(csvPath, "|");
	if (result === true)
		console.log("вњ“ Test 4: Export all logs to CSV with pipe delimiter - PASSED");
	else
		console.log("вњ— Test 4: Export all logs to CSV with pipe delimiter - FAILED");
}

main();