Thanks Massimo, Mr. Freeze and Weheh. In the end I just used
form.vars.file.file.read(15) to make sure it was a SQLite file to begine with.
At first I'd neglected to followup with a form.vars.file.file.seek(0) to reset
the read position in the file. It's pretty important to remember that piece
Thanks again.
On Sun, Dec 05, 2010 at 06:22:54PM -0800, mdipierro spake:
> from python you can read the file content with
> form.vars.file.file.read()
>
> On Dec 5, 8:16 pm, "mr.freeze" <nat...@freezable.com> wrote:
> > Onvalidation is called before the file is stored on disk. You can
> > define a custom_store method on the field to control how and where it
> > is stored. I don't know of a way to open the file with sqlite from the
> > cgi FieldStorage object form.vars.file.
> >
> > On Dec 5, 7:11 pm, "G. Clifford Williams" <g...@notadiscussion.com>
> > wrote:
> >
> > > I have a project that requires users to upload transaction files. These
> > > files
> > > are sqlite databases created with a desktop application. I'm trying to
> > > figure
> > > out a way to ensure that the files uploaded by the various users are
> > > infact
> > > valid transaction files from the proper version of the appropriate
> > > application.
> > > Since they are sqlite3 this _should_ be pretty easy with Python.
> >
> > > I've crated an onvalidation function that can pass off parameters to
> > > another
> > > function that checks for the appropriate fields in the transaction file.
> > > The
> > > problem is that I can't seem to get the name of the uploaded file as a
> > > string
> > > that I can pass along to transaction_test().
> >
> > > My question(s):
> > > How can I access the name of the file (as stored on disk)?
> > > Is the name of the file only accessible after the form has been
> > > accepted?
> >
> > > model:
> > > ...
> > > db.define_table('transaction',
> > > Field('property', 'string',
> > > requires=IS_MATCH('^[\w.-]{2,32}$',
> > > error_message = 'Invalid characters')),
> > > Field('owner', db.auth_user, default=auth.user_id,
> > > readable=False, writable=False,),
> > > Field('visibility', 'boolean', label='List publicly', default=True),
> > > Field('description', 'text'),
> > > Field('created_on', 'datetime', readable=True, writable=False,),
> > > Field('file', 'upload', uploadseparate=True),
> > > )
> >
> > > controller:
> > > ...
> > > @auth.requires_login()
> > > def create():
> > > mechanism = request.args(0)
> > > if mechanism == 'upload':
> > > message = "Upload your Transaction"
> > > db.transaction.file.writable=True
> > > db.transaction.file.readable=True
> > > form = crud.create(db.transaction, onvalidation=upload_proc)
> > > else:
> > > message = "Create a new Transaction"
> > > db.transaction.file.writable=False
> > > db.transaction.file.readable=False
> > > form = crud.create(db.transaction, onvalidation=scratch_proc)
> > > return dict(message=T(message), form=form)
> >
> > > def upload_proc(form):
> > > form.vars.created_on = request.now #set time stamp properly
> > > print form.vars.file.filename
> > > if transaction_test(form.vars.file):
> > > import os.popen2
> > > popen2(transaction_BIN+' rebuild '+ form.vars.file)
> > > else:
> > > form.errors.file = "File is not a valid transaction repo"
> > > ...
> >
> > > def transaction_test(transaction_file):
> > > #simple test to see whether 'transaction_file' is actually a sqlite3
> > > database
> > > #with some key tables required for transactions from (REDACTED)
> > > import sqlite3
> > > dbobj = sqlite3.connect(str(transaction_file.upload))
> > > dbcursor = connection.cursor()
> > > query_string = "SELECT name FROM sqlite_master WHERE type='table' AND
> > > " +\
> > > "name='receiver' OR name='bursar' OR name='clagent' "
> > > +\
> > > "name='lbroker' OR name='bbroker' OR name='loc';"
> > > dbcursor.execute(query_string)
> > > rows_returned = len(db.fetchall())
> > > ...
> >
> > > Thanks in advance...
> > > --Cliff
> >
> >
