Closed

Change SQL designer to add more web2py validators

You can take a look at this or download the source.

[url removed, login to view]

source:

[url removed, login to view]

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=[url removed, login to view]),

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=[url removed, login to view]),

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=[url removed, login to view]),

26 Field('created_by', 'reference auth_user', default=auth.user_id),

27 format='%(name)s')

28

29 [url removed, login to view] = IS_NOT_IN_DB(db, '[url removed, login to view]')

30 [url removed, login to view] = IS_NOT_EMPTY()

31 [url removed, login to view] = [url removed, login to view] = False

32 [url removed, login to view] = [url removed, login to view] = False

33

34 [url removed, login to view] = IS_NOT_EMPTY()

35 [url removed, login to view] = [url removed, login to view] = False

36 [url removed, login to view] = [url removed, login to view] = False

37 [url removed, login to view] = [url removed, login to view] = False

38

39 [url removed, login to view] = IS_NOT_IN_DB(db, '[url removed, login to view]')

Skills: Django, Javascript, MySQL, Python

See more: web2py, mysql to sql, dal, cs auth, mysql sql syntax, sharepoint password change web part sql, sql syntax, page mysql output, url datetime format, url datetime, download file sql, output file change field sql, sql copy file, file format change, url syntax, change title page url, designer f, sql file download, format document change, document format change

About the Employer:
( 13 reviews ) Fort Wayne, United States

Project ID: #7419614

6 freelancers are bidding on average $626 for this job

SoftDevelopINC

Hello , I would prefer to discuss for further details about this project. I'm a webdeveloper over 6 years experience, solid knowledge MCV and OOP. I have a lot of experience with PYTHON (Djdango framework). And I More

$631 USD in 10 days
(254 Reviews)
8.4
seekdeveloper

Hi, I have read your post and understood your requirement. I have great experience in handling /SQL/PHP/Wordpress/Magento/Joomla/Drupal/Angular.js/node.js/ HTML5/CSS3/Java/Python/Django/Javascript/MySQL/iOS/Andro More

$1030 USD in 10 days
(47 Reviews)
8.0
gopalvora

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 excite More

$515 USD in 18 days
(250 Reviews)
7.7
eGlobalSoft

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. Th More

$555 USD in 10 days
(13 Reviews)
4.8
mewartechnosoft

sir, please come on chat more discus about this projects.... [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] htt More

$471 USD in 10 days
(0 Reviews)
0.0
AnhTuDinh

A proposal has not yet been provided

$555 USD in 10 days
(0 Reviews)
0.0