Added testing stubs

dominict · dominict · commit 76e3381d6abe · 2019-12-06T18:15:22.000-05:00
diff --git a/4 DB in Python/MySQL Demo/DBconnectgrades.py b/4 DB in Python/MySQL Demo/DBconnectgrades.py
@@ -2,7 +2,7 @@
 import pymysql as my
 
 #root password is something you set when you install mysql on your system
-#the default may be blank; I used python123 for testing
+#the default may be blank; I used python123 for testing 
 #BE SURE to match your password to the password you set when installing MySQL. If in doubt, try a blank password
 dbconn = my.connect (host='127.0.0.1',port=3306,user='root', password='python123',  db='students')
  
diff --git a/4 DB in Python/MySQL Demo/StudentsDBdump.sql b/4 DB in Python/MySQL Demo/StudentsDBdump.sql
@@ -1,4 +1,4 @@
-CREATE DATABASE  IF NOT EXISTS `students` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */;
+CREATE DATABASE  IF NOT EXISTS `students` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci */;
 USE `students`;
 -- MySQL dump 10.13  Distrib 8.0.12, for macos10.13 (x86_64)
 --
@@ -23,7 +23,7 @@ USE `students`;
 
 DROP TABLE IF EXISTS `grades`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
- SET character_set_client = utf8mb4 ;
+ SET character_set_client = latin1 ;
 CREATE TABLE `grades` (
   `GradeID` int(11) NOT NULL AUTO_INCREMENT,
   `Grade` float DEFAULT NULL,
@@ -32,7 +32,7 @@ CREATE TABLE `grades` (
   PRIMARY KEY (`GradeID`),
   KEY `UserID_idx` (`UserID`),
   CONSTRAINT `UserID` FOREIGN KEY (`UserID`) REFERENCES `user` (`id`)
-) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
+) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -51,7 +51,7 @@ UNLOCK TABLES;
 
 DROP TABLE IF EXISTS `user`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
- SET character_set_client = utf8mb4 ;
+ SET character_set_client = utf8 ;
 CREATE TABLE `user` (
   `ID` int(11) NOT NULL AUTO_INCREMENT,
   `FirstName` varchar(45) DEFAULT NULL,
@@ -60,7 +60,7 @@ CREATE TABLE `user` (
   `Password` varchar(45) DEFAULT NULL,
   `LastLogin` datetime DEFAULT NULL,
   PRIMARY KEY (`ID`)
-) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
+) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
diff --git a/4 DB in Python/SQLite Demo/myinventory.db b/4 DB in Python/SQLite Demo/myinventory.db
diff --git a/4 DB in Python/SQLite Demo/vinventory.py b/4 DB in Python/SQLite Demo/vinventory.py
@@ -3,6 +3,7 @@
     For example, the changemade variable does not update once the program is started.
     So, if someone left the application open for a long time and made changes later, the data would not be accurate.
     '''
+debug = False
 import sqlite3
 #importing Error this way let's us refer to it by this name instead of sqlite3.Error
 from sqlite3 import Error 
@@ -89,7 +90,8 @@ def update_data():
        sql = "UPDATE vaccines set arrivaldate  = ? where id =  ?"
     elif (feature == "6"):
        sql = "UPDATE vaccines set expirationdate = ? where id =  ?"  
-        
+    if debug:
+        print("Update SQL is:",sql)    
     try:
         #if we call the connection execute method it invisibly creates a cursor for us
         conn.execute(sql, (update_value,update_ID))
@@ -127,7 +129,8 @@ def delete_data():
 now = datetime.datetime.now()
 
 if conn:
-    print ("Connected to database: ",conn)  
+    if debug:
+        print ("Connected to database: ",conn)  
 else:
     print("Error connecting to database.")
 
diff --git a/6 Web Page with Flask/basic page/.vscode/settings.json b/6 Web Page with Flask/basic page/.vscode/settings.json
@@ -0,0 +1,3 @@
+{
+    "python.pythonPath": "/usr/local/bin/python3"
+}
diff --git a/6 Web Page with Flask/basic page/static/css/main.css b/6 Web Page with Flask/basic page/static/css/main.css
@@ -2,7 +2,7 @@ body {
   margin: 0;
   padding: 0;
   font-family: "Helvetica Neue", Helvetica, Arial, sans-serif;
-  color: rgb(50, 77, 13);
+  color: rgb(107, 141, 58);
 }
 
 /*

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,3 @@`
	`1`	`+{`
	`2`	`+ "python.pythonPath": "/usr/local/bin/python3"`
	`3`	`+}`
Original file line number	Diff line number	Diff line change
`@@ -2,7 +2,7 @@ body {`
`2`	`2`	`margin: 0;`
`3`	`3`	`padding: 0;`
`4`	`4`	`font-family: "Helvetica Neue", Helvetica, Arial, sans-serif;`
`5`		`- color: rgb(50, 77, 13);`
	`5`	`+ color: rgb(107, 141, 58);`
`6`	`6`	`}`
`7`	`7`
`8`	`8`	`/*`