Chandra I can't help, perhaps a sample of the code. I only use SQLite with SQL Alchemy <http://www.sqlalchemy.org>. It can make these issues a little simpler by improving the api.
For some samples check out https://github.com/miguelgrinberg/flasky. In particular https://github.com/miguelgrinberg/flasky/blob/master/app/models.py for the Models, and https://github.com/miguelgrinberg/flasky/blob/master/app/main/views.py for the samples on how these Models are inserted. The app uses alembic <https://www.google.com.au/url?sa=t&rct=j&q=&esrc=s&source=web&cd=2&cad=rja&uact=8&ved=0CCcQFjAB&url=https%3A%2F%2Falembic.readthedocs.org%2F&ei=RKOMVbPUNaLemAXV_4Eg&usg=AFQjCNHRkjr2TRmhkfSA0dFcB4j_IXjG2w&bvm=bv.96782255,d.dGY>migrations to create the database tables from the models file so setting up / running takes a few more steps. Regards Dave David +61 3 9036 2788 On 26 June 2015 at 10:45, AMARASINGHAM, Chandra < [email protected]> wrote: > Hi All, > > > > I am doing exploratory work in sqlite3. I can't seem to store dates in a > table when importing from a csv. It seems to store it as a text file, even > when I specify type affinity as date when creating the table. > > > > Any comments? > > > > Sorry a bit off topic, but I hope to process the sqlite3 db in > python......and sqlite3 and python seem to go together. > > > > Regards, > > Chandra > > > *Chandra Amarasingham* > Analyst Programmer > Specialist Diagnostic Services Pty Ltd > 17 Enterprise Grove, Mt Helen, 3350 > Federation University Technology Park > > T: (03) 5330 1056 ext 212 > > This email (including any attachments) is intended only for the > addressee. It may contain confidential or legally privileged information. > Confidentiality and privilege are not waived or lost if you are not the > intended recipient of this email, nor may you use, review, disclose, > disseminate or copy any information contained in or attached to it. If you > receive this email in error, please delete it and any attachments from your > system and notify us immediately. It is your responsibility to check this > email and any attachments, before opening or using them, for viruses or > defects. You assume all liability arising from opening or using this email > and any attachment. > > _______________________________________________ > melbourne-pug mailing list > [email protected] > https://mail.python.org/mailman/listinfo/melbourne-pug > >
_______________________________________________ melbourne-pug mailing list [email protected] https://mail.python.org/mailman/listinfo/melbourne-pug
