using com.cloudsoft.utils;
using NUnit.Framework;
using System;

namespace GPS.XML.Utils.Tests
{
    public class XMLHelperTests
    {
        [SetUp]
        public void Setup()
        {
        }

        [Test]
        public void SimpleTestWithNode()
        {
            var expectedXml = "<test><node1>nodeval</node1></test>";
            var xml = new XMLHelper("test");
            xml.appendNode("node1").setValue("nodeval");
            Console.WriteLine(xml.getXML());
            Assert.AreEqual(expectedXml, xml.getXML());
        }

        [Test]
        public void SimpleTestWithNodeAndAttribute()
        {
            var expectedXml = "<test><node1 attribute=\"1\">nodeval</node1></test>";
            var xml = new XMLHelper("test");
            var node1 = xml.appendNode("node1");
            node1.appendAttribute("attribute", "1");
            node1.setValue("nodeval");
                
            Console.WriteLine(xml.getXML());
            Assert.AreEqual(expectedXml, xml.getXML());
        }

        [Test]
        public void SimpleSelectTestFromDB()
        {
            var db = new DBHelper("test");
            var xml = db.getDOM("select * from [Transaction]");
            Console.WriteLine(xml.getXML());
        }

        [Test]
        public void SimpleTestFromDB()
        {
            var db = new DBHelper("test");
            var xml = db.getTables();
            Console.WriteLine(xml.nodeCount("rows/row"));
            Console.WriteLine(xml.getXML());
            Console.WriteLine(xml.getJSON());
        }
        
        [Test]
        public void SimpleSelectTesWithParamstFromDB()
        {
            var oRequest = new XMLHelper("request");
            oRequest.appendNode("status", "14");
            var db = new DBHelper(oRequest);
            var xml = db.getDOM("select * from Cards where Status = v:status");
            Console.WriteLine(xml.getXML());
            Console.WriteLine(xml.getJSON());
        }
    }
}