thanks! i didn't remember that i had installed python 2.7 myself and had
to hack it to run with 10.9!
cfh
On Sunday, October 27, 2013 1:46:49 PM UTC-7, Jonathan Lundell wrote:
Just FYI, in case this bites you.
I had installed Python 2.7.2 on my Mac some time back, and had an override
of
Also, keep in mind that there is not really a model on GAE big table
(google datastore), so there is nothing to view in the console until you
write rows to the database. once you write data, you will be able to see
the schema of the data that was written.
cfh
On Sunday, October 27, 2013
interesting i as skim the NDB docs very quickly and the patch above i
see that it is *very* similar to the DB Datastore/Big Table. if the APIs
are the same then we should just use the same DAL adapter with a parameter
to use NDB. Though because of the caching nature of NDB there may be a
Yes, using the same adapter with a parameter is also a possibility i thought
of. Don't really know anymore why i choose this. Maybe because initially i
wanted to create a plugable thingy without changing the DAL code.
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
-
I read the web2py book's chapter on deployment recipes. My application is
now compliant with
all efficiency tricks listed here:
http://web2py.com/books/default/chapter/29/13/deployment-recipes#Efficiency-tricks
I host my app at webfaction. I created a static-only app to serve the files
from
This is a common issue with the scheduler, you have to explicitly force a
commit
db.commit()
Paolo
On Monday, October 28, 2013 3:36:13 AM UTC+1, Ignacio Llamas Avalos Jr
wrote:
I am trying to create a task where every night the following function is
run to decrement the days left on my
Hi,
I'm trying to use DAL in web2py interactive shell.
The troubles is that DAL doesn' show the already defined tables.
I can create new tables perfectly
They show up in SQLLite manager (Firefox add-on).
After closing/reopening the shell, it's as if the database connexion didn't
work
Ola, bom dia... ainda nao consegui resolver esse problema, nao consigo
conectar o postgresql no projeto python/web2py... alguem pode me da mais
alguma dica, ja vi varios exemplos mas nao dá certo...
Em domingo, 27 de outubro de 2013 11h01min51s UTC-2, Carlynhos77 escreveu:
Ola, bom dia..
*Não , Não mexa no Gluon nem crie conexões
Só urilize isto no local onde esta sa conexão sqlite.
*
Dica Macete: Apos substituir a conexao existente do Sqlite por
postgres://username:password@localhost/test
va no diretorio seuweb2py/applications/suaaplicação/databases e delete tudo
deixe zerado
Porque voce nao usa a ORM do web2py, e esta tentando criar o que existe em
models, nao mexa na configuração do gluon
no seu db.py use no local do sqlite:
import psycopg2
db = DAL('postgres://usuario:senha@localhost:5432/meubanco')
OBS.: Usuario do Postgresql e senha do postgres.
Start the shell with:
c:\suzand\swDev\private\web2pypython web2py.py -S gps -M
On Mon, Oct 28, 2013 at 7:10 AM, arutti andre.ru...@gmail.com wrote:
Hi,
I'm trying to use DAL in web2py interactive shell.
The troubles is that DAL doesn' show the already defined tables.
I can create new tables
ola, bom dia rapaz, sinceramente ja me passou pela cabeça largar
isso... e continuar no meu velho e bom Visual Basic... kkk
joguei esse codigo no APPSETINGS.PY
import psycopg2
db = DAL('postgres://postgres:123@localhost:5432/saude')
mando atualizar a tela e dá o erro
Traceback (most
On Sunday, October 27, 2013 8:40:18 PM UTC-4, mr.freeze wrote:
I wouldn't say the use case is odd but it's definitely complex. Then
again, without a context for custom widgets to operate in (i.e. no
knowledge of the record or form that they are bound to) only simple use
cases are
Isto nao faça conexões python dentro do gluon ela ja existe. voce tem que
fazer no models de cada aplicação.
ex: web2py\aplications\minhaapp1\model\db.py
import psycopg2
db = DAL('sqlite://storage.db')
db = DAL(' postgres://username:password@localhost/test')
Para cada aplicação uma conexao ou
If you send me a revised patch to do this, I will include. It may be better
than using a different adapter.
On Monday, 28 October 2013 01:40:41 UTC-5, Quint wrote:
Yes, using the same adapter with a parameter is also a possibility i
thought of. Don't really know anymore why i choose this.
If you are sure that the user that will be manage by other user is 1 to
many (many users that can declared which user is their manager), you can do
that (self-reference). But this is only one part of the problem, I think
you need to create a group of admin_user that are allow to manage other
ola, realmente esse trem nao vai... criei o arquivo db.py, joguei o codigo
nele, tirei as referencias do gluon, dai ja veio outros erros...
vou rever os videos do curso q fiz com o bruno rocha, apesar o curso ser
voltado para o SQLLITE, em algum lugar ele fala das conexoes, vou ver se
ele diz
Posting in english may be a better ideaj
--rob
Sent from my cell...excuse typos
On Oct 28, 2013 10:35 AM, Carlynhos77 carlynho...@hotmail.com wrote:
ola, realmente esse trem nao vai... criei o arquivo db.py, joguei o codigo
nele, tirei as referencias do gluon, dai ja veio outros erros...
Thanks Anthony, it sounds like a good idea but the browser ends up
receiving:
data-options={quot;modequot;:quot;calboxquot;,
quot;useNewStylequot;:true}
We need to make this easier (let alone work), the newer mobile add-ons/plug-ins
are using the data attributes a lot.
If anyone else wants
On Monday, October 28, 2013 10:46:30 AM UTC-4, DenesL wrote:
Thanks Anthony, it sounds like a good idea but the browser ends up
receiving:
data-options={quot;modequot;:quot;calboxquot;,
quot;useNewStylequot;:true}
When I try it, web2py returns the following to the browser:
input
Hello,
I want to use startswith in a query like following, but it didn't work:
db.person.name.startswith(db.student.name)
What is wrong in this query? Is there a better way for it or a work
around? Any help would be greatly appreciated.
Thanks
--
Resources:
- http://web2py.com
-
You're going to need a value for db.student.name... so you'll need a join
or something.
On Monday, October 28, 2013 8:50:29 AM UTC-7, Mark wrote:
Hello,
I want to use startswith in a query like following, but it didn't work:
db.person.name.startswith(db.student.name)
What is wrong in
Richard, I was about to post a similar question, but let me just ask you. I
am also new to web2py, and I am not able to find any good resources in
relation to creating multiple groups or assigning roles to users. For
example, lets say I have a group of users that I want to categorize as
Check the source of the returned page, is it still good?.
The code is:
def CALBOX(*args, **vars):
vars['_type']='text'
vars['_data-role']='datebox'
vars['data']={'options':XML('{mode:calbox, useNewStyle:true}')}
x = INPUT(*args, **vars)
return XML(x.xml().replace('{', '{).replace('}',
I am happy to announce a great new opportunity for web2py users:
https://www.pythonanywhere.com/try-web2py
Basically they give you the opportunity to create a web2py instance
directly from the browser without sign-up. The instance only lives for 24
hrs unless you sign-up. In that case it
BTW, the quoted representation **should** be valid nonetheless.
What plugins do is extracting whatever is in the data and evaluating to a
js object, so it shouldn't really matter beween
data-something='{a: b}'
and
data-something=thequotedrepr_of_{a:b}
unless the plugin is so strict (and
I have tried it - works fine!
Martin
2013/10/28 Massimo Di Pierro massimo.dipie...@gmail.com
I am happy to announce a great new opportunity for web2py users:
https://www.pythonanywhere.com/try-web2py
Basically they give you the opportunity to create a web2py instance
directly from
nope, shouldn't work either
if your module is inside the modules folder, either you need to do
import appname.modules.utils
or
import utils
Il giorno lunedì 28 ottobre 2013 05:24:15 UTC+1, Massimo Di Pierro ha
scritto:
Can you please try the nightly build?
what button ?
any A element should display a tooltip pretty well if you just use the
_title attribute
Il giorno domenica 27 ottobre 2013 23:41:32 UTC+1, libe...@gmail.com ha
scritto:
I am trying to figure out a way customize a button in a SQLFORM.grid so
that a tooltip text is shown.
Is
If you are just using the column value itself, you probably need to convert
it to a string before putting it in the json.
Example:
c = long(10)
c
10L
str(c)
'10'
On Saturday, October 26, 2013 8:09:25 AM UTC-7, Ramesh Kumar wrote:
Thanks Derek, but I am facing one more problem. An 'L'
I am not sure exactly what you want.
You can create group by the appadmin, and you only need to do it once for
each group. For the assignation of user to a given group, with the appadmin
you have to do it many time (one for each group member, one at a time), if
you have to review/add new group
https://github.com/elcio/badmin
On Mon, Oct 28, 2013 at 1:23 PM, Richard Vézina ml.richard.vez...@gmail.com
wrote:
I am not sure exactly what you want.
You can create group by the appadmin, and you only need to do it once for
each group. For the assignation of user to a given group, with
Hi Derek,
Thank you very much for your answer. I get the idea.
On Monday, October 28, 2013 12:06:54 PM UTC-4, Derek wrote:
You're going to need a value for db.student.name... so you'll need a join
or something.
On Monday, October 28, 2013 8:50:29 AM UTC-7, Mark wrote:
Hello,
I want to
https://groups.google.com/d/msg/web2py/xeSxEu4xfA0/qDN6V4_BqK0J
http://rochacbruno.com.br/web2py-manage-users-and-membership-in-the-same-form/
Little research...
On Mon, Oct 28, 2013 at 1:25 PM, Richard Vézina ml.richard.vez...@gmail.com
wrote:
https://github.com/elcio/badmin
On
Most of you know Railscast and stuff like Rails for zombies.
No, I don't care for Ruby, so I never paid it any attention. I have no clue
where someone would go to learn it. Web2Py is good, I heard Django is good
also, but I'm not a sheep that's just going to follow the herd to where
it's
I'm having a similar problem with KeyError: 'email'.
I have a site in production that uses oauth2 and offers the possibility of
register/login using personal facebook account.
I created a Facebook app and set permissions to get user's email (so I can
create the account on my site). Everything
That works well too. It looks a little better so I'm using it. Thanks!
On Monday, October 21, 2013 11:24:29 AM UTC-4, Niphlod wrote:
uhm. what if you do
td{{=PRE(r_.run_output)}}/td
Without an example it's hard to guess what should be the correct style.
On Monday, October 21, 2013
+1
Maybe add a link to this from the web2py.com home page (could add a button
to the group of red buttons on the right).
On Monday, October 28, 2013 12:41:35 PM UTC-4, Massimo Di Pierro wrote:
I am happy to announce a great new opportunity for web2py users:
Thanks Richard,
I am having a look right now.
On Monday, October 28, 2013 12:34:34 PM UTC-5, Richard wrote:
https://groups.google.com/d/msg/web2py/xeSxEu4xfA0/qDN6V4_BqK0J
http://rochacbruno.com.br/web2py-manage-users-and-membership-in-the-same-form/
Little research...
On Mon, Oct
I discovered and reported in
http://code.google.com/p/pyfpdf/issues/detail?id=66 an issue with
gluon/contrib/FPFD. Basically, rendering HTML UL tags as PDF may trigger
a utf8 codec error because fpdf/html.py sets the bullet character as
'\x95'. As a work-around I have replaced '\x95' with '*'.
Yes. I think we should remove the demo_admin with this. No reason to have
them both.
On Monday, 28 October 2013 13:22:32 UTC-5, Anthony wrote:
+1
Maybe add a link to this from the web2py.com home page (could add a
button to the group of red buttons on the right).
On Monday, October 28,
rows = db(db.person.name.startswith(John)).select()
On Mon, Oct 28, 2013 at 1:50 PM, Mark czhang2...@gmail.com wrote:
Hello,
I want to use startswith in a query like following, but it didn't work:
db.person.name.startswith(db.student.name)
What is wrong in this query? Is there a better way
Viniciusban,
Thank you for the help. But I don't know if the name is John or whatever.
I hope the name such as John can be fetched dynamically from another
table (e.g. db.student). Now, I think maybe it is not possible.
On Monday, October 28, 2013 3:04:29 PM UTC-4, viniciusban wrote:
rows
The instance only lives for
24 hrs unless you sign-up. In that case it will persist.
Hi,
I tried creating something last week as I saw it announced on the dev
mailing list, and despite not signing up, I now see it still appears to
be alive. Is this expected?
Best regards,
Stefaan.
--
On Monday, October 28, 2013 7:24:39 PM UTC, stefaan wrote:
I tried creating something last week as I saw it announced on the dev
mailing list, and despite not signing up, I now see it still appears to
be alive. Is this expected?
(PythonAnywhere guy here.)
It's more the case that we don't
click the 'update settings' button after changing the settings, and you
should see the url change (it uses a GET request).
On Sunday, October 27, 2013 1:37:08 PM UTC-7, melmg wrote:
Hello,
I am trying to understand how to set up communication between a
microcontroller (Stellaris LM3S8962
Could you supply an example of what you intend to achieve, preferably a query?
On Mon, Oct 28, 2013 at 5:17 PM, Mark czhang2...@gmail.com wrote:
Viniciusban,
Thank you for the help. But I don't know if the name is John or whatever.
I hope the name such as John can be fetched dynamically from
Hey guys, I'm using web2py with mysql and I can't do a Inner Join
When I try:
groups = db().select(db.groups.name,db.city.name,
join=[db.groups.on(db.groups.id ==
db.lab.group_id),
db.city.on(db.city.id == db.groups.city_id),
did you user your_string.decode('utf8') before passing to FPDF??
I think you have mistake in your code, you should provide example code in
you issue report!!
Richard
On Mon, Oct 28, 2013 at 2:40 PM, step step.l...@gmail.com wrote:
I discovered and reported in
This is pretty nice, but since I heard about it the first time, I thought
what a greate ressources for fishing attack for malicious geek
:)
Richard
On Mon, Oct 28, 2013 at 3:52 PM, Giles Thomas giles.tho...@gmail.comwrote:
On Monday, October 28, 2013 7:24:39 PM UTC, stefaan wrote:
I tried
I was wondering how to put a style on a form tag.
{{login_form.custom.begin['_style']=display:inline}} fails with
error type 'exceptions.TypeError'('XML' object does not support item
assignment)
Thank you in advance!
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
-
I have a equipment table contains different equipments with model numbers
such as SVP701, SVP710, SVP755. Another lookup table contains their
expected life time for model numbers such as SVP7 for 10 years, TPU3
for 20 years. I want the wildcard SVP7 match all SVP701, SVP710,
SVP755, so that
I was wondering how to put a style on a form tag.
{{login_form.custom.begin['_style']=display:inline}} fails with
error type 'exceptions.TypeError'('XML' object does not support item
assignment)
Thank you in advance!
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
I published http://learn-web2py.com a few minutes ago. It's far away from
being perfect, but it's an first attempt. I'm neither an expert in web2py
nor a native speaker. All of your feedback is welcome!
- Andreas
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
-
Thanks Niphlod, that is true.
The problem was in one of the js files from dev.jtsage.com (or with the one
I had downloaded).
It works fine with the latest from their cdn
http://dev.jtsage.com/cdn/datebox/latest/
*Still, having to add Anthony's trick seems very un-web2py-ish*
@DenesL...uhm...what I was saying is that a plugin **should** expect
anything in a data-* to be escaped. This means that from a plugin
standpoint,
input data-options={quot;modequot;:quot;calboxquot;} type=text id=
test1 /
should be treated exactly as
input data-options='{mode:calbox}'
sera que nao tem algo haver com minha versao do postgresql? identicar alem
do banco, qual o esquema ta as tabelas? to usando a versao 8.4 do
postgresql, as tabelas ta no esquema 1 - saude... ja criei novos arquivos
para conexao, tirando referencias do gluon mas nao da certo...
Em
form.custom.begin is not an helper like A, LI, FORM, etc... so you can't
use usual _attributes for it.
form.custom.begin just carries form .. ... that's because you're
supposed to fill in between all your form widgets and then close it with
form.custom.end, that in turn just carries the
maybe in your controller...
form.element(_name='email')['_class'] = campo_email
form.element(_name='first_name')['_class'] = campo_nome
form.element(_name='last_name')['_class'] = campo_sobrenome
form.element(_name='password')['_class'] = campo_senha
I actually wanted to append the style to the form tag itself, not its
elements. So like form style='display:inline'
What I am getting is that this isn't possible?
On Monday, October 28, 2013 5:56:45 PM UTC-4, Ramos wrote:
maybe in your controller...
form.element(_name='email')['_class'] =
if i understand you , use css in your view to acomplish that
form {
...
}
2013/10/28 archean...@gmail.com
I actually wanted to append the style to the form tag itself, not its
elements. So like form style='display:inline'
What I am getting is that this isn't possible?
On Monday, October
Perhaps this still works
https://groups.google.com/d/msg/web2py/DyspJUl_IMM/njKjq9mEb_0J
Replace
form['_class'] = form-horizontal
with
form['_style'] = display:inline;
Il giorno lunedì 28 ottobre 2013 22:00:20 UTC+1, arche...@gmail.com ha
scritto:
I was wondering how to put a style on
CALBOX(_name='tsdate', _id='tsdate')
Where exactly does the above line go? When I try you exact code, I do not
get any escaping of the quotes (checked the source returned to the browser
and even tried using gluon.tools.fetch from the shell).
Anthony
--
Resources:
- http://web2py.com
-
For a specific case, I'd rather have the css be inline, meaning in the tag
as form style='display:inline' rather than in a css file or anywhere else
on the page
On Monday, October 28, 2013 6:05:36 PM UTC-4, Ramos wrote:
if i understand you , use css in your view to acomplish that
form {
I think the admin demo is still useful. Creating an installation at
pythonanywhere and going to the admin app is still an extra barrier that
some won't bother to jump.
On Monday, October 28, 2013 3:05:03 PM UTC-4, Massimo Di Pierro wrote:
Yes. I think we should remove the demo_admin with
ok. there's clearly a mismatch between what you expect from what you're
writing.
db.table.field == 'something'
db.table.field something
db.table.field.startswith('something')
db.table.field.contains('something')
are what in DAL are called Queries.
They turn out to be the WHERE part in
{{login_form['_style']=display:inline}} does not work
@Ramos, in this specific case, I would like the style to be inline with the
form tag rather than anywhere else, since anywhere else would affect forms
globally.
On Monday, October 28, 2013 6:12:28 PM UTC-4, Paolo Caruccio wrote:
Perhaps
No but if you join the same table multiple times
(db.researcher_lab_permission) you have to do so using an alias. This
should work.
groups = db().select(db.groups.name,db.city.name
,db.auth_user.email,db.researcher.with_alias('name1').ALL, db.lab.
with_alias('name2').ALL,
More slightly OT tips for Mac users: Postgres support for OS X in the form of
an app.
http://postgresapp.com
This ought to be a really easy way to run Postgres locally on OS X, perhaps for
development and testing when sqlite isn't enough. If you develop on the Mac/iOS
side, you'll recognize
@css
form.myform {
...
}
only afects myform class, not all forms
2013/10/28 archean...@gmail.com
{{login_form['_style']=display:inline}} does not work
@Ramos, in this specific case, I would like the style to be inline with
the form tag rather than anywhere else, since anywhere else would
Part of what I wanted to do was manipulate the inline style dynamically
inline in the tag. It seems that it is being stated that a workaround is
needed for this... but thank you for all your help!
On Monday, October 28, 2013 6:42:13 PM UTC-4, Ramos wrote:
@css
form.myform {
...
}
only
I created this gist to help people testing controllers that makes redirection:
https://gist.github.com/viniciusban/7206413
Hope it helps someone.
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
-
How are you creating the form? Is it the auth.login() form, or your own
form? Do you need to use form.custom.begin to get the layout you need?
On Monday, October 28, 2013 6:48:26 PM UTC-4, arche...@gmail.com wrote:
Part of what I wanted to do was manipulate the inline style dynamically
Yes, thanks Massimo! The first error pass, but now:
class 'gluon.contrib.pymysql.err.InternalError' (1054, uUnknown column
'researcher.user_id' in 'on clause')
How could I generate sql to debug it?
2013/10/28 Massimo Di Pierro massimo.dipie...@gmail.com
groups =
On Friday, October 25, 2013 9:40:10 PM UTC-7, Massimo Di Pierro wrote:
It would help to know exactly what we can do better. Where do you need we
need more explanations?
You'll have to wait for a specific example; they've all drained out of my
head for the moment. Probably in the area of
I use PA, and am supper happy. I have thought about doing a VPS or Shared
Hosting at other places, however, PA is just so well integrated with web2py
(or vice-versa?), that it just makes sense to just go with them.
Well done Giles!!
Currently using the free account, but thanks to the great
Niphlod,
Thank you very much for your detail answers. It seems that your new data
model is better, and is the way to go.
My old model may be fine for my small database using the OR. I may try
both and compare.
Thanks!
On Monday, October 28, 2013 6:20:31 PM UTC-4, Niphlod wrote:
ok. there's
faça um w2p e me envie para eu poder ver o erro.
Ovidio Marinho Falcao Neto
ITJP.NET.BR
ovidio...@gmail.com
Brasil
Em 28 de outubro de 2013 19:56, Carlynhos77 carlynho...@hotmail.comescreveu:
sera que nao tem algo haver com
I am reading this again. I misunderstood the model. This is not an outer
join. This is an inner join. There is no conflict.
Yet I do not understand. You only select db.groups.name and db.city.name.
So what you so seem equivalent to this.
groups = db(db.city.id ==
I need these joins because I need filter some tables without selecting all
the tables and filtering with where. Anyway, I tried:
rows = (db.groups.id == db.lab.group_id)(db.lab.id ==
db.researcher_lab_permission.lab_id)(db.researcher.id ==
Here is the sql generated:
SELECT groups.name, city.name, auth_user.email, name1.id,
name1.is_active, name1.created_on, name1.created_by, name1.modified_on,
name1.modified_by, name1.user_id, name1.image, name1.image_file,
name1.lattes, name2.id, name2.is_active, name2.created_on,
Thanks for the responses everyone.
I've tried the welcome app n read through the docs, things were a breeze to
set up.
I'm now at the data modeling stage for my app.
I'm quite familiar with bigtable, and most probably going to deploy my
startup live on app-engine for the initial launch.
Now my
I'm using PostgreSQL and debugging in Eclipse, although I also see this
issue when not using the Eclipse IDE bugger. The issue is that when I try
to go to look at a ticket or the db contents via the web2py admin
interface, the interface won't come up. In other words, I can click on a
ticket
I am trying to break up a large form into steps that have complex
interdependent values for a benefit application. I can achieve everything
with controller/client side logic but I was hoping to do it at the widget
level so that the form is portable (i.e. works in appadmin too). It would
be a
I am afraid that expression $$ x + y $$ will render as xy rather than
x+y. I tried escaping the plus character but without any luck. I was
wondering if somebody else encountered such an issue.
Any help will be much appreciated. Thanks
--
Resources:
- http://web2py.com
- http://web2py.com/book
85 matches
Mail list logo