Hi I am having a requirement that i have to encrypt some of the fields in a table. I am using Django 1.3.1 and postgres 9.1. I am referring to this app django-fields :-
https://github.com/svetlyak40wt/django-fields/blob/master/src/django_fields/fields.py Here is my code :- patient_type = EncryptedCharField(max_length=80, choices=CHOICES.PATIENT_TYPES) date_of_birth = EncryptedDateField(null=True, blank=True) gender = EncryptedCharField(max_length=1024, choices=CHOICES.GENDERS, blank=True) contact_phone = EncryptedCharField(max_length=1024, blank=True) security_question = models.ForeignKey(SecurityQuestion, null=True, blank=True) security_answer = EncryptedCharField(max_length=1024, null=True, blank=True) It stores everything in encrypted form in the database except date_of_birth.It throws this error Traceback: File "/usr/local/lib/python2.7/dist-packages/django/core/handlers/base.py" in get_response 111. response = callback(request, *callback_args, **callback_kwargs) File "/home/user/slave/old_careprep/CPMS-Source/careprep/../careprep/utilities/decorators.py" in _dec 14. return view_func(request, *args, **kwargs) File "/home/user/slave/old_careprep/CPMS-Source/careprep/../careprep/visit/views.py" in setup 202. patient.save() File "/usr/local/lib/python2.7/dist-packages/django/db/models/base.py" in save 460. self.save_base(using=using, force_insert=force_insert, force_update=force_update) File "/usr/local/lib/python2.7/dist-packages/django/db/models/base.py" in save_base 553. result = manager._insert(values, return_id=update_pk, using=using) File "/usr/local/lib/python2.7/dist-packages/django/db/models/manager.py" in _insert 195. return insert_query(self.model, values, **kwargs) File "/usr/local/lib/python2.7/dist-packages/django/db/models/query.py" in insert_query 1436. return query.get_compiler(using=using).execute_sql(return_id) File "/usr/local/lib/python2.7/dist-packages/django/db/models/sql/compiler.py" in execute_sql 791. cursor = super(SQLInsertCompiler, self).execute_sql(None) File "/usr/local/lib/python2.7/dist-packages/django/db/models/sql/compiler.py" in execute_sql 735. cursor.execute(sql, params) File "/usr/local/lib/python2.7/dist-packages/django/db/backends/util.py" in execute 34. return self.cursor.execute(sql, params) File "/usr/local/lib/python2.7/dist-packages/django/db/backends/postgresql_psycopg2/base.py" in execute 44. return self.cursor.execute(query, args) Exception Type: DatabaseError at /visit/setup/ Exception Value: invalid input syntax for type date: "$AES$55403376ed906e119b0f7779554fbb51" LINE 1: ...L, NULL, '$AES$0452edae035cc33c4084e7b0fb39edd7', '$AES$5540... ^ Any help will be appreciated. -- Regards Nikhil Verma +91-958-273-3156 -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
