擅长:python、mysql、java
<pre><code>from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import (Column, Index, Date, DateTime, Numeric, BigInteger, String, ForeignKey, Boolean)
Base = declarative_base()
class Project(Base):
"""sqlalchemy ORM for my table."""
__tablename__ = "table1"
id = Column("id", BigIntegerID, primary_key=True, autoincrement=True)
date = Column("date", Date, nullable=False)
value = Column("value", Numeric(20, 8))
...
...
</code></pre>
<p>然后返回列名['id','date','value',…]:</p>
<pre><code>Project.__table__.columns.keys()
</code></pre>
<p>或者这个</p>
<pre><code>Project.metadata.tables['table1'].columns.keys()
</code></pre>