gitfvb

// get the size of associative arrays
$.assocArraySize = function(obj) {
  var size = 0, key;
  for (key in obj) {
    if (obj.hasOwnProperty(key)) size++;
  }
  return size;
};

gitfvb

/*

description:
  This function allows you to resize an html element
  when the screen size is changing (resize the browser or ).
  This allows you responsive design on some elements with
  fixed pixel sizes. This can be used e.g. for d3.js visualisations.

author: Florian von Bracht
email: f@dataflo.de

gitfvb

// count all the records first
db.getCollection('foo').find({}).count();

// save the the first 1000 entries ids to an array
removeIdsArray = db.getCollection('foo').find({})
    .limit(1000)
    .toArray()
    .map(function(doc) { return doc._id; });

gitfvb

SELECT
  e.entity_id
 ,e.email
 ,e.group_id
 ,e.store_id
 ,e.created_at
 ,e.updated_at
 ,e.is_active
 ,at_birthday.value as birthday
 ,at_firstname.value AS firstname

gitfvb

  //Load the request module
  var request = require('request');
  var content = request('<url with json content>', function (error, response, body) {
      if (!error && response.statusCode == 200) {
          //console.log(body); // Show the HTML for the Modulus homepage.
          //console.log(util.inspect(body, {showHidden: false, depth: null})); // show the full content

            // load the modules
            var bbj2j = require('jsonapter');

gitfvb

$exiftool = "C:\Users\Florian\Pictures\exiftool(-k).exe"
$source = "C:\Users\Florian\Pictures\k-r\DCIM1"
$destination = "C:\Users\Florian\Pictures\k-r\sorted"
$timestamp = [datetime]::UtcNow.ToString("yyyyMMddHHmmss")
$logfile = "copymedia_date$( $timestamp ).log"

<#
source: https://www.sno.phy.queensu.ca/~phil/exiftool/exiftool_pod.html

-ext    only files with this extension

gitfvb

This statement in a single query (e.g. in FastStats Designer) can attach other databases to the current one attach database C:\Apteco\Build\system\data\lookups.sqlite as lookup The ATTACH is not persistent in Designer

ATTACH DATABASE "C:\Apteco\Build\system\data\lookups.sqlite" AS lookup;
SELECT g.*, p.*
FROM geschaeftspartner g
INNER JOIN lookup.plz5 p ON g.plz = p.plz limit 10;

gitfvb

$ExtIPv4 = Get-NetIpAddress -InterfaceAlias "Ethernet 2" -AddressFamily "IPv4"
$source = "https://dyndns.strato.com/nic/update?hostname={host}&myip=$($ExtIPv4.IPAddress)"

$user = "{username}"
$pass = "{password}"

$secpasswd = ConvertTo-SecureString $pass -AsPlainText -Force
$credential = New-Object System.Management.Automation.PSCredential($user, $secpasswd)

Invoke-WebRequest -Uri $source -Credential $credential

gitfvb

# Things you might want to change

# options(papersize="a4")
# options(editor="notepad")
# options(pager="internal")

# set the default help type
# options(help_type="text")
  options(help_type="html")

gitfvb

# https://msdn.microsoft.com/en-us/library/dn894107.aspx

<#
.Synopsis
   This function uses the Google Maps API to Geocode an address.
.DESCRIPTION
   This function uses the Google Maps API to Geocode an address by sending a web request to the API and then processes the resulting XML file for the longitude & latitude.  The Google API has a threshold and when violated, you get an OVER_QUERY_LIMIT error based on the number of calls made per second and per day.  If the function encounters this error it will pause for 2 seconds and throw a warning.  If two subsequent calls fail, then the daily max call may have been reached and it will error out.
.EXAMPLE
PS C:\> "7171 Southwest Parkway, Austin, TX" | Get-GeoCode