Thursday, 31 July 2008

Find dublicates when SQL is your friend

Just to remember it another day. If you want to find which elements there is more then one time.


SELECT CODE
FROM table
GROUP BY CODE
HAVING count(CODE) > 1


It helped me a lot, so I hope you, my reader can utilise it as well.

Tuesday, 1 July 2008

Add entry macro in my word document

I am using a word document, to document may daily tasks and doings. And as the good geek I am, I wanted to implement a macro in MS word to make a day entry at the punch of a short cut.

After playing alot with the anything-but-intuitive vb I finally finished the following macro:

Sub addEntry()
'
' addEntry Macro
' Macro recorded 4/7/2008 by kim
'
' write headline ("Diario di bordo ")
Selection.Font.Name = "Courier New"
Selection.Font.Bold = True
Selection.Font.Underline = True
Selection.TypeText Text:="Diario di bordo "
Selection.InsertDateTime DateTimeFormat:="dd/MM/yyyy HH:mm:ss", _
InsertAsField:=False, DateLanguage:=wdItalian, CalendarType:= _
wdCalendarWestern, InsertAsFullWidth:=False
Selection.TypeParagraph
Selection.Style = ActiveDocument.Styles("Normal")

' add bold headline ("Should-does:")
Selection.Font.Bold = wdToggle
Selection.TypeText Text:="Should-dos:"
' add point lists.
Selection.TypeParagraph
Selection.MoveUp Unit:=wdLine, Count:=1
Selection.TypeParagraph
Selection.MoveDown Unit:=wdLine, Count:=1
Selection.Style = ActiveDocument.Styles("List Bullet")

' if it is friday, add "Write Status report" to bullet list.
today = Weekday(Date$, vbMonday)
If (today = vbFriday) Then
Selection.TypeText Text:="Write Status report"
End If

Selection.TypeParagraph
Selection.TypeParagraph
Selection.MoveRight Unit:=wdCharacter, Count:=1
Selection.MoveLeft Unit:=wdCharacter, Count:=1
' remove type type.
Selection.Range.ListFormat.RemoveNumbers NumberType:=wdNumberParagraph
End Sub

Which does exactly as I have described in the comments (the stuff in green). And produces the following in my diary.



Diario di bordo 01/07/2008 17:43:57

Should-dos:

·

·



(sorry the mess of HTML (if you look in "document source" of this HTML, its pretty ugly, but I just did a copy paste from Word).

If its a friday, it will add the "Write status report" to the list of "Should dos"

Thursday, 26 June 2008

c# with XmlDocument and xpaths

Im almost embarrassed to admit it but I have spend almost a day playing around with the XmlDocument .NET class and xpaths. My problem was that I have the XML shown below(only a snipped of it is pasted below)

And wanted to get hold of the "id" tag inside patient. To do this I found that the fast way was to use the method SelectSingleNode to and a xpath expression like the following:

"/ClinicalDocument/recordTarget/patientRole/id".

In the following way:

XmlDocument xml = new XmlDocument();
xml.LoadXml(cda.Xmlcda);
XmlNode node = xml.SelectSingleNode("/ClinicalDocument/recordTarget/patientRole/id");

But no element was found. I tried quite a lot of different stuff. But nothing worked.

Until finally I found this article: (link) (which I only skimmed(to be completely honest))which described the funny thing that even if the elements is not prefixed in the XML the base namespace is used anyway. So to enable me to Xpath my way to the patient Id tag I needed a XmlNameSpaceManager to handle the namespaces.


The working code looks like this:
XmlDocument xml = new XmlDocument();
xml.LoadXml(cda.Xmlcda);
XmlNamespaceManager nsmgr = new XmlNamespaceManager(xml.NameTable);
nsmgr.AddNamespace("cda", "urn:hl7-org:v3");
XmlNode node = xml.SelectSingleNode("/ClinicalDocument/recordTarget/patientRole/id", nsmgr);



The XML:

<!-- ?xml-stylesheet type="text/xsl" href="CDA.xsl"? -->
<!-- Readers should be aware of the evolving "Using SNOMED CT in HL7 Version 3" implementation guide, currently in a draft state. The guide, co-developed by HL7 and the College of American Pathologists, will be balloted by HL7 as an Informative Document. Recommendations in the final published guide should usurp patterns of SNOMED CT usage found in this sample instance. -->
<clinicaldocument xmlns="urn:hl7-org:v3" voc="urn:hl7-org:v3/voc"
xsi="http://www.w3.org/2001/XMLSchema-instance"
schemalocation="urn:hl7-org:v3 CDA.xsd">
<!-- ******************************************************** CDA Header ******************************************************** -->
<typeid root="2.16.840.1.113883.1.3" extension="POCD_HD000040">
<templateid root="2.16.840.1.113883.3.27.1776">
<id extension="c266" root="2.16.840.1.113883.19.4">
<code code="11488-4" codesystem="2.16.840.1.113883.6.1" codesystemname="LOINC" displayname="Consultation note">
<title>Good Health Clinic Consultation Note</title>
<effectivetime value="20000407">
<confidentialitycode code="N" codesystem="2.16.840.1.113883.5.25">
<languagecode code="en-US">
<setid extension="BB35" root="2.16.840.1.113883.19.7">
<versionnumber value="2">
<recordtarget>
<patientrole>
<id extension="12345" root="2.16.840.1.113883.19.5">
<patient>
<name>
</name></patient></id></patientrole></recordtarget></versionnumber></setid></languagecode></confidentialitycode></effectivetime></code>

Tuesday, 10 June 2008

"?" - Question mark in c# code (Nullable value types)

In a piece of auto generated code, I found the following property


public DateTime? EffettiveTime
{
get { return m_effettiveTime; }
set { this.m_effettiveTime = value; }
}


This was the first time I seen the question mark in the c# code (at least in this context) The problem arose when I wanted to do the following:


someInstance.date = EffettiveTime.ToString("yyyy-mm-dd");


It returned an error saying that the ToString method does not have any overload methods, which takes a string. I looked up DateTime and found the overloaded method, so why couldn't I use it.

After some googling I found the wikipedia site for c-sharp (link) where I found the following:


Nullable value types (denoted by a question mark, e.g. int? i = null;) which add null to the set of allowed values for any value type. This provides improved interaction with SQL databases, which can have nullable columns of types corresponding to C# primitive types: an SQL INTEGER NULL column type directly translates to the C# int?.


But then there is just the problem that this new type (DateTime?) did not implement the method that I needed, so I had to cast it to DateTime before continuing, on. This seemed to work:

DateTime eTime = (DateTime) EffettiveTime;
someInstance.date = eTime.ToString("yyyy-mm-dd");





The "?" question mark is also used for short if statements. The following can be written much shorter:


SomeClasse someInstance = null;
if(<someBoolean>)
{
someInstance= <doSomething>;
}
else
{
someInstance = <doSomethingElse>;
}



This could be written like this instead

SomeClasse someInstance = <someBoolean> ? <doSomething> : <doSomethingElse>;

Thursday, 8 May 2008

androMDA.net download

In a new project, I heard that it would be of great use to auto generate some code. and that AndroMDA is the tool to use.

Sadly I had only reached about a 100 lines into the how-to androMDA before running into problems. I was not able to download the mavenplugin (which is AndroMDA).

So when the tutorial (link) wrote the following

To install the C# Application plugin open a Command Prompt and Execute the following command. Make sure you get a "BUILD SUCCESSFUL" message at the end of the command output.

maven plugin:download -DgroupId=andromda -DartifactId=maven-andromdacsapp-plugin -Dversion=1.0-SNAPSHOT

Notice that you will now have maven-andromdacsapp-plugin-1.0-SNAPSHOT.jar installed at MAVEN_HOME\plugins ( C:\Program Files\Apache Software Foundation\Maven 1.0.2\plugins for this example).

I just got a lot of errors instead of actually downloading anything. Luckily I wasnt the first one to have this problem, to after a bit of search I found the following solution (link)


After a long fight with maven, I found a solution to the problem.
Maven 1.x doesn't support redirection thus we must indicate a non redirected repository. So in build.properties :

maven.repo.remote=http://www.ibiblio.org/maven,http://team.andromda.org/maven
become
maven.repo.remote=http://repo1.maven.org/maven,http://team.andromda.org/maven

and a valid command line is :

maven plugin:download -DartifactId=maven-torque-plugin -DgroupId=torque -Dversion=3.3-RC1

if you try to use an other apache's server, it seems that jsch isn't created. [neria]



Joy and happiness, now I can continue, my androMDA tutorial, and actually download androMDA, with the following command:


maven plugin:download -DgroupId=andromda -DartifactId=maven-andromdacsapp-plugin -Dversion=1.0-SNAPSHOT

Wednesday, 16 April 2008

Found in System.Uri in the .NET lib


Protected Overridable Sub CheckSecurity()
Member of: System.Uri
Summary:
Calling this method has no effect.


Wonder how many no-effect-methods is needed to run windows. and if all their CheckSecurity methods have no effect.

Sunday, 6 April 2008

Reading rails 1.2 while learning rails 2.0

Learning rails 2.0 from a book about rails 1.2.6 keeps you awake, cause there are things that does not do exactly what it is described in the book.


depot>rails depot


Generates lots of code. Now to setup the database open the database.yml file in depot\config\ and correct it to match your database:


# SQLite version 3.x
# gem install sqlite3-ruby (not necessary on OS X Leopard)
development:
adapter: mysql
database: depot_development
user: userNam
password: pass
test:
adapter: mysql
database: depot_test
user: userNam
password: pass

production:
adapter: mysql
database: depot_production
user: userNam
password: pass


then make use of the rake tool, to create the databases:


rake db:create:all


then to make the product scaffolding do the following:


depot>ruby script/generate scaffold Product title:string description:text image_url:string


And now its possible to start the server (ruby script/server) and create a product. following this url:


http://localhost:3000/products