Skip to content

Instantly share code, notes, and snippets.

@mankind
mankind / rails-jsonb-queries
Last active May 3, 2025 05:37
Ruby on Rails-5 postgresql-9.6 jsonb queries
http://stackoverflow.com/questions/22667401/postgres-json-data-type-rails-query
http://stackoverflow.com/questions/40702813/query-on-postgres-json-array-field-in-rails
#payload: [{"kind"=>"person"}]
Segment.where("payload @> ?", [{kind: "person"}].to_json)
#data: {"interest"=>["music", "movies", "programming"]}
Segment.where("data @> ?", {"interest": ["music", "movies", "programming"]}.to_json)
Segment.where("data #>> '{interest, 1}' = 'movies' ")
Segment.where("jsonb_array_length(data->'interest') > 1")
This file has been truncated, but you can view the full file.
第一章 青衫磊落险峰行
青光闪动,一柄青钢剑倏地刺出,指向在年汉子左肩,使剑少年不等招用老,腕抖剑斜,剑锋已削向那汉子右颈。那中年汉子剑挡格,铮的一声响,双剑相击,嗡嗡作声,震声未绝,双剑剑光霍霍,已拆了三招,中年汉子长剑猛地击落,直砍少年顶门。那少年避向右侧,左手剑诀一引,青钢剑疾刺那汉子大腿。
两人剑法迅捷,全力相搏。
练武厅东坐着二人。上首是个四十左右的中年道姑,铁青着脸,嘴唇紧闭。下首是个五十余岁的老者,右手捻着长须,神情甚是得意。两人的座位相距一丈有余,身后各站着二十余名男女弟子。西边一排椅子上坐着十余位宾客。东西双方的目光都集注于场中二人的角斗。
眼见那少年与中年汉子已拆到七十余招,剑招越来越紧,兀自未分胜败。突然中年汉子一剑挥出,用力猛了,身子微微一幌,似欲摔跌。西边宾客中一个身穿青衫的年轻男子忍不住“嗤”的一声笑。他随即知道失态,忙伸手按住了口。
便在这时,场中少年左手呼一掌拍出,击向那汉子后心,那汉子向前跨出一步避开,手中长剑蓦地圈转,喝一声:“着!”那少年左腿已然中剑,腿下一个踉跄,长剑在地下一撑,站直身子待欲再斗,那中年汉子已还剑入鞘,笑道:“褚师弟,承让、承让,伤得不厉害么?”那少年脸色苍白,咬着嘴唇道:“多谢龚师兄剑下留情。”
那长须老者满脸得色,微微一笑,说道:“东宗已胜了三阵,看来这‘剑湖宫’又要让东宗再住五年了。辛师妹,咱们还须比下去么?”坐在他上首的那中年道姑强忍怒气,说道:“左师果然调教得好徒儿。但不知左师兄对‘无量玉壁’的钻研,这五年来可已大有心得么?”长须老者向她瞪了一眼,正色道:“师妹怎地忘了本派的规矩?”那道姑哼了一声,便不再说下去了。
这老者姓左,名叫子穆,是“无量剑”东宗的掌门。那道姑姓辛,道号双清,是“无量剑”西宗掌门。
“无量剑”原分东、北、西三宗,北宗近数十年来已趋式微,东西二宗却均人才鼎盛。“无量剑”于五代后唐年间在南诏无量山创派,掌门人居住无量山剑湖宫。自于大宋仁过年间分为三宗之后,每隔五年,三宗门下弟子便在剑湖宫中比武斗剑,获胜的一宗得在剑湖宫居住五年,至第六年上重行比试。五场斗剑,赢得三场者为胜。这五年之中,败者固然极力钻研,以图在下届剑会中洗雪前耻,胜者也是丝毫不敢松懈。北宗于四十年前获胜而入住剑湖宫,五年后败阵出宫,掌门人一怒而率领门人迁往山西,此后即不再参预比剑,与东西两宗也不通音问。三十
@csrutil
csrutil / rbenv
Created November 12, 2019 13:54
time RUBY_BUILD_MIRROR_URL=http://localhost:7890/ruby-2.6.5.tar.bz2 RUBY_CONFIGURE_OPTS="--disable-install-doc --with-jemalloc --with-readline-dir=$(brew --prefix readline) --with-openssl-dir=$(brew --prefix openssl)" rbenv install 2.6.5 --verbose
@TorvaldsDB
TorvaldsDB / webpack.config.md
Last active June 28, 2021 05:42
Webpack Basic Configuration

Webpack

Webpack 配置文件放置在webpack.config.js中,

代码源码在 src/, 文件分布结构图(使用tree ./

├── src
│   ├── css
│   │   ├── iconfont.css
│ │ └── index.less
@harssh
harssh / pr-checklist.md
Created February 13, 2023 15:40 — forked from katyhuff/pr-checklist.md
Pull Request Review Checklist
  • Read the PR description
  • Read through all the changes, considering the following questions.
    • Is there anything you can praise about this PR? Start with praise.
    • Are variable names brief but descriptive?
    • Are new/changed functions no longer than a paragraph?
    • Do all function parameters have default values where appropriate?
    • Is the code clear and clean? (see Robert C. Martin's Clean Code)
    • Is there enough documentation?
  • Does the programming style meet the requirements of the repository (PEP8 for python, google for c++, etc.)