Skip to content

Posts...

Page 15 of 43

Select Rows Where Value from One Column Matches Other Column

November 23, 2016Categories: Software, Tutorial
TL;DR: Use a JOIN . I've got a table representing a tree, using two columns: and I want to select all children for parents whose CLASS_ID have a certain value (e.g. abcd ). The way I could do it was via a JOIN statement: This will: Perform a join where child.parent_prop_id = parent.prop_id…

Simulate UNION with BLOBs

November 21, 2016Category: Software
TL;DR : If you have BLOB s, you need to use UNION ALL . If you use UNION ALL , you need to partition off a criterion and select the first row. The other day I had to figure out how UNION works in Oracle, because we're retrofitting an application with extra features. Assuming I have 2 tables…

Use Git Bash as Integrated Terminal in VS Code

November 18, 2016Categories: Software, Tutorial
TL;DR: : Install windows git to get bash and add "C:\\Program Files\\Git\\bin\\bash.exe" to "terminal.integrated.shell.windows" in VS Code's user settings. As I'm trying my hand at developing a node application today, I'm getting frustrated by the Terminate batch job (Y/N) every time I need to…

Debug Javascript - Some Methods

November 17, 2016Category: Software
These days I'm trying to tweak a 3rd-party framework and I'm missing stuff sometimes (e.g. injected data). Below are some methods I've found useful when debugging the script. console.log - print all things Object inspection - see your object's content HTH,

Debug Javascript - Object Inspection

November 17, 2016Category: Software
Many times, you have objects where you may or may not know their content. If you're running in the browser, life is easy as you can pause the code and inspect the object. at command line is a bit more annoying. In this case, at least for the first run, you can execute something like: where obj is…

Debug Javascript - console.log

November 17, 2016Category: Software
This is the holy grail of debugging for me. It's old school, simple and effective. It works both in browser and from command line. My code looks like: You can make it fancier with debug levels (in if() statements or with your tiny library). I however tend to add/remove them progressively as I…

Pass Through a Corporate Proxy in Java

October 26, 2016Categories: Software, Tutorial
TL;DR: There's no easy way to create a proxy :) I've tried for a while to build a way to request something through a proxy, for testing an emulated android app. The solution came from Octavian who kindly provided me a snippet to run once per app lifetime. It tackles the problem from two fronts…

Get all Proposal Names from the Participant Portal

October 25, 2016Categories: Software, Tutorial
I've found out the participant portal for H2020 offers an API . This is quite neat as one can integrate with the data, e.g. by reading and listing the calls. I've written a proof of concept to list all calls from this and last years. First, we load the data in a JSON object: Then, we extract the…

Inject Proxy Settings in Selenium/Chrome

October 24, 2016Categories: Software, Tutorial
I have the following situation: I'm behind a corporate proxy and I need to run a test accessing an external website. To do this, I've picked up chrome/chromium as driver of choice. My current solution implies an authentication via plugin. The plugin The chrome plugin is essentially 2 files: a…

Move SQL Developer Data from the Roaming Profile in Windows

October 19, 2016Category: IT
TL;DR: : Set up IDE_USER_DIR . I have to keep my roaming profile on a diet and this means moving a bunch of default directories around. The latest victim is SQL Developer According to this post , the environment variable to be changed is IDE_USER_DIR . From the post: According to documentation…
PreviousNext

All tags