ChinaGisRestApi: RestDbInterface.py annotate

annotate RestDbInterface.py @ 11:b8922e13e7b5

fixed xml templates to work with new data structures

author	casties
date	Wed, 11 Aug 2010 15:16:36 +0200
parents	76ac7a721273
children	0fa22c291ff1 b915bce65372

rev	line source
2 61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	1 '''
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	2 Created on 19.5.2010
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	3
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	4 @author: casties
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	5 '''
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	6
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	7 from OFS.Folder import Folder
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	8 from Products.PageTemplates.PageTemplateFile import PageTemplateFile
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	9 from Products.ZSQLExtend import ZSQLExtend
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	10 import logging
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	11
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	12 from zope.interface import implements
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	13 from zope.publisher.interfaces import IPublishTraverse
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	14 from ZPublisher.BaseRequest import DefaultPublishTraverse
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	15 #from zope.publisher.interfaces import NotFound
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	16 #from zope.app import zapi
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	17 #from zope.component import queryMultiAdapter
4 e3ee1f358fe6 new version that doesn't use ZSQLExtend but the database connection more directly. casties parents: 2 diff changeset	18 import Shared.DC.ZRDB.DA
e3ee1f358fe6 new version that doesn't use ZSQLExtend but the database connection more directly. casties parents: 2 diff changeset	19 from Products.ZSQLMethods.SQL import SQLConnectionIDs
2 61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	20
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	21
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	22 class RestDbInterface(Folder):
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	23 """Object for RESTful database queries
7 bd52d9445a41 trying to rework casties parents: 5 diff changeset	24 path schema: /db/{schema}/{table}/
2 61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	25 omitting table gives a list of schemas
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	26 omitting table and schema gives a list of schemas
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	27 """
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	28 implements(IPublishTraverse)
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	29
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	30 meta_type="RESTdb"
4 e3ee1f358fe6 new version that doesn't use ZSQLExtend but the database connection more directly. casties parents: 2 diff changeset	31 manage_options=Folder.manage_options+(
e3ee1f358fe6 new version that doesn't use ZSQLExtend but the database connection more directly. casties parents: 2 diff changeset	32 {'label':'Config','action':'manage_editRestDbInterfaceForm'},
e3ee1f358fe6 new version that doesn't use ZSQLExtend but the database connection more directly. casties parents: 2 diff changeset	33 )
e3ee1f358fe6 new version that doesn't use ZSQLExtend but the database connection more directly. casties parents: 2 diff changeset	34
e3ee1f358fe6 new version that doesn't use ZSQLExtend but the database connection more directly. casties parents: 2 diff changeset	35 # management templates
e3ee1f358fe6 new version that doesn't use ZSQLExtend but the database connection more directly. casties parents: 2 diff changeset	36 manage_editRestDbInterfaceForm=PageTemplateFile('zpt/editRestDbInterface',globals())
2 61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	37
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	38 # data templates
8 a9a49f5765c9 reworking templates and schema casties parents: 7 diff changeset	39 XML_index = PageTemplateFile('zpt/XML_index', globals())
a9a49f5765c9 reworking templates and schema casties parents: 7 diff changeset	40 XML_schema = PageTemplateFile('zpt/XML_schema', globals())
a9a49f5765c9 reworking templates and schema casties parents: 7 diff changeset	41 XML_schema_table = PageTemplateFile('zpt/XML_schema_table', globals())
a9a49f5765c9 reworking templates and schema casties parents: 7 diff changeset	42 HTML_index = PageTemplateFile('zpt/HTML_index', globals())
a9a49f5765c9 reworking templates and schema casties parents: 7 diff changeset	43 HTML_schema = PageTemplateFile('zpt/HTML_schema', globals())
a9a49f5765c9 reworking templates and schema casties parents: 7 diff changeset	44 HTML_schema_table = PageTemplateFile('zpt/HTML_schema_table', globals())
2 61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	45
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	46
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	47
4 e3ee1f358fe6 new version that doesn't use ZSQLExtend but the database connection more directly. casties parents: 2 diff changeset	48 def __init__(self, id, title, connection_id=None):
2 61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	49 """init"""
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	50 self.id = id
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	51 self.title = title
4 e3ee1f358fe6 new version that doesn't use ZSQLExtend but the database connection more directly. casties parents: 2 diff changeset	52 # database connection id
e3ee1f358fe6 new version that doesn't use ZSQLExtend but the database connection more directly. casties parents: 2 diff changeset	53 self.connection_id = connection_id
2 61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	54 # create template folder
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	55 self.manage_addFolder('template')
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	56
4 e3ee1f358fe6 new version that doesn't use ZSQLExtend but the database connection more directly. casties parents: 2 diff changeset	57
e3ee1f358fe6 new version that doesn't use ZSQLExtend but the database connection more directly. casties parents: 2 diff changeset	58 def getCursor(self):
e3ee1f358fe6 new version that doesn't use ZSQLExtend but the database connection more directly. casties parents: 2 diff changeset	59 """returns fresh DB cursor"""
e3ee1f358fe6 new version that doesn't use ZSQLExtend but the database connection more directly. casties parents: 2 diff changeset	60 conn = getattr(self,"_v_database_connection",None)
e3ee1f358fe6 new version that doesn't use ZSQLExtend but the database connection more directly. casties parents: 2 diff changeset	61 if conn is None:
e3ee1f358fe6 new version that doesn't use ZSQLExtend but the database connection more directly. casties parents: 2 diff changeset	62 # create a new connection object
e3ee1f358fe6 new version that doesn't use ZSQLExtend but the database connection more directly. casties parents: 2 diff changeset	63 try:
e3ee1f358fe6 new version that doesn't use ZSQLExtend but the database connection more directly. casties parents: 2 diff changeset	64 if self.connection_id is None:
e3ee1f358fe6 new version that doesn't use ZSQLExtend but the database connection more directly. casties parents: 2 diff changeset	65 # try to take the first existing ID
e3ee1f358fe6 new version that doesn't use ZSQLExtend but the database connection more directly. casties parents: 2 diff changeset	66 connids = SQLConnectionIDs(self)
e3ee1f358fe6 new version that doesn't use ZSQLExtend but the database connection more directly. casties parents: 2 diff changeset	67 if len(connids) > 0:
e3ee1f358fe6 new version that doesn't use ZSQLExtend but the database connection more directly. casties parents: 2 diff changeset	68 connection_id = connids[0][0]
e3ee1f358fe6 new version that doesn't use ZSQLExtend but the database connection more directly. casties parents: 2 diff changeset	69 self.connection_id = connection_id
e3ee1f358fe6 new version that doesn't use ZSQLExtend but the database connection more directly. casties parents: 2 diff changeset	70 logging.debug("connection_id: %s"%repr(connection_id))
e3ee1f358fe6 new version that doesn't use ZSQLExtend but the database connection more directly. casties parents: 2 diff changeset	71
e3ee1f358fe6 new version that doesn't use ZSQLExtend but the database connection more directly. casties parents: 2 diff changeset	72 da = getattr(self, self.connection_id)
e3ee1f358fe6 new version that doesn't use ZSQLExtend but the database connection more directly. casties parents: 2 diff changeset	73 da.connect('')
e3ee1f358fe6 new version that doesn't use ZSQLExtend but the database connection more directly. casties parents: 2 diff changeset	74 # we copy the DAs database connection
e3ee1f358fe6 new version that doesn't use ZSQLExtend but the database connection more directly. casties parents: 2 diff changeset	75 conn = da._v_database_connection
e3ee1f358fe6 new version that doesn't use ZSQLExtend but the database connection more directly. casties parents: 2 diff changeset	76 #conn._register() # register with the Zope transaction system
e3ee1f358fe6 new version that doesn't use ZSQLExtend but the database connection more directly. casties parents: 2 diff changeset	77 self._v_database_connection = conn
e3ee1f358fe6 new version that doesn't use ZSQLExtend but the database connection more directly. casties parents: 2 diff changeset	78 except Exception, e:
e3ee1f358fe6 new version that doesn't use ZSQLExtend but the database connection more directly. casties parents: 2 diff changeset	79 raise IOError("No database connection! (%s)"%str(e))
e3ee1f358fe6 new version that doesn't use ZSQLExtend but the database connection more directly. casties parents: 2 diff changeset	80
5 7539a9e69365 small fix casties parents: 4 diff changeset	81 cursor = conn.getcursor()
4 e3ee1f358fe6 new version that doesn't use ZSQLExtend but the database connection more directly. casties parents: 2 diff changeset	82 return cursor
e3ee1f358fe6 new version that doesn't use ZSQLExtend but the database connection more directly. casties parents: 2 diff changeset	83
e3ee1f358fe6 new version that doesn't use ZSQLExtend but the database connection more directly. casties parents: 2 diff changeset	84 def executeSQL(self, query, *args):
e3ee1f358fe6 new version that doesn't use ZSQLExtend but the database connection more directly. casties parents: 2 diff changeset	85 """execute query with args on database and return all results.
e3ee1f358fe6 new version that doesn't use ZSQLExtend but the database connection more directly. casties parents: 2 diff changeset	86 result format: {"fields":fields, "rows":data}"""
e3ee1f358fe6 new version that doesn't use ZSQLExtend but the database connection more directly. casties parents: 2 diff changeset	87 cur = self.getCursor()
e3ee1f358fe6 new version that doesn't use ZSQLExtend but the database connection more directly. casties parents: 2 diff changeset	88 cur.execute(query, args)
e3ee1f358fe6 new version that doesn't use ZSQLExtend but the database connection more directly. casties parents: 2 diff changeset	89 # description of returned fields
e3ee1f358fe6 new version that doesn't use ZSQLExtend but the database connection more directly. casties parents: 2 diff changeset	90 fields = cur.description
e3ee1f358fe6 new version that doesn't use ZSQLExtend but the database connection more directly. casties parents: 2 diff changeset	91 # get all data in an array
e3ee1f358fe6 new version that doesn't use ZSQLExtend but the database connection more directly. casties parents: 2 diff changeset	92 data = cur.fetchall()
e3ee1f358fe6 new version that doesn't use ZSQLExtend but the database connection more directly. casties parents: 2 diff changeset	93 cur.close()
e3ee1f358fe6 new version that doesn't use ZSQLExtend but the database connection more directly. casties parents: 2 diff changeset	94 return {"fields":fields, "rows":data}
e3ee1f358fe6 new version that doesn't use ZSQLExtend but the database connection more directly. casties parents: 2 diff changeset	95
2 61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	96
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	97 def publishTraverse(self,request,name):
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	98 """change the traversal"""
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	99 # get stored path
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	100 path = request.get('restdb_path', [])
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	101 logging.debug("publishtraverse: name=%s restdb_path=%s"%(name,path))
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	102
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	103 if name == "index_html":
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	104 # end of traversal
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	105 return self.index_html
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	106 #TODO: should we check more?
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	107 else:
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	108 # traverse
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	109 if len(path) == 0:
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	110 # first segment
8 a9a49f5765c9 reworking templates and schema casties parents: 7 diff changeset	111 if name == 'db':
2 61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	112 # virtual path -- continue traversing
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	113 path = [name]
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	114 request['restdb_path'] = path
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	115 else:
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	116 # try real path
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	117 tr = DefaultPublishTraverse(self, request)
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	118 ob = tr.publishTraverse(request, name)
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	119 return ob
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	120 else:
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	121 path.append(name)
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	122
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	123 # continue traversing
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	124 return self
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	125
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	126 def index_html(self,REQUEST,RESPONSE):
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	127 """index method"""
8 a9a49f5765c9 reworking templates and schema casties parents: 7 diff changeset	128 # ReST path was stored in request
2 61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	129 path = REQUEST.get('restdb_path',[])
8 a9a49f5765c9 reworking templates and schema casties parents: 7 diff changeset	130 # type and format are real parameter
a9a49f5765c9 reworking templates and schema casties parents: 7 diff changeset	131 format = REQUEST.get('format','HTML').upper()
a9a49f5765c9 reworking templates and schema casties parents: 7 diff changeset	132 type = REQUEST.get('type',None)
a9a49f5765c9 reworking templates and schema casties parents: 7 diff changeset	133 logging.debug("index_html path=%s format=%s type=%s"%(path,format,type))
a9a49f5765c9 reworking templates and schema casties parents: 7 diff changeset	134
a9a49f5765c9 reworking templates and schema casties parents: 7 diff changeset	135 if type is not None:
a9a49f5765c9 reworking templates and schema casties parents: 7 diff changeset	136 # non-empty type -- look for template
a9a49f5765c9 reworking templates and schema casties parents: 7 diff changeset	137 pt = getattr(self.template, "%s_%s"%(format,type), None)
a9a49f5765c9 reworking templates and schema casties parents: 7 diff changeset	138 if pt is not None:
a9a49f5765c9 reworking templates and schema casties parents: 7 diff changeset	139 return pt(format=format,type=type,path=path)
a9a49f5765c9 reworking templates and schema casties parents: 7 diff changeset	140
2 61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	141 if len(path) == 1:
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	142 # list of schemas
8 a9a49f5765c9 reworking templates and schema casties parents: 7 diff changeset	143 return self.showListOfSchemas(format=format)
2 61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	144 elif len(path) == 2:
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	145 # list of tables
8 a9a49f5765c9 reworking templates and schema casties parents: 7 diff changeset	146 return self.showListOfTables(format=format,schema=path[1])
2 61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	147 elif len(path) == 3:
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	148 # table
8 a9a49f5765c9 reworking templates and schema casties parents: 7 diff changeset	149 return self.showTable(format=format,schema=path[1],table=path[2])
2 61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	150
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	151 # don't know what to do
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	152 return str(REQUEST)
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	153
4 e3ee1f358fe6 new version that doesn't use ZSQLExtend but the database connection more directly. casties parents: 2 diff changeset	154
2 61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	155 def showTable(self,format='XML',schema='public',table=None):
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	156 """returns PageTemplate with tables"""
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	157 logging.debug("showtable")
9 76ac7a721273 more rework of templates casties parents: 8 diff changeset	158 pt = getattr(self.template, '%s_schema_table'%format, None)
2 61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	159 if pt is None:
9 76ac7a721273 more rework of templates casties parents: 8 diff changeset	160 return "ERROR!! template %s_schema_table not found"%format
2 61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	161
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	162 data = self.getTable(schema,table)
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	163 return pt(data=data,tablename=table)
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	164
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	165
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	166 def getTable(self,schema='public',table=None,username='guest'):
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	167 """return table data"""
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	168 logging.debug("gettable")
4 e3ee1f358fe6 new version that doesn't use ZSQLExtend but the database connection more directly. casties parents: 2 diff changeset	169 data = self.executeSQL("select * from %s"%table)
2 61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	170 return data
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	171
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	172 def showListOfTables(self,format='XML',schema='public'):
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	173 """returns PageTemplate with list of tables"""
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	174 logging.debug("showlistoftables")
9 76ac7a721273 more rework of templates casties parents: 8 diff changeset	175 pt = getattr(self.template, '%s_schema'%format, None)
2 61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	176 if pt is None:
9 76ac7a721273 more rework of templates casties parents: 8 diff changeset	177 return "ERROR!! template %s_schema not found"%format
2 61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	178
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	179 data = self.getListOfTables(schema)
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	180 return pt(data=data,schema=schema)
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	181
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	182 def getListOfTables(self,schema='public',username='guest'):
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	183 """return list of tables"""
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	184 logging.debug("getlistoftables")
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	185 # get list of fields and types of db table
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	186 qstr="""select c.relname FROM pg_catalog.pg_class c
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	187 LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	188 WHERE c.relkind IN ('r','') AND n.nspname NOT IN ('pg_catalog', 'pg_toast')
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	189 AND pg_catalog.pg_table_is_visible(c.oid)"""
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	190 #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"
4 e3ee1f358fe6 new version that doesn't use ZSQLExtend but the database connection more directly. casties parents: 2 diff changeset	191 data=self.executeSQL(qstr)
2 61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	192 return data
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	193
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	194 def showListOfSchemas(self,format='XML'):
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	195 """returns PageTemplate with list of schemas"""
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	196 logging.debug("showlistofschemas")
9 76ac7a721273 more rework of templates casties parents: 8 diff changeset	197 pt = getattr(self.template, '%s_index'%format, None)
2 61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	198 if pt is None:
9 76ac7a721273 more rework of templates casties parents: 8 diff changeset	199 return "ERROR!! template %s_index not found"%format
2 61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	200
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	201 data = self.getListOfSchemas()
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	202 return pt(data=data)
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	203
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	204 def getListOfSchemas(self,username='guest'):
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	205 """return list of schemas"""
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	206 logging.debug("getlistofschemas")
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	207 # TODO: really look up schemas
9 76ac7a721273 more rework of templates casties parents: 8 diff changeset	208 data={'fields': (('schemas',),), 'rows': [('public',),]}
2 61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	209 return data
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	210
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	211
4 e3ee1f358fe6 new version that doesn't use ZSQLExtend but the database connection more directly. casties parents: 2 diff changeset	212 def manage_editRestDbInterface(self, title=None, connection_id=None,
e3ee1f358fe6 new version that doesn't use ZSQLExtend but the database connection more directly. casties parents: 2 diff changeset	213 REQUEST=None):
e3ee1f358fe6 new version that doesn't use ZSQLExtend but the database connection more directly. casties parents: 2 diff changeset	214 """Change the object"""
e3ee1f358fe6 new version that doesn't use ZSQLExtend but the database connection more directly. casties parents: 2 diff changeset	215 if title is not None:
e3ee1f358fe6 new version that doesn't use ZSQLExtend but the database connection more directly. casties parents: 2 diff changeset	216 self.title = title
e3ee1f358fe6 new version that doesn't use ZSQLExtend but the database connection more directly. casties parents: 2 diff changeset	217
e3ee1f358fe6 new version that doesn't use ZSQLExtend but the database connection more directly. casties parents: 2 diff changeset	218 if connection_id is not None:
e3ee1f358fe6 new version that doesn't use ZSQLExtend but the database connection more directly. casties parents: 2 diff changeset	219 self.connection_id = connection_id
e3ee1f358fe6 new version that doesn't use ZSQLExtend but the database connection more directly. casties parents: 2 diff changeset	220
e3ee1f358fe6 new version that doesn't use ZSQLExtend but the database connection more directly. casties parents: 2 diff changeset	221 #checkPermission=getSecurityManager().checkPermission
e3ee1f358fe6 new version that doesn't use ZSQLExtend but the database connection more directly. casties parents: 2 diff changeset	222 REQUEST.RESPONSE.redirect('manage_main')
e3ee1f358fe6 new version that doesn't use ZSQLExtend but the database connection more directly. casties parents: 2 diff changeset	223
2 61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	224
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	225 manage_addRestDbInterfaceForm=PageTemplateFile('zpt/addRestDbInterface',globals())
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	226
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	227 def manage_addRestDbInterface(self, id, title='', label='', description='',
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	228 createPublic=0,
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	229 createUserF=0,
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	230 REQUEST=None):
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	231 """Add a new object with id id."""
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	232
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	233 ob=RestDbInterface(str(id),title)
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	234 self._setObject(id, ob)
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	235
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	236 #checkPermission=getSecurityManager().checkPermission
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	237 REQUEST.RESPONSE.redirect('manage_main')
61a3764cd5fb new version RestDbInterface with working traversal and templates casties parents: diff changeset	238
5 7539a9e69365 small fix casties parents: 4 diff changeset	239

Mercurial > hg > ChinaGisRestApi

annotate RestDbInterface.py @ 11:b8922e13e7b5