如何运行sqlacodegen? [英] How to run sqlacodegen?

问题描述

我不明白为什么我不能运行sqlacodegen.我希望将其用于从现有PostgreSQL数据库创建SQLAlchemy模型.它不会运行.

I'm not understanding why I can't run sqlacodegen. I'm looking to use it for create a SQLAlchemy model from my existing PostgreSQL database. It won't run.

当我键入sqlacodegen --help寻求帮助时，会得到:

When I type sqlacodegen --help for help I get:

Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
TypeError: bad operand type for unary -: '_Helper'

基本说明位于此处.

推荐答案

这是因为您是在Python shell中完成的:

It is because you did this in Python shell:

>>> import sqlacodegen
>>> sqlacodegen --help
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
TypeError: bad operand type for unary -: '_Helper'

您应该已经在 Unix命令shell/Windows命令提示符中执行了sqlacodegen --help:

You should have executed sqlacodegen --help in your Unix command shell / Windows command prompt:

% sqlacodegen --help
usage: sqlacodegen [-h] [--version] [--schema SCHEMA] [--tables TABLES]
                   [--noviews] [--noindexes] [--noconstraints] [--nojoined]
                   [--noinflect] [--outfile OUTFILE]
                   [url]

Generates SQLAlchemy model code from an existing database.

positional arguments:
  url                SQLAlchemy url to the database

optional arguments:
  -h, --help         show this help message and exit
  --version          print the version number and exit
  --schema SCHEMA    load tables from an alternate schema
  --tables TABLES    tables to process (comma-separated, default: all)
  --noviews          ignore views
  --noindexes        ignore indexes
  --noconstraints    ignore constraints
  --nojoined         don't autodetect joined table inheritance
  --noinflect        don't try to convert tables names to singular form
  --outfile OUTFILE  file to write output to (default: stdout)

然后是实际命令的示例:

An example of the actual command would then be:

% sqlacodegen --outfile models.py \
postgresql://gollyjer:swordfish@localhost:5432/mydatabase

其中gollyjer:swordfish是您的凭据，格式为user:password.

Where gollyjer:swordfish are your credentials in the format user:password.

这篇关于如何运行sqlacodegen?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！