IRC Chat : 2014-01-15 - OpenMRS

00:35:43 *** upul has joined #openmrs
01:17:13 *** harshadura_ has joined #openmrs
01:17:14 *** harshadura has joined #openmrs
01:17:14 *** harshadura__ has joined #openmrs
01:17:15 *** ChanServ sets mode: +v harshadura
02:06:26 *** aka_007 has joined #openmrs
02:07:44 <aka_007> Hie... I am a second year undergrad from IIIT hyderabad.... I want to work for openMRS for GSOC'14.... how should i proceed.. plz help
02:14:00 <aka_007> ??
02:17:03 <upul> aka_007: check this out from last year, https://wiki.openmrs.org/display/RES/Summer+Of+Code+2013#SummerOfCode2013-ApplicationTips
02:20:41 <aka_007> upul thanx for the link..... checking it out.. last question.... at first we need to solve the tickets mainly and get familiar with the code,r8?
02:20:53 *** harshadura_ has quit IRC
02:21:02 *** harshadura has quit IRC
02:21:07 *** harshadura_ has joined #openmrs
02:21:25 *** harshadura__ has quit IRC
02:21:51 <upul> aka_007: that will show the community you can do stuff, so you'll have a better chance getting selected
02:21:57 *** harshadura has joined #openmrs
02:21:57 *** ChanServ sets mode: +v harshadura
02:21:58 *** harshadura__ has joined #openmrs
02:22:11 <aka_007> upul okae....!
02:34:49 *** aka_007 has quit IRC
02:38:01 *** dkithmal has quit IRC
02:55:05 *** dkithmal has joined #openmrs
03:10:54 *** dkithmal has quit IRC
03:11:17 *** dkithmal has joined #openmrs
03:18:28 *** rday has joined #openmrs
03:24:42 *** wluyima has joined #openmrs
03:36:22 *** rday has quit IRC
03:36:48 *** rday has joined #openmrs
03:38:34 *** wluyima_ has joined #openmrs
03:38:45 *** wluyima has quit IRC
03:38:45 *** wluyima_ is now known as wluyima
03:41:01 *** vinayv has joined #openmrs
04:28:02 *** dkithmal has quit IRC
04:54:26 *** rday has quit IRC
04:54:50 *** rday has joined #openmrs
05:07:27 *** dkithmal has joined #openmrs
05:28:15 *** harsz89 has quit IRC
05:34:38 *** geekgugi has joined #openmrs
05:34:47 *** wluyima has quit IRC
05:35:45 *** wluyima has joined #openmrs
05:37:56 *** wluyima has quit IRC
05:39:47 *** harsz89 has joined #openmrs
05:39:47 *** ChanServ sets mode: +v harsz89
05:56:02 *** upul has quit IRC
05:59:53 *** dkithmal has quit IRC
06:04:49 *** dkithmal has joined #openmrs
06:46:55 *** Ch3ck_ has joined #openmrs
07:34:28 *** dkithmal has quit IRC
07:35:32 *** rday has quit IRC
07:50:40 *** davidpardz has quit IRC
07:51:44 *** dkayiwa has joined #openmrs
08:02:15 <OpenMRSBot> Recent updates in the world of openmrsci: REFAPP-DEMO-98 has FAILED : Scheduled build <https://ci-stg.openmrs.org/browse/REFAPP-DEMO-98>
08:08:42 *** k-joseph has joined #openmrs
08:12:01 *** dkithmal has joined #openmrs
08:34:11 *** geekgugi has quit IRC
08:35:50 *** GitHub97 has joined #openmrs
08:35:50 <GitHub97> [openmrs-core] lrozanski opened pull request #535: TRUNK-3974: ConceptNumeric(concept) incorrectly copies collections (1.9.x...TRUNK-3974) http://git.io/1_wKnQ
08:35:50 *** GitHub97 has left #openmrs
08:47:05 *** djazayeri has quit IRC
08:48:37 *** GitHub115 has joined #openmrs
08:48:38 <GitHub115> [openmrs-core] dkayiwa closed pull request #520: TRUNK-2147: Double quote truncate error (master...TRUNK-2147) http://git.io/rbB_-Q
08:48:38 *** GitHub115 has left #openmrs
08:48:38 *** GitHub13 has joined #openmrs
08:48:38 <GitHub13> [openmrs-core] dkayiwa pushed 4 new commits to master: http://git.io/vogq4Q
08:48:38 <GitHub13> openmrs-core/master 2d42268 madawa-rc: TRUNK-2147: Changed html input text to spring:message
08:48:38 <GitHub13> openmrs-core/master a2f9ed3 madawa-rc: TRUNK-2147: Fixed property name truncate error
08:48:38 <GitHub13> openmrs-core/master aebca23 madawa-rc: TRUNK-2147: Svae message fixed
08:48:38 *** GitHub13 has left #openmrs
08:50:59 *** djazayeri has joined #openmrs
08:50:59 *** ChanServ sets mode: +o djazayeri
08:59:12 *** travis-ci has joined #openmrs
08:59:12 <travis-ci> [travis-ci] [openmrs/openmrs-core] [6603102] [dkayiwa] The build was fixed. - http://travis-ci.org/openmrs/openmrs-core/builds/16983071
08:59:12 *** travis-ci has left #openmrs
08:59:54 *** k-joseph has quit IRC
09:13:06 *** GitHub127 has joined #openmrs
09:13:06 <GitHub127> [openmrs-core] dkithmal opened pull request #536: Trunk 2218 (master...TRUNK-2218) http://git.io/d_SNmA
09:13:06 *** GitHub127 has left #openmrs
09:14:09 *** dkithmal has quit IRC
09:14:59 *** dkithmal has joined #openmrs
09:21:23 *** geekgugi has joined #openmrs
09:26:56 *** AK_ has joined #openmrs
09:29:05 *** AK_ has left #openmrs
09:30:47 *** Akshika47 has joined #openmrs
09:30:52 <Akshika47> Hi
09:31:17 <Akshika47> Anyone Knows intelliJ IDE
09:31:40 <dkayiwa> Akshika47: i use eclipse :)
09:32:09 <Akshika47> hope there isn't much of difference
09:32:35 <dkayiwa> Akshika47: just enough difference to make you for one instead of the other :)
09:32:56 <dkayiwa> just enough difference to make you go for one instead of the other
09:32:56 <Akshika47> :)
09:34:21 <Akshika47> As u commented in my GitHub
09:34:34 <Akshika47> it seems like my source code is not up to date
09:35:22 <dkayiwa> Akshika47: you need to type my name everytime you type, if you need my irc client to alert me :)
09:35:23 <Akshika47> is there a way to check that. I clicked update project button. It says all files are up to date
09:36:05 <Akshika47> dkayiwa
09:36:20 <Akshika47> @dkayiwa
09:36:42 <Akshika47> is it alerting u?
09:37:23 <dkayiwa> Akshika47: i use command line for all my git operations
09:37:34 <dkayiwa> Akshika47: i do not trust IDE git plugins
09:37:54 <dkayiwa> Akshika47: did you read this page? https://wiki.openmrs.org/display/docs/Using+Git
09:39:21 *** dkithmal has quit IRC
09:39:26 <Akshika47> dkayiwa yeah. it seems I have the same problem. when made the push and clicked to make the merge & pull request.it says "There isn't anything to compare. openmrs:master and akshika47:Trunk_2136.1 are entirely different commit histories."
09:39:38 *** dkithmal has joined #openmrs
09:39:48 <dkayiwa> Akshika47: are you using command line?
09:40:08 <Akshika47> dkayiwa No I was using the IDE integration
09:40:21 <dkayiwa> Akshika47: i trust command line more :)
09:40:43 <Akshika47> dkayiwa looks like it is better to go with the cmd.
09:42:12 <Akshika47> dkayiwa thank u for your help.so it is okay to edit in Intellij and use to push and pull
09:42:31 <dkayiwa> Akshika47: yes
09:42:31 *** GitHub35 has joined #openmrs
09:42:31 <GitHub35> [openmrs-core] dkayiwa closed pull request #536: Trunk 2218 (master...TRUNK-2218) http://git.io/d_SNmA
09:42:32 *** GitHub35 has left #openmrs
09:42:32 *** GitHub65 has joined #openmrs
09:42:32 <GitHub65> [openmrs-core] dkayiwa pushed 14 new commits to master: http://git.io/uQvA9Q
09:42:32 <GitHub65> openmrs-core/master be8d7be dkithmal: TRUNK-2218: remove direct method calls in CohortServiceImpl class
09:42:32 <GitHub65> openmrs-core/master 7a3af31 dkithmal: TRUNK-2218: remove direct method calls in ConceptServiceImpl class
09:42:32 <GitHub65> openmrs-core/master 85492da dkithmal: TRUNK-2218: remove direct method calls in EncounterServiceImpl class
09:42:32 *** GitHub65 has left #openmrs
09:43:21 <Akshika47> dkayiwa thank u I will try that and let you know the progress
09:43:21 <Akshika47> :)
09:43:29 <dkayiwa> Akshika47: sure :)
09:45:25 *** dkithmal has quit IRC
09:49:44 <Akshika47> dkayiwa why would this kind of an error message come in CMD "error: refs/heads/Trunk_2136 does not point to a valid object! error: refs/heads/master does not point to a valid object! error: refs/remotes/origin/Trunk_2136 does not point to a valid object! fatal: unable to access 'https://github.com/openmrs/openmrs-core.git/': Failed c onnect to github.com:3128; No error"
09:50:19 <Akshika47> dkayiwa git pull --rebase upstream master
09:50:39 <Akshika47> dkayiwa this is the line I entered in cmd
09:51:38 <dkayiwa> Akshika47: did you read all that wiki page i sent you?
09:53:33 *** travis-ci has joined #openmrs
09:53:33 <travis-ci> [travis-ci] [openmrs/openmrs-core] [a553303] [dkayiwa] The build passed. - http://travis-ci.org/openmrs/openmrs-core/builds/16985390
09:53:33 *** travis-ci has left #openmrs
09:54:39 <Akshika47> dkayiwa. I was going through that typing the code lines. I came across this error
09:54:39 <Akshika47> :(
09:55:10 <dkayiwa> Akshika47: which error and for which command
09:55:22 *** k-joseph has joined #openmrs
09:55:47 <Akshika47> dkayiwa why would this kind of an error message come in CMD "error: refs/heads/Trunk_2136 does not point to a valid object! error: refs/heads/master does not point to a valid object! error: refs/remotes/origin/Trunk_2136 does not point to a valid object! fatal: unable to access 'https://github.com/openmrs/openmrs-core.git/': Failed c onnect to github.com:3128; No error"
09:56:06 <Akshika47> dkayiwa : this is the error
09:56:12 <dkayiwa> Akshika47: which command
09:56:25 <Akshika47> dkayiwa : dkayiwa git pull --rebase upstream master
09:57:03 <dkayiwa> Akshika47: did you run the command for orgin master on that wiki page?
10:00:10 *** GitHub18 has joined #openmrs
10:00:10 <GitHub18> [openmrs-core] dkayiwa pushed 1 new commit to master: http://git.io/IFW9qA
10:00:10 <GitHub18> openmrs-core/master 9b69342 dkayiwa: Doing some file formatting
10:00:10 *** GitHub18 has left #openmrs
10:00:35 <Akshika47> dkayiwa: what do u mean origin master. ?
10:01:02 <dkayiwa> Akshika47: have you taken a look at the wiki page?
10:01:38 <Akshika47> dkayiwa: I read it. but not everything, wait I will read to the bottom :)
10:02:11 <dkayiwa> Akshika47: you do not have to do everything there, but atl east read it all to know when you will need which :)
10:02:41 <Akshika47> dkayiwa: yeah yeah I understand
10:12:59 *** travis-ci has joined #openmrs
10:13:00 <travis-ci> [travis-ci] [openmrs/openmrs-core] [9b69342] [dkayiwa] The build passed. - http://travis-ci.org/openmrs/openmrs-core/builds/16985995
10:13:00 *** travis-ci has left #openmrs
10:14:53 *** dkayiwa has quit IRC
10:15:25 *** Ch3ck_ has quit IRC
10:22:51 <OpenMRSBot> Recent updates in the world of openmrsci: RDD-RDD-306 has FAILED (3 tests failed) : Dependant of EMRAPI-EMRAPI-391 <https://ci-stg.openmrs.org/browse/RDD-RDD-306>
10:26:52 <OpenMRSBot> Recent updates in the world of openmrsci: CA-CA-593 has FAILED (6 tests failed) : Dependant of EMRAPI-EMRAPI-391 <https://ci-stg.openmrs.org/browse/CA-CA-593>
10:31:40 *** harsz89 has quit IRC
10:34:53 <OpenMRSBot> Recent updates in the world of openmrsci: HFEUI-HFEUI-272 has FAILED (9 tests failed) : Dependant of APPUI-APPUI-278 <https://ci-stg.openmrs.org/browse/HFEUI-HFEUI-272>
10:37:05 *** harshadura has quit IRC
10:37:05 *** harshadura_ has quit IRC
10:37:14 *** harshadura has joined #openmrs
10:37:18 *** ChanServ sets mode: +v harshadura
10:37:30 *** harshadura__ has quit IRC
10:37:52 *** harshadura__ has joined #openmrs
10:37:53 *** harshadura_ has joined #openmrs
10:44:50 <OpenMRSBot> Recent updates in the world of openmrsci: REFAPP-OMODDISTRO-1623 has FAILED : Dependant of CA-CA-594 <https://ci-stg.openmrs.org/browse/REFAPP-OMODDISTRO-1623>
10:51:16 *** harshadura__ has quit IRC
10:51:20 *** harshadura has quit IRC
11:03:00 *** harshadura has joined #openmrs
11:03:00 *** ChanServ sets mode: +v harshadura
11:06:43 *** harshadura_ has quit IRC
11:10:11 *** GitHub147 has joined #openmrs
11:10:11 <GitHub147> [openmrs-core] rkorytkowski pushed 1 new commit to 1.10.x: http://git.io/a4hrVw
11:10:11 <GitHub147> openmrs-core/1.10.x b130616 Rafal Korytkowski: TRUNK-4143 Fixing build
11:10:11 *** GitHub147 has left #openmrs
12:28:00 *** angshuonline has joined #openmrs
12:38:15 <angshuonline> all: I have 2 classes implementing a common interface. Both these classes are identified by component scan. These classes specify a spring qualifer (e.g "numberBased", "timeBased").
12:38:16 <angshuonline> The interface and implementations are present in a omod.
12:38:17 <angshuonline> Other classes need to autowire the interface dependency in the constructor using the qualifier name. They mention requirement to the previous omod in config.xml
12:38:18 <angshuonline> However, while autowiring they throw up error as unresolved dependency, saying no instance exists for the qualifier.
12:48:46 <angshuonline> basically, all I want to do is expose simple spring beans from an omod, and use them in another omod.
12:53:06 *** k-joseph has quit IRC
12:58:11 *** geekgugi has quit IRC
13:14:50 *** wluyima has joined #openmrs
13:50:08 *** cioan has joined #openmrs
14:11:09 *** dkayiwa has joined #openmrs
14:12:42 *** harshadura_ has joined #openmrs
14:21:35 *** k-joseph has joined #openmrs
14:22:35 *** angshuonline has quit IRC
14:22:38 *** vinayv has quit IRC
14:58:34 <k-joseph> dkayiwa: hi
14:58:59 *** Akshika47 has quit IRC
15:00:36 <dkayiwa> k-joseph: hi
15:03:04 <k-joseph> dkayiwa: i have some issue that is taking me long solving, that is here is my changeset http://pastebin.com/W58JYupD and this is resulting into http://pastebin.com/6dj0RGXR failure, when i manually run the query i run into a #1452 - Cannot add or update a child row: a foreign key constraint fails
15:03:23 <dkayiwa> k-joseph: where did we stop yesterday?
15:04:09 <k-joseph> dkayiwa: yesturday we stopped while resolving the uuid method issue, that i have fixed
15:04:23 <cpower> Hello!
15:04:28 <cpower> Are we ready to scrum?
15:04:32 <cpower> !scrumon cpower
15:04:32 * OpenMRSBot says the DAILY SCRUM MEETING is STARTING. This meeting should not last longer than 15 minutes. Please hold other comments until the end of the meeting, or message someone privately. Thank you! ScrumMaster cpower- you may begin when ready.
15:04:49 <cpower> Order: wluyima , rafa , dkayiwa , djazayeri
15:07:39 <wluyima> Tuesday:
15:07:40 <wluyima> - Code reviews ane merging pull requests
15:07:41 <wluyima> - Order entry bi weekly call
15:07:43 <wluyima> - Code cleanups
15:07:44 <wluyima> Wednesday:
15:07:46 <wluyima> - PM Call
15:07:47 <wluyima> - Design call
15:07:49 <wluyima> - More code reviews
15:07:50 <wluyima> - Address review comments for
15:07:51 <wluyima>
15:07:52 <wluyima> Blockers: None
15:09:51 <rafa> Today:
15:09:51 <rafa> * Fixed openmrs-core build
15:09:51 <rafa> * Presented at the OpenMRS University
15:09:51 <rafa> * Worked on TRUNK-3644
15:09:51 <rafa> Define which resources to load for module based on OpenMRS version
15:09:52 <rafa> https://tickets.openmrs.org/browse/TRUNK-3644
15:09:52 <rafa> (working on htmlformentry implementation)
15:09:53 <rafa> No blockers.
15:10:11 <dkayiwa> Been doing code reviews and merging
15:10:11 <dkayiwa> Ticket management tasks (un assigning where necessary, checking on progress status, etc)
15:10:12 <dkayiwa> Will be on the Design Call and continuing with code reviews
15:10:12 <dkayiwa> No Blockers
15:11:53 *** dkithmal has joined #openmrs
15:20:34 *** aka_007 has joined #openmrs
15:22:21 <dkayiwa> k-joseph: so is this a new problem?
15:23:22 <k-joseph> dkayiwa: it is, it is emerging from my changes!!!
15:24:04 <dkayiwa> k-joseph: does the query run well in phpadmin?
15:24:56 <k-joseph> dkayiwa: it results into a foreign key constraint failure
15:25:29 <dkayiwa> k-joseph: did you fix that?
15:28:07 *** aka_007 has quit IRC
15:30:15 *** vinayv has joined #openmrs
15:30:34 <k-joseph> dkayiwa: i have tried and it was in vain so far
15:30:55 <cpower> !scrumoff
15:30:55 * OpenMRSBot says the DAILY SCRUM MEETING has ENDED. This channel is now returned to normal hacking operations. Post-scrum meeting follow-up conversations may now begin.
15:31:07 *** harsz89 has joined #openmrs
15:31:07 *** ChanServ sets mode: +v harsz89
15:31:56 <dkayiwa> k-joseph: pastebin the phpadmin sql
15:33:23 <k-joseph> dkayiwa: http://pastebin.com/THYuH4iA
15:34:00 <dkayiwa> k-joseph: also pastebin the phpadmin error message
15:35:27 <k-joseph> dkayiwa: http://pastebin.com/8HXRcPYt
15:36:41 <dkayiwa> k-joseph: which value are you inserting for person_id?
15:37:32 <k-joseph> dkayiwa: it is the result of runing the sql query
15:37:53 <k-joseph> dkayiwa: 'SELECT orderer FROM orders WHERE orders.orderer IS NOT NULL AND orders.orderer NOT IN (SELECT provider_id FROM provider)'
15:38:07 <dkayiwa> k-joseph: since it is in quotes, i think i will insert the whole of that text
15:38:15 <dkayiwa> k-joseph: does that make sense?
15:38:30 <k-joseph> dkayiwa: it does make sence
15:40:25 <k-joseph> dkayiwa: with out the ' quotes, the query is misinterpred i think
15:40:59 <dkayiwa> k-joseph: which means the query is not correctly written
15:41:42 <k-joseph> dkayiwa: ok, in which way then is i t to be corrected!!!
15:42:01 <dkayiwa> k-joseph: what is the query trying to do?
15:43:40 *** rday has joined #openmrs
15:44:14 <k-joseph> dkayiwa: it is entering the orderer into provider table or creating provider accounts for users who have placed orders for patients
15:45:08 <dkayiwa> k-joseph: which ticket?
15:45:29 <k-joseph> dkayiwa: TRUNK-4202
15:48:01 <dkayiwa> !ticket TRUNK-4202
15:48:02 <OpenMRSBot> dkayiwa: [#TRUNK-4202] Convert Order.orderer to be a Provider - OpenMRS JIRA - https://tickets.openmrs.org/browse/TRUNK-4202
15:49:23 <dkayiwa> k-joseph: you can start by breaking it down into smaller parts
15:50:06 <dkayiwa> k-joseph: for instance you could start by writing sql for: all users have placed orders for patients and have no associated provider accounts
15:50:34 <dkayiwa> k-joseph: such that you have that simply listing all of them. When you get that correct, then we can proceed to the next part
15:51:16 <k-joseph> dkayiwa: ok,
15:52:14 <dkayiwa> k-joseph: that is a very important principle in software development. Attacking complexity by breaking it down into smaller sections :)
15:53:39 <k-joseph> dkayiwa: i guess i refer to the user that placed an order by refering to orders.orderer!!!
15:54:48 <dkayiwa> k-joseph: do what you think and we shall see
15:58:29 *** rday has quit IRC
16:00:19 *** aka_007 has joined #openmrs
16:00:46 <aka_007> hie guys I am a newbie in here... I am stuck in the phase of "Deploy OpenMRS"
16:00:58 <aka_007> I am in ubuntu so after downloading the file what should I do with it...
16:01:02 <aka_007> from this link https://wiki.openmrs.org/display/docs/Step+5+-+Deploy+OpenMRS
16:01:03 <OpenMRSBot> <http://ln-s.net/8dpK> (at wiki.openmrs.org)
16:01:47 <harsz89> hi aka_007
16:02:00 <harsz89> aka_007, did you downloaded the war file?
16:04:10 <aka_007> 1 minute remaining :P
16:04:29 <aka_007> it's .zip, r8??
16:04:37 <aka_007> @harsz89 ??
16:04:56 <harsz89> aka_007, openmrs.zip?
16:05:12 <aka_007> openmrs-standalone-1.9.7.zip
16:05:17 <aka_007> harsz89
16:05:35 <harsz89> ah then cool
16:05:47 <aka_007> what should I do now...
16:05:47 <harsz89> aka_007, you just need to run the jar file
16:05:47 <aka_007> ??
16:05:53 <aka_007> okae
16:05:58 <harsz89> java -jar openmrs-standalone.jar
16:06:08 <harsz89> through cmd
16:06:40 <aka_007> ohh okae... any specific folder in which it should be placed.. ??
16:07:28 <harsz89> nope
16:07:38 <harsz89> extract it and run it :)
16:08:19 <aka_007> harsz89 yaa did it.. which configuration should I choose for running it... Demonstration, starter, or expert mode??
16:09:03 <harsz89> aka_007, you can select either demo or starter
16:10:14 <aka_007> okae
16:10:39 *** GitHub130 has joined #openmrs
16:10:40 <GitHub130> [openmrs-core] dkayiwa closed pull request #535: TRUNK-3974: ConceptNumeric(concept) incorrectly copies collections (1.9.x...TRUNK-3974) http://git.io/1_wKnQ
16:10:40 *** GitHub130 has left #openmrs
16:10:40 *** GitHub94 has joined #openmrs
16:10:40 <GitHub94> [openmrs-core] dkayiwa pushed 2 new commits to 1.9.x: http://git.io/7G22bA
16:10:40 <GitHub94> openmrs-core/1.9.x 73feb3f Lech Rozanski: TRUNK-3974: ConceptNumeric(concept) incorrectly copies collections
16:10:40 <GitHub94> openmrs-core/1.9.x ea1c138 dkayiwa: Merge pull request #535 from lrozanski/TRUNK-3974...
16:10:40 *** GitHub94 has left #openmrs
16:25:07 *** aka_007 has quit IRC
16:25:47 *** wluyima has quit IRC
16:27:24 *** GitHub132 has joined #openmrs
16:27:24 <GitHub132> [openmrs-core] chelseakomlo closed pull request #534: person controller tests passing (master...person_controller_refactor_final) http://git.io/jTXxMQ
16:27:24 *** GitHub132 has left #openmrs
16:32:09 *** vinayv has quit IRC
16:38:32 *** howardf has joined #openmrs
16:38:45 *** Ch3ck_ has joined #openmrs
16:41:03 *** djazayeri has quit IRC
16:41:25 <k-joseph> dkayiwa: how do i know that a user has ordered for a patient?
16:42:06 <k-joseph> dkayiwa: technically!!!
16:43:34 <dkayiwa> k-joseph: what do you think?
16:45:47 *** GitHub84 has joined #openmrs
16:45:47 <GitHub84> [openmrs-core] dkayiwa pushed 1 new commit to master: http://git.io/WLYM_A
16:45:47 <GitHub84> openmrs-core/master 3808bfc dkayiwa: ConceptNumeric(concept) incorrectly copies collections - TRUNK-3974
16:45:47 *** GitHub84 has left #openmrs
16:46:01 <k-joseph> dkayiwa: where ordrers.patient_id is in select patient_id from patient
16:46:40 *** djazayeri has joined #openmrs
16:46:40 *** ChanServ sets mode: +o djazayeri
16:47:11 *** harshadura_ has quit IRC
16:47:12 *** harshadura has quit IRC
16:47:25 <dkayiwa> k-joseph: what do you mean by "user has ordered for a patient"?
16:47:58 <dkayiwa> k-joseph: when an order is made, in which table is the data stored?
16:49:08 <k-joseph> dkayiwa:i mean a user had placed an order for a patient, it is stored in the orders table,
16:49:28 <dkayiwa> k-joseph: so doesnt that answer your question? :)
16:50:27 <k-joseph> dkayiwa: what answer are u meaning
16:50:49 <dkayiwa> k-joseph: you asked how to know if an order has been placed for a patient. not so?
16:50:59 *** Ch3ck_ has quit IRC
16:51:37 <k-joseph> dkayiwa: that is it
16:52:16 <k-joseph> dkayiwa: so then what is the implied answer, is it it is stored in the orders table,
16:52:26 <dkayiwa> k-joseph: yes
16:53:19 <k-joseph> dkayiwa: can a user order for any other object besides a patient?
16:55:36 <dkayiwa> k-joseph: what are orders made for?
16:56:13 <dkayiwa> k-joseph: as in made for who?
16:57:03 <k-joseph> dkayiwa: patient, that is what i think, but saying a user had placed an order for a patient may also mean that a user can make an order for something else
16:57:58 <dkayiwa> k-joseph: for now deal with only what you know. That way you will not complicate things for yourself :)
16:58:13 <k-joseph> dkayiwa: ok
17:01:16 *** GitHub161 has joined #openmrs
17:01:16 <GitHub161> [openmrs-core] chelseakomlo opened pull request #537: refactored person controller to not use instance methods (master...final_person_controller_refactor) http://git.io/Ap9r1A
17:01:16 *** GitHub161 has left #openmrs
17:05:28 *** travis-ci has joined #openmrs
17:05:28 <travis-ci> [travis-ci] [openmrs/openmrs-core] [3808bfc] [dkayiwa] The build passed. - http://travis-ci.org/openmrs/openmrs-core/builds/17007446
17:05:28 *** travis-ci has left #openmrs
17:08:29 *** dkithmal has quit IRC
17:10:14 *** dkithmal has joined #openmrs
17:17:36 <k-joseph> dkayiwa: this is my query to get; all users who have placed orders for patients and have no associated provider accounts
17:17:55 <k-joseph> dkayiwa: select person_id from users where (person_id = (select orderer from orders)) and person_id not in (select person_id from provider)
17:24:08 <dkayiwa> k-joseph: let us break it down even further
17:24:09 <k-joseph> dkayiwa: hi
17:24:29 <dkayiwa> k-joseph: to just get all users who have placed orders for patients
17:25:13 <k-joseph> dkayiwa: select person_id from users where (person_id = (select orderer from orders))
17:25:53 <dkayiwa> k-joseph: what does the orderer field store?
17:26:08 <k-joseph> dkayiwa: it stores a user
17:26:22 <dkayiwa> k-joseph: who has done what?
17:26:40 <k-joseph> dkayiwa: i mean a user who has ordered for a patient
17:27:18 <dkayiwa> k-joseph: so how do you relate that to the sql you have just written above?
17:28:58 <k-joseph> dkayiwa: as long as the user places an order, he is entered into the orders table
17:29:12 *** GitHub116 has joined #openmrs
17:29:12 <GitHub116> [openmrs-core] dkayiwa pushed 1 new commit to 1.10.x: http://git.io/CnCfvA
17:29:12 <GitHub116> openmrs-core/1.10.x 75a01e8 dkayiwa: ConceptNumeric(concept) incorrectly copies collections - TRUNK-3974
17:29:12 *** GitHub116 has left #openmrs
17:29:35 <dkayiwa> k-joseph: do you see the above sql statement you have just written?
17:29:47 <k-joseph> dkayiwa: i see it
17:30:42 *** dkayiwa_ has joined #openmrs
17:33:45 *** dkayiwa has quit IRC
17:33:45 *** dkayiwa_ is now known as dkayiwa
17:34:24 <downey> ryates: incoming osu mail re: tubah
17:37:44 <k-joseph> dkayiwa: !!!
17:37:49 <dkayiwa> k-joseph: hi
17:38:28 <k-joseph> dkayiwa: were'nt you continuing your question
17:39:04 <dkayiwa> k-joseph: can you scroll back and see where i typed this a few mins ago? let us break it down even further
17:41:39 *** Ch3ck_ has joined #openmrs
17:42:16 <k-joseph> dkayiwa: am there, and am not if my answer after breaking it further was convincing to you
17:42:42 <dkayiwa> k-joseph: read from there up to where you find this: so how do you relate that to the sql you have just written above?
17:48:27 <k-joseph> dkayiwa: when a user places an order for a patient, he is entered into the orders table, and we can tell that by selecting the user from the orders table,
17:49:01 <dkayiwa> k-joseph: is that the sql statement you gave me above?
17:49:39 <k-joseph> dkayiwa: that was represented in this part
17:49:44 <k-joseph> dkayiwa:
17:49:45 <k-joseph> where (person_id = (select orderer from orders))
17:50:25 <dkayiwa> k-joseph: can you just copy and paste from above?
17:51:19 <k-joseph> dkayiwa: select person_id from users where (person_id = (select orderer from orders))
17:51:56 <dkayiwa> k-joseph: what is the purpose of that sql statement?
17:52:06 <dkayiwa> k-joseph: as in what does it do
17:53:43 <k-joseph> dkayiwa: selects the user who placed the order for a patient
17:54:13 <dkayiwa> k-joseph: what does this do? select orderer from orders
17:54:22 <k-joseph> dkayiwa: sorry for some delayed replies, responding to some students this side
17:54:44 <k-joseph> dkayiwa: that gets the iser who placed the order
17:55:15 <dkayiwa> k-joseph: how does it differ from the one you have just pasted above?
17:55:18 <k-joseph> dkayiwa: iser = user
17:57:03 <k-joseph> dkayiwa: one i have pasted checks whether the user that placed the order is the same as the one whose provider account am planning to create
17:57:43 <dkayiwa> k-joseph: what sql did i tell you to write?
17:58:07 <k-joseph> dkayiwa: to just get all users who have placed orders for patients
17:58:52 <dkayiwa> k-joseph: and which answer did you give?
17:59:36 <k-joseph> dkayiwa: select person_id from users where (person_id = (select orderer from orders))
18:01:04 <dkayiwa> k-joseph: and what does the checking of same provider etc as you have stated above have to do with it in reference to my question?
18:01:53 *** wluyima has joined #openmrs
18:01:53 *** GitHub158 has joined #openmrs
18:01:54 <GitHub158> [openmrs-core] dkayiwa closed pull request #529: TRUNK-3283 Add observation to an encounter: the field person can be overwritten, and it leads to inconsistent behaviour after saving (master...TRUNK-3283) http://git.io/0qm10g
18:01:54 *** GitHub158 has left #openmrs
18:05:12 <k-joseph> dkayiwa: let me rephrase what i meant, the user that is returned after selectt person id from users is any user available in our DB, and i need to confirm whether this user is available in the orders table in order for me to create for this user a provider account
18:06:12 <k-joseph> dkayiwa: this user is available in the orders table as orderer
18:06:25 <dkayiwa> k-joseph: did i give you a go ahead to go beyond just getting a list of user who placed orders?
18:07:49 <k-joseph> dkayiwa: sorry for having exceeded the scope wherein you had restricted me in your description, then my answer is as brief as: select orderer from orders
18:10:34 <dkayiwa> k-joseph: that is all i needed. Like i said above, because the query became too complicated for you, i decided to break it down into smaller parts and ensure that you fully understand each part. So please be very careful with my instructions. ok?
18:11:29 <k-joseph> dkayiwa: ok
18:12:23 *** Ch3ck_ has quit IRC
18:14:23 <dkayiwa> k-joseph: how do we tell if a user has an associated provider account? (answer in english not sql) :)
18:16:08 <k-joseph> dkayiwa: if the user is in the providers table added a person by id
18:18:13 <dkayiwa> k-joseph: so how do we get all user who have placed orders, but also in the providers table?
18:18:19 <dkayiwa> k-joseph: now answer in sql :)
18:18:29 *** dkithmal has quit IRC
18:20:02 <k-joseph> dkayiwa: select orderer from orders where person_id is in (select person_id from providers)
18:21:45 <dkayiwa> k-joseph: can you run that sql statement in your phpadmin and tell me what happens?
18:23:44 *** GitHub69 has joined #openmrs
18:23:44 <GitHub69> [openmrs-core] dkayiwa closed pull request #537: refactored person controller to not use instance methods (master...final_person_controller_refactor) http://git.io/Ap9r1A
18:23:44 *** GitHub69 has left #openmrs
18:23:45 *** GitHub46 has joined #openmrs
18:23:46 <GitHub46> [openmrs-core] dkayiwa pushed 2 new commits to master: http://git.io/p8G8hw
18:23:46 <GitHub46> openmrs-core/master dcdaf00 Chelsea H. Komlo: refactored person controller to not use instance methods
18:23:46 <GitHub46> openmrs-core/master 4724e75 dkayiwa: Merge pull request #537 from chelseakomlo/final_person_controller_refactor...
18:23:46 *** GitHub46 has left #openmrs
18:24:09 <k-joseph> dkayiwa: as it is results into an #1064 error
18:24:34 <dkayiwa> k-joseph: thats exactly what i wanted you to know that it is not properly written
18:25:09 <dkayiwa> k-joseph: can you correct it?
18:29:17 <k-joseph> dkayiwa: select orderer from orders where orderer in (select person_id from provider)
18:29:41 <dkayiwa> k-joseph: that is exactly what i was looking for :)
18:29:54 <dkayiwa> k-joseph: does it execute successfully?
18:30:05 <k-joseph> dkayiwa: yes, it does
18:30:14 <dkayiwa> k-joseph: how many rows does it return?
18:30:50 <k-joseph> dkayiwa: returns an empty result set,
18:30:58 <dkayiwa> k-joseph: ok no problem
18:31:31 <dkayiwa> k-joseph: so how do we get all users who have placed orders, but NOT in the providers table?
18:31:37 <dkayiwa> k-joseph: answer in sql :)
18:32:23 <k-joseph> dkayiwa: select orderer from orders where orderer not in (select person_id from provider)
18:32:48 <dkayiwa> k-joseph: ok good. does it return any rows?
18:33:10 <k-joseph> dkayiwa: still returns empty resultset
18:33:41 <dkayiwa> k-joseph: no problem. that is simply because your orders table is empty. not so?
18:33:59 <k-joseph> dkayiwa: it is
18:35:12 <dkayiwa> k-joseph: so far according to your ticket requirements, what section have we so far dealt with? just copy and paste from the ticket.
18:35:57 <k-joseph> dkayiwa: Add a changeset that creates provider accounts for all users have placed orders for patients and have no associated provider accounts
18:36:22 <dkayiwa> k-joseph: excellent. what what are we left with?
18:36:56 <k-joseph> dkayiwa: Migrate data in orders.orderer column to be provider_ids instead of user_ids is what is next
18:37:05 <dkayiwa> k-joseph: actually not excellent. you got it wrong
18:37:19 <dkayiwa> k-joseph: what sql do we so far have?
18:38:38 <k-joseph> dkayiwa: one that returns users who have placed orders for patients and have no associated provider accounts
18:39:29 <dkayiwa> k-joseph: so what do we have to do next?
18:39:49 <k-joseph> dkayiwa: so we are still on the first part, let me get what i think about the remaining sections in this first part here
18:43:29 *** travis-ci has joined #openmrs
18:43:30 <travis-ci> [travis-ci] [openmrs/openmrs-core] [4724e75] [dkayiwa] The build passed. - http://travis-ci.org/openmrs/openmrs-core/builds/17013224
18:43:30 *** travis-ci has left #openmrs
18:47:57 <k-joseph> dkayiwa: having finished the part that deals with returning the users who have placed orders and don't have provider accounts, we shall use this as person_id, and then generate the other values
18:52:41 *** Anushya has joined #openmrs
18:56:01 <dkayiwa> k-joseph: yes
18:56:12 <djazayeri> AdaYeung_, lstanisic : any chance that either of you use R statistical software, on windows?
18:56:15 <djazayeri> (or anybody else?)
18:56:32 <lstanisic> djazayeri: No, I haven't.
18:56:56 <lstanisic> djazayeri: I know Shaun Grannis and Judy Wawira have used R, but I am not sure if that was on Windows OS
18:57:22 <djazayeri> lstanisic: thanks, I'll reach out to them if more googling doesn't solve my problem...
18:57:29 <lstanisic> djazayeri: Sure! Good luck.
18:57:37 *** Ch3ck_ has joined #openmrs
18:57:50 <dkayiwa> lstanisic: i thought you are never on irc :)
18:58:04 <lstanisic> dkayiwa: I am lauren the lurker
18:58:10 <lstanisic> dkayiwa: :-)
18:58:15 <dkayiwa> lstanisic: hahahha :)
18:59:49 *** Ch3ck_ has quit IRC
19:06:48 <OpenMRSBot> Recent updates in the world of openmrsci: TRUNK-MASTER-260 has FAILED (1 tests failed) : Updated by dkayiwa <https://ci-stg.openmrs.org/browse/TRUNK-MASTER-260>
19:08:53 <OpenMRSBot> Recent updates in the world of openmrsci: REPUI-REPUI-394 has FAILED (1 tests failed) : Dependant of REP-REP-165 <https://ci-stg.openmrs.org/browse/REPUI-REPUI-394>
19:10:38 * burke loves the ability to jump back to my last read message in IRCCloud in a single click... even if it was days ago – http://bit.ly/19PNrKq
19:12:53 <burke> downey: can you remove the PIN from the Adobe Connect audio provider for OpenMRS forums? since uber dropped PINs, connecting audio from Adobe Connect fires several DTMF tones into the call. :-)
19:13:05 <k-joseph> dkayiwa: hi
19:13:11 <dkayiwa> k-joseph: hi
19:14:27 <k-joseph> dkayiwa: i have crated the whole query to look like http://pastebin.com/UAhJTwtQ it looks like there might be need of seperating it into some other parts, i get the error below when i run it
19:14:38 <k-joseph> #1093 - You can't specify target table 'provider' for update in FROM clause
19:14:40 <dkayiwa> k-joseph: ok
19:15:00 <cpower> dkayiwa: you around?
19:15:06 *** Ch3ck_ has joined #openmrs
19:15:08 <dkayiwa> cpower: yes
19:15:09 <downey> burke: done
19:16:03 <cpower> dkayiwa: Ujwala Nanavare is asking about TRUNK-4207, you know the answer to his emails, have you seen them?
19:16:20 <dkayiwa> !ticket TRUNK-4207
19:16:21 <OpenMRSBot> dkayiwa: [#TRUNK-4207] Ticket 4160 - OpenMRS JIRA - https://tickets.openmrs.org/browse/TRUNK-4207
19:16:57 <cpower> See his comment on the ticket
19:17:12 <dkayiwa> cpower: we closed it
19:17:37 <cpower> dkayiwa: why?
19:17:52 <cpower> dkayiwa: Which I think is what he's asking
19:18:42 <dkayiwa> cpower: i think he should instead be working on TRUNK-4160
19:18:44 <dkayiwa> !ticket TRUNK-4160
19:18:45 <OpenMRSBot> dkayiwa: [#TRUNK-4160] ProgramWorkflowService.retireProgram always throws Exception - OpenMRS JIRA - https://tickets.openmrs.org/browse/TRUNK-4160
19:18:55 <cpower> dkayiwa: Should he work on 4160 that's similar?
19:19:16 <dkayiwa> cpower: he is supposed to be working on 4160
19:19:35 <cpower> Ok, So why did we close 4207?
19:19:47 <cpower> now more out of curiousity than anything
19:21:09 <dkayiwa> cpower: he was working on 4160 and then he thought every time one makes a followup commit , he needs to create a new ticket :)
19:21:37 <cpower> dkayiwa: ahh that's no good :-)
19:21:41 *** Ch3ck_ has quit IRC
19:21:53 <dkayiwa> cpower: :)
19:21:57 <cpower> dkayiwa: Have we explained that to him yet, or should I when I reply?
19:22:14 <dkayiwa> cpower: i think i missed out on explaining that to him :)
19:22:28 <dkayiwa> cpower: so feel free to go ahead
19:22:36 <cpower> okie dokie :-)
19:22:43 <dkayiwa> cpower: thanks :)
19:25:07 <dkayiwa> k-joseph: hi
19:25:21 <k-joseph> dkayiwa: hi
19:25:22 *** Ch3ck_ has joined #openmrs
19:25:29 <dkayiwa> k-joseph: look at the file: liquibase-update-to-latest.xml
19:25:49 <k-joseph> dkayiwa: :)
19:25:51 <dkayiwa> k-joseph: and search for all changesets having this text: insert into
19:26:03 <dkayiwa> k-joseph: tell me if they give you some clues :)
19:27:22 <Ch3ck_> dkayiwa, started work on the intro tickets was in the process of running "git checkout -b TRUNK- master" and it failed due to loss of network upon resuming I had an error like code repo exists so how do i fix that?
19:28:12 <dkayiwa> Ch3ck_: you can always delete the folder and do it again :0
19:28:30 <Ch3ck_> aight thanks
19:37:17 *** Ch3ck_ has quit IRC
19:38:40 <k-joseph> dkayiwa: am not getting the clue yet!!! that you implied
19:39:36 <dkayiwa> k-joseph: how do they do their insert statements?
19:40:59 <OpenMRSBot> Recent updates in the world of openmrsci: TRUNK-ONEPOINTTENX-74 has FAILED (1429 tests failed) : Updated by dkayiwa <https://ci-stg.openmrs.org/browse/TRUNK-ONEPOINTTENX-74>
19:47:17 <k-joseph> dkayiwa: am not sure if am getting this right, but i see each almost unique
19:51:35 *** howardf has quit IRC
19:53:34 <dkayiwa> k-joseph: do they have a VALUES clause?
19:53:57 <k-joseph> dkayiwa: they don't
19:54:13 <dkayiwa> k-joseph: what do they have instead?
19:55:30 <k-joseph> dkayiwa: sorry, there's one with values
19:57:25 <dkayiwa> k-joseph: how about others
19:57:50 <k-joseph> dkayiwa: others don't
19:58:05 <dkayiwa> k-joseph: what do they have instead
19:58:21 *** Ch3ck_ has joined #openmrs
19:59:34 <k-joseph> dkayiwa: am not sure, if you mean what they have instead of 'values'!
20:01:29 <dkayiwa> k-joseph: have you ever read about the "insert into select" statement?
20:03:02 <k-joseph> dkayiwa: i read about insert into and select statements seperately, i don't remember having read that, let me checkout google
20:03:19 <dkayiwa> k-joseph: ok
20:10:13 *** sgithens has joined #openmrs
20:10:17 *** howardf has joined #openmrs
20:23:53 *** Anushya has quit IRC
20:38:24 *** howardf has quit IRC
20:38:57 *** Ch3ck_ has quit IRC
20:40:37 *** cioan1 has joined #openmrs
20:42:47 *** cioan has quit IRC
20:49:29 *** dkayiwa_ has joined #openmrs
20:50:47 *** dkayiwa has quit IRC
20:50:48 *** dkayiwa_ is now known as dkayiwa
21:00:24 *** k-joseph has quit IRC
21:01:21 <OpenMRSBot> Recent updates in the world of openmrsci: TRUNK-MASTER-260 has FAILED (234 tests failed) : Rebuilt 1 times <https://ci-stg.openmrs.org/browse/TRUNK-MASTER-260>
21:06:14 *** wluyima has quit IRC
21:10:42 *** Ch3ck_ has joined #openmrs
21:23:25 <OpenMRSBot> Recent updates in the world of openmrsci: REFMETA-REFMETA-229 has FAILED (2 tests failed) : Dependant of EMRAPI-EMRAPI-392 <https://ci-stg.openmrs.org/browse/REFMETA-REFMETA-229>
21:37:28 <OpenMRSBot> Recent updates in the world of openmrsci: TRUNK-MASTER-261 has FAILED (235 tests failed) : Updated by dkayiwa <https://ci-stg.openmrs.org/browse/TRUNK-MASTER-261>
22:02:57 *** dkayiwa_ has joined #openmrs
22:04:24 *** dkayiwa has quit IRC
22:04:27 *** dkayiwa_ is now known as dkayiwa
22:35:11 <robbyoconnor> downey: ping?
22:43:56 *** cioan1 has quit IRC
22:44:23 <downey> Pong
22:47:01 *** sgithens has quit IRC
22:49:54 *** dkayiwa has quit IRC
22:54:27 *** Ch3ck_ has quit IRC
23:16:00 *** Ch3ck_ has joined #openmrs
23:17:11 *** jkeiper has quit IRC
23:17:12 *** Ch3ck has quit IRC
23:17:12 *** ibewes has quit IRC
23:17:13 *** suranga has quit IRC
23:17:24 *** ibewes_ has joined #openmrs
23:18:06 *** jkeiper_ has joined #openmrs
23:18:48 *** suranga___ has joined #openmrs
23:24:59 *** davidpardz has joined #openmrs
23:25:00 *** ChanServ sets mode: +v davidpardz
23:32:13 *** harshadura has joined #openmrs
23:32:13 *** ChanServ sets mode: +v harshadura
23:32:14 *** harshadura_ has joined #openmrs