baybatu’s gists

## json-format-using-vim-with-python.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
              baybatu
            / json-format-using-vim-with-python.md
          
          
            Created Nov 26, 2018
          
          
            JSON format in Vim using Python json.tool module
          
        
      View json-format-using-vim-with-python.md
  
    
    In Vim, use :%!python -m json.tool command to format text as json in current buffer.
Source: https://blog.realnitro.be/2010/12/20/format-json-in-vim-using-pythons-jsontool-module/

  
## datagrip-database-connections.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
              baybatu
            / datagrip-database-connections.md
          
          
            Last active Nov 6, 2018
          
          
            Import & Export database connection properties in DataGrip
          
        
      View datagrip-database-connections.md
  
    
    on macOS
default folder in /Users/USERNAME/Library/Preferences/DataGrip2018.1/projects contains database connection properties.
DataGrip2018.1 states your DataGrip version

  
## pip-install-by-specific-python.sh
pyenv shell 3.6.4 # Shell specific Python version
/usr/local/var/pyenv/versions/3.6.4/bin/python -m pip install -U PACKAGE_NAME

## realtime-tracking-stdout-line-count.sh
docker logs -f --since 2s $(docker ps -qa --filter "name=CONTAINER_NAME") | pv -l -c > /dev/null

## last-records-on-elasticsearch.sh
curl -XGET "http://ES_CLUSTER/_search" -H 'Content-Type: application/json' -d'
{
    "query": {
        "range" : {
            "@timestamp" : {
                "gte" : "now-15m",
                "lt" :  "now"
            }
        }
    }

## macos-mail-gmail-mail-complete.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
              baybatu
            / macos-mail-gmail-mail-complete.md
          
          
            Created Sep 13, 2018
          
          
            macOS'da Mail uygulamasının Gmail'deki e-posta adreslerinin tamamlamaması sorunu çözümü
          
        
      View macos-mail-gmail-mail-complete.md
  
    
Address Book uygulamasında Preferences > Account sekmesinde Google hesabını etkinleştir.
Uygulamanın sunucuyla senkronize olmasını bekle.
Mail uygulamasını kapat aç.


## delete-by-query.json
POST INDEX_NAME/_delete_by_query
{
  "query": {
    "bool": {
      "must": [
        {
          "term": {
            "field1": "100"
          }
        },

## disable-vino-encryption.sh
gsettings set org.gnome.Vino require-encryption false

## update-rows-using-subquery.sql
UPDATE cars
SET model = subNewCarsTable.newModelName
FROM (SELECT
         nc.id    AS carId,
         nc.model AS newModelName
       FROM new_cars nc
       WHERE year=2018) subNewCarsTable
WHERE subNewCarsTable.carId = cars.id;

## elasticsearch-adjust-max-result-window.sh
# tested on Elasticseach 6.0.0
curl -XPUT "http://es-host:9200/my_index/_settings" -H 'Content-Type:application/json' -d '{ "index" : { "max_result_window" : 1000000 } }'