CJHwong

Origin: https://news.ycombinator.com/item?id=39798115

Replace the database name by yours

mysqldump --no-data $DB_NAME --result-file myschema.sql

Download mysql2sqlite from https://github.com/dumblob/mysql2sqlite

./mysql2sqlite myschema.sql | sqlite3 mysqlite3.db

CJHwong

Introduction

This instruction explains how to create a Quick Action in macOS that can send selected text directly to your preferred large language model.

The workflow is inspired by this Hacker News post of eliya_confiant: https://news.ycombinator.com/item?id=39592297.

Prerequisites

To follow this guide, you will need the following tools:

CJHwong

ALL_FILES=$(git ls-files)

echo "filename,commit_ct,last_updated_at"
while IFS= read -r FILENAME
do
    COMMIT_CT=$(git --no-pager log --pretty=tformat:"%h" ${FILENAME} | wc -l | sed 's/ //g')
    LATEST_UPDATED_AT=$(git --no-pager log -1 --pretty="format:%ci" $FILENAME)
    echo "${FILENAME},${COMMIT_CT},${LATEST_UPDATED_AT}"
done < <(printf '%s\n' "$ALL_FILES")

CJHwong

import argparse
import codecs
import csv


def extract_table_sql(table_name, source_dir, target_dir):
    TABLE_STRUCTURE_START = '-- Table structure for table'
    TARGET_TABLE_STRUCTURE_START = f'{TABLE_STRUCTURE_START} `{table_name}'

    backup_sql = codecs.open(f'{source_dir}/backup.sql', 'r', encoding='utf-8', errors='replace')

CJHwong

import sqlite3
import json

def dump_from_sqlite():
    conn = sqlite3.connect('db.sqlite')
    c = conn.cursor()

    c.execute("SELECT name FROM sqlite_master WHERE type='table';")
    for t in c.fetchall():
        c.execute("SELECT * FROM " + t[0])

CJHwong

set shell=bash
"======Color Scheme======
"set rtp+=~/.vim/bundle/vim-colorschemes
set rtp+=~/.vim/bundle/vim-colors-solarized/
set t_Co=256
set background=dark
colorscheme solarized

"=====Vim Environment====
set tabstop=4 shiftwidth=4 expandtab