1257 self.execute, "Any P WHERE X is CWUser, X login 'bob', X upassword P") |
1257 self.execute, "Any P WHERE X is CWUser, X login 'bob', X upassword P") |
1258 cursor = self.cnxset['system'] |
1258 cursor = self.cnxset['system'] |
1259 cursor.execute("SELECT %supassword from %sCWUser WHERE %slogin='bob'" |
1259 cursor.execute("SELECT %supassword from %sCWUser WHERE %slogin='bob'" |
1260 % (SQL_PREFIX, SQL_PREFIX, SQL_PREFIX)) |
1260 % (SQL_PREFIX, SQL_PREFIX, SQL_PREFIX)) |
1261 passwd = str(cursor.fetchone()[0]) |
1261 passwd = str(cursor.fetchone()[0]) |
1262 self.assertEqual(passwd, crypt_password('toto', passwd[:2])) |
1262 self.assertEqual(passwd, crypt_password('toto', passwd)) |
1263 rset = self.execute("Any X WHERE X is CWUser, X login 'bob', X upassword %(pwd)s", |
1263 rset = self.execute("Any X WHERE X is CWUser, X login 'bob', X upassword %(pwd)s", |
1264 {'pwd': Binary(passwd)}) |
1264 {'pwd': Binary(passwd)}) |
1265 self.assertEqual(len(rset.rows), 1) |
1265 self.assertEqual(len(rset.rows), 1) |
1266 self.assertEqual(rset.description, [('CWUser',)]) |
1266 self.assertEqual(rset.description, [('CWUser',)]) |
1267 |
1267 |
1272 {'pwd': 'tutu'}) |
1272 {'pwd': 'tutu'}) |
1273 cursor = self.cnxset['system'] |
1273 cursor = self.cnxset['system'] |
1274 cursor.execute("SELECT %supassword from %sCWUser WHERE %slogin='bob'" |
1274 cursor.execute("SELECT %supassword from %sCWUser WHERE %slogin='bob'" |
1275 % (SQL_PREFIX, SQL_PREFIX, SQL_PREFIX)) |
1275 % (SQL_PREFIX, SQL_PREFIX, SQL_PREFIX)) |
1276 passwd = str(cursor.fetchone()[0]) |
1276 passwd = str(cursor.fetchone()[0]) |
1277 self.assertEqual(passwd, crypt_password('tutu', passwd[:2])) |
1277 self.assertEqual(passwd, crypt_password('tutu', passwd)) |
1278 rset = self.execute("Any X WHERE X is CWUser, X login 'bob', X upassword %(pwd)s", |
1278 rset = self.execute("Any X WHERE X is CWUser, X login 'bob', X upassword %(pwd)s", |
1279 {'pwd': Binary(passwd)}) |
1279 {'pwd': Binary(passwd)}) |
1280 self.assertEqual(len(rset.rows), 1) |
1280 self.assertEqual(len(rset.rows), 1) |
1281 self.assertEqual(rset.description, [('CWUser',)]) |
1281 self.assertEqual(rset.description, [('CWUser',)]) |
1282 |
1282 |