Wietse Wind WietseWind

## sample.sql
SELECT
  SAFE_CONVERT_BYTES_TO_STRING(FROM_HEX(Domain))
FROM
  xrpledgerdata.fullhistory.transactions
WHERE
  Account = 'rPEPPER7kfTD9w2To4CQk6UCfuHM9c6GDY'
  AND TransactionType = 'AccountSet'
  AND Domain IS NOT null
ORDER BY
  LedgerIndex DESC

## For_ Craig_DeWitt.sql
-- Remove the surrounding Q3 for a complete list of account activations

SELECT
  Account,
  COUNT(1) as AccountsActivated
FROM (
  SELECT
    Q1.*,
    Q2.Account,
    Q2.hash

## stdsql.sql
SELECT
  T.LedgerIndex,
  COUNT(1) as TxCount,
  MIN(L.CloseTime) as LedgerClosed
FROM xrpledgerdata.fullhistory.transactions as T
JOIN xrpledgerdata.fullhistory.ledgers as L ON (
  L.LedgerIndex = T.LedgerIndex
)
WHERE
  L.CloseTime > '2019-10-01 12:00:00'

## keybase.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                WietseWind
                / keybase.md
            
            
              Created Sep 10, 2019
            
              
                keybase.md
              
          
      View keybase.md
  
    
    Keybase proof
I hereby claim:

I am wietsewind on github.
I am wietsewind (https://keybase.io/wietsewind) on keybase.
I have a public key ASAxGrMuZ--NGUAhUgpcPEpSdPYMi4zDzu4uy7ru8kuRVAo

To claim this, I am signing this object:

  
## index.js
<script src="https://xrpaddress.info/js/xrpl-tagged-address-codec-browser.js"></script>
<script>
  var XCodec = require('xrpl-tagged-address-codec')
  console.log(XCodec.Encode({ account: 'rPEPPER7kfTD9w2To4CQk6UCfuHM9c6GDY', tag: 495 }))
  console.log(XCodec.Decode('XV5sbjUmgPpvXv4ixFWZ5ptAYZ6PD28Sq49uo34VyjnmK5H'))
</script>

## index.js
#!/usr/bin/env node

const makePlugin = require('ilp-plugin')
const { Server } = require('ilp-protocol-stream')
const Koa = require('koa')
const app = new Koa()
const crypto = require('crypto')

process.on('SIGINT', () => {
  console.log('Hi')

## cc.js
cc = require('five-bells-condition')

const fulfillment_bytes = Buffer.from('Hi! This is me testing :) 😇  🎉🎈🍺🎂🍾🍻...'.repeat(1), 'utf8') //.toString('hex').toUpperCase()
// Or random:
// const fulfillment_bytes = crypto.randomBytes(2)
console.log('EscrowFinish Fee:', 10 * (33 + Math.ceil(Buffer.byteLength(fulfillment_bytes) / 16)))
console.log()
// console.log(fulfillment_bytes)

const myFulfillment = new cc.PreimageSha256()

## afas-tableau-wdc.html
<!doctype html>
<html lang="en">
  <head>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">

    <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/css/bootstrap.min.css" integrity="sha384-Gn5384xqQ1aoWXA+058RXPxPg6fy4IWvTNh0E263XmFcJlSAwiGgFAW/dAiS6JXm" crossorigin="anonymous">
    <script src="https://connectors.tableau.com/libs/tableauwdc-2.3.latest.js" type="text/javascript"></script>
    <script crossorigin="anonymous" src="https://polyfill.io/v3/polyfill.min.js?flags=gated%7Calways"></script>
    <script src="https://cdn.jsdelivr.net/npm/fetch-polyfill@0.8.2/fetch.min.js"></script>

## pub.js
// PubSub example, check pub.js and sub.js
// This is the publising of messages
// Messages will only be seen by subscribers that are already listening
// Credits: https://thisdavej.com/guides/redis-node/node/pubsub.html

const Redis = require('ioredis')
const pub = new Redis()
const channel = 'mychannel:123'

console.log('Started publisher...')

## query.sql
SELECT
  CloseTimeHuman
FROM
  xrpledgerdata.fullhistory.ledgers
WHERE
  LedgerIndex = (
    SELECT
      LedgerIndex
    FROM
      xrpledgerdata.fullhistory.transactions