Differences

This shows you the differences between two versions of the page.

--- unraid:dockers:tomcat [2023/03/12 20:23] – [App Settings] dirk
+++ unraid:dockers:tomcat [2023/08/20 20:14] (current) – [Add football season] dirk
@@ Line 33: / Line 33: @@
 ln -sf /usr/local/tomcat/webapps/jar/javax.mail.jar /usr/local/tomcat/lib/javax.mail.jar
 etc</code>
-    * If webinf files need to be compiled:<code>javac -cp /usr/local/tomcat/lib/servlet-api.jar:/usr/local/tomcat/lib/jsp-api.jar util/*.java</code>
+    * If webinf files need to be compiled:<code>javac -cp /usr/local/tomcat/lib/servlet-api.jar:/usr/local/tomcat/lib/jsp-api.jar:/usr/local/tomcat/lib/javax.activation.jar:/usr/local/tomcat/lib/javax.mail.jar webapps/ROOT/WEB-INF/classes/util/*.java</code>
     * Note: this step is different from Tomcat v9 in VM because paths are different.
     * Note2: MUST CHANGE import javax.servlet.* to import jakarta.servlet.* in all the .java files under the WEB-INF folder before compiling with above.
     * Restart
+==== Add football season ====
+<code>docker cp /mnt/user/backup/webpage/mysql/2023o.csv mysql:/var/lib/mysql-files/</code>
+<code>mysql --local-infile=1 -uUSERNAME -p
+use DB;
+LOAD DATA LOCAL INFILE "2023o.csv" INTO TABLE games_nfl COLUMNS TERMINATED BY ',';
+UPDATE games_nfl SET vscore = NULL where year = 2023;
+UPDATE games_nfl SET hscore = NULL where year = 2023;</code>

brimble.com