Hi, Side note: Please sanitize the strings you use for the concatenation or use prepared statements, otherwise you could be vulnerable to SQL INJECTION attacks. Best regards, Esteban A. Maringolo 2017-09-13 17:34 GMT-03:00 Sven Van Caekenberghe <sven@stfx.eu>:
On 13 Sep 2017, at 19:44, Casimiro de Almeida Barreto <casimiro.barreto@gmail.com> wrote:
Hello,
Perhaps someone can help me with this problem: I'm saving a key pair in a mariadb/mysql table as follows:
str := 'INSERT INTO chaves_de_encriptacao (numero_funcional, chave_privada, chave_publica) '. str := str,'VALUES ('''. str := str, self personId leaId asString, ''', '''. str := str, self keyPair privateKey asAsn1DerBytes asByteArray hex, ''', '''. str := str, self keyPair publicKey asAsn1DerBytes asByteArray hex,''')'.
[ dbConnection execute: str ] on: Exception do: [ ^ false ].
And I'd like to recover the keys (SELECT * FROM chaves_de_encriptacao WHERE numero_funcional = 1010) and then reconvert in order to recover the original keys. Obviously I can do that by writting a parser that will get the hex and bring it back to binary but I'd like to avoid it.
Question is: is there a reverse for asByteArray hex?
Yes:
ByteArray readHexFrom: #[ 0 1 2 3 4 5 6 7 8 9 10 ] hex.
HTH,
Sven