WesleyBatista

Is the bigserial compatible with the bigint on Cockroach?

Create the tables

Let's create table_x with a bigserial column and set it as the primary key.

CREATE TABLE table_x (
	id bigserial PRIMARY KEY, 

WesleyBatista

import dateutil.parser

dates = [
    # dates that comes as str from kafka message:
    '2019-05-27T12:54:28.777652636Z',
    '2019-05-27T12:54:28.128Z',  # added
    '2019-05-27T12:54:28.120Z',  # added
    '2019-05-27T12:54:28.100Z',  # added
    '2019-05-27T12:54:28.1Z',  # added
    '2019-05-27T12:54:29.993908166Z',

WesleyBatista

setup

mongo

1. create the data dir mkdir -p /home/pi/mongo/data
2. run the following docker command:

   docker run --restart always -d -p 27017:27017 -p 28017:28017 -e AUTH=no -v /home/pi/mongo/data:/data/db --name mongo izone/arm:mongo-3.0.9
   

   source: https://github.com/luvres/armhf

WesleyBatista

import clickhouse_driver


def execute_query(sql, settings):
    conn_params = {
        'host': '<HOST>',
        'port': 9000,
        'user': '<USER>',
        'password': '<PASSWORD>',
        'database': 'default',

WesleyBatista

package main

import (
	"fmt"
)

type Base interface {
	SetParams(string)
	GetParams() string
}

WesleyBatista

ℹ️ to change the default color of the images replace #6c63ff with whatever color you want.

originally from: https://gist.github.com/antonydevanchi/56be1c739e47c72e11ddabf853ddc6db

WesleyBatista

When
    [Case
        (Deposit
            (Role "Seller")
            (Role "Buyer")
            (Token "" "")
            (ConstantParam "Price")
        )
        (When
            [Case