PixeltablePixeltable Logo
Example apps

Plant Care

Houseplant care API that turns soil moisture and watering history into care advice via computed columns

Open in CodespacesView on GitHub

One app.py with 1 table, 3 computed columns, 4 HTTP routes. Needs pixeltable[serve]>=0.7.14. Updated 2026-09-26.

app.py
"""Plant Care API built with Pixeltable.


    pxt schema update app.py plants
    pxt service run app.py plants
"""
import pixeltable as pxt
import pixeltable.functions as pxtf
from pixeltable.serving import FastAPIRouter


from udfs import care_blurb, water_advice


# ---- tables ----
TableModel = pxt.model_base()




class Plants(TableModel, name='plants'):
    id = pxt.Column(value=pxtf.uuid.uuid7(), primary_key=True)
    species: pxt.String
    location: pxt.String
    moisture: pxt.String | None
    days_since_water: pxt.Int | None
    notes: pxt.String | None


    water_label = water_advice(moisture, days_since_water)
    species_upper = pxtf.string.upper(species)
    notes_blurb = care_blurb(species, location)




# ---- queries ----
@pxt.query
def thirsty():
    """Plants whose computed advice is 'water today'."""
    return Plants.where(Plants.water_label == 'water today').select(
        Plants.id, Plants.notes_blurb, Plants.days_since_water
    ).order_by(Plants.days_since_water, asc=False)




# ---- routes ----
plants_api = FastAPIRouter(name='plants_api')
plants_api.add_insert_route(
    Plants, path='/plants',
    inputs=[Plants.species, Plants.location, Plants.moisture, Plants.days_since_water, Plants.notes],
    outputs=[Plants.id, Plants.water_label, Plants.species_upper, Plants.notes_blurb],
)
plants_api.add_update_route(Plants, path='/plants/update', inputs=[Plants.moisture, Plants.days_since_water],
                            outputs=[Plants.id, Plants.water_label])
plants_api.add_compute_route(Plants, path='/water-label', inputs=[Plants.moisture, Plants.days_since_water],
                             outputs=[Plants.water_label])
plants_api.add_query_route(path='/plants/thirsty', query=thirsty, method='get')

What app.py declares

Each row links to its line.

  • runs on insert
  • stored
  • index
  • route
plantsL16
  1. idspecieslocationmoisturedays_since_waternotes
  2. water_label = water_advice(moisture, days_since_water)L24
  3. species_upper = pxtf.string.upper(species)L25
  4. notes_blurb = care_blurb(species, location)L26

serves plants_api

  1. POST/plantstakes species, location, moisture, days_since_water, notes; returns id, water_label, species_upper, notes_blurbL40
  2. POST/plants/updatetakes moisture, days_since_water; returns id, water_labelL45
  3. POST/water-labeltakes moisture, days_since_water; returns water_labelL47
  4. GET/plants/thirstyL49

Run it

Needs uv. The routes then answer on port 8000.

terminal
git clone https://github.com/pierrebrunelle/pixeltable-plant-care
cd pixeltable-plant-care
uv sync
uv run pxt schema update app.py plants
uv run python seed.py plants
uv run pxt service run app.py plants --port 8000

Related apps

All 29 example apps