Tim Cifuentes Vargas timcv

Google Sheets Script for Fetching Data from Supabase

This Google Sheets script fetches data from a Supabase database and writes the selected headers and data to the active sheet. The script first clears the sheet, writes the headers, then fetches the data from the Supabase API, and finally writes the data to the sheet.

Prerequisites

Make sure your Supabase Database RLS policy allows reads (you might need to tweak some RLS policies).

How to Use

Create a new Google Sheet or open an existing one.

	<?php

	namespace App\Http\Middleware;

	use Closure;
	use Illuminate\Support\Facades\URL;
	use Illuminate\Support\Str;

	class RestrictFromReferer
	{

	#!/usr/bin/env python3
	import socket
	import requests
	from subprocess import Popen, PIPE
	import json


	# These lines are examples only. They may be useful to compare what your remote sends. To capture the codes that your remote sends,
	# tail the OZW_Log.

	.ui-datepicker {
	background-color: #fff;
	border: 1px solid #66AFE9;
	border-radius: 4px;
	box-shadow: 0 0 8px rgba(102,175,233,.6);
	display: none;
	margin-top: 4px;
	padding: 10px;
	width: 240px;
	font-family: "Helvetica Neue",Helvetica,Arial,sans-serif;

	#include <ESP8266WiFi.h>
	#include <PubSubClient.h>
	#include <DHT.h>

	DHT dht(D5, DHT22);

	const char* ssid = "........";
	const char* password = "........";

	IPAddress mqttServer(192, 168, 1, 10);

	/* ======================================================================================
	//! -- On Demand Image Sizing --

	Experimental code for generating custom image sizes on demand.
	http://wordpress.stackexchange.com/a/124790

	From the author...
	"When an image is then requested in a particular size,
	which is not yet generated, it will be created only that once."
	====================================================================================== */

	function my_remove_wp_seo_meta_box() {
	remove_meta_box('wpseo_meta', YOUR_POST_TYPE_NAME_HERE, 'normal');
	}
	add_action('add_meta_boxes', 'my_remove_wp_seo_meta_box', 100);

	<?php
	function wc_get_product_by_sku($sku) {
	global $wpdb;

	if( defined( 'ICL_LANGUAGE_CODE' ) ){
	$product_id = $wpdb->get_var($wpdb->prepare("SELECT pm.post_id FROM ".$wpdb->postmeta." AS pm LEFT JOIN ".$wpdb->prefix."icl_translations AS tr ON pm.post_id = tr.element_id WHERE pm.meta_key='_sku' AND pm.meta_value='%s' AND tr.language_code = '".ICL_LANGUAGE_CODE."'", $sku));
	} else {
	$product_id = $wpdb->get_var($wpdb->prepare("SELECT post_id FROM $wpdb->postmeta WHERE meta_key='_sku' AND meta_value='%s' LIMIT 1", $sku));
	}

	<?php

	$validator = Validator::make(Input::all(),
	[
	'name' => 'required',
	'city' => 'required',
	'address' => 'required',
	'country' => 'required',
	'site' => 'required',
	'phone' => 'required',