gargomoma

## Replace [STATION_ID] with your station ID
## you can retrieve it from the URL while checking your station status at tinygs.com
rest:
  - resource: "https://api.tinygs.com/v1/station/[STATION_ID]"
    scan_interval: 300
    sensor:
      - name: "TinyGs Satellite"
        value_template: "{{ value_json.satellite }}"

      - name: "TinyGs ConfirmedPackets"

gargomoma

<?xml version="1.0" encoding="UTF-8"?>
<manifest>
  <!-- GitLab -->
  <remote name="gl" fetch="https://gitlab.com/" /> 

  <!--android_device_google_gsXXX-->
  <project path="device/google/gs-common" remote="aosp" name="device/google/gs-common" />
  <project path="device/google/gs201" remote="statix" name="android_device_google_gs201" revision="tm-qpr2" />
  <project path="device/google/gs201-sepolicy" remote="statix" name="android_device_google_gs201-sepolicy" revision="tm-qpr2" />
  <project path="device/google/gs101" remote="statix" name="android_device_google_gs101" revision="tm-qpr2" />

gargomoma

#   Copyright 2014 Dan Krause
#
#   Licensed under the Apache License, Version 2.0 (the "License");
#   you may not use this file except in compliance with the License.
#   You may obtain a copy of the License at
#
#       http://www.apache.org/licenses/LICENSE-2.0
#
#   Unless required by applicable law or agreed to in writing, software
#   distributed under the License is distributed on an "AS IS" BASIS,

gargomoma

function extractParam(url,param){
  var regex = new RegExp(`(?<=${param}=)[^&]+`);
  var match = url.match(regex);
  if (match) {
    const result = match[0];
    return result
  }
}

gargomoma

/////////////////////////////////////////////////////////////////////////////////
//setBQDataSource is a GappS function to build/update your Big Query connections.
//Ideal if you need to update or create multiple connections, making mantainers life easier.
//Imagination, life is your creation!
/////////////////////////////////////////////////////////////////////////////////
function setBQDataSource(ProjID,Query,SheetName,refreshAllLinkedObjects=true) {
  SpreadsheetApp.enableBigQueryExecution(); //.enableAllDataSourcesExecution();
  ///////////////
  var ss = SpreadsheetApp.getActive();
  ///////////////

gargomoma

##
##Coming from your friendly neighborhood Spider-Man!
##
def chunkArray(ArrObj, length):
    '''Splits a list on a list of lists given a lenght'''
    return list(ArrObj[0+i:length+i] for i in range(0, len(ArrObj), length))

def where_in_builder(list_of_elements, var_to_filter,split_by=1_000,is_str=True,return_as_str=True):
    '''Builds a IN(...) clause from a list, user can select either a single string or a list of IN(...) for each chunk'''        
    quotation = "'" if is_str else ""

gargomoma

###My essential imports and functions to play with Selenium on Python

import os
import sys
import threading
import time
import datetime as dt

from selenium import webdriver
from selenium.webdriver.common.by import By

gargomoma

#Based on: https://github.com/samlopezf/google-drive-api-tutorial/blob/master/google-drive-api-tutorial-project/main.py
from __future__ import print_function
import os, io
import pickle
import os.path
from googleapiclient.discovery import build
from google_auth_oauthlib.flow import InstalledAppFlow
from google.auth.transport.requests import Request
from apiclient.http import MediaFileUpload, MediaIoBaseDownload

gargomoma

/* In case of inconsistencies - Check:
https://stackoverflow.com/questions/11870304/google-apps-script-geteventsforday-returns-invalid-recurring-events
*/ 
function EventsToday() {
var user = Session.getActiveUser().getEmail();  /*The mail will be sent to the user running the script*/
var startOfDay = new Date();
var events = CalendarApp.getDefaultCalendar().getEventsForDay(startOfDay);
var evlist = 'Hey!! These are the events you have for today<br>';
Logger.log('Number of events: ' + events.length);
  

gargomoma

/*
HOW IT WORKS??
https://jeffreyeverhart.com/2016/02/24/using-google-sheet-and-google-apps-script-to-work-with-apis/
https://codepen.io/ChynoDeluxe/pen/WGQzWW
*/
function getGIF() {
	// Giphy API defaults
	const giphy = {
		baseURL: "https://api.giphy.com/v1/gifs/",
		key: "APIKEYHERE",