| // Simple implementation of lodash.get | |
| // Handles arrays, objects, and any nested combination of the two. | |
| // Also handles undefined as a valid value - see test case for details. | |
| // Based on: https://gist.github.com/harish2704/d0ee530e6ee75bad6fd30c98e5ad9dab | |
| export function deepGet(obj, query, defaultVal) { | |
| query = Array.isArray(query) ? query : query.replace(/(\[(\d)\])/g, '.$2').replace(/^\./, '').split('.'); | |
| if (!(query[0] in obj)) { | |
| return defaultVal; | |
| } | |
| obj = obj[query[0]]; |
| /* | |
| * MIT License | |
| * | |
| * Copyright (c) 2023 Fabio Lima | |
| * | |
| * Permission is hereby granted, free of charge, to any person obtaining a copy | |
| * of this software and associated documentation files (the "Software"), to deal | |
| * in the Software without restriction, including without limitation the rights | |
| * to use, copy, modify, merge, publish, distribute, sublicense, and/or sell | |
| * copies of the Software, and to permit persons to whom the Software is |
Cheatseet assumes you're just playing around on a not clustered ClickHouse server.
docker run -it yandex/clickhouse-client --host your.toy.server.host --port 9500 --user default --password password123 --multiline
SHOW DATABASES
SHOW TABLES (in current database)
SHOW DICTIONARIES (in current database)
| <div id="container" style="height:100%;"></div> |
My Elasticsearch cheatsheet with example usage via rest api (still a work-in-progress)
| httpClient.DefaultRequestHeaders.Authorization = | |
| new AuthenticationHeaderValue( | |
| "Basic", | |
| Convert.ToBase64String( | |
| System.Text.ASCIIEncoding.ASCII.GetBytes( | |
| string.Format("{0}:{1}", username, password)))); |