function handle(){
  //MYSQL INFO
  //host	    tks.wtf:3306
  //User	    vtDataBot
  //Password	vtDbAccess#2019+
  //Schema	    vt_Data
  //MMEType	    utf8_general_ci
  //Locals	    UTC

  //sqladmin	sqladmin.tks.wtf
  //User	    vtDataBot
  //Password	vtDbAccess#2019+

  //database:	vt_data
  //table:	    vt_warehouse_logistics (Lager)
  //table:	    vt_warehouse_foundry (Lager)
  //table:	    vt_warehouse_vehicle (Lager)
  //table:	    vt_vehicleimport_data (Import Motor)

  vt_warehouse_all()
  vt_warehouse_logistics()
  vt_warehouse_foundry()
  vt_warehouse_vehicle()
}

function vt_warehouse_logistics() {
  //clear old stuff
  var spreadsheet = SpreadsheetApp.getActive();
  spreadsheet.getActiveSheet().getRange('LagerBot!K3:N2000').clearContent()

  var conn = Jdbc.getConnection('jdbc:mysql://tks.wtf:3306/vt_data', 'vtDataBot', 'vtDbAccess#2019+');
  var stmt = conn.createStatement();
  var start = new Date();
  var rs = stmt.executeQuery('SELECT name, number, warehouse, datafrom FROM vt_warehouse_logistics');

  var doc = SpreadsheetApp.getActiveSpreadsheet();
  var cell = doc.getRange('LagerBot!K3');
  var row = 0;
  var getCount = rs.getMetaData().getColumnCount();
  var i;

  for (var i = 0; i < getCount; i++){
    cell.offset(row, i).setValue(rs.getMetaData().getColumnName(i+1));
  }

  var row = 1;
  while (rs.next()) {
    for (var col = 0; col < rs.getMetaData().getColumnCount(); col++) {
      cell.offset(row, col).setValue(rs.getString(col + 1));
    }
    row++;
  }

  rs.close();
  stmt.close();
  conn.close();


  //spreadsheet.getActiveSheet().getRange('LagerBot!F2').setValue('Daten vom: ')
  //spreadsheet.getActiveSheet().getRange('LagerBot!G2').setFormula('I4')

}


function vt_warehouse_foundry() {
  //clear old stuff
  var spreadsheet = SpreadsheetApp.getActive();
  spreadsheet.getActiveSheet().getRange('LagerBot!P3:S2000').clearContent()

  var conn = Jdbc.getConnection('jdbc:mysql://tks.wtf:3306/vt_data', 'vtDataBot', 'vtDbAccess#2019+');
  var stmt = conn.createStatement();
  var start = new Date();
  var rs = stmt.executeQuery('SELECT name, number, warehouse, datafrom FROM vt_warehouse_foundry');

  var doc = SpreadsheetApp.getActiveSpreadsheet();
  var cell = doc.getRange('LagerBot!P3');
  var row = 0;
  var getCount = rs.getMetaData().getColumnCount();
  var i;

  for (var i = 0; i < getCount; i++){
    cell.offset(row, i).setValue(rs.getMetaData().getColumnName(i+1));
  }

  var row = 1;
  while (rs.next()) {
    for (var col = 0; col < rs.getMetaData().getColumnCount(); col++) {
      cell.offset(row, col).setValue(rs.getString(col + 1));
    }
    row++;
  }

  rs.close();
  stmt.close();
  conn.close();
  var end = new Date();
}

function vt_warehouse_vehicle() {
  //clear old stuff
  var spreadsheet = SpreadsheetApp.getActive();
  spreadsheet.getActiveSheet().getRange('LagerBot!U3:X2000').clearContent()

  var conn = Jdbc.getConnection('jdbc:mysql://tks.wtf:3306/vt_data', 'vtDataBot', 'vtDbAccess#2019+');
  var stmt = conn.createStatement();
  var start = new Date();
  var rs = stmt.executeQuery('SELECT name, number, warehouse, datafrom FROM vt_warehouse_vehicle');

  var doc = SpreadsheetApp.getActiveSpreadsheet();
  var cell = doc.getRange('LagerBot!U3');
  var row = 0;
  var getCount = rs.getMetaData().getColumnCount();
  var i;

  for (var i = 0; i < getCount; i++){
    cell.offset(row, i).setValue(rs.getMetaData().getColumnName(i+1));
  }

  var row = 1;
  while (rs.next()) {
    for (var col = 0; col < rs.getMetaData().getColumnCount(); col++) {
      cell.offset(row, col).setValue(rs.getString(col + 1));
    }
    row++;
  }

  rs.close();
  stmt.close();
  conn.close();
  var end = new Date();
}











  //database:	vt_data
  //table:	    vt_warehouse_logistics (Lager)
  //table:	    vt_warehouse_foundry (Lager)
  //table:	    vt_warehouse_vehicle (Lager)
  //table:	    vt_vehicleimport_data (Import Motor)





function vt_warehouse_all() {
  //clear old stuff
  var spreadsheet = SpreadsheetApp.getActive();
  spreadsheet.getActiveSheet().getRange('LagerBot!F3:I2000').clearContent()

  var conn = Jdbc.getConnection('jdbc:mysql://tks.wtf:3306/vt_data', 'vtDataBot', 'vtDbAccess#2019+');
  var stmt = conn.createStatement();
  var start = new Date();
  var rs = stmt.executeQuery('SELECT name, number, warehouse, datafrom FROM vt_warehouse_logistics');
  var doc = SpreadsheetApp.getActiveSpreadsheet();
  var cell = doc.getRange('LagerBot!F3');
  var row = 0;
  var getCount = rs.getMetaData().getColumnCount();
  var i;

  for (var i = 0; i < getCount; i++){
    cell.offset(row, i).setValue(rs.getMetaData().getColumnName(i+1));
  }

  var row = 1;
  while (rs.next()) {
    for (var col = 0; col < rs.getMetaData().getColumnCount(); col++) {
      cell.offset(row, col).setValue(rs.getString(col + 1));
    }
    row++;
  }

  var rs = stmt.executeQuery('SELECT name, number, warehouse, datafrom FROM vt_warehouse_foundry');
  for (var i = 0; i < getCount; i++){
    cell.offset(row, i).setValue(rs.getMetaData().getColumnName(i+1));
  }

  while (rs.next()) {
    for (var col = 0; col < rs.getMetaData().getColumnCount(); col++) {
      cell.offset(row, col).setValue(rs.getString(col + 1));
    }
    row++;
  }

  var rs = stmt.executeQuery('SELECT name, number, warehouse, datafrom FROM vt_warehouse_vehicle');
  for (var i = 0; i < getCount; i++){
    cell.offset(row, i).setValue(rs.getMetaData().getColumnName(i+1));
  }

  while (rs.next()) {
    for (var col = 0; col < rs.getMetaData().getColumnCount(); col++) {
      cell.offset(row, col).setValue(rs.getString(col + 1));
    }
    row++;
  }

  rs.close();
  stmt.close();
  conn.close();
}