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
