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()