查看: 65|回复: 0

Introducing Records: just write SQL (from the author of python's requests)

发表于 2017-8-26 08:00:00

来自: https://github.com/kennethreitz/records

Records: SQL for Humans?

Records is a very simple, but powerful, library for making raw SQL queries to Postgres databases.

This common task can be surprisingly difficult with the standard tools available. This library strives to make this workflow as simple as possible, while providing an elegant interface to work with your query results.

We know how to write SQL, so let's send some to our database:

  1. import records
  2. db = records.Database('postgres://...')
  3. rows = db.query('select * from active_users') # or db.query_file('sqls/active-users.sql')
复制代码
? The Basics

Rows are represented as standard Python dictionaries: {'column-name': 'value'} .

Grab one row at a time:

  1. >>> rows.next()
  2. {'username': 'hansolo', 'name': 'Henry Ford', 'active': True, 'timezone': datetime.datetime(2016, 2, 6, 22, 28, 23, 894202), 'user_email': 'hansolo@gmail.com'}
复制代码

Or iterate over them:

  1. for row in rows:
  2. spam_user(name=row['name'], email=row['user_email'])
复制代码

Or store them all for later reference:

  1. >>> rows.all()
  2. [{'username': ...}, {'username': ...}, {'username': ...}, ...]
复制代码
? Features HSTORE support, if available. Iterated rows are cached for future reference. $DATABASE_URL environment variable support. Convenience Database.get_table_names method. Safe parameterization : Database.query('life=%s', params=('42',)) Queries can be passed as strings or filenames, parameters supported. Query results are iterators of standard Python dictionaries: {'column-name': 'value'}

Records is proudly powered by Psycopg2 and Tablib .

? Data Export Functionality

Records also features full Tablib integration, and allows you to export your results to CSV, XLS, JSON, HTML Tables, or YAML with a single line of code. Excellent for sharing data with friends, or generating reports.

  1. >>> print rows.dataset
  2. username|active|name |user_email |timezone
  3. --------|------|----------|-----------------|--------------------------
  4. hansolo |True |Henry Ford|hansolo@gmail.com|2016-02-06 22:28:23.894202
  5. ...
复制代码
CSV
  1. >>> print rows.dataset.csv
  2. username,active,name,user_email,timezone
  3. hansolo,True,Henry Ford,hansolo@gmail.com,2016-02-06 22:28:23.894202
  4. ...
复制代码
YAML
  1. >>> print rows.dataset.yaml
  2. - {active: true, name: Henry Ford, timezone: '2016-02-06 22:28:23.894202', user_email: hansolo@gmail.com, username: hansolo}
  3. ...
复制代码
JSON
  1. >>> print rows.dataset.json
  2. [{"username": "hansolo", "active": true, "name": "Henry Ford", "user_email": "hansolo@gmail.com", "timezone": "2016-02-06 22:28:23.894202"}, ...]
复制代码
Excel (xls, xlsx)
  1. with open('report.xls', 'wb') as f:
  2. f.write(rows.dataset.xls)
复制代码

You get the point. Of course, all other features of Tablib are also available, so you can sort results, add/remove columns/rows, remove duplicates, tranpose the table, add separators, slice data by column, and more.

See the Tablib Documentation for more details.

? Installation

Of course, the recommended installation method is pip:

  1. $ pip install records
  2. :sparkles::cake::sparkles:
复制代码
? Thank You

Thanks for checking this library out! I hope you find it useful.

Of course, there's always room for improvement. Feel free toopen an issue so we can make Records better, stronger, faster.

扩展阅读程序员瑞典最大的约会网站的开发测试经验
Python开源框架、类库、软件集合
Python框架、库和软件资源大全
可以编译为Javascript的语言列表大全
Go语言框架,类库,软件汇总:awesome-go
为您推荐Laravel大型项目系列教程
史上最全 前端开发面试问题及答案整理
web安全实战
HTML5环形音乐播放器
基于Html5的网页大头贴
更多SQL
Python


回复

使用道具 举报