Completly untested: #!/usr/bin/env python
import sys, datetime
user = sys.argv[1]
starttime = None
for l in sys.stdin:
flds = l.strip().split()
datestr, timestr, prog, op, to, sname = flds
month, day, year = [int(x) for x in datestr.split("-", 2)]
hour, min, sec, ms = [int(x) for x in timestr.split(":")]
timestamp = datetime.datetime(year, month, day, hour, min, sec)
if op == 'CONNECTED':
assert starttime is None
starttime = timestamp
elif op == 'DISCONNECTED':
assert starttime is not None
endtime = timestamp
sql = "insert into data (start, end, user) value (%r, %r, %r);"
print sql % (starttime, endtime, user)
else:
raise AssertationError("%r is not a valid line" % l)
Am Sonntag, den 14.08.2005, 07:31 -0700 schrieb CG:
> Thanks Andreas,
>
> In your first paragraph, you ask about incorrect input. I guess it is
> possible, but without that information, my collection of the data is
> useless, so I really don't know what I would do with that.
>
> As for the other stuff, I can hack the data in other ways, such as with
> VBA and MSAccess, which I am more familiar with, but I am trying to
> move to Linux and want to do it right the first time. I figure Perl is
> the more common language for this kind of stuff, but I did want to try
> to learn some Python while I am at it. I have started the tutorial,
> but being a businessman, time is an issue, which, if I had an example
> script that did a similar thing, I can learn by doing that (I am
> looking for something similar now).
>
> I do live in a low-labor cost country, so I can hire someone to do it
> for a small amount of money, but Python people are a little harder to
> find.
>
> Thanks for the comments,
> Clint
>
signature.asc
Description: Dies ist ein digital signierter Nachrichtenteil
-- http://mail.python.org/mailman/listinfo/python-list
