from pybitable import Connection, ConnectionPool
db_url = 'bitable+pybitable://<app_id>:<app_secret>@open.feishu.cn/<app_token>'
# 支持使用personal_base_token访问多维表格,这里建议使用后面一种写法,sqlalchemy打印日志的时候,会将personal_base_token当成密码显示星号
db_url = 'bitable+pybitable://<personal_base_token>@open.feishu.cn/<app_token>'
db_url = 'bitable+pybitable://:<personal_base_token>@open.feishu.cn/<app_token>'
conn_pool = ConnectionPool(
maxsize=10,
connection_factory=lambda: Connection(db_url),
)
with conn_pool.connect() as connection:
print('connect', connection)
cursor = connection.cursor()
result = cursor.execute('select * from tbl2w2QJgo6YCthm')
cursor.close()
pip install pybitable[cli]
pybitable -h base-api.feishu.cn -p <personal_base_token> <app_token>
pybitable -h open.feishu.cn -u <app_id> -p <app_secret> <app_token>
pybitable bitable+pybitable://<app_id>:<app_secret>@open.feishu.cn/<app_token>
pybitable bitable+pybitable://:<personal_base_token>@base-api.feishu.cn/<app_token>
pip install pybitable[sqlalchemy]
from sqlalchemy import create_engine, Column, String, Text, text
from sqlalchemy.orm import sessionmaker, declarative_base
engine = create_engine(db_url, echo=False)
Session = sessionmaker(engine)
with engine.connect() as conn:
result = conn.execute(
text("select `文本` as a from tblID0QbOnjktwdC")
)
for row in result:
print(f"{row}")
Base = declarative_base()
class BITable1(Base):
__tablename__ = 'tblID0QbOnjktwdC'
record_id = Column(String(32), primary_key=True)
文本 = Column(Text, nullable=True, server_default=text("''"), comment="文本")
单选 = Column(String(32), nullable=True, server_default=text("''"), comment="单选")
多选 = Column(Text, nullable=True, server_default=text("''"), comment="多选")
with Session.begin() as session:
for item in session.query(BITable1).all():
print('record_id: ', item.record_id, '文本: ', item.文本, '单选', item.单选, '多选', item.多选)
print('engine', engine, BITable1)