From d62bd1ab3a14b31eaf4cead27f96ccbdfbca0a54 Mon Sep 17 00:00:00 2001
From: Leandro Lucarella <llucax@gmail.com>
Date: Wed, 16 Apr 2003 19:36:47 +0000
Subject: [PATCH] Se agrega la carga de novedades para intranet2.

---
 novedades/cargas/intranet2.mecon.ar/carga     | 25 +++++++++++++++++++
 .../scripts/10.borrar.codep                   |  9 +++++++
 .../scripts/20.copiar.datos                   | 11 ++++++++
 .../intranet2.mecon.ar/scripts/40.codep       | 21 ++++++++++++++++
 .../intranet2.mecon.ar/scripts/50.novedades   |  9 +++++++
 .../scripts/60.copiar.codep                   |  9 +++++++
 6 files changed, 84 insertions(+)
 create mode 100755 novedades/cargas/intranet2.mecon.ar/carga
 create mode 100755 novedades/cargas/intranet2.mecon.ar/scripts/10.borrar.codep
 create mode 100755 novedades/cargas/intranet2.mecon.ar/scripts/20.copiar.datos
 create mode 100755 novedades/cargas/intranet2.mecon.ar/scripts/40.codep
 create mode 100755 novedades/cargas/intranet2.mecon.ar/scripts/50.novedades
 create mode 100755 novedades/cargas/intranet2.mecon.ar/scripts/60.copiar.codep

diff --git a/novedades/cargas/intranet2.mecon.ar/carga b/novedades/cargas/intranet2.mecon.ar/carga
new file mode 100755
index 0000000..1df396b
--- /dev/null
+++ b/novedades/cargas/intranet2.mecon.ar/carga
@@ -0,0 +1,25 @@
+#!/bin/sh
+#
+# Script para cargar bases de datos.
+#
+# Creado por Leandro Lucarella (llucar) el mié abr 16 14:00:46 ART 2003
+#
+
+# Configuración.
+home="$1"
+datos="$2"
+host="intranet2"
+user="intranet"
+pass="intranet"
+db="novedades"
+
+# Script.
+/bin/run-parts \
+    --verbose \
+    --arg="$host" \
+    --arg="$user" \
+    --arg="$pass" \
+    --arg="$db" \
+    --arg="$home" \
+    --arg="$datos" \
+    "$home/scripts"
diff --git a/novedades/cargas/intranet2.mecon.ar/scripts/10.borrar.codep b/novedades/cargas/intranet2.mecon.ar/scripts/10.borrar.codep
new file mode 100755
index 0000000..027807b
--- /dev/null
+++ b/novedades/cargas/intranet2.mecon.ar/scripts/10.borrar.codep
@@ -0,0 +1,9 @@
+#!/bin/sh
+host="$1"
+user="$2"
+pass="$3"
+db="$4"
+home="$5"
+datos="$6"
+
+ssh novedades@"$host" rm -vf "$datos"/codep
diff --git a/novedades/cargas/intranet2.mecon.ar/scripts/20.copiar.datos b/novedades/cargas/intranet2.mecon.ar/scripts/20.copiar.datos
new file mode 100755
index 0000000..4b26ca7
--- /dev/null
+++ b/novedades/cargas/intranet2.mecon.ar/scripts/20.copiar.datos
@@ -0,0 +1,11 @@
+#!/bin/sh
+host="$1"
+user="$2"
+pass="$3"
+db="$4"
+home="$5"
+datos="$6"
+
+scp -r "$datos"/* novedades@"$host":"$datos"
+ssh novedades@"$host" chmod -v  775 "$datos"
+ssh novedades@"$host" chmod -vR 664 "$datos"/*
diff --git a/novedades/cargas/intranet2.mecon.ar/scripts/40.codep b/novedades/cargas/intranet2.mecon.ar/scripts/40.codep
new file mode 100755
index 0000000..d7be87a
--- /dev/null
+++ b/novedades/cargas/intranet2.mecon.ar/scripts/40.codep
@@ -0,0 +1,21 @@
+#!/bin/sh
+host="$1"
+user="$2"
+pass="$3"
+#db="$4"
+db="CODEP"
+home="$5"
+datos="$6"
+
+cat <<EOT | mysql -h"$host" -u"$user" -p"$pass" "$db"
+SELECT
+    codigo_actual, nombre_breve
+INTO OUTFILE
+    '$datos/codep'
+FIELDS TERMINATED BY
+    ','
+LINES TERMINATED BY
+    '\n'
+FROM
+    Dependencias;
+EOT
diff --git a/novedades/cargas/intranet2.mecon.ar/scripts/50.novedades b/novedades/cargas/intranet2.mecon.ar/scripts/50.novedades
new file mode 100755
index 0000000..4655d8f
--- /dev/null
+++ b/novedades/cargas/intranet2.mecon.ar/scripts/50.novedades
@@ -0,0 +1,9 @@
+#!/bin/sh
+host="$1"
+user="$2"
+pass="$3"
+db="$4"
+home="$5"
+datos="$6"
+
+"$home/../../run-sql-data-parts" "$host" "$user" "$pass" "$db" "$datos"
diff --git a/novedades/cargas/intranet2.mecon.ar/scripts/60.copiar.codep b/novedades/cargas/intranet2.mecon.ar/scripts/60.copiar.codep
new file mode 100755
index 0000000..ff18f7f
--- /dev/null
+++ b/novedades/cargas/intranet2.mecon.ar/scripts/60.copiar.codep
@@ -0,0 +1,9 @@
+#!/bin/sh
+host="$1"
+user="$2"
+pass="$3"
+db="$4"
+home="$5"
+datos="$6"
+
+scp -r novedades@"$host":"$datos"/codep "$datos"
-- 
2.43.0