open(str(os.sep).join([
    os.getcwd(),
    'applications',
    request.application,
    'databases',
table+'.csv']),'w').write(str(db(db[table].id).select ())) How can i encrypt and descrypt the created file above??

Well, as I was recently admonished (and have come to love), the first recommendation is to use the "csv" module for writing CSV files. It deals with oddities like quotation-escaping, and a bunch of other details.

However, you want some sort of encryption/decryption method, but you don't specify what type. You can do something simple like

  def encrypt(s):
    return s.encode('rot13')
  def decrypt(s):
    return s.decode('rot13')
  f = open(filename, 'wb')
  f.write(encrypt(content))
  f.close()
  f = open(filename, 'r')
  content = decrypt(f.read())
  f.close()

It's not very good encryption though ;-) For better encryption see [1] & [2] for the pycrypto module. It's been a while since I've done anything using this module, but the docs are available for it and the basic premise is the same (encrypt the content before writing, decrypt the content upon reading). It would help to read up on crypto best-practices about storing key-files, password-management, etc.

-tkc


[1]
http://www.pycrypto.org

[2]
http://www.amk.ca/python/code/crypto.html



--
http://mail.python.org/mailman/listinfo/python-list

Reply via email to