unit testing - Fluent NHibernate - PersistenceSpecification of HiLo scheme -

-

not sure if i'm asking right question please bear me! bit of nhibernate noob.

we're using fluent nh , have following id generation scheme tables

public class idgenerationconvention : iidconvention {     public void apply(iidentityinstance instance)     {         var = string.format("tablekey = '{0}'", instance.entitytype.name);         instance.generatedby.hilo("hiloprimarykeys", "nexthighvalue", "1000", x => x.addparam("where", where));     } }

we have sql script generates hiloprimarykeys table , seeds data gets run during deployment. working fine.

i'm trying write unit tests verify our persistence layer, ideally using sqlite in memory configuration speed. how configure nh tests:

[setup] public void setupcontext() {     config = new sqliteconfiguration()             .inmemory()             .showsql()             .raw("hibernate.generate_statistics", "true");      var nhconfig = fluently.configure()             .database(persistenceconfigurer)             .mappings(mappings =>                  mappings.fluentmappings.addfromassemblyof<documentmap>()             .conventions.addfromassemblyof<idgenerationconvention>());      sessionsource = new sessionsource(nhconfig);     session = sessionsource.createsession();     sessionsource.buildschema(session); }

the problem don't know how tell nhibernate our deployment script generates correct schema , seed data during tests.

the specific problem when running following persistencespecification test:

[test] public void shouldadddocumenttodatabasewithsimplevalues() {     new persistencespecification<document>(session)             .checkproperty(x => x.createdby, "anonymous")             .checkproperty(x => x.createdon, new datetime(1954, 12, 23))             .checkproperty(x => x.reference, "anonymous")             .checkproperty(x => x.ismigrated, true)             .checkreference(x => x.documenttype, documenttype)             .verifythemappings(); }

which throws following exception:

testcase ... failed:  execute nhibernate.exceptions.genericadoexception:          not or update next value[sql: ]          ---> system.data.sqlite.sqliteexception: sqlite error         no such column: tablekey

so deduction hasn't run deployment script when checking persistence spec.

is there existing solution situation? google-fu seems have deserted me on one.

as brian said, can run deployment script after schema built. code works me:

var config = new sqliteconfiguration()         .inmemory()         .showsql()         .raw("hibernate.generate_statistics", "true");  var nhconfig = fluently.configure()         .database(config)         .mappings(mappings =>              mappings.fluentmappings.addfromassemblyof<documentmap>()         .conventions.addfromassemblyof<idgenerationconvention>());  var sessionsource = new sessionsource(nhconfig); var session = sessionsource.createsession(); sessionsource.buildschema(session);  // run deployment script var deploymentscriptquery = session.createsqlquery("alter table hiloprimarykeys add column tablekey varchar(255); insert hiloprimarykeys (tablekey, nexthighvalue) values ('document', 1);"); deploymentscriptquery.executeupdate();

the deployment script loaded file etc...

building fnh configuration , database schema time consuming action. execution of test suit take unacceptable amount of time if count of tests using schema grows , schema , configuration built each test class. both configuration , schema should shared between tests. here how achieve without loosing test isolation.

edit: if more 1 session instance required in test connection pooling should turned on, or both sessions should created via same connection. details here...


Comments

Post a Comment

Popular posts from this blog

how to build hyperlink for query string in php -

-
i have question, how can add variable in current url book.php?action=addressbook i want add book.php?action=addressbook&page=2 how generate hyperlink this, have tried using $_server['php_self'] query string not included in url showing that book.php?page=2 i want append other variables query string please you can use http_build_query(); append more params url $params = $_get; $params["item"] = 45; $new_query_string = http_build_query($params); for instance: $data = array('page'=> 34, 'item' => 45); echo http_build_query($data); //page=34&item=45 or include amp echo http_build_query($data, '', '&amp;'); //page=34&amp;&item=45
Read more

php - What is the difference between $_SERVER['PATH_INFO'] and $_SERVER['ORIG_PATH_INFO']? -

-
what’s difference between $_server['path_info'] , $_server['orig_path_info'] ? how use them? when run print_r($_server) , path_info , orig_path_info not present in array. why not? how can enable them? i have read php manual on them, still don’t understand them. the path_info variable present if invoke php script this: http://www.example.com/phpinfo.php/hello_there it's /hello_there part after .php script. if don't invoke url that, there won't $_server["path_info"] environment variable. the porig_ prefix uncommon. path_info standard cgi-environment variable, , should never prefixed. did read that? (there issues around php3/php4 if invoked php interpreter via cgi-bin/ - hardly has such setups today.) for reference: http://www.ietf.org/rfc/rfc3875
Read more

queue - mq_receive: message too long -

-
i implementing communication between 2 processes using queue. problem when call function mq_receive, error: message long. i have done following: struct mq_attr attr; long size = attr.mq_msgsize; .... // initializing queue "/gateway" int rc = mq_receive(gateway, buffer, size, &prio); if print size value, size=1, while when print same size program (got same mechanism), not long integer ( -1217186280 )... how can solve error?....so while size = 1, believe it's right "message long" why 1? p.s. have tried put : int rc = mq_receive(gateway, buffer, sizeof(buffer), &prio); but no result. it seems need read docs more carefully. when call mq_receive should pass size of destination buffer. this size must greater mq_msgsize attribute of queue . in addition, seems have error in queue attributes initialisation makes proper mq_receive call impossible. here standard message queue session: fill mq_attr struct ( doc ): struct mq_a...
Read more