...but I cannot get it to work. As soon as I start the service via the
service console, it terminates without an error code. It tried 32/64 bit
version of nssm, w and w/o quotes for the paths. In procexp I see that the
python.exe is started but it terminates immediately.
pythonw.exe without
HI,
Started working on a project where the team is already working on using
extjs to develop the views. Each view of web2py application is basically an
ExtJS application. They've placed extjs library in
web2py/applications/app/static /extjs and created an extjs_views folder in
Do you know jqwidgets from www.jqwidgets.com? That's a superb jquery based
widgets, than i think may be included in web2py.
There are a commercial licence, but you can use jQWidgets for free under
the Creative Commons Attribution-NonCommercial 3.0
and about this one?
http://www.jeasyui.com/index.php
2013/4/5 puercoespin jzaragoza.puercoes...@gmail.com
Do you know jqwidgets from www.jqwidgets.com? That's a superb jquery
based widgets, than i think may be included in web2py.
There are a commercial licence, but you can use jQWidgets for
I dug around in the event log and found:
Started C:\Python27\pythonw.exe D:\web2py\web2py.py -K imagecontest for
service web2py_scheduler_imagecontest4 in C:\Python27\.
Program C:\Python27\pythonw.exe for service web2py_scheduler_imagecontest4
exited with return code 1.
Killing process tree
I have the following code:
fig = plt.figure(1, figsize=(6,6))
ax = fig.add_axes([0.1,0.1,0.8,0.8])
labels = 'Female', 'Male'
fracs = [50,50]
ax.pie(fracs, labels=labels, autopct='%1.1f%%', shadow=True)
image_folder=os.path.join(request.folder, 'static/tmp/')
fig.savefig('%stest.png' %
Can someone confirm whether the issue with options_std.py/options.py is
worth filing a bug about? It may be trivial but it seems unnecessarily
broken.
Walter
--
---
You received this message because you are subscribed to the Google Groups
web2py-users group.
To unsubscribe from this group
As soon as I get home I'll make screenshot of the configs I hadn't any
problems a few months back, but I'll recheck for sure and post here or on
web2pyslices.com the steps involved.
On Friday, April 5, 2013 11:34:30 AM UTC+2, Marian wrote:
I dug around in the event log and found:
what db are you using ?
On Friday, April 5, 2013 6:24:13 AM UTC+2, Yoel Benitez Fonseca wrote:
i have this setup:
2 severs with the same web2py app installed, each of then run a
scheluder worker
the problem is that only one of then get jobs, and in
db.scheluder_worker the one with do
Hi everyone,
I have noticed that i cannot use 2 or more datetime validators on the
same field.
I'm building a SCRUM project management app. Making the sprints module I
need to validate that a new sprint is inside the project date range, and
at the same time, the sprint doesn't overlaps with
also this one:
http://www.slideshare.net/blackthorne/web2pyweb-development-like-a-boss
On Thursday, April 4, 2013 11:56:20 AM UTC+1, Francisco Costa wrote:
Hi,
I'm going to give a briefly presentation about web2py this Saturday:
That would be awesome. Thanks for the great work! :)
On Friday, April 5, 2013 12:46:36 PM UTC+2, Niphlod wrote:
As soon as I get home I'll make screenshot of the configs I hadn't
any problems a few months back, but I'll recheck for sure and post here or
on web2pyslices.com the steps
Hi! I'm newbie with web2py.
I do tutorial in FORM chapter
Model
db.define_table('person', Field('personname', 'string', requires =
IS_NOT_EMPTY()))
Controller :
def index():
form = SQLFORM(db.person)
if form.process().accepted:
also this one:
http://www.slideshare.net/blackthorne/web2pyweb-development-like-a-boss
And Bruno Rocha's work:
Slides (Demistificando web2py)
http://www.slideshare.net/rochacbruno/desmistificando-web2py-tdc2011
Video (IDE, pra que?)
http://vimeo.com/26387038
Perhaps you need to check
that's the one in the header comments on the scheduler.py itself.
Given that upstart is present in your ubuntu version it's definitely the
shortest way (and simple, also) to run a service.
On Thursday, April 4, 2013 11:57:01 PM UTC+2, Yoel Benitez Fonseca wrote:
i have found this script in the
Hm maybe I have a hint, I found a failed entry in db.scheduler_run:
gluon.shell line 137: sys.exit(1).
When I try to restart the service, I don't get new failed tasks, so I
cannot say where this specific one came from.
On Friday, April 5, 2013 1:36:37 PM UTC+2, Marian wrote:
That would be
redirect('default', 'list')
Should be:
redirect(URL('default', 'list'))
When I submit form with empty value (person name), validation does not work.
What do you mean it doesn't work? Do you not see the error message on the
form? What do you expect, and what happens instead? It
It's hard to answer this without knowing what are the application goals and
what are the issues you're facing. So... what exactly is a problem with the
current approach? What would you like to achieve by restructuring?
Regards,
Ales
On Friday, April 5, 2013 8:45:28 AM UTC+2, at wrote:
HI,
Amazon Simple Email Service (Amazon SES)
http://aws.amazon.com/ses/
--
---
You received this message because you are subscribed to the Google Groups
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For
Hi,
i have a problem.
In my models/db.py file i have this code:
auth.settings.extra_fields['auth_user'] = [Field('deleted', 'boolean',
default=False),
Field('company_id', 'reference
companies', requires=IS_IN_DB(db,db.companies.id))]
In my
models are executed in alphabetical order. db.py and after that
companies.py, you make reference to a non define table. you sould define
companies table right after auth = Auth(db) and before auth.settings.
extra_fields['auth_user'] =
auth = Auth(db)
#
#
#
#
Hey,
I was hoping someone could help me understand what I'm doing wrong.
For some reason, in my SQLFORM.factory created form, even though I had
specified formstyle='divs' and everything else was inside divs, my radio
buttons were still being rendered inside a table.
Which I found odd since
the point is having that db.companies.id evaluated later .
you can pass a string to the is_in_db validator, it shouldn't raise the
error
IS_IN_DB(db, 'companies.id', '%(name)s')
*should* work giving you a nice dropdown too.
On Friday, April 5, 2013 4:48:33 PM UTC+2, ctrlSoft wrote:
models
Thanks guys,
right now my db.py looks like this:
from gluon.tools import Auth, Crud, Service, PluginManager, prettydate
auth = Auth(db)
crud, service, plugins = Crud(db), Service(), PluginManager()
db.define_table('companies',
Field('name', 'string',
Nope.
when auth definition is encountered, if you want to use db.companies.id
written as it is, db.define_table('companies') should have been executead
already.
You need to change your IS_IN_DB call to (db, 'companies.id', '%(name)s')
... notice the ticks around companies.id, it's a string
Hum. from the book
...http://web2py.com/books/default/chapter/29/07#Widgets
Sometimes widgets take additional arguments and one needs to specify their
values. In this case one can use lambda
db.mytable.myfield.widget = lambda field,value:
I have a question about db.table.ALL
In case of:
db(db.table1.id1).select(db.table1.ALL)
this:
db(db.table1.id1).select()
gives the same result.
In case of:
db((db.table1.id1)(db.table1.refID==db.table2.id)).select(db.table1.ALL,db.table2.ALL)
this:
hello, i´m using a sqlform.factory to edit a record.
The form is prepopulated using this code
row=db((db.trabalhador.id==request.args(0))).select().first()
if row:
for field in row:
if field in db.trabalhador.fields:
print setting
recap:
- db.table1.ALL is just a shortcut to db.table1.field1, db.table1.field2,
db.table1.field3, etc etc etc
- select() without arguments selects all fields for all tables involved.
- if you pass something explicit to select() , you get just what you asked
for
tl;dr : exactly what you
Thanks man!
On Friday, April 5, 2013 5:30:38 PM UTC+2, Niphlod wrote:
Nope.
when auth definition is encountered, if you want to use
db.companies.idwritten as it is, db.define_table('companies') should have
been executead
already.
You need to change your IS_IN_DB call to (db,
Hi,
Thanks for your answer, I just wasn't sure I could leave out the .ALL, now
I know for sure ...
Annet
--
---
You received this message because you are subscribed to the Google Groups
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email
to
Note, .ALL is also useful when you don't want to specify any query:
db().select(db.mytable.ALL)
That will give you all the records and all the fields in db.mytable. If you
do specify a query, then calling .select() with no fields is equivalent to
using .ALL.
Anthony
On Friday, April 5, 2013
Note, simply doing (db, 'companies.id', ...) may not completely resolve the
problem. Even doing that, the db.companies table is only getting defined
conditionally when the companies controller is called, but the
db.auth_user table is defined on every request, and it could be used by
other
Well, I just tested version 2.4.5 Stable ts 2013.04.04.21.10.38 and all
worked for me. What issue have you encountered?
Anyway, the code was and is experimental (for example it doesn't work on
IE).
If do you want something more tested please try comet messaging included in
web2py as Derek
Hi Massimo,
This class looks really interesting. Do you have any more information on
what types of projects you typically have students complete, what skill
level you are expecting students to reach after completing the course,
maybe a syllabus? For example do you try to gear your course
http://www.techempower.com/blog/2013/04/05/frameworks-round-2/
--
---
You received this message because you are subscribed to the Google Groups
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more
El 5.4.2013 6:47 am, Niphlod escribió:
what db are you using ?
postgres, is the same database shared between servers
On Friday, April 5, 2013 6:24:13 AM UTC+2, Yoel Benitez Fonseca wrote:
i have this setup:
2 severs with the same web2py app installed, each of then run a
scheluder worker
this is the second time the issue is posted and yet I can't find a way to
reproduce it It's true that I'm running two scheduler processes on the
same machine vs one scheduler on on machine and the other on another
separate one, but as far as the assign algorithm is concerned, as long as
I am trying to create a single web2py server with multiple applications
that each use a single CAS provider to handle user authentication. I keep
running into a wall when it comes to getting the applications to work with
the CAS. In particular I get an error from the consumer app that
I am writing a number of Web2py applications. The base CAS application is
an administration system to keep track of users, organizations, groups,
etc. That part is working fine, but now I want to add additional
applications that use this administration system as a CAS provider. I have
been
El 5.4.2013 2:57 pm, Niphlod escribió:
this is the second time the issue is posted and yet I can't find a way
to
reproduce it It's true that I'm running two scheduler processes on
the
same machine vs one scheduler on on machine and the other on another
separate one, but as far as the
I've said in the past that they were unfair to Ruby because they were using
their ruby server in dev mode which recompiles code on every access.
This time, I looked more closely at their 'Flask' setup. They are running
Flask via gunicorn, so you'd think all is good. However, they aren't
I'd also add that it's debatable whether using gunicorn's 'jsonify' is any
better than json.dumps(). They had to add a shim in to make jsonify work.
jsonify adds the correct header for json, whereas json.dumps doesn't. I'd
expect the database performance to take a hit in this setup because of
that should be it
http://www.web2pyslices.com/slice/show/1614/nssm-webserver-and-scheduler-as-services-in-windows-oses
On Friday, April 5, 2013 2:35:15 PM UTC+2, Marian wrote:
Hm maybe I have a hint, I found a failed entry in db.scheduler_run:
gluon.shell line 137: sys.exit(1).
When I try
I get that if you manually force them to pick tasks from different groups
they are processed, but different schedulers with the same group name
should receive the same amount of tasks anyway.
On Friday, April 5, 2013 9:17:23 PM UTC+2, Yoel Benitez Fonseca wrote:
El 5.4.2013 2:57 pm, Niphlod
Post your code on github, link to it here, we could provide you a with a
code review if that's what you're after.
On Thursday, April 4, 2013 6:37:15 AM UTC-7, jjg0 wrote:
Are there any good self paced learning courses on webdev with web2py?
So far I am enjoying learning how to make
I'd suggest all the 'views' be placed in static. Your ExtJS should handle
all the data. Add json services and let the ExtJS consume them. Note that
you won't get form helpers or the security that web2py provides, but you
get the authentication, DAL, automatic jsonifying and caching.
On
more on the matter this is the result of 600 queued tasks all in the
main group, with two different schedulers started with -K appname, with
postgresql
select assigned_worker_name, status, count(*) as howmany
from scheduler_task
group by assigned_worker_name, status
Sorry for the delay.
My DAL code would ideally be something like this:
mems=[135123123,135123154,150012323]
rows=odb(odb.player_master.link_id.belongs(mems)).select()
This works, but I know if I scale up to a large list, as I eventually must,
it will bring complaints lockout from our oracle
will this be an online class per chance for extended/adult students?
On Thursday, April 4, 2013 4:14:01 PM UTC-7, Luca wrote:
I am considering teaching one such class in connection with UCSC in the
Fall of this year.
Luca
On Thursday, April 4, 2013 6:37:15 AM UTC-7, jjg0 wrote:
Are
suppose password='12345' and db.auth_user.first_name=='Lucas'
so i find user by first_name,
row_user=db(db.auth_user.first_name=='Lucas').select().first()
and
row_user.password='pbkdf2(1000,20,sha512)$97448b22487eca1d$dae65c0429430b7ae7bb311fed8e844b6a37ff30'
I've found an issue where the Windows Service isn't working the same as the
command line. I have an options file like this:
import socket
import os
interfaces = [('0.0.0.0',80),('0.0.0.0',443,'server.key','server.crt')]
password = 'testing123'
pid_filename = 'httpserver.pid'
log_filename =
i remember reading somewhere that it's better to use the built-in shell in
web2py, but i can't find the article/post. anyone know (1) if it is
better, and, (2) if so, why?
--
---
You received this message because you are subscribed to the Google Groups
web2py-users group.
To unsubscribe
http://web2py.com/books/default/chapter/34/07#SQLFORM.grid-and-SQLFORM.smartgrid-(experimental)
I tried examples , and one of them gives err:
With SQLFORM.grid you can list all parents:
SQLFORM.grid(db.parent)
all children:
SQLFORM.grid(db.child)
and all parents and children in one table:
I really don't understand.
The query shipped to your oracle instance will be exactly the same using
DAL as the one using bind variables.
The DAL just does binding for you (in the 90% of the cases, better)
If you want to retrieve from a table all records in one query, and you have
a large list
I'd say it's an error on the docs
*SQLFORM.grid(db.parent,left=db.child.on(db.child.parent=db.parent.id)) *
should be
*SQLFORM.grid(db.parent,left=db.child.on(db.child.parent==db.parent.id
http://db.parent.id)) *
i.e. the condition must have two equal signs instead of one.
--
---
Anybody looking for an internship using web2py in the Philadelphia area?
--
---
You received this message because you are subscribed to the Google Groups
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email
to
I's say using nssm.exe will spare you some headaches.
It seems that there are a few errors in winservice.py
You can try to patch it.
self.server = main.HttpServer(
ip=options.ip,
port=options.port,
password=options.password,
You'll better code a view and access it as a fake table.
are there examplses of this?
Is it possible to show virtual fields in grid (in appadmin they don't show
up)?
--
---
You received this message because you are subscribed to the Google Groups
web2py-users group.
To unsubscribe
No it is not. Something in the code must be resetting it.
On Thursday, 4 April 2013 22:13:25 UTC-5, 黄祥 wrote:
hi,
is it normal for list:string type field is empty when on editing page?
e.g.
db.define_table('contact',
*Field('salutation'),*
Field('first_name'),
I have been using matplotlib and never seen this. What version of
web2py/python/matplotlib?
On Friday, 5 April 2013 05:06:23 UTC-5, software.ted wrote:
I have this code:
import matplotlib
matplotlib.use('Agg')
import matplotlib.pyplot as plt
## Graphs
fig = plt.figure(1, figsize=(6,6))
Please do. Looks like a bug.
On Friday, 5 April 2013 05:37:17 UTC-5, wprins wrote:
Can someone confirm whether the issue with options_std.py/options.py is
worth filing a bug about? It may be trivial but it seems unnecessarily
broken.
Edit: Never mind I see someone previously suggested I
I am very much interested in your project. Can you send some screenshots?
Anyway, the problem is that you are probably piping your validator to the
normal one. Can I see your validator and how it is applied?
On Friday, 5 April 2013 06:23:39 UTC-5, demetrio wrote:
Hi everyone,
I have
Can you post a simpler example (including mode) to reproduce the problem?
Looks like the field in the table has a validator which requires an upload.
On Friday, 5 April 2013 11:06:52 UTC-5, Ramos wrote:
hello, i´m using a sqlform.factory to edit a record.
The form is prepopulated using this
If you use CAS you must change:
auth = Auth(db)
into
auth = Auth(db, username=True)
CAS requires a username.
On Friday, 5 April 2013 11:26:50 UTC-5, joe smith wrote:
I am writing a number of Web2py applications. The base CAS application is
an administration system to keep track of users,
Answered in other thread.
On Friday, 5 April 2013 13:19:46 UTC-5, joe smith wrote:
I am trying to create a single web2py server with multiple applications
that each use a single CAS provider to handle user authentication. I keep
running into a wall when it comes to getting the applications
It is not better. The web2py shell is the normal Python shell or the
IPython shell if available. The difference is that the code in the web2py
shell has already imported for you web2py environment (and optionally the
models) so it it like coding in a web2py controller:
python
print db.tables
Where is this?
On Friday, 5 April 2013 16:20:02 UTC-5, Niphlod wrote:
I's say using nssm.exe will spare you some headaches.
It seems that there are a few errors in winservice.py
You can try to patch it.
self.server = main.HttpServer(
ip=options.ip,
By built-in shell, do you mean the one in the admin app? I think there
are sometimes problems with that (particularly with database operations),
so I tend to use the web2py shell in the terminal, which you can start as
follows from the web2py directory:
python web2py.py -S yourapp/[optional
yes. so when working with DAL directly from the shell it's better to
work from the web2py shell in the terminal rather than the admin app
shell? any idea why?
On Fri, Apr 5, 2013 at 2:43 PM, Anthony abasta...@gmail.com wrote:
By built-in shell, do you mean the one in the admin app? I think
Does anyone have any advice?
On Thursday, April 4, 2013 2:29:55 PM UTC+2, Domagoj Kovač wrote:
Hi Guys,
i am new to web2py. I have a problem and i am not sure how to approach it.
I am working on a multitenant application.
I have two tables:
Tenants
- id
- name
- url_sufix
gluon/winservice.py
However, there's a problem.
when you pass --interfaces to rocket, it overrides whatever ip,port you
pass (reading the docs)
normally gluon.widget just discards -i and -p in favour of --interfaces
options_std.py reports interfaces AND ip AND port ... it should be cleared
El vie, 05-04-2013 a las 13:17 -0700, Niphlod escribió:
more on the matter this is the result of 600 queued tasks all in
the main group, with two different schedulers started with -K appname,
with postgresql
select assigned_worker_name, status, count(*) as howmany
from scheduler_task
Thanks for the info, Niphlod.
I will look into the efficiency of the IN clause for my needs, as it
appears to offer a solution which may mollify the IT DBA, and his demands
for bind vars (they are concerned that a looped select will bring the db to
it's knees).
Martin Barnard.
On 6 April
often referred as materialized views for the ones who can spare me a
lecture about what are exactly those :P, let's say you have an
iper-complicated query that reconstructs to a table that you want to
show in a grid just for searching purposes (other purposes not listed,
sorry, they make
On Friday, April 5, 2013 11:58:37 PM UTC+2, Martin Barnard wrote:
Thanks for the info, Niphlod.
I will look into the efficiency of the IN clause for my needs, as it
appears to offer a solution which may mollify the IT DBA, and his demands
for bind vars (they are concerned that a
Well, give the admin shell a try and see if it works. I just had some
problems in the past with db operations not committing (at least on
Windows) -- not sure why. I think the terminal shell is easier to use
anyway (don't have to type print before every command, recall previous
command, etc.).
Ok thank you for your help. Does that mean I have to allow usernames for
login for CAS to work? All of our users now use email addresses. I can get
around the issue by manually creating a auth_user.username column in
Postgres, but a cleaner fix would be as Anthony posted somewhere else:
Hi Folks!
I am trying to migrate my web2py application from one server to another.
I have pack my application and restored the MYSQL database but when I tried
to run it there I got:
InternalError: (1050, uTable 'auth_user' already
exists)https://74.207.229.72/admin/default/errors/novelas#
I have
pass the same migrate argument of you DAL call to auth.define_tables() too
(e.g., auth.define_tables(fake_migrate=True))
On Saturday, April 6, 2013 1:24:33 AM UTC+2, Tito Garrido wrote:
Hi Folks!
I am trying to migrate my web2py application from one server to another.
I have pack my
http://franciscocosta.com/web2py.html
On Thursday, April 4, 2013 11:56:20 AM UTC+1, Francisco Costa wrote:
Hi,
I'm going to give a briefly presentation about web2py this Saturday:
https://tymr.com/event/encontro-python-pt-6-abril-2013-porto/515c6f2a03d36d409716741e
Are there any great
Hi,
i got a couple of errors today which tell me the database is locked. I know
I'm using sqlite. which is less than ideal. I got about 30 users a day
which should be perfectly fine with SQLite.
Especially since I added this part of code:
if not request.env.web2py_runtime_gae:
## if NOT
Hi Folks!
I am trying to use ab to benchmark my website that is hosted on linode
(512MB RAM) using nginx + mysql + web2py, installed via the install script
provided in the book.
Should I point ab to my index? I have been running some tests and the
results are scary...
Server Software:
I fall on this exact problem, I don't see anything about taht in the change
log of 2.4.4. Is this will be fix soon? I mean SQLFORM.grid support for
virtual field
THanks
Richard
On Tue, Dec 18, 2012 at 10:32 AM, Massimo Di Pierro
massimo.dipie...@gmail.com wrote:
Right now grid does not work
is it related to the other field constructor, like required, label, etc?
and for controller i'm using grid.
*default.py*
@auth.requires_login()
def contact():
grid=SQLFORM.grid(db.contact, user_signature=False)
return locals()
*db_wizard.py*
# create table : contact
hi,
is it possible for me to contribute in indonesian language translate?
i'm trying to create new file in languages name : id.py in my application
after that i've define :
*gluon/contrib/plural_rules/id.py*
#!/usr/bin/env python
# -*- coding: utf8 -*-
# Plural-Forms for id (Indonesian)
I migrate applications fairly often, and using fake_migrate_all works best
for me:
db = DAL(...,fake_migrate_all=True)
On Friday, April 5, 2013 5:24:33 PM UTC-6, Tito Garrido wrote:
Hi Folks!
I am trying to migrate my web2py application from one server to another.
I have pack my
You can look at db.stat and start your app with profiler. Look in the
generic.thml view for db.stat you have to the little piece of code in your
view to access it. You can serach de groop for the profiler or check the
book section how to start the shell I think there is explanation there...
Hello,
I am searching way to set class to some row in the html table depend on
particular field value of table row for changing background color of the
row...
Until now I was looping over html table for that but I start to see the
limit of this approach as the number of records grow...
I try
sí, web2pyslices es una buena opción, es posible hacer una automatización en
el código fuente https://github.com/rochacbruno/Movuca
El martes, 2 de abril de 2013 16:54:10 UTC-5, Niphlod escribió:
Here https://github.com/niphlod/w2p_timezone_plugin
As always, you're welcome to submit patches,
Thanks again for the help - it's invaluable to the oracle noob! :D
I'm actually building an analysis system so that my boss can view some
statistical subset of the information based on a few months or weeks. One
part of the data is stored in *our* MySQL database (which our department
control),
Hi!
I was running page speed on my website and all image files from the
database (upload folder) are not cached...
Is there a way to enable cache for them?
Thanks!
Tito
--
Linux User #387870
.
_/_õ|__|
..º[ .-.___.-._| . . . .
.__( o)__( o).:___
--
---
You received
The admin shell has problems maintaining state. I do not consider it
reliable. The terminal shell is rock solid. It is a normal pyhton shell.
On Friday, 5 April 2013 16:48:50 UTC-5, Michael Herman wrote:
yes. so when working with DAL directly from the shell it's better to
work from the
One of the problems is that the extjs implementation has made the
application slow. Because each page is itself an extjs application, it
reloads extjs libs on accessing a view.
So wanted to at least avoid reloading of js libs on each page access
request.
Regards
On Friday, 5 April 2013
94 matches
Mail list logo