script autoBdd

16 files changed, 17 insertions, 0 deletions

diff --git a/LICENSE b/LICENSE
index f288702..f288702 100644..100755
--- a/LICENSE
+++ b/LICENSE
diff --git a/README.md b/README.md
index afdfee5..afdfee5 100644..100755
--- a/README.md
+++ b/README.md
diff --git a/analyse/script.sh b/analyse/script.sh
index 0eb3150..0eb3150 100644..100755
--- a/analyse/script.sh
+++ b/analyse/script.sh
diff --git a/automatisation/BDDAuto.sh b/automatisation/BDDAuto.sh
new file mode 100755
index 0000000..3ec2490
--- /dev/null
+++ b/automatisation/BDDAuto.sh
@@ -0,0 +1,17 @@
+#!/bin/bash
+
+cp /root/ATS-Project/web/website/init-bd.sql /tmp/table.sql #Car problème de droit root
+
+apt install postgresql
+
+useradd atsuser
+
+echo atsuser:123456 | chpasswd
+
+
+echo "CREATE USER atsuser WITH PASSWORD '123456'; CREATE DATABASE atsdb; GRANT ALL PRIVILEGES ON DATABASE atsdb to atsuser;" > /tmp/conf
+
+
+su - postgres -c "psql -f /tmp/conf"
+
+su - atsuser -c "psql -d atsdb -U atsuser -f /tmp/table.sql"
diff --git a/automatisation/txt b/automatisation/txt
deleted file mode 100644
index e69de29..0000000
--- a/automatisation/txt
+++ /dev/null
diff --git a/web/.htpasswd b/web/.htpasswd
index 029fc64..029fc64 100644..100755
--- a/web/.htpasswd
+++ b/web/.htpasswd
diff --git a/web/apache-modified/apache2.conf b/web/apache-modified/apache2.conf
index 96c1601..96c1601 100644..100755
--- a/web/apache-modified/apache2.conf
+++ b/web/apache-modified/apache2.conf
diff --git a/web/howto_psql b/web/howto_psql
index 7d5adfc..7d5adfc 100644..100755
--- a/web/howto_psql
+++ b/web/howto_psql
diff --git a/web/website/.htaccess b/web/website/.htaccess
index 825c08d..825c08d 100644..100755
--- a/web/website/.htaccess
+++ b/web/website/.htaccess
diff --git a/web/website/fonctions.py b/web/website/fonctions.py
index c1566af..c1566af 100644..100755
--- a/web/website/fonctions.py
+++ b/web/website/fonctions.py
diff --git a/web/website/index.html b/web/website/index.html
index 27f4dda..27f4dda 100644..100755
--- a/web/website/index.html
+++ b/web/website/index.html
diff --git a/web/website/index.py b/web/website/index.py
index 131a82a..131a82a 100644..100755
--- a/web/website/index.py
+++ b/web/website/index.py
diff --git a/web/website/init-bd.sql b/web/website/init-bd.sql
index f1a4f2b..f1a4f2b 100644..100755
--- a/web/website/init-bd.sql
+++ b/web/website/init-bd.sql
diff --git a/web/website/style.css b/web/website/style.css
index 6d0bd42..6d0bd42 100644..100755
--- a/web/website/style.css
+++ b/web/website/style.css
diff --git a/web/website/test.html b/web/website/test.html
index b789672..b789672 100644..100755
--- a/web/website/test.html
+++ b/web/website/test.html
diff --git a/web/website/test.py b/web/website/test.py
index 6ff289c..6ff289c 100644..100755
--- a/web/website/test.py
+++ b/web/website/test.py