jbaranski

# Download H2 driver
mvn org.apache.maven.plugins:maven-dependency-plugin:2.8:get -Dartifact=com.h2database:h2:1.4.200

Full documentation: https://maven.apache.org/plugins/maven-dependency-plugin/get-mojo.html

jbaranski

I needed to password protect an existing H2 database. I wanted to do two things:

• Delete existing ADMIN user, who had no user name or password:

DROP USER "";

• Create a new user, add a password for the new user:

CREATE USER IF NOT EXISTS example PASSWORD 'example password' ADMIN;

jbaranski

/* tslint:disable */

import { AutocompleteCandidate } from '../autocomplete/candidate';

// Source code token from below link
// https://gist.github.com/tpae/72e1c54471e88b689f85ad2b3940a8f0
// @MODIFIED has been added where modifications have been made
//
// Trie.js - super simple JS implementation
// https://en.wikipedia.org/wiki/Trie

jbaranski

// assume you have a member on the component like dataSource1: MatTableDataSource<any>; and dataSource2: MatTableDataSource<any>; that 
// are the datasources for the two tables
@ViewChildren(MatSort) set matSort(matSortList: QueryList<MatSort>) {
    const ref = this;
    matSortList.forEach((matSort: any, index: number) => {
      const dataSource = ref['dataSource' + (index + 1)];
      // https://material.angular.io/components/table/api
      // to see about sortingDataAccessor
      dataSource.sortingDataAccessor = (item: any, property: string) => {
        if (cond1) {

jbaranski

"""
    Oracle database connection wrapper
    @author: jbaranski
"""
import cx_Oracle


class OracleDB:
    """
        Usage:

jbaranski

# nexus 2.x
# Assuming you run this command against the directory the jar sits in
#
# r - repository
# hasPom - whether you are supplying the pom or you want one generated. If generated g, a, v, p, and c are not needed
# e - extension
# g - group id
# a - artifact id
# v - version
# p - packaging