Thanks Massimo,
probably the better way to do this kind of bindings is at the db
level
if multiple applications needs to access the db.
otherwise an application level check works too.
On 12 Feb, 15:51, mdipierro <mdipie...@cs.depaul.edu> wrote:
> Thanks for your patch. I will include it.
>
> Currently in web2py you can only set unique multicol constraints at
> the web2py level (IS_NOT_IN_DB(subset,...)).
> This could be added but would make migrations a nightmare.
>
> Massimo
>
> On Feb 12, 8:42 am, kralin <andrea.pierle...@gmail.com> wrote:
>
> > I've being doing some testing
> > and actually setting
>
> > primarykey=[]
>
> > seems to work for creating tables without primary key
> > and read and write them.
>
> > however appadmin interface crash because it expect a primarykey to
> > pass a query.
> > I fixed this by changing in appadmin.html:
>
> > {{if request.function=='index':}}
> > <h1>{{=T("Available databases and tables")}}</h1>
> > {{if not databases:}}{{=T("No databases in this application")}}
> > {{pass}}
> > {{for db in sorted(databases):}}
> > {{for table in databases[db].tables:}}
> > {{qry='%s.%s.id>0'%(db,table)}}
> > {{tbl=databases[db][table]}}
> > {{if hasattr(tbl,'_primarykey'):}}
> > {{if tbl._primarykey:}}
> > {{firstkey=tbl[tbl._primarykey[0]]}}
> > {{if firstkey.type in ['string','text']:}}
> > {{qry='%s.%s.%s!=""'%(db,table,firstkey.name)}}
> > {{else:}}
> > {{qry='%s.%s.%s>0'%(db,table,firstkey.name)}}
> > {{pass}}
> > {{else:}}
> > {{qry=''}}
> > {{pass}}
> > {{pass}}
> > <h2>{{=A("%s.%s"%
> > (db,table),_href=URL(r=request,f='select',args=[db],vars=dict(query=qry)))}}
> > </h2>
> > [ {{=A(str(T('insert new'))+'
> > '+table,_href=URL(r=request,f='insert',args=[db,table]))}} ]
> > <br /><br />
> > {{pass}}
> > {{pass}}
>
> > one last thing.
> > Is there a way to set by the web2py DAL a multiple field constraint at
> > db level?
>
> > let's say this is my db model:
>
> > db.define_table('table_name',
> > Field('col_1','integer'),
> > Field('col_2','string'),
> > primarykey=[])
>
> > is it possible to set(using the DAL) at the db level a constraint so
> > that
> > the combination of col_1 and col_2 is unique?
> > if not are you planning to add constraint support to DAL?
>
> > I know this can be done in the application, and I'm doing this way...
>
> > On 10 Feb, 03:18, DenesL <denes1...@yahoo.ca> wrote:
>
> > > Don't wait for me, currently I have no plans to work on this.
>
> > > On 9 feb, 10:47, kralin <andrea.pierle...@gmail.com> wrote:
>
> > > > Let me know if I can help.
>
> > > > anyhow a good starting point would be making the table.insert() able
> > > > to return None
> > > > if no primary key or ID is defined. what do u think? is this
> > > > possible?
>
> > > > On 8 Feb, 17:29, mdipierro <mdipie...@cs.depaul.edu> wrote:
>
> > > > > You know I would take a patch
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en.
