We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
1 parent da85752 commit 5d80064Copy full SHA for 5d80064
1 file changed
tests/sqltests.py
@@ -1,8 +1,10 @@
1
-from cs50.sql import SQL
+import logging
2
import sys
3
import unittest
4
import warnings
5
6
+from cs50.sql import SQL
7
+
8
class SQLTests(unittest.TestCase):
9
def multi_inserts_enabled(self):
10
return True
@@ -15,11 +17,6 @@ def test_delete_returns_affected_rows(self):
15
17
]
16
18
for row in rows:
19
self.db.execute("INSERT INTO cs50(val) VALUES(:val);", val=row["val"])
-
- print(self.db.execute("DELETE FROM cs50 WHERE id = :id", id=rows[0]["id"]))
20
- print(self.db.execute("SELECT * FROM cs50"))
21
- return
22
23
self.assertEqual(self.db.execute("DELETE FROM cs50 WHERE id = :id", id=rows[0]["id"]), 1)
24
self.assertEqual(self.db.execute("DELETE FROM cs50 WHERE id = :a or id = :b", a=rows[1]["id"], b=rows[2]["id"]), 2)
25
self.assertEqual(self.db.execute("DELETE FROM cs50 WHERE id = -50"), 0)
@@ -122,5 +119,5 @@ def multi_inserts_enabled(self):
122
119
unittest.TestLoader().loadTestsFromTestCase(MySQLTests),
123
120
unittest.TestLoader().loadTestsFromTestCase(PostgresTests)
124
121
])
125
+ logging.getLogger("cs50.sql").disabled = True
126
sys.exit(not unittest.TextTestRunner(verbosity=2).run(suite).wasSuccessful())
0 commit comments