")
+ json.dump(ret, RESPONSE)
+ RESPONSE.write("\n\n")
+
+ else:
+ # 400 Bad Request
+ RESPONSE.setStatus(400)
+ return
+
+ def showTable(self,format='XML',schema='public',table=None,REQUEST=None,RESPONSE=None):
"""returns PageTemplate with tables"""
logging.debug("showtable")
+ if REQUEST is None:
+ REQUEST = self.REQUEST
+
+ # should be cross-site accessible
+ if RESPONSE is None:
+ RESPONSE = self.REQUEST.RESPONSE
+
+ RESPONSE.setHeader('Access-Control-Allow-Origin', '*')
+
+ # everything else has its own template
pt = getattr(self.template, '%s_schema_table'%format, None)
if pt is None:
return "ERROR!! template %s_schema_table not found"%format
- data = self.getTable(schema,table)
- return pt(data=data,tablename=table)
+ #data = self.getTable(schema,table)
+ return pt(schema=schema,table=table)
-
- def getTable(self,schema='public',table=None,username='guest'):
+ def getTable(self,schema='public',table=None,sortBy=1,username='guest'):
"""return table data"""
logging.debug("gettable")
- data = self.executeSQL("select * from %s.\"%s\" "%(schema,table))
+ if sortBy:
+ data = self.executeSQL('select * from "%s"."%s" order by %s'%(schema,table,sortBy))
+ else:
+ data = self.executeSQL('select * from "%s"."%s"'%(schema,table))
return data
- def showListOfTables(self,format='XML',schema='public'):
+ def hasTable(self,schema='public',table=None,username='guest'):
+ """return if table exists"""
+ logging.debug("hastable")
+ data = self.executeSQL('select 1 from information_schema.tables where table_schema=%s and table_name=%s',(schema,table))
+ ret = bool(data['rows'])
+ return ret
+
+ def showListOfTables(self,format='XML',schema='public',REQUEST=None,RESPONSE=None):
"""returns PageTemplate with list of tables"""
logging.debug("showlistoftables")
+ # should be cross-site accessible
+ if RESPONSE is None:
+ RESPONSE = self.REQUEST.RESPONSE
+ RESPONSE.setHeader('Access-Control-Allow-Origin', '*')
+
pt = getattr(self.template, '%s_schema'%format, None)
if pt is None:
return "ERROR!! template %s_schema not found"%format
- data = self.getListOfTables(schema)
- return pt(data=data,schema=schema)
+ #data = self.getListOfTables(schema)
+ return pt(schema=schema)
def getListOfTables(self,schema='public',username='guest'):
"""return list of tables"""
logging.debug("getlistoftables")
# get list of fields and types of db table
- qstr="""select c.relname FROM pg_catalog.pg_class c
- LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
- WHERE c.relkind IN ('r','') AND n.nspname NOT IN ('pg_catalog', 'pg_toast')
- AND pg_catalog.pg_table_is_visible(c.oid)"""
- #qstr="select attname, format_type(pg_attribute.atttypid, pg_attribute.atttypmod) from pg_attribute, pg_class where attrelid = pg_class.oid and pg_attribute.attnum > 0"
- data=self.executeSQL(qstr)
+ #qstr="""SELECT c.relname AS tablename FROM pg_catalog.pg_class c
+ # LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
+ # WHERE c.relkind IN ('r','') AND n.nspname NOT IN ('pg_catalog', 'pg_toast')
+ # AND pg_catalog.pg_table_is_visible(c.oid)
+ # AND c.relname ORDER BY 1"""
+ qstr = """SELECT table_name FROM information_schema.tables WHERE table_type = 'BASE TABLE'
+ AND table_schema = %s ORDER BY 1"""
+ data=self.executeSQL(qstr,(schema,))
return data
- def showListOfSchemas(self,format='XML'):
+ def showListOfSchemas(self,format='XML',REQUEST=None,RESPONSE=None):
"""returns PageTemplate with list of schemas"""
logging.debug("showlistofschemas")
+ # should be cross-site accessible
+ if RESPONSE is None:
+ RESPONSE = self.REQUEST.RESPONSE
+ RESPONSE.setHeader('Access-Control-Allow-Origin', '*')
+
pt = getattr(self.template, '%s_index'%format, None)
if pt is None:
return "ERROR!! template %s_index not found"%format
- data = self.getListOfSchemas()
- return pt(data=data)
+ #data = self.getListOfSchemas()
+ return pt()
def getListOfSchemas(self,username='guest'):
"""return list of schemas"""
logging.debug("getlistofschemas")
# TODO: really look up schemas
- data={'fields': (('schemas',),), 'rows': [('public','chgis','mpdl'),]}
+ data={'fields': (('schemas',),), 'rows': [('public',),]}
return data
-
- # Methods for GoogleMaps creation
- def showGoogleMap(self,schema='public',table='mpdl',id=[],doc=None):
- logging.debug("showGoogleMap")
- data = self.getDataForGoogleMap(schema,table,id,doc)
- kmlFileName=self.getKMLname(data=data,table=table)
- initializeStringForGoogleMaps="""onload=\"initialize(\'http://chinagis.mpiwg-berlin.mpg.de/chinagis/REST/daten/"""+kmlFileName+"""\')\""""#+str(data)
- initializeStringForGoogleMaps=initializeStringForGoogleMaps.replace("None","0")
- googleMap_page=str(self.htmlHead())+str(self.getGoogleMapString(initializeStringForGoogleMaps))
- return googleMap_page
-
- def kml_header(self):
- return """
- ")
+ json.dump(res, RESPONSE)
+ RESPONSE.write("\n\n")
+
+ else:
+ return "ERROR: invalid format"
- def getDataForGoogleMap(self,schema='public',table='mpdl',id=[],doc=None):
- logging.debug("getDataForGoogleMap")
- qstr="SELECT * FROM "+schema+".\""+table+"\""
- data={}
- try:
- if id!=[]:
- qstr=qstr+" WHERE "
- for id_item in id.split(","):
- if schema=='mpdl' or table.find('mpdl')>-1:
- qstr=qstr+" mpdl_xmlsource_id = '"+id_item+ "' OR"
-
- else:
- qstr=qstr+" cast(id as text) LIKE '"+id_item+ "' OR"
- qstr=str(qstr).rsplit(" ",1)[0] #to remove last " OR "
- data=self.ZSQLSimpleSearch(qstr)
- return data
- except:
- return qstr
+ def checkTableFromXML(self,schema,table,data,REQUEST=None,RESPONSE=None):
+ """check the table with the given XML data.
+ returns valid data fields and table name."""
+ logging.debug("checkTableFromXML schema=%s table=%s"%(schema,table))
+ # clean table name
+ tablename = sqlName(table)
+ tableExists = self.hasTable(schema, table)
+ if data is None:
+ fieldNames = []
+ else:
+ # get list of field names from upload file
+ fields = self.importExcelXML(schema,tablename,data,fieldsOnly=True)
- def getAttributeList(self, table=""):
- attributeList={}
- if table != "":
- sql_for_attributes="SELECT column_name FROM information_schema.columns WHERE table_name = '"+ str(table) + "' AND column_name NOT LIKE 'the_geom'"
- # print sql_for_attributes
- results=self.ZSQLSimpleSearch(sql_for_attributes)
- # print results
- for result in results:
- if attributeList=={}:
- attributeList=[getattr(result,"column_name")]
- else:
- attributeList.append(getattr(result,"column_name"))
- return attributeList
+ res = {'tablename': tablename, 'table_exists': tableExists}
+ res['fields'] = fields
+ return res
+
+ def createEmptyTable(self,schema,table,fields):
+ """create a table with the given fields
+ returns list of created fields"""
+ logging.debug("createEmptyTable")
-
- def getKMLname(self,data=[],table=""):
- logging.debug("getKMLname")
- kml4Marker=self.kml_header()
- initializeStringForGoogleMaps=""
- gisID=""
- xCoord=0
- yCoord=0
- SQL=""
- unknownPointCounter=0
- kmlFileName="marker"+str(time.time())+".kml"
- attributeList=self.getAttributeList(table)
- # Mapping a set of points from table-based SQL-query:
- if data!=None:
- try:
- SQL="SELECT \"attribute with gis_id\" FROM public.metadata WHERE tablename LIKE %r" % (table)
- gisIDattribute=self.ZSQLSimpleSearch(SQL)
- except:
- return "table not registered within metadata"
- for dataset in data:
- try:
- xCoord=getattr(dataset,'longitude')
- yCoord=getattr(dataset,'latitude')
- if str(xCoord)=='None':
- xCoord=0
- if str(yCoord)=='None':
- yCoord=0
- except:
- try:
- xCoord=getattr(dataset,'x_coord')
- yCoord=getattr(dataset,'y_coord')
- if str(xCoord)=='None':
- xCoord=0
- if str(yCoord)=='None':
- yCoord=0
- except:
- continue2getPoint4GISid=""
- try:
- if float(xCoord)==0 and float(yCoord)==0:
- gisID=getattr(dataset,getattr(gisIDattribute[0],'attribute with gis_id'))
- coords=self.getPoint4GISid(gisID)
- if coords!=None:
- xCoord=coords[0]
- yCoord=coords[1]
- except:
- kml4Marker=kml4Marker + "No Coordinates for:"+gisID +", "+ str(xCoord)+", "+ str(xCoord)+"\n"
- markerTitel=""
- kml4Marker+="\n
+ Search
+ 
+ Create
+ 
+ Open
+
+ Account
+ 
+ Notes
+ | Layer Name | ++ |
|---|---|
| Source Table | ++ |
| Position | |
|---|---|
| Label | |
| Size | |
| Color | |
| Shape | |
| connect markers with a line | |
| Map name | ++ |
|---|
| show | +layer name | +
|---|
+
| 01.10.2010 | You have been granted access to the workspace "buddhist_shrines". | +
| 21.09.2010 | Looks like SomeAnnoyedUser is working on the same thing at the moment, [...] | + | |
| 19.09.2010 | Cool website, definitely have to find out how to use the damn thing. | + |
| Place | Date | gis_id |
|---|---|---|
| Beijing | 1848 | 131451 |
| ... | ... | ... |
| Page | description | source | gis_id |
|---|---|---|---|
| 71 | A description of the [...] | The Big Book of [...] | 93128 |
| ... | ... | ... | ... |
| callno | object | kind | title | ... |
|---|---|---|---|---|
| printing 25 | book | xylograph | Huang Ming dianli | ... |
| ... | ... | ... | ... | ... |
| table loading... |
| table loading... |
| table loading... |
+ Search
+
+ Messages
+
+ Create
+
+ Open
+ This page demonstrates the widgets you downloaded using the theme you selected in the download builder. We've included and linked to minified versions of jQuery, your personalized copy of jQuery UI (js/jquery-ui-1.8.1.custom.min.js), and css/smoothness/jquery-ui-1.8.1.custom.css which imports the entire jQuery UI CSS Framework. You can choose to link a subset of the CSS Framework depending on your needs.
+You've downloaded components and a theme that are compatible with jQuery 1.3+. Please make sure you are using jQuery 1.3+ in your production environment.
+ +YOUR COMPONENTS:
+ + +Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.
+
+ Map
+ 
\
+ 