How to convert sqlite format to CSV format?

0 votes

Hi everyone,

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

Thank You

6 days ago in Python by akhtar
• 1,440 points
40 views

1 answer to this question.

0 votes

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!'

 
answered 6 days ago by MD
• 2,750 points

Related Questions In Python

+1 vote
1 answer

how to convert json to csv or to store in sql

You can convert JSON data to csv ...READ MORE

answered Jul 2, 2018 in Python by Nietzsche's daemon
• 4,260 points
191 views
0 votes
1 answer

How can I convert JSON to CSV?

I am not sure this question is ...READ MORE

answered Oct 1, 2018 in Python by Aryya
• 7,350 points
4,760 views
+1 vote
1 answer

How to convert records from csv to a list in Python?

If you are using Python 3.x then ...READ MORE

answered Jun 25, 2019 in Python by Arvind
• 2,980 points

edited Jun 26, 2019 by Kalgi 89 views
+1 vote
1 answer

Python: convert txt file to csv format with rows and columns

This code should work. You have to ...READ MORE

answered Aug 1, 2019 in Python by Ashish
5,346 views
0 votes
1 answer

how to convert date field into UTC format (2019-10-29T19:20:30.45Z)

Hey, I think this should do what ...READ MORE

answered Oct 29, 2019 in Python by Niharika
270 views
+1 vote
1 answer

Python: How to convert text to csv rows separated by a record separator?

Hi @Sumanth, try something like this: import csv with ...READ MORE

answered Dec 17, 2019 in Python by Pri
210 views
0 votes
0 answers

How can we use sqlite with WAL?

Can you give an example? READ MORE

May 29, 2019 in Python by Waseem
• 4,520 points

edited May 30, 2019 by Omkar 42 views
0 votes
0 answers

What is the use of cursor while querying a sqlite database?

I am completely new to sqlite, and ...READ MORE

Jul 4, 2019 in Python by Waseem
• 4,520 points
18 views
0 votes
1 answer

How to install python-poster in RedHat?

Hi@akhtar, To install python-poster in RedHat/CentOs, you can ...READ MORE

answered 6 days ago in Linux Administration by MD
• 2,750 points
16 views
0 votes
1 answer