From dc539fda0108dc724693fbdd7599bd86980f0de0 Mon Sep 17 00:00:00 2001 From: clyhtsuriva Date: Sun, 29 Mar 2020 19:53:38 +0200 Subject: some web changes --- www/howto_psql | 35 +++++++++++++++++++++++++++++++++++ 1 file changed, 35 insertions(+) create mode 100755 www/howto_psql (limited to 'www/howto_psql') diff --git a/www/howto_psql b/www/howto_psql new file mode 100755 index 0000000..7d5adfc --- /dev/null +++ b/www/howto_psql @@ -0,0 +1,35 @@ +#in order to make things right, you should check the following comments to visualize and use properly the PSQL database. + +#assuming that you installed psql prior +#https://www.postgresql.org/download/linux/debian/ + +#create the user +adduser atsuser +#use the password '123456' + +#connect as postgres +su - postgres + +#launch the psql terminal +psql + +#create the user that we use in our scripts +CREATE USER atsuser WITH PASSWORD '123456'; + +#create our databse +CREATE DATABASE atsdb; + +#grant the privileges to our user +GRANT ALL PRIVILEGES ON DATABASE atsdb to atsuser; + +#quit +Ctrl+D + +#log in as atsuser +su - atsuser + +#launch psql with our user and our database +psql -d atsdb -U atsuser + +#initialize the tables +\i /WHATEVER_PATH_YOUR_INIT_IS_IN/ATS-Project/website/init-bd.sql -- cgit v1.2.3 href='/Spoteezer.git/log/target/site/jacoco/musichub.util/XMLHandler.java.html?h=develop&follow=1'>logtreecommitdiffstats
path: root/target/site/jacoco/musichub.util/XMLHandler.java.html (unfollow)
Commit message (Expand)AuthorFilesLines
2021-06-27Delete TEST-musichub.business.CategoryTest.xmlSaid Belhadj1-58/+0
2021-06-27Add unit test for Category and Languagesaid belhadj4-0/+164
2021-06-27Update search functionalitysaid belhadj2-0/+8
2021-06-27Added an extension check for songs and covered it with a test.Clyhtsuriva65-77/+92
2021-06-27Fix : Javadoc missingClyhtsuriva80-0/+8465
2021-06-27PlayList class covered at 84%.Clyhtsuriva14-78/+117
2021-06-27Song class fully covered.Clyhtsuriva13-49/+96
2021-06-27Starting Song testsClyhtsuriva17-59/+119
2021-06-27Changed the log type for the JUnit test of LogHandlerClyhtsuriva5-26/+4
2021-06-27XMLHandler tests covered at 91%Clyhtsuriva93-7962/+82