Mark Simonds simonds

## snippets.js
// Source: https://medium.com/dailyjs/13-javascript-one-liners-thatll-make-you-look-like-a-pro-29a27b6f51cb

const randomBoolean = () => Math.random() >= 0.5;
// randomBoolean() == true || false (a 50/50 change on returning true of false)

const isWeekday = (date) => date.getDay() % 6 !== 0;
// isWeekday(new Date(2021, 0, 11)) == true

const reverse = str => str.split('').reverse().join('');
// reverse('hello world') == 'dlrow olleh'

## Blockstack Proof #3
Verifying my Blockstack ID is secured with the address 1FLudoN99abz3cdd6MJuAkcgX9NkkSySg8 https://explorer.blockstack.org/address/1FLudoN99abz3cdd6MJuAkcgX9NkkSySg8

## zipcode.html
<!DOCTYPE html>
<html>
  <head>
  <title>Zipcode Lookup Demo</title>
  <script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/1.12.0/jquery.js"></script>
  <style>
  input, label, select {
    display: block;
    width: 100%;
    margin: 0;

## Blockstack Proof #2
Verifying that "marksimonds.id" is my Blockstack ID. https://onename.com/marksimonds

## compress-tables.sh
#!/usr/bin/env bash

# Compress MySQL tables on disk.
# Author: Andrew Berry, andrew.berry@lullabot.com
#
# Compress all tables in a MySQL InnoDB database using compression from the
# Barracuda table format. Tables have to already be in the Barracuda file
# format to actually compress tables, otherwise the table setting is ignored.
#
# innodb_file_per_table = 1 MUST be set in my.cnf for compression to work.

## picar.py
import time
time.sleep(10)

from rrb3 import *
from bluetooth import *

speedFactor = 0.1

class Robot(object):

## keybase.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                simonds
                / keybase.md
            
            
              Created
              February 27, 2017 17:05
            
          
    Keybase proof

I hereby claim:

I am simonds on github.
I am marksimonds (https://keybase.io/marksimonds) on keybase.
I have a public key ASBqQJ9UmPluawCSeemeOPcfBxaC0Tbhpfygn7eB1GNnkwo

To claim this, I am signing this object:

  
## character_fix.sql
DELIMITER ;;
DROP PROCEDURE IF EXISTS character_fix;;
CREATE DEFINER=`root`@`localhost` PROCEDURE `character_fix`(_table_name VARCHAR(50), _field_name VARCHAR(50))
BEGIN

	DROP TEMPORARY TABLE IF EXISTS temp_cursor_table;
	SET @temp_table_query='CREATE TEMPORARY TABLE temp_cursor_table AS ';
	SET @temp_table_query=concat( @temp_table_query, 'SELECT id, ', _field_name, ' FROM ', _table_name, ' WHERE ', _field_name, ' <> convert(', _field_name, ' using ascii) ORDER BY id');
	PREPARE temp_statement from @temp_table_query;
	EXECUTE temp_statement;

## uc_words.sql
/*
Usage:
UPDATE Table_name SET column_name = UC_Words(column_name)
*/

DELIMITER ||

CREATE FUNCTION `UC_Words`( str VARCHAR(255) ) RETURNS VARCHAR(255) CHARSET utf8_general_ci
BEGIN
  DECLARE c CHAR(1);

## pokestops.json
{
    "pokestops" : [
    {
        "distance": 18,
        "name": "Salvation Army Dedication Plaque",
        "bearing": 207,
        "latitude": 47.657763,
        "image": "http://lh3.ggpht.com/Cf46atmJRu3lhO0JVbGFA4AxKWq8uHFEBxcU-GgzB8U390uqAEE-G1X4pNqT8ccHeFMSe7t1WoVDAuSnyB9v",
        "guid": "4aed3289f2ae4450964e0ab3cb5eb3d6.16",
        "compass": "SW",
	// Source: https://medium.com/dailyjs/13-javascript-one-liners-thatll-make-you-look-like-a-pro-29a27b6f51cb

	const randomBoolean = () => Math.random() >= 0.5;
	// randomBoolean() == true \|\| false (a 50/50 change on returning true of false)

	const isWeekday = (date) => date.getDay() % 6 !== 0;
	// isWeekday(new Date(2021, 0, 11)) == true

	const reverse = str => str.split('').reverse().join('');
	// reverse('hello world') == 'dlrow olleh'
	<!DOCTYPE html>
	<html>
	<head>
	<title>Zipcode Lookup Demo</title>
	<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/1.12.0/jquery.js"></script>
	<style>
	input, label, select {
	display: block;
	width: 100%;
	margin: 0;
	#!/usr/bin/env bash

	# Compress MySQL tables on disk.
	# Author: Andrew Berry, andrew.berry@lullabot.com
	#
	# Compress all tables in a MySQL InnoDB database using compression from the
	# Barracuda table format. Tables have to already be in the Barracuda file
	# format to actually compress tables, otherwise the table setting is ignored.
	#
	# innodb_file_per_table = 1 MUST be set in my.cnf for compression to work.
	import time
	time.sleep(10)

	from rrb3 import *
	from bluetooth import *

	speedFactor = 0.1

	class Robot(object):
	DELIMITER ;;
	DROP PROCEDURE IF EXISTS character_fix;;
	CREATE DEFINER=`root`@`localhost` PROCEDURE `character_fix`(_table_name VARCHAR(50), _field_name VARCHAR(50))
	BEGIN

	DROP TEMPORARY TABLE IF EXISTS temp_cursor_table;
	SET @temp_table_query='CREATE TEMPORARY TABLE temp_cursor_table AS ';
	SET @temp_table_query=concat( @temp_table_query, 'SELECT id, ', _field_name, ' FROM ', _table_name, ' WHERE ', _field_name, ' <> convert(', _field_name, ' using ascii) ORDER BY id');
	PREPARE temp_statement from @temp_table_query;
	EXECUTE temp_statement;
	/*
	Usage:
	UPDATE Table_name SET column_name = UC_Words(column_name)
	*/

	DELIMITER \|\|

	CREATE FUNCTION `UC_Words`( str VARCHAR(255) ) RETURNS VARCHAR(255) CHARSET utf8_general_ci
	BEGIN
	DECLARE c CHAR(1);
	{
	"pokestops" : [
	{
	"distance": 18,
	"name": "Salvation Army Dedication Plaque",
	"bearing": 207,
	"latitude": 47.657763,
	"image": "http://lh3.ggpht.com/Cf46atmJRu3lhO0JVbGFA4AxKWq8uHFEBxcU-GgzB8U390uqAEE-G1X4pNqT8ccHeFMSe7t1WoVDAuSnyB9v",
	"guid": "4aed3289f2ae4450964e0ab3cb5eb3d6.16",
	"compass": "SW",