Mount Virtualbox vboxsf folder in Linux

In your /etc/fstab file, append this line


projects /projects vboxsf uid=devel,gid=devel,dmode=0755,fmode=0755 0 0


then

sudo mount /projects


Host development workspace on Assembla and Trac customization

Host development workspace on Assembla and Trac customization

http://www.assembla.com/
http://trac.edgewall.org/
http://trac-hacks.org/wiki/ScrumBurndownPlugin

Help page:
http://trac2.assembla.com/appexpress/wiki/TracTicketsCustomFields

Host development workspace on Assembla and Trac customization:

Trac custom fields:
1. EstimateHours: select, value: 2|4|8|16|24|32|40
2. ActualHours: select, value: 2|4|8|16|24|32|40
3. Progress: select, value: 0|1|2|3|4|5|6|7|8|9|10

Create a new ticket report as below:

SELECT p.value AS __color__,
id AS ticket, summary, component, version, milestone, t.type AS type,
(CASE status WHEN 'assigned' THEN owner||' *' ELSE owner END) AS owner,
time AS created,
changetime AS _changetime, description AS _description,
reporter AS _reporter,
c.value as EstHours,
c2.value as ActHours,
c3.value as progress
FROM ticket t
LEFT OUTER JOIN ticket_custom c ON (t.id = c.ticket AND c.name = 'esthours')
LEFT OUTER JOIN ticket_custom c2 ON (t.id = c2.ticket AND c2.name = 'acthours')
LEFT OUTER JOIN ticket_custom c3 ON (t.id = c3.ticket AND c3.name = 'progress')
LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority'
WHERE status IN ('new', 'assigned', 'reopened')
ORDER BY p.value, milestone, t.type, time


Some useful tools/webapps

Grails/ET/DLTK
http://www.eclipse.org/dltk/

Eclipse code read tools:
Omondo/Ispace

assembla + wordpress + google domain + dimdim
Nomachine
Virtualbox
Ubuntu jeos

Config Trac + SVN + Apache with LDAP authentication

Python 2.5 + Trac 0.10 + XAMPP (Apache) + OpenDS 1.0.0 + Apache Directory Studio + Subversion

TRAC plugins:
[components]
burndown.burndown.burndowncomponent = enabled
scrumplugin.scrum.scrumcomponent = disabled
timingandestimationplugin.* = enabled
trac.wiki.web_ui.wikimodule = disabled
tractags.* = enabled
webadmin.* = enabled

Apache Configuration

<Location /svn>
DAV svn
# any "/svn/foo" URL will map to a repository /usr/local/svn/foo
SVNParentPath c:/svndata
AuthType Basic
AuthBasicProvider ldap
AuthName "Authorization required"
AuthzLDAPAuthoritative on
AuthLDAPBindDN "cn=root"
AuthLDAPBindPassword root
AuthLDAPURL ldap://127.0.0.1:1389/ou=People,dc=make,dc=com?uid?sub?(objectClass=*)
require valid-user
</Location>
<Location /trac>
SetHandler mod_python
PythonInterpreter main_interpreter
PythonHandler trac.web.modpython_frontend
PythonOption TracEnv c:\tracdata
PythonOption TracUriRoot /trac
</Location>
<Location /trac/login>
AuthType Basic
AuthBasicProvider ldap
AuthName "Authorization required"
AuthzLDAPAuthoritative on
AuthLDAPBindDN "cn=root"
AuthLDAPBindPassword root
AuthLDAPURL ldap://127.0.0.1:1389/ou=People,dc=make,dc=com?uid?sub?(objectClass=*)
require valid-user
</Location>


Host development workspace on Assembla and Trac customization

http://www.assembla.com/
http://trac.edgewall.org/
http://trac-hacks.org/wiki/ScrumBurndownPlugin

Help page:
http://trac2.assembla.com/appexpress/wiki/TracTicketsCustomFields

Host development workspace on Assembla and Trac customization:

Trac custom fields:
1. EstimateHours: select, value: 2|4|8|16|24|32|40
2. ActualHours: select, value: 2|4|8|16|24|32|40
3. Progress: select, value: 0|1|2|3|4|5|6|7|8|9|10

Create a new ticket report as below:

SELECT p.value AS __color__,
id AS ticket, summary, component, version, milestone, t.type AS type,
(CASE status WHEN 'assigned' THEN owner||' *' ELSE owner END) AS owner,
time AS created,
changetime AS _changetime, description AS _description,
reporter AS _reporter,
c.value as EstHours,
c2.value as ActHours,
c3.value as progress
FROM ticket t
LEFT OUTER JOIN ticket_custom c ON (t.id = c.ticket AND c.name = 'esthours')
LEFT OUTER JOIN ticket_custom c2 ON (t.id = c2.ticket AND c2.name = 'acthours')
LEFT OUTER JOIN ticket_custom c3 ON (t.id = c3.ticket AND c3.name = 'progress')
LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority'
WHERE status IN ('new', 'assigned', 'reopened')
ORDER BY p.value, milestone, t.type, time

Python Resources

http://en.wikibooks.org/wiki/Non-Programmer%27s_Tutorial_for_Python
http://www.sthurlow.com/python/

Python script 2

import xml.etree.ElementTree as ET
from xml.etree import *

# build a tree structure
root = ET.Element(“html”)

head = ET.SubElement(root, “head”)

title = ET.SubElement(head, “title”)
title.text = “Page Title”

body = ET.SubElement(root, “body”)
body.set(“bgcolor”, “#ffffff”)

body.text = “Hello, World!”

# wrap it in an ElementTree instance, and save as XML
tree = ET.ElementTree(root)
ET.dump(tree)
tree.write(“e:\\test\\page.xhtml”)

Python script 1


application asd
----------- -----------
1 12,001.201022
2 3,201.000121

The python file to read a particular field:


from __future__ import with_statement
i = 0
with open("e:\\test\\soundexp.txt") as f:
for line in f:
i=i+1
if i == 3:
print (line.split())[1]

the result window:

>>> 12,001.201022

LDAP Resources

Apache Directory Studio

Invoking EJB from another JEE Application

 

EJB Interface:

package ca.ns.gov.sns.embassy.pos;

import javax.ejb.Remote;

@Remote
public interface POSService {

public String createPayment(String name) ;
public String getPaymentStatus(String name);

}

EJB Implementation:

package ca.ns.gov.sns.embassy.pos;

 

import javax.ejb.Stateless;

 

@Stateless(name=”POSService”)

public class POSServiceBean implements POSService {

 

public String createPayment(String name){
// TODO Auto-generated method stub
return “create payment:” + name;
}

public String getPaymentStatus(String name){
// TODO Auto-generated method stub
return “payment status:” + name;
}

}

Client Class:

Properties props = new Properties();
props.load(EnterPOSPayment.class.getResourceAsStream(“/jndi.properties”));
InitialContext ic = new InitialContext(props);
POSService pos = (POSService)ic.lookup(“POSService”);
String retmsg = pos.getPaymentStatus(“test”);
System.out.println(“return message=” + retmsg);

jndi.properties file:

java.naming.provider.url=ormi\://localhost\:23791/sns-pos
java.naming.security.principal=oc4jadmin
java.naming.security.credentials=password
java.naming.factory.initial=oracle.j2ee.naming.ApplicationClientInitialContextFactory