@prefix dcterms: <http://purl.org/dc/terms/> .
@prefix edu: <https://knobit.org/def/> .
@prefix knobit: <https://knobit.org/id/knobit/> .
@prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> .
@prefix register: <https://knobit.org/id/register/> .
@prefix schema: <https://schema.org/> .
@prefix skos: <http://www.w3.org/2004/02/skos/core#> .

knobit:K-824 a edu:Knobit ;
    rdfs:label "Recognises an environment baked into the script"@en ;
    dcterms:identifier "K-824" ;
    dcterms:license <https://creativecommons.org/licenses/by/4.0/> ;
    dcterms:source "Review checklist 05-ddl, row 24; Humble & Farley 2010; this skill (08-ddl.md)"@en ;
    skos:altLabel "Environment baked into the script (generated DDL)"@en ;
    skos:definition "A schema or database name hard-wired so the reviewed artefact cannot build dev, test and production — which ends in somebody editing the SQL per environment, and so in row 1. Also the generator's warning that `model-config.yaml` and the model disagree about the schema."@en ;
    skos:prefLabel "Recognises an environment baked into the script"@en ;
    edu:actionVerb "Recognises"@en ;
    edu:appliesKnowledge knobit:K-858 ;
    edu:assessmentCriterion "Flags the deficient case and passes the acceptable one. Deficient: `schema: rpdm_dev` in the model; the production deploy is the same file with a `sed` in the pipeline, and the staging deploy is a copy somebody kept Acceptable: `schema: rpdm` in the model, with the environment supplied at generation time via `--schema`/`--database` or at deploy time by the session's search path; and the config/model disagreement warning closed rather than carried"@en ;
    edu:assessmentMethod "skill-tests task: Generated DDL review, Postgres and Snowflake (DDL review skills)"@en ;
    edu:contextFunction <https://knobit.org/def/contextFunction/resultEvaluation> ;
    edu:creationMethod <https://knobit.org/def/creationMethod/aiGeneratedHumanEdited> ;
    edu:expectedResult "The name and the configuration replacing it"@en ;
    edu:graphRelevance <https://knobit.org/def/graphRelevance/learnerState>,
        <https://knobit.org/def/graphRelevance/taskSelection> ;
    edu:knobitType <https://knobit.org/def/knobitType/skill> ;
    edu:targetObject "hard-wired schema or database name"@en ;
    schema:creativeWorkStatus "accepted" ;
    schema:isPartOf register:data-modelling .

edu:Knobit rdfs:label "Knobit"@en,
        "Knobit"@et .

knobit:K-858 rdfs:label "Explains environment-independent deployment"@en .