IRC Chat : 2012-11-25 - OpenMRS

03:05:49 *** lh has quit IRC
03:08:30 *** djazayeri has joined #openmrs
03:08:30 *** ChanServ sets mode: +o djazayeri
03:50:17 *** djazayeri1 has joined #openmrs
03:53:57 *** djazayeri has quit IRC
04:04:36 *** ishara has joined #openmrs
04:23:38 <ishara> hi Wyclif you here?
04:52:58 *** harshadura_ has joined #openmrs
04:56:30 *** harshadura has quit IRC
05:27:09 *** tobin_g has joined #openmrs
05:46:56 *** tobin_g has quit IRC
06:11:21 *** OpenMRSBot has joined #openmrs
06:11:21 *** zelazny.freenode.net sets mode: +ns
06:11:21 -zelazny.freenode.net- [freenode-info] if you're at a conference and other people are having trouble connecting, please mention it to staff: http://freenode.net/faq.shtml#gettinghelp
06:11:26 *** basic has joined #openmrs
06:22:09 *** zelazny.freenode.net sets mode: -o OpenMRSBot
06:22:09 -zelazny.freenode.net- *** Notice -- TS for #openmrs changed from 1353823881 to 1174073069
06:22:09 *** zelazny.freenode.net sets mode: +ct-s
06:22:09 *** Iome has joined #openmrs
06:22:09 *** Echidna has joined #openmrs
06:22:09 *** wluyima has joined #openmrs
06:22:09 *** djazayeri1 has joined #openmrs
06:22:09 *** harshadura_ has joined #openmrs
06:22:09 *** Mkop has joined #openmrs
06:22:09 *** zelazny.freenode.net sets mode: +vv Echidna Mkop
06:22:09 *** zelazny.freenode.net changes topic to "OpenMRS: open source medical record systems for the developing world - http://openmrs.org/ - IRC info & logs: http://go.openmrs.org/irc - Can't find the answer here? Try http://answers.openmrs.org/"
06:22:11 *** basic has quit IRC
06:22:11 *** basic has joined #openmrs
06:34:30 *** ishara has joined #openmrs
06:38:51 *** ishara has quit IRC
06:38:51 *** ishara has joined #openmrs
06:51:30 *** dkayiwa has joined #openmrs
07:45:38 *** dkayiwa has quit IRC
07:47:28 *** ishara has quit IRC
07:55:21 *** lh has joined #openmrs
07:59:09 *** dkayiwa has joined #openmrs
08:05:13 *** dkayiwa has quit IRC
08:07:51 *** dkayiwa has joined #openmrs
08:44:36 *** harshadura has joined #openmrs
08:47:10 *** harshadura_ has quit IRC
08:53:32 *** dkayiwa has quit IRC
08:57:41 *** robbyoconnor has joined #openmrs
08:57:41 *** ChanServ sets mode: +v robbyoconnor
09:56:53 *** djazayeri1 has quit IRC
10:08:25 *** tobin_g has joined #openmrs
10:10:29 *** tobin_g has quit IRC
10:13:57 *** tobin_g has joined #openmrs
10:31:34 *** tobin_g has quit IRC
10:50:06 *** rafa has joined #openmrs
10:50:06 *** ChanServ sets mode: +v rafa
11:40:11 *** yony258 has joined #openmrs
12:20:44 *** rafa has quit IRC
13:35:00 *** rafa has joined #openmrs
13:35:00 *** ChanServ sets mode: +v rafa
13:41:22 *** ishara has joined #openmrs
13:50:39 *** rafa has quit IRC
13:56:42 *** yony258 has quit IRC
13:58:59 *** applecool has joined #openmrs
13:58:59 *** ChanServ sets mode: +v applecool
14:45:42 *** ishara has quit IRC
14:58:11 *** yony258 has joined #openmrs
15:24:13 *** yony258_ has joined #openmrs
15:29:37 *** yony258 has quit IRC
15:30:27 *** yony258_ has quit IRC
16:42:45 *** applecool has quit IRC
16:44:54 *** lh has quit IRC
16:45:20 *** lh has joined #openmrs
18:53:36 *** rafa has joined #openmrs
18:53:36 *** ChanServ sets mode: +v rafa
18:59:12 *** yony258 has joined #openmrs
19:14:21 <yony258> Hi guys, I need some help with liquibase if anyone can. :)
19:22:57 *** yony258 has quit IRC
19:30:06 *** yony258 has joined #openmrs
19:40:17 *** djazayeri has joined #openmrs
19:40:17 *** ChanServ sets mode: +o djazayeri
19:42:50 *** dkayiwa has joined #openmrs
20:12:37 <yony258> dkayiwa: Hi
20:12:45 <dkayiwa> yony258: hi
20:13:10 <yony258> dkayiwa: Hows it going?
20:13:59 <dkayiwa> yony258: just come back from a friend's wedding :)
20:14:35 <yony258> dkayiwa: Oh nice, Well I had a question but I think I Lluis solved it :]
20:15:42 <dkayiwa> yony258: oh great
20:15:51 <dkayiwa> can you report back on the dev list? :)
20:16:26 <yony258> dkayiwa: Sure im just checking if it was the problem
20:16:56 <dkayiwa> yony258: ok
20:21:56 <yony258> dkayiwa: Still doesn't work
20:22:05 <yony258> dkayiwa: Let me try clean install
20:22:09 <dkayiwa> yony258: ok
20:24:34 <yony258> dkayiwa: Is something wrong in the middle line here?
20:24:35 <yony258> <addForeignKeyConstraint constraintName="appointment_block_creator" baseTableName="appointment_appointment_block" baseColumnNames="creator" referencedTableName="users" referencedColumnNames="user_id"/>
20:24:46 <yony258> dkayiwa: sry third line
20:26:05 <dkayiwa> yony258: no
20:26:22 <yony258> dkayiwa: I'll post the log at the devlist
20:28:18 <dkayiwa> yony258: just send pastebin link to the dev list
20:28:37 <dkayiwa> yony258: that way those with poor connections do not suffer opening email :)
20:29:04 <yony258> dkayiwa: Yea sure, Done
20:31:23 *** harshadura has quit IRC
20:31:53 <dkayiwa> yony258: can you push your changes such that i can test them on my computer?
20:32:09 <yony258> sure
20:34:44 <yony258> dkayiwa: done
20:34:52 <dkayiwa> yony258: ok let me pull
20:38:23 *** lh has quit IRC
20:45:56 <dkayiwa> yony258: what did you add to cause this?
20:52:14 <yony258> dkayiwa: Even when I tried to run just without my code it provided a similar error
20:53:05 <dkayiwa> yony258: what is the primary key for the appointment_appointment_has_status table?
20:53:23 <yony258> both of the foreign keys
20:54:32 <dkayiwa> yony258: the convention we use is to create single field primary key
20:54:38 *** rafa has quit IRC
20:54:44 <dkayiwa> yony258: like you have been doing for the other tables
20:54:48 <yony258> dkayiwa: So what do you do for link tables?
20:55:15 <dkayiwa> yony258: you do foreign key constraints
20:55:41 <yony258> dkayiwa: so an identifier (auto increment) will fix that right?
20:56:04 <dkayiwa> yony258: that was just a side comment. may not be the fix for your problem :)
20:56:50 <yony258> dkayiwa: Oh ok, related to this, what if I want to enforce that an appointment cant have the same status more than once, add a trigger?
20:58:31 <dkayiwa> yony258: no
20:58:40 <dkayiwa> yony258: a unique key constraint :)
20:59:06 <yony258> dkayiwa: Ok, can you show me an example for that table when you have time?
20:59:38 <dkayiwa> yony258: an example of a unique key constraint?
21:00:17 <yony258> dkayiwa: yea on the appointment_appointment_has_status table on the fields appointment_id and status_id
21:02:03 <dkayiwa> yony258: http://www.liquibase.org/manual/add_unique_constraint
21:04:37 *** yony258 has quit IRC
21:31:05 *** rafa has joined #openmrs
21:31:05 *** ChanServ sets mode: +v rafa
22:08:31 *** yony258 has joined #openmrs
22:08:44 <yony258> dkayiwa: How can I get the liquibase xsd?
22:10:54 *** dkayiwa has quit IRC
22:11:03 *** dkayiwa has joined #openmrs
22:24:38 *** lh has joined #openmrs
22:24:38 *** lh has joined #openmrs
22:26:48 *** lh has quit IRC
22:27:14 *** lh has joined #openmrs
22:27:32 *** yony258 has quit IRC
22:29:22 *** r0bby has joined #openmrs
22:29:22 *** ChanServ sets mode: +v r0bby
22:32:50 *** rafa has quit IRC
22:32:58 *** robbyoconnor has quit IRC
22:34:18 *** r0bby is now known as robbyoconnor
22:44:51 *** lhawthor_ has joined #openmrs
22:49:09 *** dkayiwa has quit IRC
22:49:37 *** lhawthor_ has quit IRC
23:56:34 *** djazayeri has quit IRC