How can I create a query with more that one outer join using 'left' ?
I would like to create query that has 2 left outer join statements.
How to do it?
e.g. This is what I would like to do, but using 'left' twice is not
possible ...
db(db.reply.id>0).select(db.reply.ALL, db.auth_user.ALL,.db.task.
I just found example myself:
e.g.
composer=db.person.with_alias('composer')
arranger=db.person.with_alias('arranger')
left=[composer.on(composer.id==db.work.composer),arranger.on
(arranger.id==db.work.arranger)]
recs=db().select(db.work.title,composer.name,arranger.name,left=left)
On 15 čnc, 09:1
The point was to have a 16bytes key for uuid that depends on
uuid.getnode(), time.time(), and a random component. The specific way
the key is built can be changed if there is a good argument for it.
Before we just used uuid.uuid4() an the problem was that when running
on a HA cluster with replicat
We really need a better way to post plugins and keep track of features/
versions than web2py.com/plugins.
On 14 Lug, 18:03, Thadeus Burgess wrote:
> I have this code implemented in plugin_category.py let me just find it
> =/
>
> Ah yes, here it is
>
> http://code.google.com/p/blogitizor/sourc
If not it is a bug. Can you help debug this?
On 14 Lug, 22:33, NiallSweeny wrote:
> Does this work with Oracle databases? I have defined a table as
> such:
>
> db.define_table('MITED_ROLE', Field('MITED_ROLE_ID', 'id'),
> migrate=False)
>
> ... and get the error: ORA-00904: "MITED_ROLE"."ID": in
this has been fixed in trunk. Will repost today.
On 14 Lug, 23:57, Rob wrote:
> Hi guys!
>
> I just got this traceback:
> Traceback (most recent call last):
> File "/home/rhd/Desktop/web2py/gluon/restricted.py", line 178, in
> restricted
> exec ccode in environment
> File "/home/rhd/Deskt
http://www.skulpt.org/
Hi,
I would advise to integrate jquery.ui and the ThemeSwitcher widget
(http://docs.jquery.com/UI/Theming/ThemeSwitcher) to make the app
visual appealing vor novices.
THX
Dieter Asman
On Jul 9, 3:34 pm, mdipierro wrote:
> let's consider anewscaffolding app.
>
> What should be in it?
> What sho
I have kind of got it working again by changing = to == in all
self.settings in rpx module.
Is this change in storage.py / restricted.py documented anywhere or
explaination
of why i needed to do this would be great.
chrism
On Jul 14, 10:14 am, ChrisM wrote:
> Hi is anyone else using niels rpxauth
That would be easy to do:
http://jqueryui.com/
themes/base/ui.all.css" />
http://jqueryui.com/js/
jquery.js">
$(document).ready(function(){
$('#switcher').themeswitcher();
});
There are two problems:
1) to make it work locally (behind firewall) we would have to package
them
Here is the problem:
the settings class allows to lock keys to prevent users from
mispelling settings. the rpx module need to be modified in the
following way
class RPXAuth(Auth):
def __init__():
self.settings.lock_keys=False ### insert this
## current code for __init__
I tried this. It needs (in header)
http://jqueryui.com/
themes/base/ui.all.css" />
http://jqueryui.com/js/
jquery.js">
and also this (in body) to add the button:
http://jqueryui.com/themeroller/
themeswitchertool/">
jQuery(document).ready(function()
{jQuery('#switcher').themeswitche
I am thinking about including RPXAuth into gluon/tools.
MrFreeze, what do you think?
Anybody using this already?
Has anybody tried it on GAE?
Massimo
Hi,
Has anyone created mapping for Facebook on rpxauth? If so, please do
share. (I see mappings for Yahoo and Google already in the version
I've downloaded.)
--
Thanks
Narendran
I ma be mistaken but rpxauth outsources autentication to rpx (now
http://www.janrain.com/) and they do support facebook. I am not sure
there is any need to modify the code, just add "facebook" to list of
authentication methods you wish to use.
On 15 Lug, 04:32, Narendran wrote:
> Hi,
> Has anyone
Hi Massimo,
I have done that. And Facebook login does work well.
But I also want an entry in my auth table for each registered user.
This, I assume happens only if you have mappings like these in
rpxauth.__init__. Right now, I see entries created in the table for a
Google user, but not a Facebook
Hi,
Right now, when I click on the link to user/login url, it now returns
sign-in form, and on clicking on sign-in there, it opens the rpx's
sign-in widget.
Is there a way to by-pass the intermediate sign-in form (as I anyways
don't want the register/forgot password functionality on using oauth),
a
I have to digest this a little more to understand the implications.
What do you think of it, Massimo?.
On Jul 15, 4:14 am, mdipierro wrote:
> http://www.skulpt.org/
It's all yours. You may want to update the module name since they
officially renamed it to Janrain Engage.
On Jul 15, 4:23 am, mdipierro wrote:
> I am thinking about including RPXAuth into gluon/tools.
> MrFreeze, what do you think?
>
> Anybody using this already?
> Has anybody tried it on GAE?
>
I used it but I encountered limitations when using access tokens to
get api data, this is paid service by jainran then, so the question is
will it still be cool to be in trunk?
This works for me and creates entries in my db:
--
Model
--
rpx = local_import('rpxauth')
rpxAuth = rpx.RPXAuth(auth)
rpxAuth.embed = True
#rpxAuth.allow_local = True
rpxAuth.api_key = "..."
rpxAuth.realm = "web2pyslices"
rpxAuth.token_url = "http://localhost:8000/rpxauth/default/us
I do not know myself. I am not sure how well it works.
On 15 Lug, 06:23, weheh wrote:
> I have to digest this a little more to understand the implications.
> What do you think of it, Massimo?.
>
> On Jul 15, 4:14 am, mdipierro wrote:
>
> >http://www.skulpt.org/
Try this:
rpxauth.allow_local = False
rpxauth.embed = True
On Jul 15, 6:10 am, Narendran wrote:
> Hi,
> Right now, when I click on the link to user/login url, it now returns
> sign-in form, and on clicking on sign-in there, it opens the rpx's
> sign-in widget.
> Is there a way to by-pass the inte
www.augmi.com
works fine with rpx
On Jul 15, 10:23 am, mdipierro wrote:
> I am thinking about including RPXAuth into gluon/tools.
> MrFreeze, what do you think?
>
> Anybody using this already?
> Has anybody tried it on GAE?
>
> Massimo
Hello Mr. Freeze,
It works now :). Not sure what went wrong last time when I tried with
this mapping, it made all null entries in the table.
On Jul 15, 5:09 pm, "mr.freeze" wrote:
> This works for me and creates entries in my db:
> --
> Model
> --
> rpx = local_import('rpxauth')
>
I had an existing table defined and just added "multiple=True" to the
IS_IN_DB statement because I want to convert it from a '1 to 1' to a
'1 to many'. So, I had some data in the DB before I set
'multiple=True'.
(btw, is there a bug tracker setup so I don't have to spam the group
with reports?)
Thanks!
On Jul 15, 1:06 am, mdipierro wrote:
> this has been fixed in trunk. Will repost today.
>
> On 14 Lug, 23:57, Rob wrote:
>
>
>
> > Hi guys!
>
> > I just got this traceback:
> > Traceback (most recent call last):
> > File "/home/rhd/Desktop/web2py/gluon/restricted.py", line 178, in
> >
Interesting idea! Of more immediate interest, to me at least, is the
underlying python-to-js translator (pycow 0.1) that emits very
readable and nicely indented Javascript. See
http://code.google.com/p/pygowave-server/wiki/PythonToJavaScriptTranslator
for the full scoop.
I installed pycow and ra
Since I like the idea of having a php.net like documentation
application I took some time and created a basic application that may
kick-start the development of a web2py app that is just that.
So far only few features are implemented and this is rather a proof of
concept than the real thing.
I will
multiple=True is afake 1 to many. It stores references as a string '|
1|5|8|' therefore it requires the field to be of type 'string' not int
or reference.
On 15 Lug, 09:51, Rob wrote:
> I had an existing table defined and just added "multiple=True" to the
> IS_IN_DB statement because I want to c
Markmin looks pretty sweet, tiny and fast!
http://www.web2py.com/examples/static/markmin.html
C.
On Jul 14, 12:36 pm, mdipierro wrote:
> We had an attempt to use rest and sphinx but now that despitce help
> form many people we never managed to make it work decently because of
> third party depe
Many thanks!
On Jul 15, 11:21 am, mdipierro wrote:
> multiple=True is afake 1 to many. It stores references as a string '|
> 1|5|8|' therefore it requires the field to be of type 'string' not int
> or reference.
>
> On 15 Lug, 09:51, Rob wrote:
>
> > I had an existing table defined and just add
Hi guys,
I am one of the proponents that web2py's DAL should support NoSQL
datastores like Couchdb, Mongodb et al but since the DAL rewrite isn't
quite completer yet, I would like to know how to use web2py and a
NoSQL datastore without DAL and without loosing stuff like auto-gen
forms and validatio
You can use
form = SQLFORM.factory(Field(...),Field(...),...)
if form.accepts():
call nosql api to insert form.vars
This is the only solution I can think of at the moment.
On 15 Lug, 15:07, Pystar wrote:
> Hi guys,
> I am one of the proponents that web2py's DAL should support NoSQL
> da
Thank you! I will take a look.
On 15 Lug, 11:02, selecta wrote:
> Since I like the idea of having a php.net like documentation
> application I took some time and created a basic application that may
> kick-start the development of a web2py app that is just that.
> So far only few features are imp
I definitely can - I'll let you know what I find.
-N
On Jul 15, 1:05 am, mdipierro wrote:
> If not it is a bug. Can you help debug this?
>
> On 14 Lug, 22:33, NiallSweeny wrote:
>
>
>
> > Does this work with Oracle databases? I have defined a table as
> > such:
>
> > db.define_table('MITED_ROL
Hello there,
Just a small note about the *select* widget.
When there is nothing in the table yet, I get an error:
Traceback (most recent call last):
File
"/home/jmonteiro/Devel/nightly_web2py/applications/cube2py/models/plugin_wiki.py",
line 536, in render_widget
return html.xml()
Attribut
fixed in trunk
On 15 Lug, 18:14, Júlio Monteiro wrote:
> Hello there,
>
> Just a small note about the *select* widget.
> When there is nothing in the table yet, I get an error:
>
> Traceback (most recent call last):
> File
> "/home/jmonteiro/Devel/nightly_web2py/applications/cube2py/models/plu
I have integrated Mr Freeze RPX API into web2py (trunk only).
Take your existing app and at the bottom of db.py (or after you define
auth) add
from gluon.contrib.login_methods.rpx_account import RPXAccount
auth.settings.actions_disabled=['register','change_password','request_reset_password'
P.S. You can also try the nightly built from
http://web2py.com/examples/static/download
On 15 Lug, 18:31, mdipierro wrote:
> I have integrated Mr Freeze RPX API into web2py (trunk only).
>
> Take your existing app and at the bottom of db.py (or after you define
> auth) add
>
> from gluon.con
Nice. One small issue on the Facebook mapping. First and last name are
under the profile's 'name' key so it throws and error. Just need to
change these two:
first_name = profile["name"]["givenName"],
last_name = profile["name"]["familyName"]
After that I was able to login to Google, Yahoo and Face
Two other issues:
When embed=False, the link doesn't work (I am investigating why).
Also, I don't think you should have to click another link when
embed=False. It should just show the overlay.
On Jul 15, 7:21 pm, "mr.freeze" wrote:
> Nice. One small issue on the Facebook mapping. First and last n
Actually, embed=False works fine. I think the problem was on my end.
On Jul 15, 8:35 pm, "mr.freeze" wrote:
> Two other issues:
> When embed=False, the link doesn't work (I am investigating why).
> Also, I don't think you should have to click another link when
> embed=False. It should just show t
Okay, I sent you a patch to fix the Facebook mapping and also to show
the login prompt automatically when embed=False.
On Jul 15, 9:52 pm, "mr.freeze" wrote:
> Actually, embed=False works fine. I think the problem was on my end.
>
> On Jul 15, 8:35 pm, "mr.freeze" wrote:
>
> > Two other issues:
Just a quick thought.
1. Each plugin's owner can store the source code in code.google.com
2. Too bad that code.google.com can not provide a live show about the
plugin's look-and-feel, so we can setup a plugins' "sandbox" on
web2py.com, nightly checkout plugins' source code, then user can visit
a l
45 matches
Mail list logo
