var Server_DB = "localhost"
var port_DB = "5432"
var name_DB = "ext"
var user_DB = "postgres"
password_DB = "postgres"

function Init()
 {

   Core.RegisterEventHandler("LPR_CAM","1","CAR_LP_RECOGNIZED","Auto_in");
   Core.RegisterEventHandler("LPR_CAM","2","CAR_LP_RECOGNIZED","Auto_out");
   Connection_DB = new ActiveXObject("ADODB.Connection");
   var ConnectionString = "Driver={PostgreSQL Unicode};Server=Server_DB;Port=port_DB;Database=name_DB;Uid=user_DB;Pwd=password_DB;";
   Connection_DB.Open(ConnectionString);


   }

 function Auto_in(e)
 {
  var list = e.database_type;
  if(list == "whitelist"){
      if (Core.IsObjectState("GRAY", 1, "NORM"))
      Core.DoReact ("GRELE","1","ON");
      Script.Wait(2);
      Core.DoReact ("GRELE","1","OFF");
      do
      {
          // test
      }
      while (Core.IsObjectState("GRAY", 1, "NORM")) or (Core.IsObjectState("GRAY", 2, "NORM"))
      {
          Core.DoReact ("GRELE","2","ON");
          Script.Wait(2);
          Core.DoReact ("GRELE","2","OFF");

          Connection_DB.Execute("INSERT INTO ext.info VALUES number=e.number;");
      }
  }
  Connection_DB.Close();
}

 function Auto_out(e)
 {
  var list = e.database_type;
  if(list == "informationlist"){
      if (Core.IsObjectState("GRAY", 3, "NORM"))
      Core.DoReact ("GRELE","3","ON");
      Script.Wait(2);
      Core.DoReact ("GRELE","3","OFF");
      do
      {
          // test
      }
      while (Core.IsObjectState("GRAY", 3, "NORM")) or (Core.IsObjectState("GRAY", 4, "NORM"))
      {
          Core.DoReact ("GRELE","4","ON");
          Script.Wait(2);
          Core.DoReact ("GRELE","4","OFF");

          Connection_DB.Execute("DELETE FROM ext.info WHERE number='" + nomer + "';");
      }
  }
  Connection_DB.Close();
 }