Skip to main content

Write to multiple databases and formats easily from python

Project description

Description

This project is useful in any scenario where you need to write some data in a readable manner quickly and easily.

It can be used to write to:

  • csv
  • sqlite
  • mysql
  • redis
  • mongo
  • postgres
  • aerospike

Look at https://pypi.python.org/pypi/data-readers/ to write to them. This library was written with the intention to be useful without data-readers but they work very well together.

Setup

Install

pip install data-writers

Usage

Import DataWriter

from datawriters.datawriter import DataWriter

Create a list of dictionaries for your data:

data = [{“column1”:”row1-item1”, “column2”:”row1-item2”}, {“column1”:”row2-item1”, “column2”:”row2-item2”}, {“column1”:”row3-item1”, “column2”:”row3-item2”}]

csv

DataWriter(writer=’csv’, database=’data.csv’).save(data)

sqlite

DataWriter(writer=’sqlite’, database=’data.sqlite’, table=’DataTable’).save(data)

mysql

DataWriter(writer=’mysql’, database=’data’, user=’root’, table=’DataTable’).save(data)

redis

DataWriter(writer=’redis’, database=‘1’).save(data)

mongo

DataWriter(writer=’mongo’, database=’data’, table=’DataTable’).save(data)

postgres

DataWriter(writer=’postgres’, database=’data’, table=’DataTable’).save(data)

aerospike

DataWriter(writer=’aerospike’, namespace=’data’, set=’DataTable’).save(data)

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Filename, size & hash SHA256 hash help File type Python version Upload date
data-writers-0.5.3.zip (14.8 kB) Copy SHA256 hash SHA256 Source None Aug 6, 2015

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page