Finding it flaky as well. Probably AWS playing up again.
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscr
I can't seem to get my key to verify:
This is how I verify it:
success = db.melodigram.deletion_key.validate(request.args(1)) ==
(db(db.melodigram.unique_id == request.args(0)).select().first(), None)
And this is how it is made:
form = SQLFORM(db.melodigram)
form.process(session = None, formname
Hello,
I am getting getting this:
(lastval is not yet defined in this
session )
while running:
if db(db.user_role).isempty():
db.user_role.insert(id=1, title='Application Administrator')
db.user_role.insert(id=2, title='Account Administrator')
db.user_role.insert(id=3, title='Accoun
a, i c, so that's why scheduler_task table is have a lot of record. thank
you so much simone. btw, what i want to learn in here is to have a
scheduler to create a new record in database every day, how can i achieve
it using testing example above?
what i have tried is :
*models/db.py*
db.define_
you're missing a BG point.
Either you need to queue a task as a result of some user action (i.e. send
a reminder, calculate/aggregate/refresh some data, etc) --> usually it's a
one-time-only activity, in which case, the following "pattern" applies
#models\scheduler.py
from gluon.scheduler i
was the table created by web2py ?
On Thursday, June 26, 2014 9:53:31 AM UTC+2, at wrote:
>
> Hello,
>
> I am getting getting this:
>
> (lastval is not yet defined in this
> session )
> while running:
> if db(db.user_role).isempty():
> db.user_role.insert(id=1, title='Application Administrat
>
>
>
> Is this expected behaviour?
>
It is even documented :)
Look around here:
http://www.web2py.com/books/default/chapter/29/04/the-core?search=conditional
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https:
Yes
On Thursday, 26 June 2014 14:55:35 UTC+5, Niphlod wrote:
>
> was the table created by web2py ?
>
> On Thursday, June 26, 2014 9:53:31 AM UTC+2, at wrote:
>>
>> Hello,
>>
>> I am getting getting this:
>>
>> (lastval is not yet defined in this
>> session )
>> while running:
>> if db(db.user_
Believe it will be failing with the id=1 etc. Interfering with the primary
key/ auto increment. Try it without.
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues
web2py.py -a yourpassword -K appname -X
does not work on windows
i have web2py 2.9.5 and does not start scheduler at the same time as
web2py
2014-06-06 9:07 GMT+01:00 Niphlod :
> the scheduler doesn't need a decorator... for your own organization you
> can,e.g., put all the functions in one mo
Yes you are right. Without id=1 it's working.
But if I insert data using postgres/psql with id=1, it doesn't give any
error.
Regards,
AT
On Thursday, 26 June 2014 15:39:20 UTC+5, Simon Ashley wrote:
>
> Believe it will be failing with the id=1 etc. Interfering with the primary
> key/ auto incr
Check the data types of element 0 in the tuples.
On Thursday, June 26, 2014 3:37:22 AM UTC-4, Encompass solutions wrote:
>
> I can't seem to get my key to verify:
>
> This is how I verify it:
>
> success = db.melodigram.deletion_key.validate(request.args(1)) ==
> (db(db.melodigram.unique_id == re
I'm use this code:
form = SQLFORM.grid()
form.element('.web2py_counter',replace=None)
On Thu, Jun 26, 2014 at 2:04 AM, JorgeH wrote:
> hello
> Is it possible to turn off the record counter , on the top right of the
> table generated by sqlform.frid ??
>
> --
> Resources:
> - http://web2py.com
Hi,
I try to do exactly the same and have the following in my app:
controller:
def index():
response.js = '$.web2py.component("%s", target="graph1");' %
URL('default', 'graph1.load')
index.html:
graph1.load contains a graph in pure JS
What am I overlooking?
KInd regar
So it's incorrect or impermissible to add records with custom ids?
Thanks
On Thursday, 26 June 2014 16:33:02 UTC+5, at wrote:
>
>
> Yes you are right. Without id=1 it's working.
> But if I insert data using postgres/psql with id=1, it doesn't give any
> error as well.
>
> Regards,
> AT
>
> On
yeah, i realize that something i'm lacked off, unfortunately, i don't know
where is it. tried again using your code but still no luck
started from scratch
*models\db_wizard_0.py*
db.define_table('asdf',
Field('asdf'),
auth.signature )
*models\scheduler.py*
from gluon.scheduler import Sc
Thanks!
On Thursday, June 26, 2014 7:31:28 AM UTC-5, Javier Pepe wrote:
>
> I'm use this code:
>
> form = SQLFORM.grid()
> form.element('.web2py_counter',replace=None)
>
>
> On Thu, Jun 26, 2014 at 2:04 AM, JorgeH >
> wrote:
>
>> hello
>> Is it possible to turn off the record counter , on the top
I have three tables (country, state, and town) each one has a field called
name:
db.define_table('country'
Field('name', 'string'),
... more fields ...
)
db.define_table('state'
Field('name', 'string'),
Field('country_id', 'refe
ok. steps.
web2py.py -a yourpassword
go to /appname/test/queue_task
go to /appname/appadmin/select/db?query=db.scheduler_task.id>0
if nothing is there, then in controller test.py the function queue_task is
not queuing the task.
if a single row is there, then, open a terminal and start the sch
Thanks, Niphlod. I got it working with a custom search widget.
BTW, the original post got a bit garbled when i edited it. Sorry about that.
Thanks again, Niphlod.
Love and peace,
Joe
On Saturday, June 21, 2014 11:46:04 AM UTC-7, Niphlod wrote:
>
> try simplifying the controller stripping the u
I was experimenting with Expose this week and I came across similar
problems. For example, if I click on a subfolder link, the page refreshes
but still displays the contents of the base folder.
After some digging, I think I found the problem. The code in Expose uses
request.raw_args to determin
yes, followed your step, i understood the logic flow of the web2py
scheduler and made it work, thank you so much, simone for the pointers.
just wondering, the precision for second is not exact on created_on, tested
using period = 5 and period = 60
here is the steps i took :
*cmd*
cd C:\web2py\ap
Seems to be a postgresql specific issue. Fails in the DAL at when executing
'select lastval()'. SQlite and MySQL are fine. The command also fails at
the pg command line level. This was changed back in December but uncertain
if the issue existed prior to this
https://groups.google.com/forum/?fromgro
id is implicit and defined as serial, implying that there is a sequence
that is used to fill proper values.
id is intended to be unique and primary key: an integer generator that
guarantee uniqueness or at least has a very low probability of conflict is
the standard way to go. This is very importa
>
> I tend to agree with this. We ended up dropping the id field from
> bulk_insert routines and if we need integrity (for references) in the
> target databases, we would/ should base it on other fields.
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://gith
The group information is loaded on login and cached in the session.
If you check
auth.user_groups you find a dictionary of {group_id:group_role}.
On Wednesday, 25 June 2014 13:08:17 UTC-5, Carlos Zenteno wrote:
>
> I am classifying my users within groups (ie, carpenters group) but I am
> wonde
This is very wrong:
q1 = eval('db. userLanguage.'+ language )== True
what is it supposed to be?
q1 = db.userLanguage[language] == True
I am not sure. Once q1 is correct, this works:
results = db(q1 & q2).select()
On Wednesday, 25 June 2014 17:04:28 UTC-5, Riccardo C wrote:
>
> Dear all,
Pls can someone help here. Am new to web2py. I produce a form using SQLFORM
with a submit button. After filling the form and clicking submit, i
discoverd the values in the form are not saved into the database. I login
using the appadmin, i could create and insert into the database. I will
like
Hello,
I am trying to filter out specific values in an SQLFORM.grid but I can not
figure out how to do this in the Query. Right now I have something like:
(cd.value.contains(filter_value_inc, all=False))
And this gets the values that I want to be included. filter_value_inc holds
a li
Hi there,
Yes I'm new to wep2py *and* to Python (other than having edited some
Gentoo ebuilds many summers ago), but it was the advice for the simplest
web framework to create simple input/edit functionality for a database to
have customer details captured in a closed environment (ie. only tr
Hi,
I am getting this strange error one in 10 times in my app. The error
is " unable to open database file". I am
getting this error after i replaced the *databases* folder with one from my
backup app which is running on a different server. I think the plugin_wiki
is has some problem. I wa
Hi ,
I asked Wing support the following question:
I am using Web2py framework. I saw a video that says the Wing can
> debug a running python code no matter if it launched it itself. When
> reading this: http://wingware.com/doc/howtos/web2py
> I see that I can only debug Web2py in a way that I ne
Sorry being persistent on this, but has somebody any idea why the observed
behavior is in place?
Best regards,
Tom.
On Thursday, June 19, 2014 9:46:06 AM UTC+2, Tom Clerckx wrote:
>
> Hi,
>
> I have some undesired behavior in my app that I was able to resolve, but I
> would like to understand
I have this code here in a different model file called db_nameofapp.py:
dmz.define_table('nds_ticketing_comments',
Field(blah),
Field(blah2),
Field(blah3),
auth.signature
)
DAL breaks when trying to access auth.signature.
in my db.py:
auth = Auth(db)
...
...
..
etc.
Sorry I can't copy and paste
Hello,
I am new to web2py. I am running this application , my form was produced
using SQLFORM. I noticed after i click submit the data don't get inserted
into the database. However if go through the admin and do new record my
database get updated. I dont know if I will have to do commit or som
Massimo,
Your code hash password, but it is not recognized by Joomla. :)
Anyway I have got this class in py from phpass fremwork web page. It works!
Now CUSTOMIZE CRYPT is the last effort. hash_password and check_password
shell be used.
import os
import time
import hashlib
import crypt
Hi gang
I am quite new to web2py and i am confronted to the following lack of my
own knowledge.
In other DB engine one can write :
create table sometable (
a_field varchar(10),
b_field timestamp default date(now()),
unique(a_field, b_field)
);
wich I have reproduce in web2py using
Thank you! :)
On Thursday, June 26, 2014 12:25:00 AM UTC+3, 黄祥 wrote:
>
> afaik, compute didn't work on update. for onupdate, is execute on form
> level not on dal, please take a look at book chapter about that.
>
> ref:
> http://web2py.com/books/default/chapter/29/07/forms-and-validators
>
> bes
No. At least not in the way web2py uses it.
On Wednesday, 25 June 2014 11:58:01 UTC-5, Cliff Kachinske wrote:
>
> Massimo,
>
> I like the way your thoughts are headed.
>
> doesn't the many2many issue goes away if one uses, for example, MongoDB?
>
> On Sunday, June 22, 2014 4:45:06 PM UTC-4, Massim
None of them web2py loads and exec's modes and controller codes at every
request. Not sure that qualifies as "code realoding".
We do not do what Django does because that only works when you use the
built-in web server and not in production with, for example, nginx.
Massimo
On Wednesday, 25 June
Did you do form = SQLFORM(...).process()?
On Thursday, 26 June 2014 11:12:29 UTC-5, haj...@byteplus.com.ng wrote:
>
>
> Hello,
>
> I am new to web2py. I am running this application , my form was produced
> using SQLFORM. I noticed after i click submit the data don't get inserted
> into the datab
this:
FORM.accepts(form, request.vars):
should be
SQLFORM.accepts(form,request.post_vars, session)
or better
form.accepts(request.post_vars, session)
or eve better
form.process()
On Thursday, 26 June 2014 18:24:27 UTC-5, haj...@byteplus.com.ng wrote:
>
>
> Pls can someone help
I would not do it that way. There are two places to enforce uniqueness: at
the database level and at the form level.
To enforce is at the database level you can manually do
create table sometable (
a_field varchar(10),
b_field timestamp default date(now()),
unique(a_field, b_field)
On Thursday, June 26, 2014 11:17:21 PM UTC+2, 黄祥 wrote:
>
> yes, followed your step, i understood the logic flow of the web2py
> scheduler and made it work, thank you so much, simone for the pointers.
> just wondering, the precision for second is not exact on created_on, tested
> using period
44 matches
Mail list logo