Piezoelectricity in III-V and II-VI semiconductors: A systematic ab-initio calculation