Hi everybody,
is it possible in DAL/GAE to aggregate values by several criteri?
E.g. SELECT SUM(x) where z <= 100 and z > 0 and y <= 1000 and y >=
200;
I have done a simple OLAP engine using 'multidimensional hierarchical
clustering' approach, it does not need joins and works pretty fast in
MySQL
Okay, so far I've managed to solve all the other problems but there is
one that I am stuck on. This is the code-
http://web2py.pastebin.com/nQMduejZ
I do not want to store the username/password in the database but I
want to use the auth form for authentication. When I try to go to the
login page,
I am indeed lucky.
For all curious the error went away after I upgraded to the latest
version.
On Apr 12, 6:21 pm, Christopher Steel wrote:
> me too!
>
> On 12 avr, 18:20, Thadeus Burgess wrote:
>
> > lucky, I'm jealous!
> > --
> > Thadeus
>
> > On Mon, Apr 12, 2010 at 4:32 PM, mdipierro wrote
yes. in default/users.html
replace
{{=form}}
with
{{if request.args(0)=='login'}}
{{=form.custom.begin}}
{{=form.custom.widget.email}}
{{=form.custom.widget.password}}
{{=form.custom.submit}}
{{=form.custom.end}}
{{else:}}{{=form}}{{pass}}
On Apr 14, 12:19 am, Rohan wrote:
> Hi All,
>
> I w
Hi All,
I want to change the look and feel of default login form. I want it to
display email and password fields in single row rather than 2
different rows. Any way to customize the default form?
Any pointers?
Thanks
--
To unsubscribe, reply using "remove me" as the subject.
I do not understand.
This should be correct
auth_membership.user_id=4
This should not be correct
auth_membership.user_id='4'
because auth_membership.user_id is a of type 'reference' and therefore
contains an integer. If you are using SQLite it is possible that
auth_membership.user_id conta
Newbie DAL question
I'm new to web2py and I'm trying to get the following code to
work, but it didn't return any results when there should have
been two rows.
user_id = '4'
rows = db(
(db.auth_membership.user_id==user_id) &
(db.auth_membership.group_id==db.auth_group.id) &
(db.auth_me
is there such a list?
In case not I have added it to the user voice page:
http://web2py.uservoice.com/forums/42577-general/suggestions/648813-inline-query-tables
On Apr 14, 12:26 pm, Thadeus Burgess wrote:
> Can you add this to the appropriate TODO list with a link to this group
> posting?
>
>
Can you add this to the appropriate TODO list with a link to this group posting?
--
Thadeus
On Tue, Apr 13, 2010 at 7:59 PM, mdipierro wrote:
> I think this is way to do it. We can add this to the new DAL although
> it is not yet a priority.
>
> On Apr 13, 2:11 pm, Thadeus Burgess wrote:
>>
I think this is way to do it. We can add this to the new DAL although
it is not yet a priority.
On Apr 13, 2:11 pm, Thadeus Burgess wrote:
> it is almost like you need another object, SubTable, which can be
> built from the results of a Set object.
>
> But SubTable can do anything a regular table
2) You are right and misunderstood your question.
The fact is on GAE you can have date, time and datetime field types
and you can search by date ==, <, >, <=, >= but you cannot manipulate
dates (+,month,day,year). For example you can do
db(db.mytable.mydatefield>datetime.date(2009,12,31)).selec
One answer in and while warm it uses for/if ...
it can be done with just DAL.
On Apr 13, 4:28 pm, Thadeus Burgess wrote:
> Also, reply only to DenesL, so you don't give away the answer!
> --
> Thadeus
--
To unsubscribe, reply using "remove me" as the subject.
Also, reply only to DenesL, so you don't give away the answer!
--
Thadeus
On Tue, Apr 13, 2010 at 3:25 PM, DenesL wrote:
> Using the person & dog tables, from the examples in the book, create a
> query to find which persons have less than 4 dogs (0-3).
>
> It seems deceivingly simple, but it
Using the person & dog tables, from the examples in the book, create a
query to find which persons have less than 4 dogs (0-3).
It seems deceivingly simple, but it requires you to apply several
concepts and constructs, some only documented in this user group (not
in the book yet).
Massimo, please
it is almost like you need another object, SubTable, which can be
built from the results of a Set object.
But SubTable can do anything a regular table can do, its information
is just dynamic.
mySubTable = db()._select(db.TasksTimeLog.TheDate,
db.TasksTimeLog.User_id,
db.TaskTimeLog.HoursWorked.su
Thank you Massimo.
re 1. I noticed that I was looking at wrong views/controllers/etc ,
and my applications DID load. I apologize for the false report.
re 2. I will get back to you on this, on your FAQ I saw that GAE
doesn't allow for time/datetime . I am probably confused.
re 3. Thank you.
On A
On Apr 13, 1:44 pm, Yanni wrote:
> Ok, so I'm a bit confused.
>
> 1. I am using web2py on my Windows installation, however, after I stop
> and restart the service, all my work disappears (the views,
> controllers, etc). How do I prevent this from happening?
This should not happening. I have ne
Ok, so I'm a bit confused.
1. I am using web2py on my Windows installation, however, after I stop
and restart the service, all my work disappears (the views,
controllers, etc). How do I prevent this from happening?
2. Is there a way around GAE not allowing the timestamp option? The
application I
The problem from the DAL point of view is not so much building the
queries but referring to fields of a tmp table since there is no
mechanism for it.
I will think some more about it.
On Apr 13, 1:36 pm, Thadeus Burgess wrote:
> I have no immediate use for it.
>
> However, basing queries off of su
I have no immediate use for it.
However, basing queries off of sub-queries(sub-table) happens a lot in
the ms-access world.
--
Thadeus
On Tue, Apr 13, 2010 at 1:08 PM, mdipierro wrote:
> It would be difficult but possible. Is this a priority?
>
> On Apr 13, 10:20 am, Thadeus Burgess wrote:
You found a bug. Thank you for reporting this and I will fix it in
trunk tonight.
Massimo
On Apr 13, 12:01 pm, Igor Gassko wrote:
> Hi,
> I have the following code in my app:
> #import Mail
> from gluon.tools import Mail
> mail=Mail()
> #specify server
> mail.settings.server=
I lost the source of the cookbook manual. It cannot be revised. It is
very old in fact.
On Apr 13, 11:28 am, zxynax wrote:
> Don't know if this is the right place for this.
>
> On page 70 of the cookbook it shows the example below:
> def index():
> form = SQLFORM(db.dog)
> if form.accept(requ
You cannot. You need to write your own logic.
On Apr 13, 10:58 am, npsads wrote:
> You're right, i'm trying to send more then one file using one field.
> But if each upload field must point to one file how can I use
> Mulitfile?
>
> On 13 Kwi, 15:40, mdipierro wrote:
>
> > On a second look. I th
This an easier one. @Achipa, want to do this?
On Apr 13, 10:49 am, Thadeus Burgess wrote:
> If we are working on cron can I inject a feature request?
>
> Support for multiple crontab files in applications//cron
>
> crontab, or plugin_hi.crontab can be read. Alpha order ?
>
> --
> Thadeus
>
> On T
I think had to do with editarea appending spaces.
> It probably has something to do with cross-platform compatibility.
> Since \r and \n mean different things for windows and linux.
>
> --
> Thadeus
>
> On Tue, Apr 13, 2010 at 1:23 AM, Yarko Tymciurak
>
> wrote:
> > On Apr 12, 11:27 pm, mdipierro
It would be difficult but possible. Is this a priority?
On Apr 13, 10:20 am, Thadeus Burgess wrote:
> Interesting, what would be the possibility of adding this as a feature
> to the new dal?
>
> --
> Thadeus
>
> On Tue, Apr 13, 2010 at 5:06 AM, canna wrote:
> > Hello everybody!
>
> > I really ne
Hi,
I have the following code in my app:
#import Mail
from gluon.tools import Mail
mail=Mail()
#specify server
mail.settings.server='mail.mydomain.com:26'
mail.settings.login=None or 'usern...@mydomain.com:password'
#specify address to send as
mail.settings.sender='u
Don't know if this is the right place for this.
On page 70 of the cookbook it shows the example below:
def index():
form = SQLFORM(db.dog)
if form.accept(request.vars,session):
response.flash = "record %i created" % form.vars.id
return dict(form=form)
Neither FORM nor SQLFORM have a m
You're right, i'm trying to send more then one file using one field.
But if each upload field must point to one file how can I use
Mulitfile?
On 13 Kwi, 15:40, mdipierro wrote:
> On a second look. I think you are trying to upload multiple files in
> the same upload field. This is not possible. Ea
If we are working on cron can I inject a feature request?
Support for multiple crontab files in applications//cron
crontab, or plugin_hi.crontab can be read. Alpha order ?
--
Thadeus
On Tue, Apr 13, 2010 at 10:47 AM, AchipA wrote:
> Technically, we don't need to nor are we required to skip
> Section 4.2 of the book explains what happens.
>
> If the URL does not request a static file web2py processes the request
> in the following order:
> • Parses cookies.
> • Creates an environment in which to execute the function.
> • Initializes request, response, cache.
> • Opens the existing se
I have always placed newlines at the end of my programming files...
from day one when I started with Java. I was under the impression that
this was required for all programming
As long as it does not break anything, lets do it. But lets test it
multi-platform before it gets marked as stable. And c
Technically, we don't need to nor are we required to skip *exactly*
one minute. The real question is not 'has 60 seconds passed', but
'have we checked cron in this minute'. I would thus check not for a 60
sec offset, but rather if the minute of cron start matches.
Also in line 51:
s.enter(60 - no
so i think i have to configure in way that it serves only what i have
inside /static/images
(i have put my javascripts into /javascripts and stylsheets
respectively in /stylesheets)
but being the python noob that i am i could not configure the re to
include only what there is in the images folder
On Apr 13, 2010, at 8:16 AM, Thadeus Burgess wrote:
> Agreed, we need more code comments!
>
> Massimo, no more commits unless they contain descriptive comments!
>
> I'm sure there was a reason it doesn't. Most programming languages
> require a newline at the end of your source code file.
>
> It
Interesting, what would be the possibility of adding this as a feature
to the new dal?
--
Thadeus
On Tue, Apr 13, 2010 at 5:06 AM, canna wrote:
> Hello everybody!
>
> I really need help with a query I'm trying to execute in Web2Py DAL
> is there a way to use an inline table in the FROM field
My plan was to read the css/js last modified tags and store the most
recent tag in memcache
Then in a request i ll read all last modified tags and i find smth
more recent than the on in memcache i ll go on with minifying the css/
js and store the merged file in memcache
Then my bundler would write
Agreed, we need more code comments!
Massimo, no more commits unless they contain descriptive comments!
I'm sure there was a reason it doesn't. Most programming languages
require a newline at the end of your source code file.
It probably has something to do with cross-platform compatibility.
Sinc
One thing I forgot to say in the book is that if the controller action
returns a helper this is automatically serialized.
On Apr 13, 9:55 am, DenesL wrote:
> On Apr 13, 10:06 am, greenpoise wrote:
>
> > Hi all. Dont know where to begin when it comes to controllers. I used
> > to develop client/s
You can store the CSS and/or JS in a text field and and write an
action to download it.
On Apr 13, 9:49 am, PanosJee wrote:
> Hello everyone I am working on a CSS/JS merger/minifier (with
> expiration tags) and i want to deploy on AppEngine.
> Unfortunately i cannot read static files on GAE as we
On Apr 13, 10:06 am, greenpoise wrote:
> Hi all. Dont know where to begin when it comes to controllers. I used
> to develop client/server applications and the transition to
> webframeworks web developing in general has been tough for me. Do I
> simply use pure python on web2py controllers?
Yes,
Hello everyone I am working on a CSS/JS merger/minifier (with
expiration tags) and i want to deploy on AppEngine.
Unfortunately i cannot read static files on GAE as web2py has declared
everything in /static as static files
Do you have any ideas on how to circumvent this ?
--
To unsubscribe, repl
Very interesting method.
In theory all tables can be defined and generated this way.
Tables could be defined via forms, enforcing the proper creation
sequence (tables with fields that reference other tables will have to
be created later in the process). Or the generation has to be
controlled via a
Hi all. Dont know where to begin when it comes to controllers. I used
to develop client/server applications and the transition to
webframeworks web developing in general has been tough for me. Do I
simply use pure python on web2py controllers? I bought the book and
its perfect but I need more. Any
Thank you! I thought I was missing something
you right, I used executesql anyway in case my question wont be
answered :-)
Thank you again for clearing this up!
On Apr 13, 4:08 pm, mdipierro wrote:
> DAL cannot do this. You need to use db.executesql(""). sorry.
>
> On Apr 13, 5:06 am, c
Great!
Grazie mille Massimo!
On 13 avr, 15:21, mdipierro wrote:
> Have you tried?
>
> In the index action do not require login and in the index view
> {{=auth.login()}}
>
> Massimo
>
> On Apr 13, 6:58 am, Rohan wrote:
>
> > anyway to customize login form?
>
> > from page source i see form with
On a second look. I think you are trying to upload multiple files in
the same upload field. This is not possible. Each upload field must
point to one file.
On Apr 13, 6:06 am, npsads wrote:
> Hi
> I'm web2py newbie.
> Can anybody show me example how to use jquery.multifile in web2py ?
> This is m
This may be a bug. I will investigate today. If you know python can
help us.
In sqlhtml:
if f == '' or f == None:
if self.vars.get(fd, False) or not self.record:
fields[fieldname] = ''
else:
fie
Have you tried?
In the index action do not require login and in the index view
{{=auth.login()}}
Massimo
On Apr 13, 6:58 am, Rohan wrote:
> anyway to customize login form?
>
> from page source i see form with table inside but no ids.
>
> I have vague idea about it can be done using form.widget
I do not like very much the idea of setting ctime/mtime but I do not
like the current mechanism either. It is not just the pickle overhead.
There seem to be precision issues that make it difficult to skip
exactly one minute. For example right now newcron contains:
if startup or self.now - start >
DAL cannot do this. You need to use db.executesql(""). sorry.
On Apr 13, 5:06 am, canna wrote:
> Hello everybody!
>
> I really need help with a query I'm trying to execute in Web2Py DAL
> is there a way to use an inline table in the FROM field of a query?
>
> this is my query:
>
> SELECT SUM(
Not sure I understand. The datastore is not readonly. The filesystem
is readonly.
On Apr 12, 2:22 pm, Felix wrote:
> Hi,
> I have read that database is readonly from the GAE production
> server. Is there anyother way to access and edit the database?
>
> Thanks
--
To unsubscribe, reply using
Hi
I'm web2py newbie.
Can anybody show me example how to use jquery.multifile in web2py ?
This is my code:
def add():
form=SQLFORM.factory(
Field('description'),
Field('atachment','upload',label='Załączniki'))
if form.accepts(request.vars, session):
response.flash =
Hi,
did you decorate the index action the way it is explained in the book?
Are you sure the Auth class is instantiated correctly in your model?
carlo
On 13 Apr, 09:40, aure wrote:
> Hi everyone,
>
> I already posted that at the end of a discussion ("How to by-pass user/
> login page for authenti
Oh, I'm new to python so didn't know that.. thanks!
On Apr 13, 4:00 pm, Jason Brower wrote:
> For the general features I find is very well documented. It's all in
> the book and that is available all online or with a purchase.
> Additionally, these features are pretty new. I would rather have a
anyway to customize login form?
from page source i see form with table inside but no ids.
I have vague idea about it can be done using form.widget or
form.custom or something like this
Thanks
On Apr 9, 7:52 pm, Thadeus Burgess wrote:
> From any controller.
>
> return dict(auth_form=auth())
>
>
Hey, I don't have a problem with that, just saying the lock-and-read
mechanism can increase the overhead/latency significantly in certain
setups. If a two-file approach is a problem, would you consider
avoiding the cPickle read if I can find a way to do it via setting
ctime/mtime (we set a mtime ol
For the general features I find is very well documented. It's all in
the book and that is available all online or with a purchase.
Additionally, these features are pretty new. I would rather have a
bunch of new features that increase my capabilities, rather than 1 well
documented feature. There
I found all about what I needed... however, I have found that web2py
is not very well documented. We often have to open up the source
files. I hope this problem can be resolved in the future.
On Apr 13, 2:15 pm, Ishbir wrote:
> Hmm.. yeah, that was kind of what I wanted; but isn't there any
> doc
Hello everybody!
I really need help with a query I'm trying to execute in Web2Py DAL
is there a way to use an inline table in the FROM field of a query?
this is my query:
SELECT SUM( HoursWorked / DayHoursSum ) AS DaysWorked
FROM `Tasks_TimeLog` H, (
SELECT TheDate, User_id, SUM( HoursWorked
Hmm.. yeah, that was kind of what I wanted; but isn't there any
documentation to better illuminate the alternate authentication
methods?
On Apr 12, 8:16 pm, mdipierro wrote:
> auth.settings.actions_disabled.append('register')
>
> Auth has a pluggable mechanism for alternate authentication methods
Hi everyone,
I already posted that at the end of a discussion ("How to by-pass user/
login page for authentication"). But I have no clue why it does behave
this way, sorry.
If I put in my index controller:
return dict(form=auth())
then I get error 404 when I try to access my index view.
Yet I
Chris,
Thank you very much for your extensive reply to my post. I apologize
for not replying earlier (bedtime ;-) )
The script you reference above is not the one I used to install
web2py. I read my log and found out that WebFaction no longer provides
the scrip I used:
web2py:http://wiki.webfacti
63 matches
Mail list logo
