Thanks a lot Massimo, I'll let you know what happens vj
On Fri, Mar 11, 2011 at 12:17 PM, Massimo Di Pierro <[email protected]> wrote: > You can do it with dal.SQLCustomType > > If you cannot find a useful example, let me know and I will write one. > > On Mar 11, 10:13 am, Juan Hernandez <[email protected]> wrote: >> In MySQL would go something like this >> >> #Insert >> insert into users (domain, email, password, quota) values (1, >> '[email protected]', ENCRYPT('mypass'), '101010'); >> # >> >> mysql> select * from users; >> | 3 | 1 | [email protected] | j57VHP.kk4c.o | 101010 | >> 1 row in set (0.00 sec) >> >> and reading MySQL's docs I saw this: >> """ >> Encrypts str using the Unix crypt() system call and returns a binary >> string. The salt argument must be a string with at least two >> characters or the result will be NULL. If no salt argument is given, a >> random value is used. >> """ >> >> On Fri, Mar 11, 2011 at 11:33 AM, Massimo Di Pierro >> >> >> >> >> >> >> >> <[email protected]> wrote: >> > I am not familiar with encrypt() in mysql. If you show me how you use >> > it in mysql, I can see how to do with dal. >> >> > On Mar 11, 9:15 am, Vlad Janicek <[email protected]> wrote: >> >> Hey there People, >> >> >> I have a question, lets shay that I need to create an users table that >> >> some other systems connect to and when these systems check for users, >> >> only use the MySQL encrypt() function. >> >> >> The model would be something like this: >> >> >> # My model >> >> db.define_table('users', >> >> Field('domain', db.domains, requires = IS_NOT_EMPTY()), >> >> Field('email', requires = IS_EMAIL()), >> >> Field('password', 'password', requires = IS_NOT_EMPTY()), >> >> Field('quota', requires = IS_NOT_EMPTY()), >> >> ) >> >> >> # My CRUD sentence >> >> form = crud.create(db.users, message='email has been added >> >> successfully') >> >> >> Im using in in a very simple way and it works if it was a standalone >> >> app but, I need web2py to enforce MySQL encrypt() every time I add or >> >> query for a record. I can do it manually but it would stop me from >> >> using CRUD. >> >> >> What would be the best approach?? >> >> Thanks a lot for your help... >> >> vj
