what is my IP ?

dig +short myip.opendns.com @resolver1.opendns.com
.
.

AES encryption

I cannot run queries using encryption from MySQL workbench. I need to run them from the mysql console.

SELECT id,AES_DECRYPT(firstname,UNHEX(SHA2('key',512))),AES_DECRYPT(lastname,UNHEX(SHA2('key',512))),AES_DECRYPT(email,UNHEX(SHA2('key',512))),AES_DECRYPT(password,UNHEX(SHA2('key',512))) FROM user WHERE     AES_DECRYPT(lastname,UNHEX(SHA2('key',512))) LIKE '%lee%';

mysql -h 127.0.0.1 -u root -pXXXX -e "SET block_encryption_mode = 'aes-128-cbc';SET @enc_key='mywhateverkey';SET @bytes='0000000000000000';SELECT g.id,g.flag,AES_DECRYPT(FROM_BASE64(gc.firstname), @ENC_KEY, @BYTES) FROM guest AS g, guest_capa AS gc;" app_v2_e > i9011.db

pytest

pytest tests/test_api_extract.py::TestApi::test_db_source

.

wikipedia

https://en.wikipedia.org/?curid=29922

https://en.wikipedia.org/w/api.php?action=query&generator=search&gsrsearch=jefferson&srprop=size|wordcount|timestamp|snippet&prop=info&inprop=url

Click on "Page information" on the left column to get the wikipedia page ID.

spyder python editor

spyder installed through anaconda

autocompletion  works in the spyder console ( )
but doesn't work totally in the editor part  ( )

https://stackoverflow.com/questions/42777430/why-autocompletion-options-in-spyder-3-1-are-not-fully-working-in-the-editor/42789884#42789884

https://pythonhosted.org/spyder/overview.html

--------- to have autocompletion work with Python3 on Mac (anaconda install)

pip install rope_py3k

.

jackson

JSON parser

codehaus   Jackson 1
fasterxml  Jackson 2

Solr 6 and above

• if you want to use a static schema.xml, add this in your solrconfig

< schemaFactory class="ClassicIndexSchemaFactory"/ >

•