jetspeed's blog

objc_and_vim

2011-06-12T00:00:00-07:00

objc_matchbracket.vim:


For instance, where | is the cursor:

"foo|" becomes "[foo |]" after ] is pressed.
"foo bar|" becomes "[foo bar]|"
"foo: bar|" becomes "foo: [bar |]"
"foo bar: baz|" becomes "[foo bar: baz]|"

install
Move objc_matchbracket.vim to ~/.vim/ftplugin or equivalent.

cocoa.vim


unzip cocoa.zip -d ~/.vim
:helptags ~/.vim/doc (to enable the help)

为已存在表增加主键ID

2010-03-22T00:00:00-07:00


create table report_tbl as select * from fj_report_tbl where 1=2;

alter table report_tbl add(id integer not null);

CREATE SEQUENCE REPORT_TBL_ID_SEQ
   INCREMENT BY 1
START WITH 1
   NOMAXVALUE
   NOCYCLE
   NOCACHE
    ORDER;


create or replace trigger TRI_REPORT_TBL_ID
before insert on REPORT_TBL
for each row
begin
select REPORT_TBL_ID_SEQ.nextval into :new.ID from dual;
end;

insert into REPORT_TBL(tran_key, post_date, acct_no, narrative,
branch_seq_no, deb_cre, actual_bal, total_deb_amount,
total_cre_amount, flag  ) select tran_key, post_date, acct_no, narrative,
branch_seq_no, deb_cre, actual_bal, total_deb_amount,
total_cre_amount, flag from FJ_REPORT_TBL;
commit;

select * from REPORT_TBL;

alter table REPORT_TBL (add constraint PK_REPORT_TBL_ID primary key(ID));


delete from REPORT_TBL;
commit;

GNUStep学习

2010-01-17T00:00:00-08:00

GNUMakefile


include $(GNUSTEP_MAKEFILES)/common.make
TOOL_NAME=Shape
Shape_OBJC_FILES=c4.m shape.m
include $(GNUSTEP_MAKEFILES)/tool.make

连接oracle并测试

2010-01-14T00:00:00-08:00

中文编码问题
在environment.rb的最上面添加

database连接


development:
  adapter: oracle_enhanced
  database: myserver:1521/mydatabase.mydomain.com
  username: myusername
  password: mypassword


ENV['NLS_LANG'] = 'SIMPLIFIED CHINESE_CHINA.AL32UTF8'

看我写的一个rspec测试

require 'spec_helper' describe CdbeffSmPara do it “should connect to test database” do cdbeff_sm_para = CdbeffSmPara.new cdbeff_sm_para.should be_valid end it “should select an unique para by pid and id” do pid = “007004” id = “001” cdbeff_sm_para = CdbeffSmPara.select_para(pid, id) cdbeff_sm_para.should be_valid cdbeff_sm_para.constname.should == “张三李四” end

end

测试通过，我也练习tdd了。好好学学rspec
接下来学习fixture的用法，像这样写在测试里的数据，肯定是不行的。

应该学习factory_girl，一亲芳泽。

安装


gem install factory_girl --source http://gemcutter.org

在spec_helper中

不
require 'factory_girl'
Dir.glob(File.dirname(__FILE__) + "/factories/*").each do |factory|
  require factory
end

如果用到id,type等字段，需要修改lib/factory_girl/factory.rb中加上 undef id等行

编译并安装tora
在ubuntu下连接oracle并没有很好的选择，sqlplus可以用，但是查出来的结果在终端下还是太难看了，也许是我不会使。于是寻找图形界面的客户端。navicat可以用，但是是通过wine模拟的，最后还是选择tora，toad的兄弟？
通过apt安装的tora并不支持oracle，倒是支持postgresql了。重新编译吧。
```
./configure --prefix=/home/wangxq/install/tora-2.1.0 --with-instant-client=/home/wangxq/install/instantclient_10_2
```

处理联合主键

2010-01-14T00:00:00-08:00

遗留数据库的一个问题就是联合主键，今天学习到了rails中处理联合主键。据说DataMapper已经支持了。虽然DHH不愿意支持，但是没办法，咱还是走旁门左道往rails的大树上靠吧

这个gem
http://compositekeys.rubyforge.org/

在environment.rb中增加
require ‘composite_primary_keys’

在model中如此用


set_primary_keys :user_id, :group_id
别人使用fk的时候，像这样
has_many :statuses, :class_name => 'MembershipStatus', :foreign_key => [:user_id, :group_id]

find


Membership.find(1,1)
Membership.find(:first).to_param # => "1,1"
find a list
Membership.find [1,1], [2,1]

*处理主键
rails 中默认用id做主键，且id, type默认是attributes_protected_by_default，因此不能设置，没有id=方法。
这就造成了set_primary_key 之后，id, rese_id都是private方法，用factory_girl define出来的类，无论如何不能create model。即下面的测试无法通过。


  it "should create a new instance given valid attributes" do
    lambda {
      info = CdbamReserveInfo.new(@valid_attributes)
      info.should be_valid
      info.save!()
    }.should change(CdbamReserveInfo, :count)
  end

只好


  private
  def attributes_protected_by_default
    []
  end

测试通过，既然测试通过，那可以直接用create方法了


  it "should create a new instance given valid attributes" do
    lambda {
      info = CdbamReserveInfo.create!(@valid_attributes)
      info.should be_valid
    }.should change(CdbamReserveInfo, :count)
  end

在ubuntu上设置rails访问Oracle

2010-01-13T00:00:00-08:00

先在"这里":http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/linuxsoft.html
下载oracle 的instant client和sqlplus

解压，然后


LD_LIBRARY_PATH=/opt/oracle/instantclient
export LD_LIBRARY_PATH

then add links


ln -s libclntsh.so.11.1 libclntsh.so
ln -s libocci.so.11.1 libocci.so

解压sqlplus到相同目录


PATH=$PATH:/opt/oracle/instantclient
SQLPATH=/opt/oracle/instantclient
export SQLPATH
TNS_ADMIN=/opt/oracle/instantclient
export TNS_ADMIN

如果出现libaio无法load的错误，则安装

sudo apt-get install libaio-dev

oracle与ruby
需要安装ruby-oci8和activerecord-oracle_enhanced-adapter两个gem

重新学习agilejava，养成晚上看书的习惯

2010-01-09T00:00:00-08:00

Lesson 1 Getting started

关于design
You start by building only high-level designs, not highly detailed specifications. You will continually refine the design as you understand more about the customer needs. You will also update the design as you discover what works well and what doesn’t work well in the Java code that you build. The power of object-oriented development can allow you this flexibility, the ability to quickly adapt your design to changing conditions.
关于 clean code: Keep your code clean at all times!
Part of crafting software is understanding that code is a very malleable form. The best thing you can do is get into the mindset that you are a sculptor of code, shaping and molding it into a better form at all times. Once in a while, you’ll add a flourish to make something in the code stand out. Later, you may find that the modification is really sticking out like a sore thumb, asking for someone to soothe it with a better solution. You will learn to recognize these trouble spots in your code (“code smells,” as Martin Fowler calls them.)

assertions
```
assertEquals("Jane Doe", studentName);
```

junit 中的suite


import junit.framework.TestCase;
import junit.framework.TestSuite;

public class AllTests extends TestCase {
    public static TestSuite suite(){
        TestSuite suite = new TestSuite();
        suite.addTestSuite(StudentTest.class);
        suite.addTestSuite(CourseSessionTest.class);
        return suite;

    }
}

持续集成杂记

2009-12-11T00:00:00-08:00

findbugs的集成

当前时间：


<tstamp><format property="today.date" pattern="yyyyMMdd"/></tstamp>

checkstyle和findbugs结果的打包备份


          <tar destfile="${checkstyle_report.dir}/cdbam_checkstyle_${today.date}.tar.gz" compression="gzip">
              <fileset dir=".">
                  <include name="stylesheet.css"/>
                  <include name="allclasses-frame.html"/>
                  <include name="checkstyle_report.xml"/>
                  <include name="overview-frame.html"/>
                  <include name="files/"/>
                  <include name="index.html"/>

关于fileset，请baidu http://zpq2004.javaeye.com/blog/163912

定时任务自动下载voa听力文件

2009-10-30T00:00:00-07:00

俺为了表示不抛弃英语的决心，决定每天都下点voa听力做做样子。并且还只能听慢速的special english。
做了个自动下载脚本，很简单啦。
#首先用ruby分析下载地址吧，把当天的special english都下载下来，先试试能行，以后再考虑代码质量…劣质程序员的一贯思维…


#!/usr/bin/ruby
require 'rubygems'
require 'mechanize'
def get_page
  agent = WWW::Mechanize.new
  agent.redirect_ok = true
  agent.user_agent_alias = 'Windows IE 6'
  agent.max_history = 2
page = agent.get(url)
end
def url

  “http://www.unsv.com/voanews/specialenglish/”

end
def voa

  body = get_page.body

  re = /http\:\/\/njtelecom.unsv.com\/[^\s*]special\d\.mp3/

  m = body.scan(/http\:\/\/njtelecom.unsv.com\/[^\s*]special#{Time.now.strftime(‘%Y%m%d’)}\d\.mp3/)

  m.uniq!.each do |i|

    `wget -c #{i} -P /home/wangxq/down/ftp/voa/down/`

  end

end
voa

#接着在crontab中加一个每天下午1点半给我下载，以前没试过，看来还是很简单的。


crontab -e

这个命令写完会在 /var/spool/cron/crontabs/wangxq下写上定时命令


crontab -e

	m h  dom mon dow   command

30 13 * * 1-7 ruby /home/wangxq/down/ftp/voa/voa.rb

待会我看看结果怎么样 .. 呼呼

安装QuickBuild，试验持续集成

2009-10-28T00:00:00-07:00

之前安装了CuiseControl.rb对rails项目进行持续集成，在和rspec配合起来，对于开发人员的Commit Build是非常不错的实践，也可以用Rake配置代码覆盖率检查等其它集成。但毕竟现在rails项目较少，做rspec的机会也比较少，测试优先的习惯甚至都还未养成。于是我觉得应该考虑一下java下的持续集成，看了javaeye的这篇文章，觉得 QuickBuild 不错。试试。

安装
下载 Community Edition 有16个configuration的限制。
配置
QB需要jdk 1.5 u11以上，解压后就可以了。
然后进入8810端口进行配置，怎么配置我先学习着

维护遗留系统真是太麻烦了

2009-10-27T00:00:00-07:00

首先，这个遗留系统是跑在jdk 1.4上的，并且这一点还很难改变，这基本上就决定了只能用那个年代的技术

其次，本来是一个简单的系统，结果却整合了struts 1 时代和eai时代的一堆东西，其结果却是什么也不像，并且还分成两个应用部署，查询部分一个应用，操作部分一个应用。

也罢，到这里还不算最恶心的，它还自己搞了一堆封装，操作数据库，全部写sql进行执行，执行完的结果放到一个hash里，返回给页面，这个hash的数据结构是它自己定义的，很难改变，否则就要改变前台页面的标签….

呜呼，怎么办才好！

使用findbugs

2009-10-27T00:00:00-07:00

第一次试用findbugs，够落后的。因为eclipse还在3.0，无奈只好命令行和ant。还好有google

配置如下，ant调用即可。只是ant 1.7.1需要使用jdk 1.5 害得我改JAVA_HOME。不错


#Mon May 19 10:15:43 CST 2008
findbugs.home=D:/install/findbugs-1.3.9
findbugs.project=D:/pro/git/cdbgrt/cdbps_teller
findbugs.src=${findbugs.project}/src/
findbugs.class=${findbugs.project}/app/WEB-INF/classes/

findbugs.destdir=${basedir}/found/
findbugs.file=${findbugs.destdir}findbugs_result.xml
findbugs.desthtmldir=${findbugs.destdir}
findbugs.destexceldir=${findbugs.destdir}excel/

xslt.classpath=


<?xml version="1.0" encoding="UTF-8"?>
<project name="cdbps" default="all" basedir="./" >
    <property file="findbugs.properties"/>

    <target name="all" depends="clean,findbugs,build_html,build_excel">
        <!-- TODO define script. See Help menu or http://ant.apache.org/ -->
    </target>

    <target name="init">
        <mkdir dir="${findbugs.destdir}" />

    </target>

    <target name="clean" description="清理所有Findbugs检查结果">
        <echo>清理所有Findbugs检查结果!</echo>
        <delete dir="${findbugs.destdir}" />
    </target>

    <!-- findbugs task definition -->
    <path id="findbugs.lib">
        <fileset dir="${findbugs.home}/lib">
            <include name="findbugs-ant.jar"/>
        </fileset>
    </path>


    <taskdef name="findbugs"  classname="edu.umd.cs.findbugs.anttask.FindBugsTask">
        <classpath refid="findbugs.lib" />
    </taskdef>
    <taskdef name="filterBugs" classname="edu.umd.cs.findbugs.anttask.FilterBugsTask">
        <classpath refid="findbugs.lib" />
    </taskdef>

    <taskdef name="convertXmlToText" classname="edu.umd.cs.findbugs.anttask.ConvertXmlToTextTask">
        <classpath refid="findbugs.lib" />
    </taskdef>


    <target name="findbugs" depends="init" description="用Findbugs检查代码错误.">
        <echo>开始用Findbugs检查代码错误......</echo>
        <findbugs home="${findbugs.home}"
                  output="xml"
                  outputFile="${findbugs.file}"
                  jvmargs="-Xmx1024m" >
            <!--auxClasspath path="${basedir}/lib/Regex.jar" /-->
            <sourcePath path="${findbugs.src}"  />
            <class location="${findbugs.class}" />
        </findbugs>
        <echo>Findbugs检查代码错误完成......</echo>
    </target>

    <target name="build_html"  description="将检查结果转换为Html.">
        <echo>将Findbugs检查结果转换为Html......</echo>
        <mkdir dir="${findbugs.desthtmldir}" />
        <convertXmlToText home="${findbugs.home}"
        longBugCodes="true"
        input="${findbugs.file}"
        output="${findbugs.desthtmldir}html_result.html"
        format="html">
        </convertXmlToText>
        <!--
        <xslt in="${findbugs.file}" out="${findbugs.desthtmldir}html_result.html"
              style="build/default.xsl">
            <classpath path="${findbugs.home}lib/*.jar"/>
        </xslt>
        -->
    </target>

    <target name="build_excel"  description="将检查结果转换为Excel.">
        <mkdir dir="${findbugs.destexceldir}" />
        <xslt in="${findbugs.file}" out="${findbugs.destexceldir}excel_result.xls"
              extension=".xls" style="default.xsl" >

        </xslt>
    </target>

    <!-- 分析结果 -->
    <target name="filterBugs" >
        <!--
        <filterBugs home="${findbugs.home}" output="filterBugs.html" withmessages="true" >
            <datafile name="${findbugs.file}"/>
        </filterBugs>
        -->
        <convertXmlToText home="${findbugs.home}"
        input="${findbugs.file}"
        output="${findbugs.desthtmldir}html_result2.html"
        format="html:fancy.xsl">
        </convertXmlToText>
    </target>




</project>

rspec_route_for_problem

2009-10-23T00:00:00-07:00

在restful_authentication生成的rspec中route_for通不过。原因是在rspec 1.2.9 相对于1.1.4来说， route_for需指定methods.

将


  route_for(:controller => "users", :action => "destroy", :id => "1").should == "/users/1"

改为


  route_for(:controller => "users", :action => "destroy", :id => "1").should == {:path => "/users/1", :method => :delete}

另外，在rails 2.3.4中，formatted_#{resources}_url 以及不支持了。

rbac权限系统探索

2009-10-22T00:00:00-07:00

先安装restful_authentication

git:github.com/technoweenie/restful-authentication.git git clone git:github.com/stffn/declarative_authorization.git

ruby script/generate authenticated user sessions —rspec rake db:migrate

目前生成的rspec测试还通不过，需要继续研究。
若加上—include-activation则有电子邮件的激活。其它选项请看git 上的 readme

first init in github pages

2009-10-21T00:00:00-07:00

今天第一次把blog放到github上，这种方式很好，我在本地写，然后发布到github上，一切自己操纵。


require 'date'
p "hello ruby"