Monthly Archive: August 2020

0

Extracting table and column names from SQL query

(Not original article) sql-metadata is a Python library that uses a tokenized query returned by python-sqlparse and generates query metadata. This metadata can return column and table names from your supplied SQL query. Here are a couple of example from the sql-metadata github readme:...

0

MacOS tips

Hide a user account in MacOS https://support.apple.com/en-us/HT203998 https://www.reddit.com/r/macsysadmin/comments/emxph7/catalina_create_a_hidden_user/ https://github.com/gregneagle/pycreateuserpkg Creating user account https://apple.stackexchange.com/questions/226073/how-do-i-create-user-accounts-from-the-terminal-in-mac-os-x-10-11 https://sterlingit.com.au/how-to-create-a-user-or-admin-user-in-osx-apple-mac-via-terminal-commands-in-9-simple-steps/ https://mackeeper.com/blog/post/356-using-various-types-of-user-accounts-on-mac/   Find files created or modified by an installer http://hints.macworld.com/article.php?story=20091223115101622   Related posts: Super charge bash with these bash_profile tips Hadoop mapreduce not working on...

0

JMeter test plan automation

This automation script runs JMeter test plan with multiple input files specified by JMeter. It also has ability to send email before working on an input file and once the input file processing is complete. This is a working attempt...