Running the web2py mini-fb clone demo (additional info and some questions)
Arbie Samong
I actually tried the tutorial posted here:
and here are some information that wasn't mentioned but might be helpful for absolute beginners like me:
You must first register with janrain and take note of the application name
In models/db_janrain.py, you need to set domain to the application name you registered with. In the tutorial it is set to web2py. It is https://blabla.rpxnow.com/, where blabla is the applciation name.
The file janrain_api_key.txt will contain only the secret api key, which you can see in the janrain dashboard.
The web2py source does not have app.yaml. So you copy the one in google_appengine/new_project_template over to web2py/.
Edit the file and set the application (first line) to the one you registered with in app engine. Then set script to gaehandler.py (under handlers)
When running the local app engine instance for the first time to build indexes, be sure to change the url in models/db_janrain.py from localhost:8000 to localhost:8080. If you don't it will redirect to the web2py instance instead of the app engine instance, and the indexes will not be built causing an error when running it in appspot.com
When deploying, appcfg can be found under the google_appengine/ folder, so just copy the full path.
Now, for the question. The friends and search pages do not work when deploying on GAE, both on localhost:8080 and on the real server. It works fine when using the web2py server but not on the GAE. My best guess are database issues, since GAE might not be supporting the db calls used in the tutorial. The errors are:
on friends/default/friends/ when viewing the page
ERROR 2011-03-24 07:34:36,785 restricted.py:55] In FILE: /home/arbie/Documents/python/workspace/supaprends/google_appengine/web2py/applications/friends/controllers/default.py
Traceback (most recent call last):
File "/home/arbie/Documents/python/workspace/supaprends/google_appengine/web2py/gluon/restricted.py", line 188, in restricted
exec ccode in environment
File "/home/arbie/Documents/python/workspace/supaprends/google_appengine/web2py/applications/friends/controllers/default.py:friends", line 93, in <module>
File "/home/arbie/Documents/python/workspace/supaprends/google_appengine/web2py/gluon/globals.py", line 124, in <lambda>
self._caller = lambda f: f()
File "/home/arbie/Documents/python/workspace/supaprends/google_appengine/web2py/gluon/tools.py", line 2331, in f
return action(*a, **b)
File "/home/arbie/Documents/python/workspace/supaprends/google_appengine/web2py/applications/friends/controllers/default.py:friends", line 68, in friends
File "/home/arbie/Documents/python/workspace/supaprends/google_appengine/web2py/gluon/dal.py", line 5009, in select
return self.db._adapter.select(self.query,fields,attributes)
File "/home/arbie/Documents/python/workspace/supaprends/google_appengine/web2py/gluon/dal.py", line 2892, in select
(items, tablename, fields) = self.select_raw(query,fields,attributes)
File "/home/arbie/Documents/python/workspace/supaprends/google_appengine/web2py/gluon/dal.py", line 2841, in select_raw
tablename = self.get_table(query)
File "/home/arbie/Documents/python/workspace/supaprends/google_appengine/web2py/gluon/dal.py", line 955, in get_table
raise RuntimeError, "Too many tables selected"
RuntimeError: Too many tables selected
on friends/default/search/ when trying to search
ERROR 2011-03-24 07:35:23,136 restricted.py:55] In FILE: /home/arbie/Documents/python/workspace/supaprends/google_appengine/web2py/applications/friends/controllers/default.py
Traceback (most recent call last):
File "/home/arbie/Documents/python/workspace/supaprends/google_appengine/web2py/gluon/restricted.py", line 188, in restricted
exec ccode in environment
File "/home/arbie/Documents/python/workspace/supaprends/google_appengine/web2py/applications/friends/controllers/default.py:search", line 93, in <module>
File "/home/arbie/Documents/python/workspace/supaprends/google_appengine/web2py/gluon/globals.py", line 124, in <lambda>
self._caller = lambda f: f()
File "/home/arbie/Documents/python/workspace/supaprends/google_appengine/web2py/gluon/tools.py", line 2331, in f
return action(*a, **b)
File "/home/arbie/Documents/python/workspace/supaprends/google_appengine/web2py/applications/friends/controllers/default.py:search", line 59, in search
File "/home/arbie/Documents/python/workspace/supaprends/google_appengine/web2py/gluon/dal.py", line 5009, in select
return self.db._adapter.select(self.query,fields,attributes)
File "/home/arbie/Documents/python/workspace/supaprends/google_appengine/web2py/gluon/dal.py", line 2892, in select
(items, tablename, fields) = self.select_raw(query,fields,attributes)
File "/home/arbie/Documents/python/workspace/supaprends/google_appengine/web2py/gluon/dal.py", line 2849, in select_raw
filters = self.expand(query)
File "/home/arbie/Documents/python/workspace/supaprends/google_appengine/web2py/gluon/dal.py", line 2734, in expand
return expression.op(expression.first, expression.second)
File "/home/arbie/Documents/python/workspace/supaprends/google_appengine/web2py/gluon/dal.py", line 2595, in OR
def OR(self,first,second): raise SyntaxError, "Not supported"
SyntaxError: Not supported
It would be great if somebody would post a way to get around these limitations assuming they are issues on the db layer. I *typed* the code in the video as verbatim as it could be.
Anthony
Arbie Samong
Massimo Di Pierro
In controller replace:
friends = db(User.id==Link.source)
(Link.target==me).select(orderby=alphabetical)
requests = db(User.id==Link.target)
(Link.source==me).select(orderby=alphabetical)
with:
friends = db(Link.target==me).select()
requests = db(Link.source==me).select()
and change the friends.html view into:
{{extend 'layout.html'}}
<h2>Friendship Offered</h2>
<table>
{{for friend in friends:}}
<tr>
<td>{{=A(name_of(db.auth_user(friend.source)),_href=URL('wall',args=friend.source))}}
</td>
<td>{{if friend.accepted:}}accepted{{else:}}<button
onclick="ajax('{{=URL('friendship',args=('accept',friend.source))}}',
[],null); $(this).parent().html('accepted')">accept</button>{{pass}}</
td>
<td><button
onclick="ajax('{{=URL('friendship',args=('deny',friend.source))}}',
[],null); $(this).parent().html('denied')">deny</button></td>
</tr>
{{pass}}
</table>
<h2>Friendship Requested</h2>
<table>
{{for friend in requests:}}
<tr>
<td>{{=A(name_of(db.auth_user(friend.target)),_href=URL('wall',args=friend.target))}}
</td>
<td>{{if friend.accepted:}}accepted{{else:}}pending{{pass}}</td>
<td><button
onclick="ajax('{{=URL('friendship',args=('deny',friend.target))}}',
[],null); $(this).parent().html('removed')">remove</button></td>
</tr>
{{pass}}
</table>
This is because GAE cannot do joins.
I also think that on GAE the current Query
query = reduce(lambda a,b:a&b,
[User.first_name.contains(k)|
User.last_name.contains(k) \
for k in tokens])
is too complex and should be
query =
(User.first_name==tokens[0])&(User.last_name==tokens[1])
On Mar 24, 6:06 am, Arbie Samong <phek...@gmail.com> wrote:
> I actually tried the tutorial posted here:
>
> http://blip.tv/file/4912976
>
> and here are some information that wasn't mentioned but might be helpful for
> absolute beginners like me:
>
> You must first register with janrain and take note of the application
> name
> In models/db_janrain.py, you need to set domain to the application name
> you registered with. In the tutorial it is set to web2py. It is
> https://blabla.rpxnow.com/, where blabla is the applciation name.
> The file janrain_api_key.txt will contain only the secret api key, which
> you can see in the janrain dashboard.
> The web2py source does not have app.yaml. So you copy the one in
> google_appengine/new_project_template over to web2py/.
> Edit the file and set the application (first line) to the one you
> registered with in app engine. Then set script to gaehandler.py (under
> handlers)
> When running the local app engine instance for the first time to build
> indexes, be sure to change the url in models/db_janrain.py from
> localhost:8000 to localhost:8080. If you don't it will redirect to the
> web2py instance instead of the app engine instance, and the indexes will not
> be built causing an error when running it in appspot.com
> When deploying, appcfg can be found under the google_appengine/ folder,
> so just copy the full path.
>
> Now, for the question. The friends and search pages do not work when
> deploying on GAE, both on localhost:8080 and on the real server. It works
> fine when using the web2py server but not on the GAE. My best guess are
> database issues, since GAE might not be supporting the db calls used in the
> tutorial. The errors are:
>
> on friends/default/friends/ when viewing the page
>
> ERROR 2011-03-24 07:34:36,785 restricted.py:55] In FILE:
> /home/arbie/Documents/python/workspace/supaprends/google_appengine/web2py/a pplications/friends/controllers/default.py
>
> Traceback (most recent call last):
>
> File
>
> exec ccode in environment
>
> File
>
> File
>
> self._caller = lambda f: f()
>
> File
>
> return action(*a, **b)
>
> File
>
> File
>
> return self.db._adapter.select(self.query,fields,attributes)
>
> File
>
> (items, tablename, fields) = self.select_raw(query,fields,attributes)
>
> File
>
> tablename = self.get_table(query)
>
> File
>
> raise RuntimeError, "Too many tables selected"
>
> RuntimeError: Too many tables selected
>
> on friends/default/search/ when trying to search
>
> ERROR 2011-03-24 07:35:23,136 restricted.py:55] In FILE:
> /home/arbie/Documents/python/workspace/supaprends/google_appengine/web2py/a pplications/friends/controllers/default.py
>
>
> File
>
> exec ccode in environment
>
> File
>
> File
>
> self._caller = lambda f: f()
>
> File
>
> return action(*a, **b)
>
> File
>
> File
>
> return self.db._adapter.select(self.query,fields,attributes)
>
> File
>
> (items, tablename, fields) = self.select_raw(query,fields,attributes)
>
> File
>
> filters = self.expand(query)
>
> File
>
> return expression.op(expression.first, expression.second)
>
> File
Anthony
Massimo Di Pierro
tonight.