PostgresSettings & ApiSettings

[diana0809]

from stac_fastapi.pgstac.config import PostgresSettings
from stac_fastapi.types.config import ApiSettings
I created the .env file that contains Postgres'configs and ApiSetings, as follows:

for postgres

POSTGRES_USER="username"
POSTGRES_PASS="password"
POSTGRES_HOST_READER="10.28.18.21"
POSTGRES_HOST_WRITER="10.28.18.21"
POSTGRES_PORT="5439"
POSTGRES_DBNAME="postgis"

for STAC API

STAC_API_TITLE="My STAC API"
STAC_API_DESCRIPTION="A STAC API powered by pgstac"
STAC_API_VERSION="1.0.0"

the code is as follows:

load_dotenv()
api = StacApi(
app=app,
client=CoreCrudClient(),
settings=settings,
extensions=[
QueryExtension()
]
)

How to use PostgresSettings and ApiSetings

[vincentsarago]

@diana0809 please be more descriptive about what you're trying to achieve or what result you're expecting

[diana0809]

request：http://localhost:8000/collections
response：{"code":"AttributeError","description":"'State' object has no attribute 'get_connection'"}

python code

load_dotenv()
settings = ApiSettings()
app = FastAPI()
api = StacApi(
app=app,
client=CoreCrudClient(),
settings=settings,
extensions=[
QueryExtension()
]
)

[vincentsarago]

you need to register the database connection pool to the application state using lifespan

stac-fastapi-pgstac/stac_fastapi/pgstac/app.py

Lines 155 to 160 in 4ce9075

	@asynccontextmanager
	async def lifespan(app: FastAPI):
	"""FastAPI Lifespan."""
	await connect_to_db(app)
	yield
	await close_db_connection(app)

stac-fastapi-pgstac/stac_fastapi/pgstac/app.py

Line 172 in 4ce9075

lifespan=lifespan,

[diana0809]

I want to connect the postgresql. when I write the database'name 、user and password to the .env file，error occured.  StacApi ' settings is also in the .env file. I don't know that these settings should be used.发自我的荣耀手机-------- 原始邮件 --------发件人： Vincent Sarago ***@***.***>日期： 2025年4月23日周三 傍晚5:46收件人： stac-utils/stac-fastapi-pgstac ***@***.***>抄送： Diana ***@***.***>, Mention ***@***.***>主 题： Re: [stac-utils/stac-fastapi-pgstac] PostgresSettings & ApiSettings (Discussion #233) @diana0809 please be more descriptive about what you're trying to achieve or what result you're expecting —Reply to this email directly, view it on GitHub, or unsubscribe.You are receiving this because you were mentioned.Message ID: ***@***.***>

[hrodmn]

Did you try running the default application defined in stac_fastapi/pgstac/app.py? From your local environment with that .env file set up you should be able to run uvicorn stac_fastapi.pgstac.app:app --host 0.0.0.0 --port 8080.

You can also run it in the docker network with docker compose up.

[diana0809]

docker compose up
services.app: container name "stac-fastapi-pgstac" is already in use by service {}"
when I change the container name to "my-stac-fastapi-pgstac", the problem is still exists.
cp docker-compose.yml docker-compose.yml.bak
[root@localhost stac-fastapi-pgstac]# vi docker-compose.yml
[root@localhost stac-fastapi-pgstac]# docker compose up
services.app: container name "my-stac-fastapi-pgstac" is already in use by service {}"
run docker ps -a | grep "stac", nothing happened