Friday, April 18, 2014

Maven - Start a new java project

mvn archetyp:generate
Group, ArtefactId, Version

mvn eclipse:eclipse

Then in Eclipse, you can import the Project:
File > Import > Maven > Existing Maven Projects > Next > Browse to the Root Directory > Select the pom.xml > Finish

Or you can create the Maven project directly in Eclipse:
File > New > Other... > Maven > Maven Project > Next > Next :
Group, ArtefactId, Version

Wednesday, April 16, 2014

XSLT - Definitions

XSLT - a language for transforming XML documents 
XPath - a language for navigating in XML documents 
XSL-FO - a language for formatting XML documents
XQuery - a language for finding and extracting elements and attributes from XML documents.

SQL - First and last day of the month

-- First day of the last month
SELECT DATEADD(mm, DATEDIFF(m,0,GETDATE())-1,0);

-- Last day of the last month
SELECT DATEADD(d,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE())  ,0));

SQL - Mixing INNER and OUTER Joins [external link]

When mixing INNER and OUTER joins, it's important to understand the risks involed and this article describe it very clearly:
http://weblogs.sqlteam.com/jeffs/archive/2007/10/11/mixing-inner-outer-joins-sql.aspx

SVN > XSLT = HTML Report

svn log -v --xml file:///C:/subversion/repo/http-conf | xsltproc svnstyle.xsl - > ./svnlog.html

===== svnstyle.xsl =====
<?xml version="1.0" encoding="ISO-8859-1"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:template match="/">
<html>
   <body>
      <h2>SVN Log</h2>
      <table border="1">
      <xsl:for-each select="log/logentry">
         <xsl:if test="author='USERNAME'">
            <tr>
               <td><xsl:value-of select="date"/></td>
               <td><xsl:value-of select="author"/></td>
               <td><xsl:value-of select="msg"/></td>
            </tr>
         </xsl:if>
      </xsl:for-each>
      </table>
   </body>
</html>
</xsl:template>
</xsl:stylesheet>
===== svnstyle.xsl =====


Output: 
===== svnlog.html =====
<html>
   <body> 
      <h2>SVN Log</h2> 
      <table border="1"> 
         <tr> 
            <td>2014-04-11T21:34:31.836671Z</td> 
            <td>
USERNAME</td> 
            <td>My third commit</td> 
         </tr> 
         <tr> 
            <td>2014-04-11T21:34:31.586674Z</td> 
            <td>
USERNAME</td> 
            <td>My second commit</td> 
         </tr> 
         <tr> 
            <td>2014-04-11T21:34:31.024182Z</td> 
            <td>
USERNAME</td> 
            <td>My first commit</td> 
         </tr> 
         <tr> 
            <td>2014-04-11T21:34:30.149193Z</td> 
            <td>
USERNAME</td> 
            <td>Creating the project</td> 
         </tr> 
      </table> 
   </body>

</html>
===== svnlog.html =====


Sunday, April 13, 2014

Friday, April 11, 2014

dos2unix


To convert all the files :
find . -type f -print0 | xargs -0 dos2unix

To convert all the files except those in the « .svn » directories :
find . -type f -not -iwholename '*.svn*' -print0 | xargs -0 dos2unix