Monday, August 3, 2015

Generate Golang struct (model) from Postgres tables

A handy Postgres SQL statement to generate Golang models (structs) for you.


WITH models AS (
  WITH data AS (
    SELECT
        replace(initcap(table_name::text), '_', '') table_name,
        replace(initcap(column_name::text), '_', '') column_name,
        CASE data_type
        WHEN 'timestamp without time zone' THEN 'time.Time'
        WHEN 'timestamp with time zone' THEN 'time.Time'
        WHEN 'boolean' THEN 'bool'
        -- add your own type converters as needed or it will default to 'string'
        ELSE 'string'
        END AS type_info,
        '`json:"' || column_name ||'"`' AS annotation    
    FROM information_schema.columns
    WHERE table_schema IN ('dvs_app', 'dvs_system')
    ORDER BY table_schema, table_name, ordinal_position
  )
    SELECT table_name, STRING_AGG(E'\t' || column_name || E'\t' || type_info || E'\t' || annotation, E'\n') fields
    FROM data
    GROUP BY table_name
)
SELECT 'type ' || table_name || E' struct {\n' || fields || E'\n}' models
FROM models ORDER BY 1

Tuesday, June 30, 2015

Handy PowerShell Scripts

(because I don't want to add another GitHub repo)


Invert mouse scrolling (from http://superuser.com/questions/310681/inverting-direction-of-mouse-scroll-wheel)

Get-ItemProperty HKLM:\SYSTEM\CurrentControlSet\Enum\HID\*\*\Device` Parameters FlipFlopWheel -EA 0 | ForEach-Object { Set-ItemProperty $_.PSPath FlipFlopWheel 1 }


Saturday, December 20, 2014

Anarchic Development Efforts

Nokia, once the leader in mobile technologies really messed up big. They were poised (perhaps) to be where Apple is today with the iPad and the iPhone however they had various deeply seeded problems which ultimately caused the demise of their R&D efforts. This interesting article is a great read for technology project managers. One of the most interesting things I found was the mention of "anarchic development efforts" at Nokia which was a major factor leading to ultimate project failure. By contrast the leadership culture at Apple has been very disciplined and focused under the collaborative-dictatorship of Steve Jobs. On a personal note, this is why, when I am heading up development teams, I have no time for "anarchic development efforts". Developers that don't get with the program must be let go or the entire project will be in jeopardy. I think this article highlights a sterling example of issue.

Saturday, December 6, 2014

Installing Linux 64bit driver for eToken USB

If needed install, opensc and pcsc-lite
yum install opensc pcsc-lite

Download the driver, unzip and install
wget http://download.fh-swf.de/dvz/software/eToken/Linux/Software/SafeNetAuthenticationClient_Linux_8_1.1.zip
unzip SafeNetAuthenticationClient_Linux_8_1.1.zip
cd SAC\ 8.1\ Linux/x86_64/
unzip SAC_8_1_0_4_Linux_RPM_64.zip
cd SAC_8_1_0_4_Linux_RPM_64/Signed\ installation\ scripts/
chmod +x signed-install_SafenetAuthenticationClient-8.1.0-4.x86_64.rpm.sh
cp ../RPM/SafenetAuthenticationClient-8.1.0-4.x86_64.rpm .
./signed-install_SafenetAuthenticationClient-8.1.0-4.x86_64.rpm.sh

You should see the following (choose 1 for English):
Searching SafenetAuthenticationClient-8.1.0-4.x86_64.rpm... OK
Searching RPM-GPG-KEY-SafenetAuthenticationClient... OK
Deleting existing key
Importing key: RPM-GPG-KEY-SafenetAuthenticationClient
Starting installation
########################################### [100%]
########################################### [100%]
Adding Token security provider......done.
Starting PC/SC smart card daemon (pcscd): [  OK  ]
SafeNet Authentication Client installation completed.
Choose Client Language:
------------------------
1. English.....(En)
2. Spanish.....(Es)
3. French......(Fr)
4. Italian.....(It)
5. Japanese....(Jp)
6. Korean......(Ko)
7. Russian.....(Ru)
8. Chinese.....(Zh)
9. Portoguese..(Pt)
10. Thai.......(Th)
Your choice [1-10] -->1
Installing Language code En.
Done!

Check
opensc-tool --list-readers

The result should be similar to:
# Detected readers (pcsc)
Nr.  Card  Features  Name
0    Yes             AKS ifdh 00 00

Find out which slot the device is in:
pkcs11-tool --module /usr/lib64/libeToken.so -L

You should see something to the effect of:
Available slots:
Slot 0 (0x0): AKS xxxx 00 00
 token label:   my label
 token manuf:   SafeNet, Inc.
 token model:   eToken
 token flags:   rng, login required, PIN initialized, token initialized, other flags=0x200
 serial num  :  xxxxxxx
Slot 1 (0x1): 
  (empty)
Slot 2 (0x2): 
  (empty)
Slot 3 (0x3): 
  (empty)
Slot 4 (0x4): 
  (empty)
Slot 5 (0x5): 
  (empty)
 
 
 
----------------- 
Acknowledgements: 
"user4668" for showing how to see the used slots http://bit.ly/1w2dUT8
 
Other Sources for the SAC: 
http://www.digicert.com/util/SafeNetAuthenticationClient-610-011815-002_SAC_Linux_v8.1.zip
http://www.digicert.com/util/SafeNetAuthenticationClient.8.2.27.0.dmg 

Tuesday, August 12, 2014

Installing MS fonts into Centos for converting DOCX files to PDF using DOCX4J


a)  Install MS TT Fonts using information here:


b)  If you need font mapping you can setup a font.properties file. I copied the one on my Mac, from
 /Library/Java/Home/lib/fontconfig.properties.src
to
 /usr/lib/jvm/java-1.7.0-openjdk-1.7.0.51.x86_64/lib/font.properties
.. on my Centos development box .



Notes:
After installing the MS fonts, it must add a file to the JDK lib as (the path will vary based on whatever JVM you are using):
/usr/lib/jvm/java-1.7.0-openjdk-1.7.0.51.x86_64/lib/msttcorefonts-2.5-1.spec

The reason for renaming fontconfig.properties.src to font.properties, is found here:
http://docs.oracle.com/javase/8/docs/technotes/guides/intl/fontconfig.html

Remember to restart any Java app that's running and needs to find the newly installed fonts.

Saturday, July 5, 2014

Generating certs for testing PDF signing

Run the following as root:

openssl genrsa -out ca.key 2048
openssl req -new -key ca.key -out ca.csr
openssl x509 -req -days 365 -in ca.csr -signkey ca.key -out ca.crt
openssl pkcs12 -export -in ca.crt -inkey ca.key -name ca -passout pass:password -out ca.pfx

Wednesday, June 18, 2014

Good to know: PostgreSQL records to single JSON string

To convert a set of results to a single JSON string, use:

SELECT
ARRAY_TO_JSON(ARRAY_AGG(ROW_TO_JSON(ROW)))
as DAT FROM (
     [ your query here ]
) ROW;

Tip: In the query, if you specify field names or table.*, you will not get an object hence the JSON will not have your schema sub grouped by object name. i.e.

SELECT
ARRAY_TO_JSON(ARRAY_AGG(ROW_TO_JSON(ROW)))
as DAT FROM (
     SELECT mytable WHERE [ ... ]
) ROW;

 ... is not the same as ...

SELECT
ARRAY_TO_JSON(ARRAY_AGG(ROW_TO_JSON(ROW)))
as DAT FROM (
     SELECT mytable.* WHERE [ ... ]
) ROW;



Kudos: http://hashrocket.com/blog/posts/faster-json-generation-with-postgresql