def testQ(): import sys host, port, user, passwd = sys.argv[2:6] port = int(port) path = '/administration/.dbq?name1=users&fields1=family%2Cemail%2Ccity%2Cid&key1=id&name2=techplenary2002&fields2=plenary%2Cmeal_choice&key2=&kj2_1=id&name3=&fields3=&key3=&kj3_1=&kj3_2=&name4=&fields4=&key4=&kj4_1=&kj4_2=&kj4_3=' path, fields = split(path, '?') print "CGI parse:", cgi.parse_qs(fields) fields, tables, keys, joins, cond = parseQuery(fields) print "SQL parse:", fields, tables, keys, joins, cond print "as SQL:", asSQL(fields, tables, keys, joins, cond) sink = toXML.ToRDF(sys.stdout, 'stdout:') db = MySQLdb.connect(host=host, port=port, user=user, passwd=passwd, db='administration') dbaddr = 'http://example/administration' askdb(db, dbaddr, sink, fields, tables, keys, joins, cond) sink.endDoc()
def rdfString(self, base=None, flags=""): "Dump the formula to an absolute string in RDF/XML" buffer = StringIO.StringIO() import toXML _outURI = 'http://example.com/' _outSink = toXML.ToRDF(buffer, _outURI, base=base, flags=flags) self.store.dumpNested(self, _outSink) return buffer.getvalue()
def describeTable(self, tbl): self.send_response(200, "@@not sure you're winning yet, actually") self.send_header("Content-type", RDF_MediaType) self.end_headers() s = self.server dbdocaddr = s._base sink = toXML.ToRDF(self.wfile, dbdocaddr) aboutTable(self.server._db, dbdocaddr, sink, tbl) sink.endDoc()
def main(argv): import sys site, max = argv[1:3] max = int(max) f = formula() here = uripath.base() c = Crawler(f, here) c.crawlFrom(site, site, max) f.close() sink = toXML.ToRDF(sys.stdout, here) bind('dc', DC('')) bind('s', RDFS('')) myStore.store.dumpNested(f, sink)
def getView(self): self.send_response(200, "@@not sure you're winning yet, actually") self.send_header("Content-type", RDF_MediaType) self.end_headers() s = self.server dbaddr = s._base sink = toXML.ToRDF(self.wfile, dbaddr) path, qs = split(self.path, '?') fields, tables, keys, joins, cond = parseQuery(qs) askdb(self.server._db, dbaddr, sink, fields, tables, keys, joins, cond) sink.endDoc()
def testShow(): import sys host, port, user, passwd = sys.argv[2:6] port = int(port) dbName = 'administration' #@@ db=MySQLdb.connect(host=host, port=port, user=user, passwd=passwd, db=dbName) dbaddr = 'http://example/administration' sink = toXML.ToRDF(sys.stdout, dbaddr) aboutDB(db, dbaddr, sink) aboutTable(db, dbaddr, sink, 'users') sink.endDoc()