django-unixdatetimefield

Provides a UnixDateTimeField for your Django models.

I have found this especially useful when integrating Django into legacy databases, where the typical DateTime column type is rather stored as a Unix timestamp (http://en.wikipedia.org/wiki/Unix_time).

UnixDateTimeField is based on the implementation of the standard Django DateTimeField, making it 100% compatible with all features and options it supports.

Usage

First you'll need to attach a UnixDateTimeField to your model. This acts as a the equivalence of a Django PositiveIntegerField at the database level but provides a Django DateTimeField at the ORM abstraction layer.

Example model:

from django_unixdatetimefield import UnixDateTimeField

class MyModel(models.Model):
    created_at = UnixDateTimeField()

Python ORM query:

>>> m = MyModel()
>>> m.created_at = datetime.datetime(2015, 2, 21, 19, 38, 32, 209148)
>>> m.save()

Database:

sqlite> select created_at from mymodel;
1426967129

Enjoy!

Installation

Install with pip (or easy_install):

pip install django-unixdatetimefield

License

BSD, just as the main Django project. See LICENSE file in root of this repo.

Contributing

This project accepts contributions via GitHub pull requests.

follow Google's Python style guide https://google-styleguide.googlecode.com/svn/trunk/pyguide.html
make commits of logical units, messages should include what changed and why and be written in past tense

There is a ValueError in the UnixDataTimeField.to_python() method

There is a ValueError in the UnixDataTimeField.to_python() method.

I will a copy the complete error message

Rapid solution:

#!/usr/bin/python

-- coding: UTF-8 --

from future import unicode_literals

import datetime
import time

import django.db.models as models

from django.utils.dateparse import parse_datetime

class UnixDateTimeField(models.DateTimeField):

# TODO(niklas9):
# * should we take care of transforming between time zones in any way here ?
# * get default datetime format from settings ?
DEFAULT_DATETIME_FMT = '%Y-%m-%d %H:%M:%S'
# TODO(niklas9):
# * metaclass below just for Django < 1.9, fix a if stmt for it?
#__metaclass__ = models.SubfieldBase
description = "Unix timestamp integer to datetime object"

def get_internal_type(self):
    return 'PositiveIntegerField'

def to_python(self, val):
    if val is None or isinstance(val, datetime.datetime):
        return val
    if isinstance(val, datetime.date):
        return datetime.datetime(val.year, val.month, val.day)
        
    try:
        date_value = datetime.datetime.fromtimestamp(float(val))
        return date_value            
    except ValueError:
        # parse the following value : ('2016-10-03 19:00:00+0200'
        date_value = parse_datetime(val)
        return date_value

def get_db_prep_value(self, val, *args, **kwargs):
    if val is None:  return None
    return int(time.mktime(val.timetuple()))

def value_to_string(self, obj):
    val = self._get_val_from_obj(obj)
    return self.to_python(val).strftime(self.DEFAULT_DATETIME_FMT)

def from_db_value(self, val, expression, connection, context):
    return self.to_python(val)

pvergain / django-unixdatetimefield Goto Github PK