[Zope3-checkins] CVS: zopeproducts/sqlauth/tests - test_sqlusers.py:1.2

[Albertas Agejevas]

Update of /cvs-repository/zopeproducts/sqlauth/tests
In directory cvs.zope.org:/tmp/cvs-serv12221/tests

Modified Files:
	test_sqlusers.py 
Log Message:
Updated the SQL to the consistent style in the tests as well.


=== zopeproducts/sqlauth/tests/test_sqlusers.py 1.1 => 1.2 ===
--- zopeproducts/sqlauth/tests/test_sqlusers.py:1.1	Fri Jul 18 09:31:16 2003
+++ zopeproducts/sqlauth/tests/test_sqlusers.py	Tue Jul 22 04:44:11 2003
@@ -54,11 +54,11 @@
         self._operation = operation
         self.result = (
             {'SELECT login, password, title, description'
-             ' from "users" where id = 42':
+             ' FROM "users" WHERE id = 42':
              (('login', 'passwd', 'title', 'descr'),),
 
              'SELECT login, password, title, description'
-             ' from "users" where id = 43':
+             ' FROM "users" WHERE id = 43':
              (('jim', '5en6G6MezRroT3XKqkdPOmY/BfQ=', # password 'secret'
                'The Pope', 'descr'),),
 
@@ -78,23 +78,23 @@
              ' \'5en6G6MezRroT3XKqkdPOmY/BfQ=\' WHERE id = 42':
              (),
 
-             'SELECT id FROM "users" where login LIKE \'%foo%\'':
+             'SELECT id FROM "users" WHERE login LIKE \'%foo%\'':
              ((3,), (4,), (2,)),
 
              'SELECT login, password, title, description'
-             ' from "users" where id = 2':
+             ' FROM "users" WHERE id = 2':
              (('foo2', 'passwd', 'title', 'descr'),),
 
              'SELECT login, password, title, description'
-             ' from "users" where id = 3':
+             ' FROM "users" WHERE id = 3':
              (('foo3', 'passwd', 'title', 'descr'),),
 
              'SELECT login, password, title, description'
-             ' from "users" where id = 4':
+             ' FROM "users" WHERE id = 4':
              (('foo4', 'passwd', 'title', 'descr'),),
 
              'SELECT login, password, title, description'
-             ' from "users" where id = 22':
+             ' FROM "users" WHERE id = 22':
              (),
 
              'SELECT id FROM "users" WHERE login = \'steve\'':