blob: 4e102c37b3abf8e6d32dd9bc807b442a609f99e1 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
|
#!/bin/sh
[ "$1" = python3-sqlalchemy ] || exit 0
python3 - << 'EOF'
import sqlalchemy
assert sqlalchemy.__version__, "sqlalchemy version is empty"
from sqlalchemy import create_engine, Column, Integer, String, text
from sqlalchemy.orm import DeclarativeBase, Session
engine = create_engine("sqlite:///:memory:")
class Base(DeclarativeBase):
pass
class User(Base):
__tablename__ = "users"
id = Column(Integer, primary_key=True)
name = Column(String)
Base.metadata.create_all(engine)
with Session(engine) as session:
session.add(User(name="Alice"))
session.add(User(name="Bob"))
session.commit()
users = session.query(User).order_by(User.name).all()
assert len(users) == 2
assert users[0].name == "Alice"
assert users[1].name == "Bob"
with engine.connect() as conn:
result = conn.execute(text("SELECT count(*) FROM users"))
count = result.scalar()
assert count == 2, f"Expected 2, got {count}"
EOF
|
