{"id":724,"date":"2017-02-01T15:53:26","date_gmt":"2017-02-01T15:53:26","guid":{"rendered":"http:\/\/jafma.net\/ana\/theweekendarchaeologist\/?p=724"},"modified":"2017-02-01T15:58:06","modified_gmt":"2017-02-01T15:58:06","slug":"gvsig-python-accesing-mysql","status":"publish","type":"post","link":"https:\/\/jafma.net\/ana\/theweekendarchaeologist\/?p=724","title":{"rendered":"gvSIG + Python = accesing MySQL"},"content":{"rendered":"\"Facebook\"<\/a>\"twitter\"<\/a>\"reddit\"<\/a>\"pinterest\"<\/a>\"linkedin\"<\/a>\"mail\"<\/a>

La versi\u00f3n 2.3\u00a0de gvSIG Desktop<\/a> no permite a\u00f1adir capas a partir de una base de datos MySQL. Esto se puede resolver de forma sencilla usando la estupenda capacidad de scripting Python de gvSIG<\/a>; basta con incluir el driver JDBC apropiado<\/a> en el directorio de gvSIG, conectarse a la base de datos, y hacer la consulta deseada. A partir de ah\u00ed, pueden crearse las capas necesarias y a\u00f1adirlas a nuestro proyecto, como se muestra en esta otra entrada del blog<\/a>. Al final de la entrada (y tambi\u00e9n en mi repositorio\u00a0GitHub<\/a>) puede verse el c\u00f3digo m\u00ednimo para acceder a la base de datos y hacer una consulta.<\/p>\n

gvSIG Desktop<\/a> 2.3 does not allow to add layers from a MySQL database. This can be easily\u00a0solved using the great Python scripting<\/a> utilities provided by gvSIG; you just have to include the proper JDBC driver<\/a> in your gvSIG folder, then connect to the database and do your query. Those data can be stored\u00a0in a new layer and then added into our proyect, as it is shown in this previous\u00a0post<\/a>. At the end of this post (and also in my GitHub repository<\/a>) you can see the minimun code required to accesing a database and retrieving information.<\/p>\n

 <\/p>\n

import sys
\nimport os
\nfrom gvsig import *
\nfrom gvsig import geom
\nfrom gvsig.geom import *
\nfrom java.util import Properties<\/p>\n

sys.path.append(“\/pathtomygvSIGfolder\/mysql-connector-java-5.1.40-bin.jar”);
\nimport org.gjt.mm.mysql.Driver as Driver<\/p>\n

def main():<\/p>\n

# Connect to the database
\nprops = Properties()
\nprops.put(“user”,”myuser”)
\nprops.put(“password”,”mypasswd”)
\ndb = Driver().connect(“jdbc:mysql:\/\/localhost\/mydb”, props)
\n# Get geometry info from database and insert it into the new layer
\nc = db.createStatement()
\nrs = c.executeQuery(“select * from mytable\u00a0where somecolumn=’somevalue'”)
\nwhile rs.next():
\nid = rs.getString(“somecolumn”)
\nrs.close()
\nc.close()
\ndb.close()<\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

La versi\u00f3n 2.3\u00a0de gvSIG Desktop no permite a\u00f1adir capas a partir de una base de datos MySQL. Esto se puede resolver de forma sencilla usando la estupenda capacidad de scripting Python de gvSIG; basta con incluir el driver JDBC apropiado en el directorio de gvSIG, conectarse a la base de datos, y hacer la consulta … <\/p>\n

Continue reading “gvSIG + Python = accesing MySQL”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[12],"tags":[43,16,55,54],"_links":{"self":[{"href":"https:\/\/jafma.net\/ana\/theweekendarchaeologist\/index.php?rest_route=\/wp\/v2\/posts\/724"}],"collection":[{"href":"https:\/\/jafma.net\/ana\/theweekendarchaeologist\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jafma.net\/ana\/theweekendarchaeologist\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jafma.net\/ana\/theweekendarchaeologist\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jafma.net\/ana\/theweekendarchaeologist\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=724"}],"version-history":[{"count":5,"href":"https:\/\/jafma.net\/ana\/theweekendarchaeologist\/index.php?rest_route=\/wp\/v2\/posts\/724\/revisions"}],"predecessor-version":[{"id":729,"href":"https:\/\/jafma.net\/ana\/theweekendarchaeologist\/index.php?rest_route=\/wp\/v2\/posts\/724\/revisions\/729"}],"wp:attachment":[{"href":"https:\/\/jafma.net\/ana\/theweekendarchaeologist\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=724"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jafma.net\/ana\/theweekendarchaeologist\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=724"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jafma.net\/ana\/theweekendarchaeologist\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=724"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}