How to convert sqlite format to CSV format

Question

Hi everyone,

 I tried to read a SQLile format file. How can I convert SQLite format to CSV format?

Thank You

Answer 1

Hi@akhtar,

If you want to read SQLite format with python language, then you have to install python-poster.

$ yum install python-poster

Then use the below code and run the file.

from poster.encode import multipart_encode
from poster.streaminghttp import register_openers
import urllib2
register_openers()
datagen, headers = multipart_encode({ 'files[]': open('sqlite file', 'rb')})
request = urllib2.Request('https://www.rebasedata.com/api/v1/convert', datagen, headers)
response = urllib2.urlopen(request)
if response.info().getheader('Content-Type') == 'application/json':
    print response.read()
    sys.exit(1)
with open('/tmp/result.zip', 'wb') as local_file:
    local_file.write(response.read())
print 'Conversion result successfully written to /tmp/result.zip!'