import sqlite3
def select(self, attr="*", table="reuters", fetch=None, tologfile=False, logfile=""):
if fetch is None:
fetch=self.fetchone
if tologfile:
logfile = open(logfile, 'w')
logfile.write(str(self.execute("select * from ?;".replace('?',table).replace("select * ", ("select "+attr))).fetch()))
logfile.close()
else: return str(self.execute("select * from ?;".replace('?',table).replace("select * ", ("select "+attr))).fetch())
if __name__ == '__main__':
connection = sqlite3.connect('winkwinknudgenudgesaynomore.db')
cursor = connection.cursor()
cursor.execute("drop table reuters;")
cursor.execute("create table reuters (foo text, bar text);")
connection.commit()
print select(cursor)
aW1wb3J0IHNxbGl0ZTMKCmRlZiBzZWxlY3Qoc2VsZiwgYXR0cj0iKiIsIHRhYmxlPSJyZXV0ZXJzIiwgZmV0Y2g9Tm9uZSwgdG9sb2dmaWxlPUZhbHNlLCBsb2dmaWxlPSIiKToKICAgIGlmIGZldGNoIGlzIE5vbmU6CiAgICAgICAgZmV0Y2g9c2VsZi5mZXRjaG9uZQoKICAgIGlmIHRvbG9nZmlsZToKICAgICAgICBsb2dmaWxlID0gb3Blbihsb2dmaWxlLCAndycpCiAgICAgICAgbG9nZmlsZS53cml0ZShzdHIoc2VsZi5leGVjdXRlKCJzZWxlY3QgKiBmcm9tID87Ii5yZXBsYWNlKCc/Jyx0YWJsZSkucmVwbGFjZSgic2VsZWN0ICogIiwgKCJzZWxlY3QgIithdHRyKSkpLmZldGNoKCkpKQogICAgICAgIGxvZ2ZpbGUuY2xvc2UoKQogICAgZWxzZTogcmV0dXJuIHN0cihzZWxmLmV4ZWN1dGUoInNlbGVjdCAqIGZyb20gPzsiLnJlcGxhY2UoJz8nLHRhYmxlKS5yZXBsYWNlKCJzZWxlY3QgKiAiLCAoInNlbGVjdCAiK2F0dHIpKSkuZmV0Y2goKSkKCmlmIF9fbmFtZV9fID09ICdfX21haW5fXyc6ICAgIAogICAgY29ubmVjdGlvbiA9IHNxbGl0ZTMuY29ubmVjdCgnd2lua3dpbmtudWRnZW51ZGdlc2F5bm9tb3JlLmRiJykKICAgIGN1cnNvciA9IGNvbm5lY3Rpb24uY3Vyc29yKCkKICAgIGN1cnNvci5leGVjdXRlKCJkcm9wIHRhYmxlIHJldXRlcnM7IikKICAgIGN1cnNvci5leGVjdXRlKCJjcmVhdGUgdGFibGUgcmV1dGVycyAoZm9vIHRleHQsIGJhciB0ZXh0KTsiKQogICAgY29ubmVjdGlvbi5jb21taXQoKQogICAgcHJpbnQgc2VsZWN0KGN1cnNvcik=