Maybe it's worth to make a version for the terminal?

[kennethreitz]

Maybe it's worth to make a version for the terminal?

[dorosch]

Well, you know like this

$ records --path ~/bd/test.sql --formar csv

and is ready, the table in the desired format

[dorosch]

and make exports from the file into the table

$ records export --path ~/test.csv
user: ...
password: ...
in which database: ...
table name: ...

result export: OK

[kennethreitz]

I like this idea, very much!

[kennethreitz]

Print results out to console:
$ records myquery.sql

Print results as JSON out to console:
$ records myquery.sql json

Add parameters (for parameterized queries):
$ records myquery.sql --params 'Python|Ruby'

Export functionality:
$ records myquery.sql csv > data.csv

[dorosch]

what do you mean (language=python) ?

$ records myquery.sql language=python

[kennethreitz]

@andrew-tifon language is a parameter to the query.

[dorosch]

It's param=None ?
Database.query(query, param=None ...)

[kennethreitz]

@andrew-tifon updated my example :)

[kennethreitz]

Okay, I worked on this last night. Got the help string down with usage/etc.

Records: SQL for Humans™
A Kenneth Reitz project.

Usage:
  records <query> [<format>] [--url=<url>] [--params <params>...]
  records (-h | --help)

Options:
  -h --help    Show this screen.
  --url=<url>  The database URL to use. Defaults to $DATABASE_URL.
  --params     Prameterized query. Subsequent arguments are treated as
               parameters to the query.

Supported Formats:
   csv, tsv, json, yaml, html, xls, xlsx, dbf, latex, ods

   Note: xls, xlsx, dbf, and ods formats are binary, and should only be
         used with piped output e.g. '$ records sql xls > sql.xls'.

Notes:
  - While you may specify a Postgres connection string with --url, records
    will automatically default to the value of $DATABASE_URL, if available.
  - Query is intended to be the path of a SQL file, however a query string
    can be provided instead. Use this feature discernfully; it's dangerous.
  - Records is intended for report-style exports of database queries, and
    has not yet been optimized for extremely large data dumps.

Cake:
   ✨ 🍰 ✨

[kennethreitz]

Relased!