Tablolarda tarih ve zamanı ayrı kolonlarda tutmak hatalı sorgulama yapma ihtimalini artırır. Arama için verilen bir zamanın değerini değiştirip arama yapılıyorsa bu durumda bug çıkma ihtimali var. Örnek tablo verisinin şu şekilde olduğunu düşünelim:
| id | tarih | zaman |
|---|---|---|
| 1 | 09/12/2021 | 23:50 |
| 2 | 09/12/2021 | 23:52 |
| 3 | 09/12/2021 | 23:55 |
| import asyncio | |
| import functools | |
| from schedule import Scheduler | |
| class AsyncScheduler(object): | |
| """ | |
| schedule (https://github.com/dbader/schedule) and asyncio integration example. | |
| Jobs are executed in asyncio event loop without blocking another tasks. |
Ilginc bir projeye benziyor. Prototipleme yaparken ya da hizlica bir seyleri denemek istedigimizde kullanilabilir.
\copy (select column1, column2 from mytable) To '/tmp/dump.csv' With CSV DELIMITER ',' HEADER
| // usage: groovy nifi-test-el.groovy '${now():toNumber():minus(3999900000):format("yyyy-MM-dd HH:mm:ss", "GMT")}' | |
| // source: https://community.cloudera.com/t5/Community-Articles/Testing-NiFi-Expression-Language-with-Groovy/ta-p/247208 | |
| @Grab(group='org.apache.nifi', module='nifi-expression-language', version='1.4.0') | |
| import org.apache.nifi.attribute.expression.language.* | |
| def cli = new CliBuilder(usage:'groovy testEL.groovy [options] [expressions]', | |
| header:'Options:') | |
| cli.help('print this message') | |
| cli.D(args:2, valueSeparator:'=', argName:'attribute=value', | |
| 'set value for given attribute') |
SHOW CREATE TABLE tableName;source: https://prestodb.io/docs/current/sql/show-create-table.html#examples
~/.gitconfig:
[includeIf "gitdir:~/workspace/project1/**"]
path = .gitconfig.project1
[includeIf "gitdir:~/workspace/project2/**"]
path = .gitconfig.project2
~/.gitconfig.project1:
| # usage | |
| # python delete-index-by-pattern-in-es.py http://ES_HOST:9200 my-es-index-* | |
| # indexes matched with pattern you entered will be deleted | |
| from elasticsearch import Elasticsearch | |
| import sys | |
| es_host = sys.argv[1] | |
| index_pattern = sys.argv[2] | |
| print(f"es_host:{es_host} ; index_pattern:{index_pattern}") |
harray-ios-sdk projesini local'deki demo bir ios projesinde kullanabilmek icin adimlar:
# Uncomment the next line to define a global platform for your project
# platform :ios, '9.0'
target 'batuiostest' do
Removing keys that contain displayed:
redis-cli --scan --pattern *displayed* | xargs redis-cli del
Source: https://rdbtools.com/blog/redis-delete-keys-matching-pattern-using-scan