how to test (junit4) this mysql funciton?

[miguel lisboa]

using eclipse, i'm testing encryption password input

my sql from eclipse:

  
	String sqlInsert = "INSERT INTO teste (user, pass) VALUES (abc, SHA1(123456))";

	String sqlSelect =  "SELECT SHA1(pass) FROM teste where user = 'abc'";
  

the test:

 
	public void testEncriptacao() {

		Jdbc jdbc = new Jdbc("x");

		try {

			jdbc.executa(sqlElimina);

			jdbc.executa(sqlInsert);

			ResultSet rs = jdbc.executaQuery(sqlSelect);
	
		while (rs.next()) {

			String pp = rs.getString(1);
			
			assertEquals("SHA1(123456)","SHA1(pp)" );
				
			assertEquals("SHA1(123456)","hmm");

			} 
//...

   

what happens is that java complaints with:
SHA1(pp)

because if i use quotes, its a plain string, and if i dont, says method SHA1 isnt recognized

how can i solve this?

[Jeanne Boyarsky]

Miguel,
It sounds like you are trying to run a database encryption method. Can you pass the value to the database and do the check there. For example:

SELECT count(*) FROM table where SHA1(xxxx) == SHA1(yyy)

Or whatever you are trying to assert?

[miguel lisboa]

Jeanne Boyarsky wrote:Miguel,
It sounds like you are trying to run a database encryption method. Can you pass the value to the database and do the check there. For example:

SELECT count(*) FROM table where SHA1(xxxx) == SHA1(yyy)

Or whatever you are trying to assert?

yes, i'm trying to do it

your idea sounds great indeed, but yet i'm quite puzzled with your sql:

lets suppose i call the plain password 123456

now, i can retrieve the SHA1 of that password from the database:

String pp = rs.getString(1); 

please help me now: how i write the sql you suggest, using my data?

note:i tried several combinations inspired on your sql but allways got a zero count

thanks in advance

[miguel lisboa]

i cleared this post, since i posted twice

[miguel lisboa]

case solved!

thanks, Jeanne

here´s what i did:

String sqlSHA1 = "SELECT count(*) FROM teste where pass = SHA1(123456)";

//..

ResultSet rs = jdbc.executaQuery(sqlSHA1);
	
while (rs.next()) {

 int pp = count.getInt(1);

 assertEquals(pp,1);

} 
    

anyway i'm a tiny bit afraid i'm comparing one thing with the very same thing ...