datetime.fromst r() - how?

[Martin Bless]

Below is what I'm currently using to construct datatime objects from
strings. Date and time objects are made up similar. To and from string
conversions are frequently needed in SQL neighborhood.

(1) Is there reason enough to ask for a 'datetime.froms tr(...)'
method? At least to convert ISO timestamps?

(2) You've got a better/different idea? Glad to see. Don't let me die
with this open question ... ;-)

mb - Martin
import datetime,time

class mysql_date(date time.date):
"Represent and convert 'YYYY-MM-DD'-like date values."

def fromstr(Cls,s,f ='%Y-%m-%d'):
try:
return Cls(*time.strpt ime(s,f)[:3])
except:
return None
fromstr = classmethod(fro mstr)

dt = mysql_date.from str('2004-07-20')
print repr(dt)
print dt

""" should print:
mysql_date(2004 , 7, 20)
2004-07-20
"""

[Jeff Sandys]

Martin Bless wrote:

Below is what I'm currently using to construct datatime objects from
strings. Date and time objects are made up similar. To and from string
conversions are frequently needed in SQL neighborhood.

(1) Is there reason enough to ask for a 'datetime.froms tr(...)'
method? At least to convert ISO timestamps? Does this help?
http://www.python.org/cgi-bin/moinmoin/WorkingWithTime

(2) You've got a better/different idea? Glad to see. Don't let me die
with this open question ... ;-)

mb - Martin

import datetime,time

class mysql_date(date time.date):
"Represent and convert 'YYYY-MM-DD'-like date values."

def fromstr(Cls,s,f ='%Y-%m-%d'):
try:
return Cls(*time.strpt ime(s,f)[:3])
except:
return None
fromstr = classmethod(fro mstr)

dt = mysql_date.from str('2004-07-20')
print repr(dt)
print dt

""" should print:
mysql_date(2004 , 7, 20)
2004-07-20
"""

[Dan Bishop]

m.*****@gmx.de (Martin Bless) wrote in message news:<40******* ********@news.v ersatel.de>...

Below is what I'm currently using to construct datatime objects from
strings. Date and time objects are made up similar. To and from string
conversions are frequently needed in SQL neighborhood.

(1) Is there reason enough to ask for a 'datetime.froms tr(...)'
method? At least to convert ISO timestamps?

(2) You've got a better/different idea? Glad to see. Don't let me die
with this open question ... ;-)

import datetime
def strToDate(ymd):
return datetime.date(* map(int, ymd.split('-')))

[Martin Bless]

Dan Bishop <> wrote in
<ad************ **************@ posting.google. com>:

import datetime
def strToDate(ymd):
return datetime.date(* map(int, ymd.split('-')))

Yes, thanks, I like your solution better. This way I don't have to use
'time' as a second module. For those interested, here's what I'm using
now.

It's a pity the 'datetime' module lacks 'time.strptime( )'
functionality. In contrast it does provide 'strftime()' methods.

mb - Martin
# date,time,datet ime,timestamp handling for MySQLdb
# independant from mxdate

class mysql_date(date time.date):
"Represent and convert 'YYYY-MM-DD'-like date values."

def fromstr(Cls,s):
try:
return Cls(*map(int,s. split('-'))[:3])
except:
return None
fromstr = classmethod(fro mstr)

class mysql_time(date time.time):
"Represent and convert 'HH:MM:SS'-like time values."

def fromstr(Cls,s):
"Construct instance from string."
try:
return Cls(*map(int,s. split(':'))[:3])
except:
return None
fromstr = classmethod(fro mstr)

class mysql_datetime( datetime.dateti me):
"Represent and convert 'YYYY-MM-DD HH:MM:SS'-like datetime
values."

def fromstr(Cls,s):
"Initialize instance from string."
try:
return Cls(*map(int,s. replace('-',' ').replace(':', '
').split())[:6])
except:
return None
fromstr = classmethod(fro mstr)

class mysql_timestamp (datetime.datet ime):
"Represent and convert 'YYYYMMDDHHMMSS '-like timestamp values."

def fromstr(Cls,s,f ='%Y%m%d%H%M%S' ):
"Initialize instance from string."
try:
return
Cls(*map(int,[s[0:4],s[4:6],s[6:8],s[8:10],s[10:12],s[12:14]]))
except:
return None
fromstr = classmethod(fro mstr)

def __str__(self):
return self.strftime(' %Y%m%d%H%M%S')

myconv = MySQLdb.convert ers.conversions .copy()
myconv.update({
FIELD_TYPE.TIME STAMP : mysql_timestamp .fromstr,
FIELD_TYPE.DATE TIME : mysql_datetime. fromstr,
FIELD_TYPE.DATE : mysql_date.from str,
FIELD_TYPE.TIME : mysql_time.from str,
})