def create(request): if request.POST: form = AmtForm(request.POST, request.FILES) if form.is_valid(): form.save() username = request.POST.get('user', ' ') user = Amt.objects.get(user=username) photo_url = "http://sid.pythonanywhere.com/media/" + user.get_photo() create_AMT_hit(user.get_id(), photo_url) return HttpResponse(str(user.get_id()) + ' '+str(photo_url)) else: form = AmtForm() args = {} args.update(csrf(request)) args['form'] = form return render_to_response('create_amt.html', args)
return True sqlite_db_path = "/home/sid/csce438/db.sqlite" conn = lite.connect(sqlite_db_path) cur = conn.cursor() # Get SQLite version cur.execute('''SELECT SQLITE_VERSION()''') result = cur.fetchone() print "SQLite version: %s" % result # Create table if it doesn't exist yet if (table_exists(cur, "amt") == False): cur.execute('''CREATE TABLE amt (user TEXT, password TEXT, photo TEXT, HITId TEXT)''') #cur.execute('''INSERT INTO amt_amt VALUES ('abcd1234', 'new_user_meow', 'meowmeow', 'http://sid.pythonanywhere.com/static/sample_pic.jpg', NULL)''') #conn.commit() amt.create_AMT_hit(18, 'http://sid.pythonanywhere.com/static/sample_pic.jpg') t = (18,) cur.execute('''SELECT * FROM amt_amt WHERE id=?''', t) result = cur.fetchone() print result #print amt.get_AMT_progress('abcd1234') #print amt.get_AMT_score('abcd1234') conn.commit() conn.close()