-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 kthomps17 wrote:
>
> def searchDealers(l1, l2, r):
> l1 = str(l1)
> l2 = str(l2)
> r = str(r)
> settings = getUtility(IDatabaseSettings)
> mydb = mysql.connect(host=settings.hostname,
> user=settings.username,
> passwd=settings.password,
> db=settings.database)
> cur = mydb.cursor()
> cur.execute('SELECT name, address, lat, lng, ( 3959 * acos( cos(
> radians('+l1+') ) * cos( radians( lat ) ) * cos( radians( lng ) -
> radians('+l2+') ) + sin( radians('+l1+') ) * sin( radians( lat ) ) ) ) AS
> distance FROM dealers HAVING distance < '+r+' ORDER BY distance LIMIT 0 ,
> 25')
> results = cur.fetchall()
> doc = Document()
> markers = doc.createElement("markers")
> doc.appendChild(markers)
> for row in results:
> marker = doc.createElement("marker")
> marker.setAttribute("name", row[0])
> marker.setAttribute("address", row[1])
> marker.setAttribute("lat", str(row[2]))
> marker.setAttribute("lng", str(row[3]))
> marker.setAttribute("distance", str(row[4]))
> markers.appendChild(marker)
> mydb.close()
> return doc.toprettyxml()
>
>
>
Apart from that: managing your DB connection yourself is very bad-style.
Better use a related database adapter like ZMySQLDA or SQLAlchemyDA
dealing with connection polling, reconnection etc. for your. Never ever
do database handling yourself.
- -aj
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (Darwin)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
iQGUBAEBAgAGBQJNCPjjAAoJEADcfz7u4AZjKxALwLRKhk/Jp3PTrgV9sULaV6A9
UUJmHDcCl/KhQ3wyWiZ2dbRYfYRAGn/dbjprkJCN0IVThzNtJwJX82KOYpaGyig8
L9+OuuzBPwxbht23XolYBEei4Ykdn7Vnyy4CpnD3n+ms2y3XB4x/eoHkB3t6IT09
KHr3gn8sCcZpfMl23Pi3yB7NuHVI9j29TX1we/K3cj+AfL/QXFl3wVrIwqlzBNRj
yoIkS0c1pKmvDloW+DuF6Tm7IoVb0ORNFOwvI2N8OxiLFQHOt+Ke5D/EnF3anccM
40Jbm9sqFEvEYlXeudyzlZK3CbGVpIJ23KeUxUJD5PWwANmff8UbUGoXVoI8AgZZ
Y8+HerbN9DFgtt7+yHtBggA0TFhzgvkjuhpmRX6zmWsC5heTSmngCF2ftSIT9MhA
B/Tc7K3GKUOip/HIPUpdQJfTQcX+/vASemnfUsErKgOpIhIHEgNDFzcyRV2sI8bL
1NNbgq0oQRQcHczOhVD+cOaTgS2b640=
=nDyS
-----END PGP SIGNATURE-----
<<attachment: lists.vcf>>
_______________________________________________ Product-Developers mailing list [email protected] http://lists.plone.org/mailman/listinfo/product-developers
