Avri Blog

Here is a little script I wrote to use google maps with the lib download asynch.
You can also display a nice error if the address can't be found on gmaps, and customize it using the right css.
It's using some jquery selectors.
Include this script in your page :

KD = {
utils: { dsl: function(src) {
	                        var script = document.createElement("script");
	                        script.type = "text/javascript";
	                        script.src = src;
	                        document.body.appendChild(script);
	                },
}};
KD.gMaps = {
	utils:{
		apiLoaded: false,
		toLoad: [],
		/**
		 * Once the api is loaded, we execute all the methods we save using the waitForApi method of each map instance.
		 */
		callback: function () {
			this.apiLoaded = true ;
			var size = this.toLoad.length;
			for(var i=0;i<size;i++) {
				l = this.toLoad[i]; 
				//Call the saved function of the map instance.
				l.map[l.fun].apply(l.map, l.args);
			}
		}
	},
	Map: function () {
		if(!KD.gMaps.utils.apiLoaded) {
			KD.utils.dsl("http://maps.googleapis.com/maps/api/js?sensor=false&callback=KD.gMaps.utils.callback");
		}
	}
};
 
KD.gMaps.Map.prototype = {
	geocoder: null,
	map: null,
	divMap: null,
	divMapContainer: null,
	/**
	 * Default options.
	 */
	options: {
		addressNotFound: "", //"Address not found"
		/* If the size isn't defined in the options, divMap size will be used. Otherwise the size will be overrided by the options.
		size :{ 
			width: "300",
			height: "500"
		},*/
		//All other google maps options can be used here.
		map: {
			zoom: 14, 
			mapTypeId: "roadmap" //google.maps.MapTypeId.ROADMAP
		}
	},
	/**
	 * Init google map div. Can be called with a "options" extra parameters if needed.
	 */
	init: function (divMap, options) {
		if(!this.isWaitingForApi("init", arguments)) {
			KD.utils.initOptions(options, this.options);
			this.geocoder = new google.maps.Geocoder();
			if(typeof(divMap) !== "undefined") {
				this.divMapContainer = divMap;
			} else if(this.divMapContainer == null) {
				alert("you should init at least once with a divMap");
			}
			var width, height;
			this.divMap = this.divMapContainer.append("<div></div>");
			//Set the map size if.
			var that = this;
			$.each(['height', 'width'], function (i, type) {
				if(typeof(that.options.size) == "undefined" || typeof(that.options.size[type]) == "undefined") {
					value = that.divMapContainer.css(type);
				} else {
					value = that.options.size[type];
					that.divMapContainer.css(type, value);
				}
				that.divMap.css(type, value);
			});
			this.map = new google.maps.Map(this.divMap.get(0), this.options.map);
		}
	},
	/**
	 * Go to the given address.
	 */
	goToAddress: function(address) {
		if(!this.isWaitingForApi("goToAddress", arguments)){
			if(this.divMap == null) {
				this.init();
			}
			if(address == "") {
				this.setAddressNotFound();
			} else {
				var that = this ;
				this.geocoder.geocode( { 'address': address}, function(results, status) {
					if (status == google.maps.GeocoderStatus.OK) {
						that.goToLatLng(results[0].geometry.location);
					} else {
						that.setAddressNotFound();
					}
				});
			}
		}
	},
	/**
	 * Move the map to the given lat/long.
	 */
	goToCoo: function (lat, long) {
		if(!this.isWaitingForApi("goToCoo", arguments)){
			this.goToLatLng(new google.maps.LatLng(lat, long));
		}
	},
	/**
	 * Save the call to the method. If the api isn't loaded yet, the method will be called when the api is loaded.
	 * Return true if the api isn't loaded
	 */
	isWaitingForApi: function (functionName, args) {
		if(!KD.gMaps.utils.apiLoaded) {
			KD.gMaps.utils.toLoad.push({"fun": functionName, "map": this, "args": args}); 
			return true ;
		}
		return false;
	},
	/**
	 * Set the addressNotFound message in the map.
	 */
	setAddressNotFound: function () {
		this.divMap = null;
		this.map = null;
		this.divMapContainer.removeAttr("style");
		this.divMapContainer.html("<p>"+this.options.addressNotFound+"</p>");
	},
	/**
	 * Move the map to the given google's google.maps.LatLng object.
	 */
	goToLatLng: function(myLatlng) {
		this.map.setCenter(myLatlng);
		var marker = new google.maps.Marker({
			map: this.map,
			position: myLatlng
		});
	}
};

One its include, just use it this way to display the address you want :

companyMaps = new KD.company.Maps("Can't find this address"); 
companyMaps.init("8 RUE DE L HOPITAL ST LOUIS, 75010 PARIS, FRANCE");

(see also goToLatLng, goToCoo and goToAddress. You can use this function once the map is load using the ini method.

I recently had to use google insight for the google data viz challenge.
Google doesn't provide an api for insight, and you may need to do a request with more than 5 terms.
You will find the connection script, and an example to use it on the http://www.tendance2012.fr project : https://github.com/Avricot/prediction/tree/master/python-insight

Inspired from http://pypi.python.org/pypi/pyGTrends/0.8

Selenium select method doesn't fire a onchange event on IE.
Here is a simple hack : we have to focus the select (here located with the "locater" parameter), then change its value, and finally remove the focus. Firering a blur event doesn't work, so we simply give the focus to the body.

public void select(String locator, String optionLocator) {
   if (isIE) {
     //Add the focus to the select
      selenium.focus(locator);
   }
   selenium.select(locator, optionLocator);
   if (isIE) {
      // Remove the focus to fire the onchange()
      selenium.focus("css=body");
   }
}

Because we can have duplicated elements in a list, updating a List with hibernate will result to a full delete then re-insert. A complete explanation can be found here : Why Hibernate does "delete all then re-insert" - its not so strange A good solution is to use a Set or to add a index column to your List:

@JoinTable(name = "JOINTURE", joinColumns = @JoinColumn(name = "KEY_A"), inverseJoinColumns = @JoinColumn(name = "KEY_B"))
@ManyToMany(fetch = FetchType.LAZY)
@OrderColumn(name = "ORDERS_INDEX")
private List<MyObject> myList ;

Once the modification is done, you may need to initialize the existing entries. Here is a quick python script

#Pour installer MySQLdb : sudo apt-get install python-mysqldb
import MySQLdb
 
db=MySQLdb.connect(passwd="dev",db="mybb",host="localhost",user="dev")
#db.autocommit(1) 
 
db.query("""SELECT KEY_A, KEY_B from JOINTURE ORDER BY KEY_A""")
r=db.store_result()
 
id_A = 0 
i=0
while 1:
        row = r.fetch_row(how=1)
        if not row: 
                break
        row = row[0]
        i=i+1
        if id_A != row['KEY_A']:
                i=0 
                id_A=int(row['KEY_A']);
        try:
                c=db.cursor()
                c.execute("UPDATE JOINTURE set ORDERS_INDEX=%s where KEY_A=%s and KEY_B=%s", (i, id_A, int(row['KEY_B'])))
        except:
                print sys.exc_info()[1]
db.commit()

Using hibernate @Any mapping to map multiple entities in the same, I haven't be able to build a request to fetch all the objects of a specific class.
Hibernate doesn't seems to be capable to handle this kind of request.
My application doesn't start and throw the following error :

Invocation of init method failed; nested exception is java.lang.ClassCastException: org.hibernate.type.AnyType cannot be cast to org.hibernate.type.ComponentType

removing the part "left join fetch ic.item i" solve this error.

@Entity
@NamedQueries({
@NamedQuery(name = "GET_ITEMS", query = "from ItemContainer ic left join fetch ic.item i where ic.id=:containerId and ic.class=:clazz")})
public class ItemContainer {
.... 
    @Any(metaColumn = @Column(name = "TYPE"), fetch = FetchType.LAZY)
    @AnyMetaDef(idType = "long", metaType = "string", metaValues = { @MetaValue(targetEntity = Item1.class, value = "I1") })
    @JoinColumn(name = "TYPE_ID")
    private IItem item;
...
}

(Item1 implements IItem)

@Override
@SuppressWarnings("unchecked")
public List<ItemContainer> getItem1s(final Long containerId) {
return getHibernateTemplate().findByNamedQueryAndNamedParam("GET_ITEMS", new String[] { "containerId", "clazz" },
		new Object[] { containerId, Item1.class });
}

:/

Any ideas ?