Skip to content

Instantly share code, notes, and snippets.

View DaveLeonard's full-sized avatar
🎲
Coding Playdate games

David Leonard DaveLeonard

🎲
Coding Playdate games
View GitHub Profile
@DaveLeonard
DaveLeonard / config.json
Last active November 9, 2020 12:02
Example of xminer config.json file
{
"api": {
"id": null,
"worker-id": null
},
"http": {
"enabled": false,
"host": "127.0.0.1",
"port": 0,
"access-token": null,
@DaveLeonard
DaveLeonard / stored_proc.sql
Created November 6, 2020 07:15
Stored Procedure that will generate a view with dynamic unions
CREATE PROCEDURE `dyn_view_maker`()
READS SQL DATA
BEGIN
DECLARE schemaName VARCHAR(64);
DECLARE tablesName VARCHAR(64);
DECLARE done INT DEFAULT FALSE;
DECLARE cursor1 CURSOR FOR
SELECT table_schema, table_name
FROM information_schema.TABLES
WHERE table_schema = ‘your schema name’
@DaveLeonard
DaveLeonard / 1_Storage.sol
Created October 28, 2020 13:14
Created using remix-ide: Realtime Ethereum Contract Compiler and Runtime. Load this file by pasting this gists URL or ID at https://remix.ethereum.org/#version=soljson-v0.5.11+commit.22be8592.js&optimize=false&gist=
pragma solidity >=0.4.22 <0.7.0;
/**
* @title Storage
* @dev Store & retrieve value in a variable
*/
contract Storage {
uint256 number;
@DaveLeonard
DaveLeonard / 1_Storage.sol
Created October 28, 2020 13:02
Created using remix-ide: Realtime Ethereum Contract Compiler and Runtime. Load this file by pasting this gists URL or ID at https://remix.ethereum.org/#version=soljson-v0.5.11+commit.22be8592.js&optimize=false&gist=
pragma solidity >=0.4.22 <0.7.0;
/**
* @title Storage
* @dev Store & retrieve value in a variable
*/
contract Storage {
uint256 number;
@DaveLeonard
DaveLeonard / 1_Storage.sol
Created October 28, 2020 12:14
Created using remix-ide: Realtime Ethereum Contract Compiler and Runtime. Load this file by pasting this gists URL or ID at https://remix.ethereum.org/#version=soljson-v0.5.11+commit.22be8592.js&optimize=false&gist=
pragma solidity >=0.4.22 <0.7.0;
/**
* @title Storage
* @dev Store & retrieve value in a variable
*/
contract Storage {
uint256 number;
@DaveLeonard
DaveLeonard / 1_Storage.sol
Last active October 28, 2020 12:10
Created using remix-ide: Realtime Ethereum Contract Compiler and Runtime. Load this file by pasting this gists URL or ID at https://remix.ethereum.org/#version=soljson-v0.5.11+commit.22be8592.js&optimize=false&gist=
pragma solidity >=0.4.22 <0.7.0;
/**
* @title Storage
* @dev Store & retrieve value in a variable
*/
contract Storage {
uint256 number;
@DaveLeonard
DaveLeonard / 1_Storage.sol
Created October 28, 2020 10:27
Created using remix-ide: Realtime Ethereum Contract Compiler and Runtime. Load this file by pasting this gists URL or ID at https://remix.ethereum.org/#version=soljson-v0.5.11+commit.22be8592.js&optimize=false&gist=
pragma solidity >=0.4.22 <0.7.0;
/**
* @title Storage
* @dev Store & retrieve value in a variable
*/
contract Storage {
uint256 number;