steve flitcroft redsquare

## clickhouse_parts.sql
SELECT
    table,
    partition_id,
    count(name) AS parts,
    formatReadableSize(sum(bytes_on_disk)) AS size
FROM system.parts
WHERE (table = 'qw_3_requests_quotes') AND active AND (toUInt32(partition_id) < 20231001)
GROUP BY
    table,
    partition_id

## gist:234fd57b0ed450c1ba40cb10e8f7374b
SELECT
    table,
    partition_id,
    count(name) AS parts,
    formatReadableSize(sum(bytes_on_disk)) AS size
FROM system.parts
WHERE (table = 'qw_3_requests_quotes') AND active AND (toUInt32(partition_id) < 20231001)
GROUP BY
    table,
    partition_id

## dump_restore_clickhouse.sql
#dump table ddl's

clickhouse-client --host your_clickhouse_host -q "SHOW TABLES FROM db_name" | while read -r table_name; do
    clickhouse-client --host your_clickhouse_host -q "SHOW CREATE TABLE db_name.\`$table_name\`" >> db_structure.sql
done

#restore
clickhouse-client --host target_clickhouse_host < db_structure.sql

#also in  /var/lib/clickhouse/metadata/

## clickhouse_join_date_range.sql
  :) CREATE TABLE ranges (id UInt64, date_start Date, date_end Date) ENGINE = TinyLog;

  :) INSERT INTO ranges SELECT rowNumberInAllBlocks() AS id, least(dates[1], dates[2]) AS date_start, greatest(dates[1], dates[2]) AS date_end FROM (SELECT arrayJoin(arrayMap(d -> [today() - d - rand64(d) % 10, yesterday() - d - rand(d) % 10], range(10))) AS dates);

  :) CREATE TABLE dates (id UInt64, date Date) ENGINE = TinyLog;

  :) INSERT INTO dates SELECT rowNumberInAllBlocks() AS id, date FROM (SELECT arrayJoin(arrayMap(d -> today() - rand64(d) % 10, range(10))) AS date);


## gist:69394ee2c13dc1a541f84d88a5b12665
name: Register & Deploy Prefect flows

on:
  push:
  workflow_dispatch:
    inputs:
      pattern:
        description: "Project Name or prohect name Pattern? (defaults to all)"
        required: false
        default: ".*"

## Keybase.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                redsquare
                / Keybase.md
            
            
              Created
              June 2, 2019 20:07
            
          
    Keybase proof

I hereby claim:

I am redsquare on github.
I am redsquare (https://keybase.io/redsquare) on keybase.
I have a public key ASBXSLaKvqYBgD34X1I2FSTC5hTdJqkr6lKhzu4__ZYE8Qo

To claim this, I am signing this object:

  
## program.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Net.Security;
using System.Security.Cryptography.X509Certificates;
using System.Text;
using System.Threading;
using System.Threading.Tasks;
using StackExchange.Redis;

## index.html
<!DOCTYPE html>
<html>
<head>
	<meta charset="utf-8"/>
	<title>t1</title>
	<script src="https://cdnjs.cloudflare.com/ajax/libs/benchmark/1.0.0/benchmark.min.js"></script>
	<script src="./suite.js"></script>
</head>
<body>
	<h1>Open the console to view the results</h1>

## mongoadd
//r = require('rethinkdb')

var MongoClient = require('mongodb').MongoClient,
    format = require('util').format;

var querystring = require('querystring');
var https = require('https');

var Inserter = function (collection) {
    this.collection = collection;

## Wait.cs
public static class Wait
{
	public static bool ForExpectedValue<T>(T expectation, Func<T> source, int millisecondPolling = 500, int timeoutInMilliseconds = 5000)
	{
		var matched = Wait.Until(() => expectation.Equals(source()), millisecondPolling, timeoutInMilliseconds).WasSatisfied;

		StoryTellerAssert.Fail(!matched, () => "Expected {0}, but was {1}".ToFormat(expectation, source()));

		return true;
	}
	SELECT
	table,
	partition_id,
	count(name) AS parts,
	formatReadableSize(sum(bytes_on_disk)) AS size
	FROM system.parts
	WHERE (table = 'qw_3_requests_quotes') AND active AND (toUInt32(partition_id) < 20231001)
	GROUP BY
	table,
	partition_id
	#dump table ddl's

	clickhouse-client --host your_clickhouse_host -q "SHOW TABLES FROM db_name" \| while read -r table_name; do
	clickhouse-client --host your_clickhouse_host -q "SHOW CREATE TABLE db_name.\`$table_name\`" >> db_structure.sql
	done

	#restore
	clickhouse-client --host target_clickhouse_host < db_structure.sql

	#also in /var/lib/clickhouse/metadata/
	:) CREATE TABLE ranges (id UInt64, date_start Date, date_end Date) ENGINE = TinyLog;

	:) INSERT INTO ranges SELECT rowNumberInAllBlocks() AS id, least(dates[1], dates[2]) AS date_start, greatest(dates[1], dates[2]) AS date_end FROM (SELECT arrayJoin(arrayMap(d -> [today() - d - rand64(d) % 10, yesterday() - d - rand(d) % 10], range(10))) AS dates);

	:) CREATE TABLE dates (id UInt64, date Date) ENGINE = TinyLog;

	:) INSERT INTO dates SELECT rowNumberInAllBlocks() AS id, date FROM (SELECT arrayJoin(arrayMap(d -> today() - rand64(d) % 10, range(10))) AS date);
	name: Register & Deploy Prefect flows

	on:
	push:
	workflow_dispatch:
	inputs:
	pattern:
	description: "Project Name or prohect name Pattern? (defaults to all)"
	required: false
	default: ".*"
	using System;
	using System.Collections.Generic;
	using System.Linq;
	using System.Net.Security;
	using System.Security.Cryptography.X509Certificates;
	using System.Text;
	using System.Threading;
	using System.Threading.Tasks;
	using StackExchange.Redis;
	<!DOCTYPE html>
	<html>
	<head>
	<meta charset="utf-8"/>
	<title>t1</title>
	<script src="https://cdnjs.cloudflare.com/ajax/libs/benchmark/1.0.0/benchmark.min.js"></script>
	<script src="./suite.js"></script>
	</head>
	<body>
	<h1>Open the console to view the results</h1>
	//r = require('rethinkdb')

	var MongoClient = require('mongodb').MongoClient,
	format = require('util').format;

	var querystring = require('querystring');
	var https = require('https');

	var Inserter = function (collection) {
	this.collection = collection;
	public static class Wait
	{
	public static bool ForExpectedValue<T>(T expectation, Func<T> source, int millisecondPolling = 500, int timeoutInMilliseconds = 5000)
	{
	var matched = Wait.Until(() => expectation.Equals(source()), millisecondPolling, timeoutInMilliseconds).WasSatisfied;

	StoryTellerAssert.Fail(!matched, () => "Expected {0}, but was {1}".ToFormat(expectation, source()));

	return true;
	}