Skip to main content
Warning: You are using the test version of PyPI. This is a pre-production deployment of Warehouse. Changes made here affect the production instance of TestPyPI (testpypi.python.org).
Help us improve Python packaging - Donate today!

Handle Folder with CSV Files like SQLite Database

Project Description

FlatQL is a small tool for working on CSV files in a directory as it was an SQLite database containing the files tables.

Intro

FlatQL ist meant to be a small tool to work on a CSV textfile based, persistent database.

It is small and simple and in some way stupid. It does not correct errors in the CSV files or anything else. If it`s wrong it will print an error.

It is also not ment to be fast! If you need a fast database, textbased databases are probably not what you are looking for.

How it works

Usage

usage: flatql.py [-h] [-p PATH] [-q QUERY]

Execute SQL-Queries on a Folder containing CSV Files

optional arguments:
  -h, --help            show this help message and exit
  -p PATH, --path PATH  Database Directory Path
  -q QUERY, --query QUERY
                        Semicolon separated SQLite Queries. None gives you an
                        SQLite Terminal

What it does

FlatQL creates an SQLite database in the memory and reads all files with suffix csv in a table in this database. The content of the file foobar.csv will be put in the table foobar. Once the tables are created you can query the table in the usual manner.

There are two modes:

  • Interactive Mode
  • Commandline Argment Mode

If you ommit the commandline argument -q/--query an interactive shell will pop up. Here you can issue SQL queries. If you give the argument -q/--query, e.g. -q "SELECT * FROM foo_table" or -q "DELETE FROM foo_table WHERE bar = 5" it will modify the table or output the result of the query.

Release History

Release History

This version
History Node

0.0.1

Download Files

Download Files

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

File Name & Checksum SHA256 Checksum Help Version File Type Upload Date
flatql-0.0.1.tar.gz (4.0 kB) Copy SHA256 Checksum SHA256 Source Apr 13, 2014

Supported By

WebFaction WebFaction Technical Writing Elastic Elastic Search Pingdom Pingdom Monitoring Dyn Dyn DNS Sentry Sentry Error Logging CloudAMQP CloudAMQP RabbitMQ Heroku Heroku PaaS Kabu Creative Kabu Creative UX & Design Fastly Fastly CDN DigiCert DigiCert EV Certificate Rackspace Rackspace Cloud Servers DreamHost DreamHost Log Hosting