web2py

how can I make 'between' query with web2py.DAL?

Hi, I'm trying to make a query function that accepts two datetime.date object(start_date and end_date), and return all records with a related field that's between start_date and end_date. However, I found nothing like a between function in the web2py manual, so I implement it this way: for o in objects: # notice that...

Web2Py Working Directory

Well I want to use WEb2Py because it's pretty nice.. I just need to change the working directory to the directory where all my modules/libraries/apps are so i can use them. I want to be able to import my real program when I use the web2py interface/applications. I need to do this instead of putting all my apps and stuff inside the Web2P...

Web2py Import Once per Session

I'm using Web2Py and i want to import my program simply once per session... not everytime the page is loaded. is this possible ? such as "import Client" being used on the page but only import it once per session.. ...

"download link " fails in IE

Hi, all. I was trying to implement a "download link" and put it beside one of my report table so that users can download a csv file and open it with applications like Excel. The records are generated dynamically based on the query made by users. So somewhere in my controller there's something like: response.headers['Content-Type'] = ...

web2py Exception in sql rows

when i do the following code: family_members =db(db.member.id == membership_id).select (db.member.name,db.member.id) family_members.colnames = ('Name ','Membership ID') It cause the following error "" Traceback (most recent call last): File "/home/abeer/Desktop/web2py/New_version/web2py_src/web2py/gluon/ restricted.py", line 184, in ...

Using Nose & NoseXUnit on a Python package

This is a previous post detailing a CI setup for Python. The asker and answerer detail the use of Nose and NoseXUnit with Hudson for their builds. However, NoseXUnit throws an error when run on any source folder where init.py is present: File "build/bdist.linux-x86_64/egg/nosexunit/tools.py", line 59, in packages nosexunit.except...

web2py - my application doesn' login

i have a web2py application and am using default/user/login to login to my application but sometimes when i login the application redirect to the login page agin and sometimes the system logged fine and there is no problem i dont know why ? so please can anyone tell me ? Thanks in advance ...

DAL without web2py

I am using web2py to power my web site. I decided to use the web2py DAL for a long running program that runs behind the site. This program does not seem to update its data or the database (sometimes). from gluon.sql import * from gluon.sql import SQLDB from locdb import * # contains # db = SQLDB("mysql://user/pw@localhost/mydb", pool...

what's the most extensible/flexible FOSS e-commerce software? (or should I roll-my-own?)

I need to build an internal order entry and tracking system for a grocery store which requires many of the features of existing e-commerce systems, such as product catalog, customer_to_order relations/views, movement reporting, order statuses, etc. However, the first phase of the product is purely internal, so I don't need any online e-...

web2py, OAuth and LinkedIn

Hi everyone, i am new to Python and Web2py and i am developing an app that will use the LinkedIn api I use this library http://code.google.com/p/python-linkedin/ (it includes OAuth). My problem is very strange and that s why i am writing to the list. When i try to connect to LinkedIn from the web2py console i get a request Token. When i...

web2py and GNU GPL v2.0

web2py is listed under GNU GPL v2.0 so my question is: If I develop an application using web2py do I have to release it under GNU GPL v2.0? ...

Designing to easily migrate to Google App Engine

I am going to start designing a web app shortly, and while I have lots of experience doing it in the SQL world, I have no idea what I need to take into consideration for doing so with the goal of migrating to GAE in the very near future. Alternatively, I could design the app for GAE from the start, and so in that case, what are the diff...

Some doubts on implementing custom error pages in Web2Py

I'm trying to implement a decorator for custom error pages in web2py as per one of the haiti Todos. Ref - http://web2py.com/AlterEgo/default/show/75 I'm trying to keep it as a module in /modules directory so that I can import it into the controllers and place the decorator appropriately. I have kept error handling decorator as /modules...

Pyjamas & JavaScript: Too much recursion

I'm doing a Pyjamas example and get this error: TodoApp InternalError: too much recursion Here is the significant portion of TodoApp.py from the linked tutorial (please ignore indentation from the copy/paste): class TodoApp: def onModuleLoad(self): self.remote = DataService() panel = VerticalPanel() self.todoTextBox = T...

web2py or grok (zope) on a big portal,

Hi, I am planning to make some big project (1 000 000 users, approximately 500 request pre second - in hot time). For performance I'm going to use no relational dbms (each request could cost lot of instructions in relational dbms like mysql) - so i can't use DAL. My question is: how web2py is working with a big traffic, is it work c...

How to best design a date/geographic proximity query on GAE?

Hi all, I'm building a directory for finding athletic tournaments on GAE with web2py and a Flex front end. The user selects a location, a radius, and a maximum date from a set of choices. I have a basic version of this query implemented, but it's inefficient and slow. One way I know I can improve it is by condensing the many individual ...

web2py error while using distinct in the queries

Hi, I am using web2py with GAE. While using some of the queries which has a distinct clause, GAE throws out an error.I have pasted the Traceback. Can someone please help me out with this. In FILE: /base/data/home/apps/panneersoda/1.341206242889687944/applications/init/controllers/default.py Traceback (most recent call last): File...

Sending email from an web2py on GAE

I am trying to send a mail from my web2py app hosted on GoogleAppEngine. But it is not working. I used the mail function that was given with the web2py. Does anybody how to do this? I read in the GAE Documentation that python mail library would not work with GAE and GAE mail library has to be used. Does it also applies to web2py mail? Th...

jQuery as a replacement for Django or Web2Py

Hi all, I was planning to write a new webapp, I figured out two options for my backend - web2py or django. I recently came across jQuery and found it to be very cool. Could I just use jQuery as a replacement for django and web2py and finish this webapp. Some features that I'm going to implement - user profiles, users can add content...

Unit testing in Web2py

I'm following the instructions from this post but cannot get my methods recognized globally. The error message: ERROR: test_suggest_performer (__builtin__.TestSearch) ---------------------------------------------------------------------- Traceback (most recent call last): File "applications/myapp/tests/test_search.py", line 24, in t...