How to encrypt DateTimeField in models.py ?

[Nikhil Verma]

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

[Andres Reyes]

Looking at the log it seems your underliying database has DATE type
for the column when it should be a VARCHAR or the like

2012/1/9 Nikhil Verma <varma.n...@gmail.com>:

> --
> You received this message because you are subscribed to the Google Groups
> "Django users" group.
> To post to this group, send email to django...@googlegroups.com.
> To unsubscribe from this group, send email to
> django-users...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/django-users?hl=en.

--
Andrés Reyes Monge
arm...@gmail.com
+(505)-8873-7217

[zalew]

you probably used DateField as base for EncryptedDateField. it should inherit from CharField and only use the Date validators