This allows to use the CSV as ORM.
pip install csvorm
layout define:
from csvorm import (
Model,
Column,
Integer,
Unicode,
DateTime,
)
class TestCSV(Model):
_encoding_ = 'cp932'
id_ = Column(Integer)
name = Column(Unicode)
modified_at = Column(DateTime())
creating csv:
test_csv = TestCSV()
record = test_csv.create()
record.id_ = 1
record.name = u'first'
record.modified_at = datetime.datetime.now()
record = test_csv.create()
record.id_ = 2
record.name = u'second'
record.modified_at = datetime.datetime.now()
test_csv.dump('test.csv')
parse csv:
test_csv = TestCSV()
test_csv.load('test.csv')
export data:
id_,name,modified_at
1,first,2014-03-26-15-05-50
2,second,2014-03-26-15-05-50
Thank you for contributors.