You can take a look at this or download the source.
[login to view URL]
source:
[login to view URL]
Or I can send you a copy.
The project only outputs few validators for web2py. I would like to add more and make this to web2py specific. For example readable, writable, format like name, title, url,email,is not in db, is in db, is not empty, is required, n finally reference. But I believe reference is done by using foreign keys.
This are basically DAL syntax (you can download pyDAL from github). Here is another example. Basically want SQL designer to have all the DAL validators included and output the syntax as shown below.
db.define_table('page',
9 Field('title'),
10 Field('body', 'text'),
11 Field('created_on', 'datetime', default=[login to view URL]),
12 Field('created_by', 'reference auth_user', default=auth.user_id),
13 format='%(title)s')
14
15 db.define_table('post',
16 Field('page_id', 'reference page'),
17 Field('body', 'text'),
18 Field('created_on', 'datetime', default=[login to view URL]),
19 Field('created_by', 'reference auth_user', default=auth.user_id))
20
21 db.define_table('document',
22 Field('page_id', 'reference page'),
23 Field('name'),
24 Field('file', 'upload'),
25 Field('created_on', 'datetime', default=[login to view URL]),
26 Field('created_by', 'reference auth_user', default=auth.user_id),
27 format='%(name)s')
28
29 [login to view URL] = IS_NOT_IN_DB(db, '[login to view URL]')
30 [login to view URL] = IS_NOT_EMPTY()
31 [login to view URL] = [login to view URL] = False
32 [login to view URL] = [login to view URL] = False
33
34 [login to view URL] = IS_NOT_EMPTY()
35 [login to view URL] = [login to view URL] = False
36 [login to view URL] = [login to view URL] = False
37 [login to view URL] = [login to view URL] = False
38
39 [login to view URL] = IS_NOT_IN_DB(db, '[login to view URL]')
Hi
I have gone through the details of your project and we find it well within our capabilities.
I can create and deliver the project as per the information.I have skilled,
expert programmers I'm very excited to assist you in making your Sites successful
– please feel free to contact me directly to discuss this position further.
Thanks
Dear Sir,
I have 3 years of experience in php/python/django/html/css/mysql. I have gone through your requirement and interested to work on your project. Please check my reviews and feedback for your reference.
Thanks & Regards
eGlobalSoft