using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Npgsql;

namespace polcarDataWorker
{
    class sqlHelper
    {
        static string connectionString = "Host=10.1.10.155;Username=mvluser;Password=password123;Database=mvl_dump";

        public static void populateDatabase()
        {
            using (var connection = new NpgsqlConnection(connectionString))
            {
                connection.Open();

                using (var cmd = new Npgsql.NpgsqlCommand())
                {

                    cmd.CommandText = "COPY mvl(ktype,make,model,variant,bodystyle,type,year,engine,additionsupdate) FROM STDIN;";

                    for (int a = 0; a < mvlLoader.listOfMvlItems.Count; a++)
                    {

                    }
                }
            }
        }

    }
}