外行问个化学paper的初级问题，轻拍砖 - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>ChemEng - 化学工程

外行问个化学paper的初级问题，轻拍砖

外行问个化学paper的初级问题，轻拍砖# ChemEng - 化学工程

c*n2010-08-14 07:08

1 楼

our previous developers just use our one and only single QA db, and assume
that the content is so and so, but over time, the content changes, so the
test cases all gradually fail..
what is your strategy in this case?

j*d2010-08-14 07:08

2 楼

偶高中同学（国内的）让俺帮着改一篇英文paper，意思就是把语言改的更地道点，要
发表在CARBON
上。但是俺是aerospace行当的，没看过化学专业的paper。偶同学的paper通篇都是过
去式，尤其是
在experimental这一节。
是不是化学专业的paper在描述实验数据、结果或是过程的时候都是用过去式呢？学术
文章，至少在
aerospace一般都是用的现在式，不想想当然的把人家的时态给改了，恳请这个版块上
的专家给偶这个
外行指点一下迷津。谢谢了先，大牛请轻拍砖。

g*g2010-08-14 07:08

3 楼

Use an embeded DB for testing purpose, clean and populate test data for
each test case.

【在 c******n 的大作中提到】

: our previous developers just use our one and only single QA db, and assume
: that the content is so and so, but over time, the content changes, so the
: test cases all gradually fail..
: what is your strategy in this case?

S*n2010-08-14 07:08

4 楼

对，实验都已经做完了，所以是过去式，结论可以用现在式

【在 j*****d 的大作中提到】

: 偶高中同学（国内的）让俺帮着改一篇英文paper，意思就是把语言改的更地道点，要
: 发表在CARBON
: 上。但是俺是aerospace行当的，没看过化学专业的paper。偶同学的paper通篇都是过
: 去式，尤其是
: 在experimental这一节。
: 是不是化学专业的paper在描述实验数据、结果或是过程的时候都是用过去式呢？学术
: 文章，至少在
: aerospace一般都是用的现在式，不想想当然的把人家的时态给改了，恳请这个版块上
: 的专家给偶这个
: 外行指点一下迷津。谢谢了先，大牛请轻拍砖。

c*n2010-08-14 07:08

5 楼

but since the data is a HUGE (probably 300 nodes ) object graph,
probably inserting just one entry in a table would require us to put in
all the associated objects , constrained by foreign keys.
essentially we'd have to keep the entire DB dump for every release of the
test code.
true, this db dump can be very small, for derby or something

【在 g*****g 的大作中提到】

: Use an embeded DB for testing purpose, clean and populate test data for
: each test case.

j*d2010-08-14 07:08

6 楼

谢谢！

g*g2010-08-14 07:08

7 楼

Populate just enough data for testing purpose, you don't need to
maintain the test data between tests, that's what a unit test
is supposed to be. If that's not feasible, you are looking into
external DB depnedency and integration test instead.

【在 c******n 的大作中提到】

: but since the data is a HUGE (probably 300 nodes ) object graph,
: probably inserting just one entry in a table would require us to put in
: all the associated objects , constrained by foreign keys.
: essentially we'd have to keep the entire DB dump for every release of the
: test code.
: true, this db dump can be very small, for derby or something

c*n2010-08-14 07:08

8 楼

actually sometimes we need to go back to a previous version (back out some
changes), then if you don't keep the data source (a db dump ) in svn, when
you back out later changes, the old tests will fail

【在 g*****g 的大作中提到】

: Populate just enough data for testing purpose, you don't need to
: maintain the test data between tests, that's what a unit test
: is supposed to be. If that's not feasible, you are looking into
: external DB depnedency and integration test instead.

g*g2010-08-14 07:08

9 楼

That's why you keep the schema and the data with the tests.
Different tests can use different schema and data if you wish.

【在 c******n 的大作中提到】

: actually sometimes we need to go back to a previous version (back out some
: changes), then if you don't keep the data source (a db dump ) in svn, when
: you back out later changes, the old tests will fail

S*h2010-08-14 07:08

10 楼

There is a tool called dbunit. It can export the data (maybe also schema)
from database as xml and repopulate the database. Probably it can stand
for some schema change. http://www.dbunit.org/. It might be useful for you.

【在 c******n 的大作中提到】

c*n2010-08-14 07:08

11 楼

pretty neat, thanks!

【在 S****h 的大作中提到】

: There is a tool called dbunit. It can export the data (maybe also schema)
: from database as xml and repopulate the database. Probably it can stand
: for some schema change. http://www.dbunit.org/. It might be useful for you.

r*s2010-08-14 07:08

12 楼

理论上是个好办法，
实践上
maintaining the seed data is a headache,
especially with multiple types of dbs.
adding another db, like derby, becomes
a burden to both devs and dba, what made
it worse was that derby differs from other
dbs like mysql in some behaviors
(transaction? i forgot) and thus the unit tests
thread with the embedded db were evetually
abandoned.

【在 g*****g 的大作中提到】

: Use an embeded DB for testing purpose, clean and populate test data for
: each test case.