cattaka

/*
   This example code is in the Public Domain (or CC0 licensed, at your option.)
   Unless required by applicable law or agreed to in writing, this
   software is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR
   CONDITIONS OF ANY KIND, either express or implied.
*/

/****************************************************************************
*
* This file is for gatt server. It can send adv data, be connected by client.

cattaka

DROP FUNCTION IF EXISTS shrink_db;
CREATE FUNCTION shrink_db() RETURNS VOID AS $$
DECLARE
    r RECORD;
BEGIN
    DROP TABLE IF EXISTS work1;
    CREATE TEMP TABLE work1 AS SELECT
           CONCAT('ALTER TABLE ', nsp.nspname, '.', rel.relname, ' DROP CONSTRAINT "', con.conname, '";') delete_query,
           CONCAT('ALTER TABLE ', nsp.nspname, '.', rel.relname, ' ADD CONSTRAINT ', con.conname, ' ', pg_get_constraintdef(con.oid), ' ON DELETE CASCADE;') create_cascade,
           CONCAT('ALTER TABLE ', nsp.nspname, '.', rel.relname, ' ADD CONSTRAINT ', con.conname, ' ', pg_get_constraintdef(con.oid)) create_original,

cattaka

#include <Arduino.h>
#include <M5Stack.h>
#include <WiFi.h>
#include <HTTPClient.h>

#define CYAN 0x07FF
#define ORANGE 0xFDA0
#define LIGHTGRAY 0xC618
#define FW 6
#define FH 8

cattaka

function doGet(e) {
  var now = new Date();
  var sheet = getSheetOfDate(now);
  var rawWeightFrom = e && e.parameter && e.parameter.raw_weight_from;
  var rawWeightTo = e && e.parameter && e.parameter.raw_weight_to;
  var etc = e && e.parameter && e.parameter.etc;
  
  var response;
  if (rawWeightTo) {
    // https://stackoverflow.com/a/17637159

cattaka

#include<BLEDevice.h>
#include<BLEHIDDevice.h>

BLEServer* gBLEServer;
BLEHIDDevice* gBLEHIDDevice;
BLECharacteristic* gBLECharacteristic;


class MyServerCallbacks: public BLEServerCallbacks {
  public:

cattaka

WITH SRC AS (
  SELECT
    _TABLE_SUFFIX ldate,
    *
  FROM `hoge.analytics_123456789.events_intraday_*`
--  WHERE _TABLE_SUFFIX = '2019-07-25'
),
TD_COMPAT AS (

cattaka

--- ./mutter-3.30.2_orig/src/core/meta-workspace-manager.c	2019-05-22 05:46:37.667434418 +0900
+++ ./mutter-3.30.2/src/core/meta-workspace-manager.c	2019-05-22 05:46:46.859495121 +0900
@@ -200,6 +200,8 @@ meta_workspace_manager_new (MetaDisplay
    * variable values in update_num_workspaces ()
    * This can be overriden using _NET_DESKTOP_LAYOUT in
    * meta_x11_display_new (), if it's specified */
+  workspace_manager->workspace_layout_overridden = FALSE;
+
   meta_workspace_manager_update_workspace_layout (workspace_manager,
                                                   META_DISPLAY_TOPLEFT,

cattaka

{
    "version": 2,
    "name": "My Custom",
    "inherits": "fdmprinter",
    "metadata": {
        "visible": true,
        "author": "Ultimaker",
        "manufacturer": "Custom",
        "category": "Custom",
        "file_formats": "text/x-gcode",

cattaka

#!/bin/bash

NUM=$1

if [[ ! "$NUM" =~ ^[0-9]+$ ]] || [ "$NUM" -le 0 ]; then
	echo "Usage: launch-emurators.sh <num>"
	exit
fi

EMULATOR_PIDS=""

cattaka

CREATE TEMPORARY FUNCTION pullFromQueryParams(s string, key string)
RETURNS string
LANGUAGE js AS """
// function pullFromQueryParams(s, key) {
	if (!s) return null;
	var ts = s.split("&");
	for (var i = 0;i<ts.length;i++) {
		var vs = ts[i].split("=",2);
		if (vs[0] == key && vs.length >= 2) {
			return decodeURIComponent(vs[1]);