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

jbaranski

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


class OracleDB:
    """
        Usage:

jbaranski

Here are two examples of how to define a composite primary key for some table using Liquibase.

• Add the composite primary key up front during table construction (preferred).

  <changeSet id="1">
    <createTable tableName="some_table">
      <column name="id_1" type="varchar_ignorecase">
        <constraints nullable="false" primaryKey="true" primaryKeyName="PK_SOME_TABLE"></constraints>
 

jbaranski

If you have multiple SSH keys generated for different purposes (one for GitHub, one for server administration, etc...) you can specify which private key to use via config.

In ~/.ssh/config you may have the following:

host github.com
 HostName github.com
 IdentityFile ~/.ssh/id_rsa.github
 User <your PC user name (not GitHub user name)>

jbaranski

The following snippet is how to alias a task name in Gradle:

build.gradle

    // You can now run "gradle alias" and it would be equivalent to running "gradle taskToAlias"
    task alias {
        dependsOn allprojects.collect { proj ->
            proj.tasks.matching {
                it.name == 'taskToAlias'
 }

jbaranski

Here are the steps needed to run a self hosted Open Street Map server (using Docker):

1. Download desired pbf files (like south-carolina-latest.osm.pbf) from https://download.geofabrik.de or just use the following empty planet below:

   
     <?xml version='1.0' encoding='UTF-8'?>
     <osm version="0.6" generator="osmconvert 0.8.8" timestamp="2019-10-23T20:18:02Z">
       <bounds minlat="42.4276" minlon="1.412368" maxlat="42.65717" maxlon="1.787481"/>
     </osm>
   

jbaranski

Here are the steps needed to convert an image (like JPG or TIF) to MBTiles using GDAL:

1. Download and install GDAL (https://gdal.org/, https://anaconda.org/conda-forge/gdal):

      conda install -c conda-forge gdal
   

   Installing GDAL is kind of a pain in the ass, especially on Windows. I'm assuming you'll be able to work out whatever issues you run into here.

2. Download example jpg and tif map images we can work with:

   • http://www.radcyberzine.com/xglobe/index.html#maps - See Super-hi-res maps section, download one of the jpg files.

jbaranski

Open Port 80 Oracle Cloud Compute Instance (CentOS)

FYI This was harder than it needed to be:

1. Looking at your instance info, find VNIC section, click "Public Subnet".
2. Click on your security list.
3. Add a new entry with the following options:

• "Stateless" = No, "Source" = 0.0.0.0/0, "IP Protocol" = TCP, "Source Port Range" = All, "Destination Port Range" = 80

4. SSH to your instance.
5. While SSH'ed in your instance, run command firewall-cmd --permanent --add-service=http.
6. While SSH'ed in your instance, run command firewall-cmd --reload.
7. Now start Apache, NGINX, or whatever server you need to on port 80. You can now access from the internet.

jbaranski

ffmpeg record screen on Mac M1 chip via command line

1. Install ffmpeg.

brew install ffmpeg

2. Figure out which device to use.

ffmpeg -f avfoundation -list_devices true -i ""

Ouput will look like:

jbaranski

import requests
import json
import time

if __name__ == '__main__':
    db = {}
    token = requests.get('https://opentdb.com/api_token.php?command=request').json()['token']
    while True:
        r = requests.get(f'https://opentdb.com/api.php?amount=50&token={token}')
        r_json = r.json()