mgottholsen

#!/usr/bin/env python3

import aioesphomeapi
import asyncio

async def main():
    loop = asyncio.get_running_loop()
    cli = aioesphomeapi.APIClient(loop, "HOST-OR-IP", 6053, "API-PASSWORD-OR_EMPTY")

    await cli.connect(login=True)

mgottholsen

import requests

import urllib
import requests
import json
import random

"""
  here is a wrapper for the *unreleased* electric objects API
  Built by Harper Reed (harper@nata2.org) - @harper

mgottholsen

This example loads a CartoDB layer using a crazy SQL from a small variation of this awesome Stack Overflow response. Note the use of CSS style tags for the CartoCSS to allow easy editing.

The uncompressed (and not perfect!) version of the SQL to draw the Voronoi diagram is:

WITH 
    Sample AS (
      SELECT st_setsrid(st_union(the_geom),0) as geom 
      FROM registro_centros_nz WHERE spanish = 1
    ),

mgottholsen

#!/usr/bin/env python
# encoding: utf-8
"""
make_table.py
                      
Given a CSV file with a header row, and at-least one row of data,
output a SQL `CREATE TABLE` statement by guessing the data type of the columns.

Pradeep Gowda <pradeep@btbytes.com>
License: Public Domain