Re: [sqlite] dynamic bulk import

2012-09-23 Thread Elefterios Stamatogiannakis
You could do it by creating a virtual table that parses the file and gives back rows to sqlite. For example in madIS we have implemented the "file" virtual table: http://doc.madis.googlecode.com/hg/vtable.html#module-functions.vtable.file that can present as a table (columns are deduced automa

Re: [sqlite] dynamic bulk import

2012-09-22 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 22/09/12 13:41, Keith Medcalf wrote: > Take a look at the apsw (Another Python SQLite Wrapper) shell which has > an .autoimport command that may do what you want. Thanks for pointing out APSW (I'm the author). It is only necessary to use the APSW

Re: [sqlite] dynamic bulk import

2012-09-22 Thread Keith Medcalf
gt; To: General Discussion of SQLite Database > Subject: [sqlite] dynamic bulk import > > Hi is there way of doing a dynamic file import into sqlite without > specifying the table fields. Just specifying the target (temporary?) table > so columns or fileds are created dynamically. &g

[sqlite] dynamic bulk import

2012-09-22 Thread Sébastien Roux
Hi is there way of doing a dynamic file import into sqlite without specifying the table fields. Just specifying the target (temporary?) table so columns or fileds are created dynamically. If this cannot be done with cmdline interface maybe using perl amodules (DBD, DBI)? Many thanks for any help