;ll have the password file you can rename).
>
> On Sat, Sep 26, 2009 at 12:52 PM, howesc wrote:
>
> > Hello,
>
> > I'm using Cherokee webserver, and FCGI to connect to web2py. in
> >http://www.web2py.com/examples/default/cronit recommends that I use
> > exte
Hello,
I'm using Google App Engine, and trying to make use of the new
'belongs' feature in queries (thanks much for adding it in!), and am
having a problem. It seems that when i construct the query my list is
being converted to a unicode string, and then the query generation
code fails.
here's
> rows = db(db.media_type.name=='paper').select()&db
> (db.media_type.name=='cd').select()
>
> The & is done at the web2py level but since records are exclusive and
> you are not sorting them, there is no major slowdown.
>
> Massimo
>
> On
ahh, perfect. thanks for the clarification!
On Nov 20, 5:35 am, mdipierro wrote:
> I would say imprecise.It can be mimiced using
>
> .select()|..select() and ..select()&..select() etc.
>
> On Nov 20, 1:22 am, howesc wrote:
>
> > oh, so the recent post (http://gr
I had the same problem running the dev_appserver (the latest release
1.3.0). it was trying to create:
/web2py/applications//errors which existed in my file
system. I wrapped the entire for loop in:
if not request.env.web2py_runtime_gae:
and it works fine.
thanks,
christian
On Dec 15, 1:27 pm
yes i did. :( i was a bit surprised that it finds some folders, but
not the one named 'errors'.
On Dec 15, 2:42 pm, mdipierro wrote:
> Did you run the app first locally without dev_appserver? That should
> have created the missing folders. No?
>
> On Dec 15, 4:06 pm, howe
ran into this too. the version from trunk works. (i'm using python
2.5.2)
thanks,
cfh
On Dec 15, 6:38 pm, mdipierro wrote:
> I think this is now fixed in trunk. can you confirm?
>
> massimo
>
> On Dec 15, 4:52 pm, Fran wrote:
>
> > On Dec 15, 10:40 pm, mdipierro wrote:
>
> > > I need a conc
I'm using web2py on GAE, and wanted to be able to click on a link and
view tickets in that world, so i basically did a copy of the code from
the admin interface into my default.py so that my app can display the
tickets. I'll paste it in here, hope it copies fine in email (i don't
think i can add a
; Thanks, howesc. I think having a mechanism similar to this
> and supported by Massimo would not be too much of a security
> risk, assuming it's not turned on by default. There's a
> big difference between allowing a user to view your source
> code and granting full admin access.
I agree with the 2 apps in one installation of web2py at minimum. 2
installations of web2py sounds like a maintenance nightmare to me.
Is it possible to write a virtual host so that a certain domain may
only see certain controllers in a web2py application? i suspect that
it is, but getting the a
Hi all,
sorry if i missed the discussion on this, but i was just bitten by an
upgrade issue that i'm not sure the best way to solve.
i have an existing app running on the google app engine that uses
several String fields with IS_IN_DB(... multiple=True). I upgraded
web2py and now those fields ar
isrc', 'string', length=12, unique=True),
Field('orig_publish_year', 'integer',
requires=IS_NULL_OR(IS_INT_IN_RANGE(1800, 2100))),
Field('tempo', 'integer',
requires=IS_NULL_OR(IS_INT_IN_RANGE(0, 250))),
Field('
, 'list:reference media', length=2048)
>
> and
>
> in db.define_table('media',...) add format='%(url)s'
>
> Massimo
>
> On Nov 17, 2:01 am, howesc wrote:
>
> > i upgraded from 1.74.5 to 1.88.2 (so a little bit out of date as of
> >
Hi there,
First off, read up on the GAE bulk loader:
http://code.google.com/appengine/docs/python/tools/uploadingdata.html
i think the newer releases support CSV, though i have not used it for
CSV.
below i'm pasting some old code of mine for uploading and downloading
CSV, including fixup of refer
Hi there,
First off, read up on the GAE bulk loader:
http://code.google.com/appengine/docs/python/tools/uploadingdata.html
i think the newer releases support CSV, though i have not used it for
CSV.
below i'm pasting some old code of mine for uploading and downloading
CSV, including fixup of refer
ier
>
> - property: name
> external_name: Name
>
> I learn a lot from studying this:http://bulkloadersample.appspot.com/
>
> On Nov 23, 8:16 am, howesc wrote:
>
> > Hi there,
>
> > First off, read up on the GAE bulk
> > loader:http://code.google.com/ap
on the development server i see all my errors on the console (i use
the command line so it shows up right in the terminal window. i
believe that the mac launcher has a console view that shows this info
as well)
in production everything is logged to the error logs. click on the
"logs" link on the
hi all,
i integrated paypal website payments standard on www.tenthrow.com,
using encrypted payment buttons and IPN (instant payment
notification). my implementation is based off of:
http://web2pyslices.com/main/slices/take_slice/9
i can take a look at my code and try and pull it out to share wit
Hi all,
sorry for the delay. my paypal integration code can be viewed here:
http://web2pyslices.com/main/slices/take_slice/106
please let me know if you have problems with it.
thanks,
christian
On Nov 26, 8:23 am, Andrew Evans wrote:
> hello
>
> I am interested in your code :D
>
> Let me kno
because you cannot write to the file system, your "updated files" will
need to be stored in the database. since these could get large you
might consider using blobstore to store the files.
then yes, you'll have to override T() with something that reads
blobstore, or your database. i would recomm
redited to my Paypal account, and how much, so the amount can be
> credited to the user's account in my system. I would also like to
> transfer amounts from my system to the the user's Paypal account (in
> payment for services that users provide to other users).
>
> Michael
&g
i am using it. just tested it out on an application that is running
web2py 1.85.3, which is a bit outdated i suppose.
do keep in mind that if the value is not set, it will fail all
comparisons, so you must set a default value on any fields that you
want to use in a comparison.
christian
On Dec
i just pulled from trunk, copied dal.py to sql.py, and did not get past
logging in to my app to test for you. i got this error:
ERROR 2010-12-08 22:09:31,819 restricted.py:151] Traceback (most recent
call last):
File "/home/cfhowes/tools/web2py_src/web2py/gluon/restricted.py", line
188, in restric
hmm, same issue:
ERROR 2010-12-08 23:38:06,535 restricted.py:151] Traceback (most recent
call last):
File "/home/cfhowes/tools/web2py_src/web2py/gluon/restricted.py", line
188, in restricted
exec ccode in environment
File
"/home/cfhowes/tools/web2py_src/web2py/applications/pump/controllers/defaul
actually, not the same issue, different error, same line. :(
it works, and the != test that i tried also works. i wonder if it has
to do with how i tested the constuction? my test was of a dynamic query
built like:
def build_query(field, op, value):
"""
Builds the web2py query object for a given field
"""
if op == 'equals':
return field == value
elif op ==
as far as i know you would have to write some custom big table queries
(not using web2py dal). but in theory you could:
- write a direct query to get all the keys of a table (and no data)
- cache those keys
- randomly choose a set of keys from the full list
- write a google key query.
google is no
Arun,
this line:
persons_and_dogs = db((db.person.id==db.ownership.person) &
(db.dog.id==db.ownership.dog))
won't run on GAE because of the joins. You can choose to keep the data
structure as you have it and run 2 queries and mesh the results. before
the advent of list properties i was doing that
where and how are the pictures stores? will you be adding them to the
blobstore or references pictures elsewhere?
i have never used that but this:
File "gluon/sql.py", line 742, in __getattr__
KeyError: 'name'
implies that the database table you are querying does not have a name
field. check your tables to make sure they were created properly.
Massimo and crew,
I am trying to use export_to_csv_file() on a rows object with the colnames
parameter on google app engine. it turns out that the method (in both
sql.py and the new dal.py) outputs the proper column names, but then outputs
data for every column in the table.
the culprit is on
ping. in trunk it's now at line 4774.
if there is a reason not to make the change please let me know so i can fix
my code. (but i assume this just has not made it to the priority list yet,
which is just fine, it is the holiday season and all!)
thanks,
christian
GAE recently (well a few months ago now) added a namespace feature to Big
Table. I too am interested in having each web2py app run in its own
namespace, but not yet been motivated to try and add that in. i suspect
that what you want to do is find where the GQL gets assembled and perhaps
use t
I'm trying to be a good person and post my issues to google code.
FYI for others seeing an issue, my bug report is here:
http://code.google.com/p/web2py/issues/detail?id=147
I have found several problems with the DAL on GAE, which include:
validator problems with list:reference
http://code.google.com/p/web2py/issues/detail?id=147
represent problem with list:reference (SQLTable will not display)
http://code.google.com/p/web2py/issues/detail?id=149
and belongs is br
Let's say i have a table like:
db.define_table('item_quantity',
Field('item', db.item,
requires=IS_IN_DB(db, db.item.id,'%(name)s'),
represent=lambda x: x.name),
Field('quantity', 'double', notnull=True, default=0.0,
comment="in ounces"),
Field('name', length=500, not
yes it kinda would. i would love to be able to see the values of the fields
and have them update via javascript as the fields they depend on are
modified, but that is beyond the functionality of SQLFORM. But i do want to
see the current values when i am editing the form
given the potentia
It seems that in the latest version of web2py (1.91.6 and today's trunk)
that if you have a table (say auth_user), with a format string, and then you
refer to it in another table as read-only like:
Field('updated_by', 'reference '+auth.settings.table_user_name,
default=auth.user_id,upda
I must admit i'm not following your example. why do you need to query by
GAE __key__ rather than by ID? (i have not used ancestors in GAE so maybe
that is why i'm mis-understanding).
but your reference to my previous exchange made me look at this in the new
DAL - and the !=, <, >, <=, and >=
my own forms created with SQLFORM.
RE bug reports: there is also google code to post bug reports to:
http://code.google.com/p/web2py/issues/list i know that at times things get
backed up, and occasionally a bug gets missed, which is why we have been
encouraged to start using the google code bug tracking.
RE modifying field typ
Matt,
given the arbitrary depth of the keys, perhaps it would be better to have
the user construct the key, and then have some form of operator to indicate
that you desire to run a key query?
what are your thoughts on that? would that be better or worse from your
perspective?
cfh
with the latest version of web2py i have found that you have to use
"represent" on the field as well. see my post here:
https://groups.google.com/d/topic/web2py/dnqKwf9Zxv0/discussion i think it
may be a bug though i'm not sure if the behavior is correct or not.
cfh
i'm pretty sure there is a section in the book that covers this topic
exactly. there is also new versions of routing since i last wrote this.
anyhow, my routes info:
routes_in = (('/admin(?P.*)', '/admin$f' ), #make the admin app work
('/','/ec'), #/ goes to the ec app
nope, i did a test and confirmed that this behavior is the same for older
and newer versions of web2py.
so to get the name field from the referenced table to show, you need to add
a represent parameter to your field construction:
db.define_table('stuff',
Field('name', 'string', notnull=True
it seems that upon further testing this is not a problem. i don't know what
i was doing when this showed up. sorry for the noise.
cfh
Hello there,
I have written a bunch of stuff against google app engine over the past year
and have played lots of data games. let's see if i can provide a little
insight.
- first off, the CSV download functions only work while the tables are
small (under a few thousand rows). after that loo
hmmm, something say like:
def unittests():
"""
test the ability to run unittests
"""
import os
import sys
import glob
import cStringIO
from gluon.shell import env
#save stdout so we can capture data and reset it.
stdout = sys.stdout
stderr = sys.stder
i agree with brunounless you are running on GAE. in that case join's
are not supported and are implemented as additional queries under the
covers. in the GAE case i extend my auth table so that i don't have to run
so many queries.
db[auth.settings.table_user_name] is better than db.auth_u
do you mind trying web2py trunk? there where several issues with the DAL
and GAE in the last version that are fixed in trunk. I did not see this
particular issue in my testing on GAE yet though, so it might not be
related.
thanks,
cfh
i'm way too old skool and just use the CLI to app engine. i thought i saw
something on the group about some things not working for admin on some
platforms (windows perhaps?)
cfh
I use both references and datetimes successfully on GAE.
the error message got truncated so i can't see what the exception is?
If you are using latest web2py (1.91.6), please "upgrade" to trunk. it has
some GAE fixes.
cfh
while the current version does not prescribe to RESTfulness very well, check
out http://starmakerapp.com/ this iPhone app's database backend is web2py on
GAE.
it's still kinda beta version, but many enhancements (including converting
the website for the app to web2py) are coming!
so yes, it's
to enhance massimo's response, you can test the HTTP status code in the
except block:
>>> try:
... index()
... except HTTP, e:
... assert(e.status == 400)
... assert(e.body == "Not permitted")
...
I use belong on GAE quite frequently these days. Arun - you found an
outdated post. :(
christian
in places where i wanted to keep the dropdown, but not the overhead of
creating a huge list, i filtered the list. I was lucky enough that not all
of the options were valid in all tables, and so i modified my IS_IN_DB()
calls to return a much smaller filtered set of data. not sure if this will
if i remember correctly the bulk delete was google's christmas present to us
- in the decemeber release, so it's a new feature, but quite handy!
Forcing ID's in GAE is a bit harder, and i don't think that web2py has
support for that yet.
also note that once the database gets to be of significant size the
import/export features will have to be written to run as taskqueue tasks on
GAE so that they can run for 10 minutes instead of 30 seco
Hello,
i recently tried the following:
def test4():
form = SQLFORM.factory(
Field("name", length=25),
Field("opts", "list:string",
requires=IS_IN_SET(['one', 'two','three'], multiple=True),
widget=SQLFORM.widgets.checkboxes.widget),
)
i
12 July 2012 12:33:27 UTC-5, howesc wrote:
>>
>> Hello,
>>
>> i recently tried the following:
>>
>> def test4():
>> form = SQLFORM.factory(
>> Field("name", length=25),
>> Field("opts",
for GET/POST/PUT/DELETE/HEAD etc description perhaps start with
http://en.wikipedia.org/wiki/Hypertext_Transfer_Protocol#Request_methods :)
On Friday, July 13, 2012 1:34:41 AM UTC-7, Akash Kakkar wrote:
>
> Thanks Vinicius,
>
> Wish I had read your hint earlier, a GET did the job for me, for a n
to add to massimo's response, i have added some HTML5'ness to my
registration widget:
reg_form = auth.register()
reg_form.custom.widget.email['_required'] = True
reg_form.custom.widget.stage_name['_required'] = True
reg_form.custom.widget.stage_name['_pattern'] = '
to help with your search consider posting here
http://experts4solutions.com/ if you haven't already.
On Monday, July 16, 2012 4:23:41 PM UTC-7, Pepe C wrote:
>
> Hi,
>
> We have a set of applications on web2py and we are looking for an expert
> that can help us to operate and develop them. Thi
Alec,
the Mysterious part of this mystery is the "controller" called with a
parameterin web2py land that is not really a controller, but just a
helper method. in your case event_page() returns it's value to the d()
method (which web2py does think is a controller), and then web2py execution
facebook is a picky pain in the ***
in your facebook config you set a single domain name or ip address that is
associated with the facebook app. all redirects that you specify when
making calls to the facebook API must be in that domain/ip address. so
your facebook config would need to have h
gt; # comment above and uncomment below when testing on remote host
> > # 1.2.3.4 my.facebook.app
> > ---8<-
> >
> > Testing is easier is you can use same port locally or on production.
> >
> > mic
> >
> >
> > 2012/7/23 howesc:
> >
one other scenario..
i reported a few months back that running web2py on GAE with python2.7 and
multi-threading had odd behaviors with the globals (request, response,
session). i have yet tracked down the issues i was having (might have been
a coding error on my part).but if you are us
For what it is worth i have used custom fields for this type of thing with
great success!
On Tuesday, July 24, 2012 8:20:03 AM UTC-7, Anthony wrote:
>
> You could use a SQLCustomType field:
> http://web2py.com/books/default/chapter/29/6#Custom-Field-types-(experimental)
> .
>
> Anthony
>
> On Tu
i may be speaking out of turn, but i don't recall that there is a DAL
adapter for dynamodb. i bet the DAL adapter would look like other nosql
adapters We should probably add it in if there is demand for it!
the rest of web2py should run fine.
On Wednesday, July 25, 2012 4:51:56 AM UTC-7,
check the JS console for errors. if somehow your code above is executed
before bootstrap has finished loading it bet the init fails...though i
wouldn't expect it to work at all. i guess check the console and let us
know if you see errors.
On Wednesday, July 25, 2012 9:04:00 AM UTC-7, dundee w
i'm not exactly sure what you are trying to do here based on the
description above, so i'm gonna take a guess and see if i can point you in
a helpful direction
so i use a settings table as welli like to put it's contents in
memcache to save database reads. my settings pretty rarely cha
i might also ask if that form is displayed on *every* request. if not, i
would recommend moving it from the model file to the controller where it is
used (or a module if it is used in several controllers).
On Sunday, July 29, 2012 7:25:55 AM UTC-7, weheh wrote:
>
> Massimo, thanks for pointing
i'll add a couple of comments:
- if you define your models carefully with requires parameters
(validators) in web2py, the SQLFORM object will use them, and you can
trigger the use of those validators via your REST API (i forget the exact
call, but there is something that does validation and in
for Starmaker's API we are now using the @restful decorator chained with a
decorator we wrote that checks OAuth. all requests made by the client are
OAuth signed requests. i'm sure you can use a similar method to use basic
auth for the API calls, while leaving the regular auth decorators for t
in these cases i do all the python on the server side and format the
resulting JSON in a way that i can handle easily in javascript. we don't
yet have web browsers that run python. :(
On Monday, July 30, 2012 1:58:22 PM UTC-7, curiouslearn wrote:
>
> Anthony, thanks for your response. Please se
my largest project is servicing 2.5 million requests per day. (API calls
and website views combined)
- google app engine (big table)
- modelless
- medium use of memcache, slight use of google edge cache
On Wednesday, August 1, 2012 7:13:04 AM UTC-7, viniciusban wrote:
>
> This question has b
oops.
it's the StarMaker family of products. see the web site at
starmakerstudios.com. search starmaker in the iOS app store to get the app.
On Thursday, August 2, 2012 9:44:42 AM UTC-7, viniciusban wrote:
>
> Could you tell us its url?
>
>
> On 08/02/2012 01:27 PM, h
are you using auth? auth takes around 200ms to load i think on GAE. i
avoid initializing auth except for the controllers that use it, as well as
having my model definitions in modules.
cfh
On Monday, August 6, 2012 3:57:51 PM UTC-7, Felipe Meirelles wrote:
>
> Actualy Django uses the datastor
move_id is None because either the reference does not exist, or the record
it points to is represented as "None"
star looks to be a Set, or the results of a query. something has gone
wrong in the setup of the table or in the representation of that field.
On Thursday, August 9, 2012 1:00:06 PM
the query and the error message do not match. your query has no orderby,
yet the error message suggests there is an orderby property set. this
confuses me.
i do:
db(db.table.id.belongs([list of items not more than 30 long])).select()
all the time on GAE and it works for me (latest stable web
i think there are other threads on this (or at least similar) topics.
i have multiple live apps on GAE:
www.starmakerstudios.com (plus iOS backend services)
www.diginn.com
www.elizabethscanvas.org
they all have *very* different usage profiles and costs.
given that i have spend 0 hours doing sys
lso, is there some significance to limiting the belongs lists to 30 items?
>
>
>
> On Thursday, August 9, 2012 4:24:13 PM UTC-4, howesc wrote:
>>
>> the query and the error message do not match. your query has no orderby,
>> yet the error message suggests there is an ord
the same.
>>>
>>> I tested with the query as you wrote it below, with no common_filter,
>>> and the query still failed. Since that's a pretty straightforward query
>>> that should work, this seems like a bug to me, so I filed a web2py bug
>>> report: http
i added a patch against trunk to the ticket. spiffytech - can you see if
that works for you?
cfh
On Monday, August 13, 2012 12:20:02 AM UTC-7, howesc wrote:
>
> we do special query handling on the key field, so i suspect the multiple
> filters on key is wonky. i'll try and l
i personally have not used parse_as_rest so i might be out in left field
here.but are you able to access the output of the query and update it
before it is returned?
or perhaps even better, add a format parameter to the table definitions so
that you can format the display of references (to
we can't tell what the problem is from the pasted code (aside from
indentation that was probably messed up in copy/paste).
can you show us an example of your default.py file and the traceback you
are getting with the error?
On Thursday, August 16, 2012 12:29:25 AM UTC-7, Hojat Taheri wrote:
>
>
if it is a one time data load and i have the proper constraints set in
SQLLite, i would use raw SQL.
if this was repetitive use and i wanted to use web2py validation i would
use the DAL with bulk insert (making sure that i validate the data before
adding to the insert queue)
On Friday, August
response.include_file() outputs the files that were added to response.files
(js, css). when you remove that you loose the auto output of files that
were added to response.files along the way.
response.include_mete() works much the same for HTML meta properties.
can we see the resulting HTML in
Saturday, August 18, 2012 1:47:55 PM UTC-7, Massimo Di Pierro wrote:
>
> Do you use modules? Do you do anything like
>
> from gluon import current
> request = current.request # very very thread unsafe!!!
>
> Massimo
>
>
> On Saturday, 18 August 2012 11:27:31 UTC-5, howes
hrm.i've not used the 'r' in my routesi just put the strings in and
it seems to do what i want.
on GAE you might rather do this in app.yaml as you save yourself loading
web2py to serve a static file.
cfh
On Friday, August 17, 2012 8:14:08 PM UTC-7, spiffytech wrote:
>
> I'm trying to m
db = DAL('google:sql://realm:domain/database')
realm, domain, and database are all values from when you setup your google
cloud SQL account. see
https://developers.google.com/cloud-sql/docs/before_you_begin
On Friday, August 17, 2012 4:25:42 PM UTC-7, Pystar wrote:
>
>
> I know that GAE suppor
looks like it's still unsolved. i have not used SQLFORM.factory with
multiple fields, and i have not used the blob data type in BigTable, rather
i use blobstore image uploads.
can you get it to work with just 1 table in your form? can you determine
what vars are posted and what comes out of f
you may also do orderby=db.mibmessage.end_time|~db.mibmessage.reg_time -
that is a legal sort on GAE, it may not be what you want though.
you know about select().sort(lambda r:...) right? i use that on GAE to get
around extra indexes and illegal sorts. :)
On Monday, August 20, 2012 7:20:05 AM
given that each DB implements auto_increment differently that can be
tricky. i know that some of them you would have to set a
super-secret-really-well-known variable to let it know where to start the
IDs at for the next insert when done. i suspect this works differently per
DB and could be tr
routes_in = ( ('/hello', '/app1/controller1/hello'), ('/bye',
'/app1/controller1/bye'))
On Tuesday, August 21, 2012 1:28:49 AM UTC-7, Daniel Gonzalez wrote:
>
> Hello,
>
> I have the following routing requirements, which I am unable to configure
> in routes.py:
>
> www.mysite.com/hello -> a
you have 3 options as i see it:
- port the pages to be part of web2py controllers/views
- import the DAL and your db.py file to define your models in these
pages. then use the DAL to get the data
- duplicate your web2py models as google model classes. write your own
GQL to access the data.
i use old skool regex routersi added the following to routes_in:
('/_ah/channel/(?P.*)', '//channel/$f'), #channel
messages
FWIW i tried to use the channel API but failed miserably. i did not
reliably get disconnect messages, and channels often closed before the
timeout and i
if you are doing GEO stuff i would highly recommend postrgres with
postgis! then you can just ask for a point, point in polygon, polygon
contains point etc.
On Sunday, August 26, 2012 8:54:40 PM UTC-7, Andrew Evans wrote:
>
> nvm just found acos cos and such are not available in Dal or sqlite a
you need to have a different FB app for test and for production. on
facebook you set the valid domain for an app, and that is the only domain
that it will accept redirect_uri to. (unless FB has improved and you can
set multiple domains per appbut in either case you have to login to FB
and
do you have a link to the appropriate facebook docs that describe the
signed request for canvas pages? i don't know what it is.
have you used HTTP traffic inspectors to watch the traffic sent back and
forth that might give a clue as well - i use httpfox on firefox, and the
built in developer t
101 - 200 of 685 matches
Mail list logo