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.
