Find Jobs
Hire Freelancers

Change SQL designer to add more web2py validators

$250-750 USD

Closed
Posted about 9 years ago

$250-750 USD

Paid on delivery
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]')
Project ID: 7419614

About the project

6 proposals
Remote project
Active 9 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
6 freelancers are bidding on average $626 USD for this job
User Avatar
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
$515 USD in 18 days
4.7 (250 reviews)
7.7
7.7
User Avatar
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
$555 USD in 10 days
4.6 (13 reviews)
4.8
4.8
User Avatar
A proposal has not yet been provided
$555 USD in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Fort Wayne, United States
4.8
13
Payment method verified
Member since Jun 10, 2014

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.