[web2py] Re: Can 2 apps use 1 database ?

2012-07-07 Thread Horus
dvc14RQhuwGE32cSVmd-p35Tw21hW2R4PB9UcXbXLwTVrGRcthvusLvcdRDhnz8B2g-LsohKy64TyJcMX0yuCw5qiypnsPSxUyWHHoPT&sig=AHIEtbQPUlFmojpWCTBBJKHdwdR34aZeuw explained it. DRY is broken however, which isn't a good thing as the database gets bigger. On Saturday, July 7, 2012 2:15:58 PM UTC-4, Horus wrote: > > I currently

[web2py] Can 2 apps use 1 database ?

2012-07-07 Thread Horus
I currently have 2 apps which i would like to share one database. one app is for authentication the other is the main app. When I run the app1 it creates the auth tables along with another table called *base_tags* when I run app2 I get the following error. (the base_tags table in app1 is refere

Re: [web2py] Re: can CAS provider use a different database to apps?

2012-07-06 Thread Horus
*I will put all my tables in one app and call it a day!* On Friday, July 6, 2012 2:40:32 PM UTC-4, Horus wrote: > > Right viniciusban i agree. i don't want to perform joins across > databases explicitly i have never seen that in SQL > BUT I can use the user id from the CAS pro

Re: [web2py] Re: can CAS provider use a different database to apps?

2012-07-06 Thread Horus
) *Are you saying that Web2Py will not get id from base tags and make that relationship?* On Friday, July 6, 2012 1:56:47 PM UTC-4, viniciusban wrote: > > Short answer: manually. > > You cannot connect (join or make a relation) fields among different > databases. > > >

[web2py] Re: can CAS provider use a different database to apps?

2012-07-06 Thread Horus
Yes I understand CAS is for central auth, so i have let the cas provider be the app that takes care of login, registration, signup, what have you; as it should the tables are being created, so I am assuming that the other apps should be able to access the tables if they exist all in the same dat

[web2py] Re: can CAS provider use a different database to apps?

2012-07-06 Thread Horus
e, writable=False, readable=False) File "C:\web2py\gluon\dal.py", line 6343, in __getattr__ return self[key] File "C:\web2py\gluon\dal.py", line 6337, in __getitem__ return dict.__getitem__(self, str(key)) KeyError: 'base_tags' *Does anyone know why thi

[web2py] can CAS provider use a different database to apps?

2012-07-06 Thread Horus
I desire to have multiple apps. one of them will be a CAS provider My questions are: 1. Can these app have different databases i.e db = DAL('postgres://user:password@localhost:5432/cas', migrate=True), db = DAL('postgres://user:password@localhost:5432/db1', migrate=True), db = DAL('postgre

[web2py] Re: invalid literal for int() with base 10: ''

2012-06-25 Thread Horus
pe[8:-1].split(',')) ftype = self.types[field.type[:7]] % \ dict(precision=precision,scale=scale) elif not field.type in self.types: raise SyntaxError, 'Field: unknown field type: %s for %s' % \ On Monday, June 25, 2012

[web2py] Re: Adding reference tables to auth

2012-06-25 Thread Horus
'type_id',db.base_types), Field('sex_id',db.base_sexes), are other tables On Monday, June 25, 2012 10:33:47 PM UTC-4, Massimo Di Pierro wrote: > > You can defined your own auth_user before auth.define_table and your own > will be used. Or you can use > > au

[web2py] invalid literal for int() with base 10: ''

2012-06-25 Thread Horus
I am currently getting this error working with DAL based on db.define_table('base_tags', Field('name', 'string', length=64, required=True, notnull=True), format='%(name)' ) db.define_table('base_timezones', Field('name', 'string'

[web2py] Adding reference tables to auth

2012-06-25 Thread Horus
is there a way to add other tables to the current auth table setup ? I am aware of customizing existing tables but not adding tables to the database structure. e.g. Is it VALID to add other tables such at a country table and have auth_user reference this table without breaking web2py internal

[web2py] Re: unsigned DAL integer

2012-06-25 Thread Horus
Thanks Anthony. On Monday, June 25, 2012 2:27:19 PM UTC-4, Anthony wrote: > > Is there a way to get unsigned DAL integers ? >> > > I don't think so. If you have created the table outside the DAL, perhaps > telling the DAL it's a regular "integer" field will still work, though. > > >> Is there a

[web2py] unsigned DAL integer

2012-06-25 Thread Horus
Is there a way to get unsigned DAL integers ? Is there a way to represent BIGINT using DAL? --

[web2py] Re: Web2Py + library.zip

2012-05-31 Thread Horus
OK, I saw my error. Thank You! On Wednesday, May 30, 2012 10:12:22 PM UTC-4, Massimo Di Pierro wrote: > > You must be using the binary distribution. If you use the source > distribution there is a web2py/gluon/ folder. > > On Wednesday, 30 May 2012 20:00:32 UTC-5, Horus wrote: &g

[web2py] Re: Web2Py + library.zip

2012-05-31 Thread Horus
12 20:00:32 UTC-5, Horus wrote: >> >> I have been going through the book and I have been seeing gluon imports. >> Don't say this is crazy but is Web2Py Pulling from this library.zip, this >> is where the gluon import are coming from? > >

Re: [web2py] replacing router.example.py or routes.example.py

2012-05-30 Thread Horus
understood! On Wednesday, May 30, 2012 10:13:43 PM UTC-4, Jonathan Lundell wrote: > > On May 30, 2012, at 7:08 PM, Horus wrote: > > I have attached a screenshot to show you what i am seeing. > > I started python 4 weeks ago and web2py for the last 2 so this > is comp

Re: [web2py] replacing router.example.py or routes.example.py

2012-05-30 Thread Horus
Additionally, if routes.py is the main file what is the purpose of router.py? On Wednesday, May 30, 2012 9:07:40 PM UTC-4, Jonathan Lundell wrote: > > On May 30, 2012, at 5:56 PM, Horus wrote: > > #1 I am assuming that when you replace router.example.py or > routes.example.py

Re: [web2py] replacing router.example.py or routes.example.py

2012-05-30 Thread Horus
I removed the .example from routes.example.py to make it routes.py, changed the values but noting happened? On Wednesday, May 30, 2012 9:07:40 PM UTC-4, Jonathan Lundell wrote: > > On May 30, 2012, at 5:56 PM, Horus wrote: > > #1 I am assuming that when you replace router.e

[web2py] Web2Py + library.zip

2012-05-30 Thread Horus
I have been going through the book and I have been seeing gluon imports. Don't say this is crazy but is Web2Py Pulling from this library.zip, this is where the gluon import are coming from?

[web2py] replacing router.example.py or routes.example.py

2012-05-30 Thread Horus
#1 I am assuming that when you replace router.example.py or routes.example.py with router.py or routes.py, respectively, in the base folder they should take over? #2 Can they be added to app folder? if they are added will they take precedence ? I am not finding a lot about this online

[web2py] Re: Wep2Py Database Tables

2012-05-29 Thread Horus
Having authentication as a core and apps built around it rather than every app having its own admin/CAS On Monday, May 28, 2012 9:38:51 PM UTC-4, Anthony wrote: > > Not sure what you mean. > > On Monday, May 28, 2012 9:16:27 PM UTC-4, Horus wrote: >> >> ok understood.

Re: [web2py] Re: Web2Py + OAuth2 Server

2012-05-29 Thread Horus
ikely to provide the same services > as > > facebook and therefore clients written for facebook will not work for > it. > > > > I would stay away from Oauth 2.0 unless you need it as a client to > > authenticate to third party services. > > > > Mass

[web2py] Web2Py + OAuth2 Server

2012-05-28 Thread Horus
I have seen that web2py supports integration with Facebook + Twitter. What if I want to create my own OAuth2 Server like what is offered by Facebook and Twitter? Is this possible with Web2Py?

[web2py] Re: Wep2Py Database Tables

2012-05-28 Thread Horus
> the app is not used as a provider, that table will simply remain empty. If > you want to prevent it from being created in the first place, before > calling auth.define_tables(), you can do: > > auth.settings.cas_domains = None > > Anthony > > On Sunday, May 27, 2012 2:

[web2py] Re: Wep2Py Database Tables

2012-05-27 Thread Horus
:37:09 PM UTC-4, Niphlod wrote: > > it's for Central Authentication Services > > http://web2py.com/books/default/chapter/29/9#Central-Authentication-Service > > Il giorno sabato 26 maggio 2012 18:46:26 UTC+2, Horus ha scritto: >> >> In the administrative section

[web2py] Wep2Py Database Tables

2012-05-26 Thread Horus
In the administrative section of your app there are the usual ACL tables. I realise there is a *acl_cas* table along with these tables. I am curious as to what this tables does?