Razeen razeencheng

🎯

Focusing

Stay hungry, Stay foolish

razeencheng / chatpdf-zh.ipynb

Created March 27, 2023 15:21 — forked from ninehills/chatpdf-zh.ipynb

ChatPDF-zh.ipynb

Sorry, something went wrong. Reload?

Sorry, we cannot display this file.

Sorry, this file is invalid so it cannot be displayed.

razeencheng / dial-pq-via-ssh.go

Created August 5, 2022 11:28 — forked from vinzenz/dial-pq-via-ssh.go

Use postgres via SSH in Golang

razeencheng / go-daily-pg-tips-006

Created April 14, 2019 02:25

	var ids := pq.Int64Array{}
	err := db.QueryRow(`SELECT array_agg(id) FROM users WHERE "age" > $1`,18).Scan(&ids)
	…

razeencheng / go-daily-pg-tips-005

Created April 14, 2019 02:24

	ids := []int64{12,16,33,55}
	rows,err := db.Query(`SELECT name FROM users WHERE id=ANY($1),pq.Int64Array(ids))
	…

razeencheng / go-daily-pg-tips-004

Created April 14, 2019 02:23

	var count int
	err := db.QueryRow(`SELECT count(*) FROM users`).Scan(&count)
	if err != nil {
	if err == sql.ErrNoRaw {
	count = 0
	…
	}
	…
	}

razeencheng / go-daily-pg-tips-003

Last active April 14, 2019 02:26

	err := db.Exec(`INSERT INTO users(name,favorite_fruit,age)
	VALUES($1, $2, $3)
	ON CONFLICT (name) DO UPDATE
	SET favorite_fruit=$2,
	age=$3`)

	err := db.Exec(`INSERT INTO users(name,favorite_fruit,age)
	VALUES($1, $2, $3)
	ON CONFLICT (name) DO UPDATE
	SET favorite_fruit=$2

razeencheng / go-daily-pg-tips-002

Created April 14, 2019 02:21

	var userid int
	err := db.QueryRow(`INSERT INTO users(name, favorite_fruit, age)
	VALUES('beatrice', 'starfruit', 93) RETURNING id`).Scan(&userid)

razeencheng / go-daily-pg-tips-001

Created April 14, 2019 02:18

	// $2 使用了两次都标记的值是64
	rows, err := db.Query(`SELECT name FROM users WHERE favorite_fruit = $1
	OR age BETWEEN $2 AND $2 + 3`, "orange", 64)

razeencheng / test-sqlite.go

Created September 10, 2018 23:31

golang sqlite3 demo 1