Skip to content

Instantly share code, notes, and snippets.

@jay61439476
jay61439476 / postgresql_test.md
Created December 20, 2018 07:41 — forked from xiazhibin/postgresql_test.md
postgresql生成测试数据

核心方法

generate_series(start,stop);生成序列
(random()*(2*10^9))::integer;生成随机数
substr('abcdefghijklmnopqrstuvwxyz',1,(random()*26)::integer);生成随机字符串

例如有一下的Test表

 Table "public.test"
@jay61439476
jay61439476 / JVM参数.md
Created December 3, 2015 03:47
IDE等开发工具使用配置
  • 编码 -Dfile.encoding=UTF-8

  • 内存 -XX:PermSize=512M -XX:MaxPermSize=512M -Xms1024m -Xmx1024m

@jay61439476
jay61439476 / allRowsInGrid_in_page.js
Last active January 10, 2018 02:58
jqGrid常用方法
//分页情况下获取全部数据
var allRowsInGrid = $('#list4').jqGrid('getGridParam','data');
@jay61439476
jay61439476 / pre-commit.bat
Created November 17, 2015 05:49
SVN提交时必须输入备注信息,放置在仓库的hooks目录下,名称为pre-commit.bat
@echo off
setlocal
set REPOS=%1
set TXN=%2
rem check that logmessage contains at least 10 characters
rem .....代表5个字符
svnlook log "%REPOS%" -t "%TXN%" | findstr ".........." > nul
if %errorlevel% gtr 0 goto err
exit 0
:err