We need to make sure that new cities get inserted if someone adds a tree within a city that has no previous trees, trigger and insertion function or node logic

Repository metrics

Stars

0 stars (0 stars)

PR merge metrics

PR metrics pending (PR metrics pending)

Description

Contributor guide

Research direction

Explore how tree insertion currently works, identify the city table structure, and implement a database trigger or application level logic to insert a new city row if it doesn't exist when a tree is added in that city.

Tech stack

javascriptnodejsexpresspostgresql

Domain

backend

Issue type

Feature

DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.

3

Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.

Half day

Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.

Fresh

ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.

Clear

Prerequisites

Node.jsPostgreSQL

Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.

60