Blog Rss Feed
In your relational database, the date and time are usually stored as a DateTime field, because it is more convenient for sorting, search and dates calculation. But when displayed these fields don't look very nice. Often on popular web sites the date of an article is displayed like this «about a hour ago». The following function shows you how to display human readable elapsed times.
# -*- coding: utf-8 -*- # # $Id:$ # import datetime as dt import time _partialMinute = 45 * 60 _partialHour = 90 * 60 _fullDay = 24 * 60 * 60 _twoDays = _fullDay * 2 def relative_time(date): """ """ now = dt.datetime.now() if not isinstance(date, dt.datetime): raise TypeError now = time.mktime(now.timetuple()) date = time.mktime(date.timetuple()) delta = now - date if delta < 60: return u"less than a minutes ago" elif delta < 120: return u"about a minute ago" elif delta < _partialMinute: return u"%d minutes ago" % int(delta / 60) elif delta < _partialHour: return u"about an hour ago" elif delta < _fullDay: return u"%d hours ago" % int(delta / 3600) elif delta < _twoDays: return u"1 day ago" else: return u'%d days ago' % int(delta / 86400)
You can create a new property in you sqlalchemy class to automatically return a nicely formatted time.
item_table = Table('item', metadata, Column('id', Integer, primary_key=True), ... Column('updated', DateTime, default=datetime.now), ... ) class Item(object): """ Item information """ @property def show_updated(self): """ Return a nicely formated time. Ex: '1 hour 20 minutes ago' """ return relative_time(self.updated)
Now your database object has a new property called show_updated that returns the property updated from the database but formated by the function relative_time
>>> i=session.query(Item).get(1) >>> print i.updated 2008-11-04 08:00:00.000001 >>> print i.show_updated 3 days ago >>>
Comments
Posted by: Guillaume Nov 07, 2008 @ 15:10
John Resig has a similar library to do this in Javascript. http://ejohn.org/projects/javascript-pretty-date/
Posted by: chat Nov 23, 2009 @ 03:08
Also need to continuously develop and grow in order to return people's lives. Sometimes, we have to say that UGG's history is worthy of study.
Posted by: sohbet Nov 23, 2009 @ 03:09
thanks you eyw sagOL Kocum :P
Posted by: cheapest voip calls Nov 24, 2009 @ 20:42
Great article. It was helpful and informative. hope to see more greats posts like this one. hmm never tried this. i will see to it
Posted by: free games Nov 27, 2009 @ 00:36
Pretty good post. thanks
Posted by: life insurance comparison Nov 29, 2009 @ 22:37
Thanks for sharing
Posted by: ugg boots Dec 11, 2009 @ 00:12
ok
Posted by: sell ugg ugg boots online ugg boots Dec 16, 2009 @ 18:45
1 Chestnut UGG Bailey Button Boots
2 Rose UGG Classic Cardy Boots 3 Sand UGG Classic Mini Boots 4 UGG Classic Argyle Knit whit 5879 5 UGG 5822 Stripe Cable Knit Chocolate White 6 Chestunt Genuine Australia classic Tall 7 Sand UGG Ultra Shotr Boots 8 Chestnut UGG Sundance Boots
Posted by: links of london Dec 20, 2009 @ 23:09
Early morning time, the mist is dim. Curved river bank, willow obviously elegant like smoke. Far does not see the mountain, nearly does not see the ship, only a little selects the lights, embellishes in the faintly recognizable mist. The young young schoolchild, sings in this mist at sunset; In a hurry the pedestrian, the moist hair clothing which fills by the mist. Most beautiful, when is in the fog the park, pavilion Taiwan pavilion, porch bridge park, fuzzy, partly visible. Let the human think that imitates, if places oneself in unreal, is considering, is in the world, plays in the heavenly palace?
Posted by: send flowers to japan Dec 29, 2009 @ 04:13
Early morning time, the mist is dim. Curved river bank, willow obviously elegant like smoke. Far does not see the mountain, nearly does not see the ship, only a little selects the lights, embellishes in the faintly recognizable mist. The young young schoolchild, sings in this mist at sunset; In a hurry the pedestrian, the moist hair clothing which fills by the mist. Most beautiful, when is in the fog the park, pavilion Taiwan pavilion, porch bridge park, fuzzy, partly visible. Let the human think that imitates, if places oneself in unreal, is considering, is in the world, plays in the heavenly palace?
Posted by: fake rolex watches Jan 04, 2010 @ 23:38
Welcome to our website,and you will enjoy the sunshine service. Let's
abandon all the worry,and enjoy the happy shopping travel.All the
replica watches paypal and replica watches are most in fashion
boutique this year.rolex replica and rolex replica paypal and the
replica rolex paypal show your chaming temperament. In addtin, the
fake watches paypal and the other fake rolex paypal make you mold
your unique glamour this winter.The swiss rolex replica have the high
quality but low price. replica watch paypal and replica rolex have
all the style and cheapest price replica rolex watches. Enjoying the
fun of net purchase! replica rolex We will supply you the perfect
service and after sale support system. Our honest will bring you
absolute satisfaction.
Posted by: china wholesale Jan 14, 2010 @ 00:15
Here is the richest in the world and you can find your needs bring you harvest yes there
is no other better place than here here you are with my natural beauty but also naturally
pure green world our homes a share in the bar.God bless you! www.trademic.com
Posted by: film izle Jan 17, 2010 @ 04:47
Thank you for sharing your friends. Hope to see you another day.
Posted by: divx film izle Jan 17, 2010 @ 04:50
Thank you for sharing your friends. Hope to see you another day.
Posted by: links of london Jan 19, 2010 @ 00:13
Here is the richest in the world and you can find your needs bring you harvest yes there
is no other better place than here here you are with my natural beauty but also naturally
pure green world our homes a share in the bar.God bless you! www.trademic.com
Posted by: evening dresses Feb 19, 2010 @ 06:05
I look forward to reading more from you.
Posted by: Nike Air Max Feb 22, 2010 @ 23:11
Very creative, one of the nicer sites I have seen today. Keep up the great work.
Posted by: Nike Air Max Mar 04, 2010 @ 00:17
So beautiful sharing!Thank you very much.
Posted by: tag heuer watch Mar 04, 2010 @ 23:22
can show a man not only his wealthy but also his high taste.tag heuer watch As the society developed, many people are pay more attention to one's wearing than before, especially a watch. tag heuer watch If you are wearing a famous brand watch, people will look up you, also will love to do business with you. You will be a successful man with a such luxury fashion watch.
Posted by: Nike Air Max Mar 11, 2010 @ 18:58
Best wishes!Your blog is very good!
Posted by: omega moon watch Mar 11, 2010 @ 20:32
I recently came across your blog and have been reading along. I thought I would leave my first comment. I don't know what to say except that I have enjoyed reading. Nice blog. I will keep visiting this blog very often.
Posted by: MBT Chapa Mar 12, 2010 @ 23:04
can show a man not only his wealthy but also his high taste.tag heuer watch As the society developed, many people are pay more attention to one's wearing than before
Posted by: Nike Air Max Mar 18, 2010 @ 02:36
It is so nice.
Posted by: Data Recovery Mar 29, 2010 @ 08:06
That's true, display issues have always crept up on us in the past.
Posted by: Data Recovery Mar 29, 2010 @ 08:09
couldn't get this to work within a drupal cms
Posted by: SQL Apr 02, 2010 @ 06:22
Thanks for sharing the information dude. I found the information very helpful. That's a awesome article you posted. I will come back to read some more.
Posted by: replica handbags Apr 04, 2010 @ 09:14
Such a good article, caught my sympathy!
Posted by: brand designer handbags Apr 07, 2010 @ 19:56
Here is the richest in the world and you can find your needs bring you harvest. yes brand designer handbags there is no other better place than here,in here you are with my natural beauty dvd brand designer handbags but also naturally pure green world. our homes brand designer handbags a share in the bar.God bless you!
Posted by: chopard watch Apr 18, 2010 @ 23:09
chopard watches and replica chopard tend to be coated in a simulation silver or tag heuer gold and replica rolex filled with breitling watches a much cheaper rolex watche smetal to save on cost.
Posted by: wholesale clothing Apr 19, 2010 @ 00:12
It is good!
Posted by: wholesale electronics Apr 21, 2010 @ 06:14
Here have a variety of advanced technology to produce electronic products, http://www.trademic.com Most wholesale electronics today use semiconductor apparatus to accomplish electron control. The abstraction of semiconductor wholesale electronics and accompanying technology is advised a annex of physics, admitting the architecture and architecture of cyberbanking circuits to break applied problems appear beneath go to wholesale electronics,engineering. This commodity focuses on engineering aspects of electronics.wholesale electronics is a able manufacturer, specializes in development, manufacture. We accept broad Cheap Consumer Electronics, China wholesale Electronics go!: Like Cheap Unlocked Cell Phones, Hiphone, MP3 Players, MP4 Players, MP5 Players, Computer Accessories, Car Electronics, Bluetooth Products, USB Flash Drive, Memory Cards, Health & Beauty, iPod & iPhone Accessories, Digital Photo Frames,Car Audios, Car DVD Players, Digital Cameras, Digital Camcorders, Video Game Accessories, Spy Cameras, Security Products and Electronic Gadgets from China. We accept over 2500 accomplished and accomplished advisers and our accessories of 7,300 aboveboard meters are able with avant-garde productions and testing machines. We accept the absolute superior ascendancy arrangement and strive to accommodated and beat our customer's expectations,wholesale electronics. Do you find mbt lami shoes for a long time. Here is the richest in the world and you can find your needs bring you harvest. yes, http://www.mbtsonsale.com [HTML_REMOVED]mbt lami shoes[HTML_REMOVED] Purple Shoes is the first physiological footwear that has a positive effect on the whole body. [HTML_REMOVED]buy mbt lami shoes[HTML_REMOVED] 's sole is curved, not flat. Anti-shoe is unstable, not stable. Swissmasai activates your muscles instead of undermining them. The [HTML_REMOVED]mbt lami shoes[HTML_REMOVED] Birch Shoes Chapa feature feature rich nubuck leather with single-layer mesh upper bodies for strong but breathable wear,[HTML_REMOVED]mbt lami[HTML_REMOVED].