[Tools-discuss] Advice on DT schema changes

"Salz, Rich" <rsalz@akamai.com> Sun, 17 November 2019 07:35 UTC

Return-Path: <rsalz@akamai.com>
X-Original-To: tools-discuss@ietfa.amsl.com
Delivered-To: tools-discuss@ietfa.amsl.com
Received: from localhost (localhost []) by ietfa.amsl.com (Postfix) with ESMTP id 35A0E120098 for <tools-discuss@ietfa.amsl.com>; Sat, 16 Nov 2019 23:35:29 -0800 (PST)
X-Quarantine-ID: <gYYjyZGxzGy8>
X-Virus-Scanned: amavisd-new at amsl.com
X-Amavis-Alert: BANNED, message contains text/x-python-script,.exe,data-changes.py
X-Spam-Flag: NO
X-Spam-Score: -2.699
X-Spam-Status: No, score=-2.699 tagged_above=-999 required=5 tests=[BAYES_00=-1.9, DKIMWL_WL_HIGH=-0.001, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_LOW=-0.7, SPF_HELO_NONE=0.001, SPF_PASS=-0.001, URIBL_BLOCKED=0.001] autolearn=ham autolearn_force=no
Authentication-Results: ietfa.amsl.com (amavisd-new); dkim=pass (2048-bit key) header.d=akamai.com
Received: from mail.ietf.org ([]) by localhost (ietfa.amsl.com []) (amavisd-new, port 10024) with ESMTP id gYYjyZGxzGy8 for <tools-discuss@ietfa.amsl.com>; Sat, 16 Nov 2019 23:35:27 -0800 (PST)
Received: from mx0b-00190b01.pphosted.com (mx0b-00190b01.pphosted.com [IPv6:2620:100:9005:57f::1]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by ietfa.amsl.com (Postfix) with ESMTPS id D452F120033 for <tools-discuss@ietf.org>; Sat, 16 Nov 2019 23:35:26 -0800 (PST)
Received: from pps.filterd (m0122330.ppops.net []) by mx0b-00190b01.pphosted.com ( with SMTP id xAH7YLao009657 for <tools-discuss@ietf.org>; Sun, 17 Nov 2019 07:35:24 GMT
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=akamai.com; h=from : to : subject : date : message-id : content-type : mime-version; s=jan2016.eng; bh=9zNyizusE6PvdQTjmuYeGuaYiB25ivGnUWe2sqjY9bU=; b=Cc58qMR+QEg4Rs5lV1C+7UI7fg063TJidFixO2oODogqdaXCwTNhVcJW4jyibdTi3dZw VhbewAOAZpiog7FmaB68qT5QZmWwHpKeIU8iFO0oPhs0RrVO38opTeZ4ufoZMuGAoS9O 7O1SGiybzZY5fn04K9PqVk6WGspPER84IAgby3+tdLrukruk7AMfes5Qx8PCFBE81cHg uk2Fn1Pq3059G4wOpPf2QRhtxY1mQ1flkLX+aJF9oTgY3TWjlw8E8jby7SRSEpo/h5hf Ax7oTXGuGSjIKqOGTvxuDEYWp3GPJAxjStrhTiXJ9AVepeGx9CkdvssdE2vOCjwUbMu/ Rw==
Received: from prod-mail-ppoint6 (prod-mail-ppoint6.akamai.com [] (may be forged)) by mx0b-00190b01.pphosted.com with ESMTP id 2wag31b1ev-1 (version=TLSv1.2 cipher=ECDHE-RSA-AES256-GCM-SHA384 bits=256 verify=NOT) for <tools-discuss@ietf.org>; Sun, 17 Nov 2019 07:35:24 +0000
Received: from pps.filterd (prod-mail-ppoint6.akamai.com []) by prod-mail-ppoint6.akamai.com ( with SMTP id xAH7X7ah024339 for <tools-discuss@ietf.org>; Sun, 17 Nov 2019 02:35:23 -0500
Received: from email.msg.corp.akamai.com ([]) by prod-mail-ppoint6.akamai.com with ESMTP id 2wadaxh77r-1 (version=TLSv1.2 cipher=ECDHE-RSA-AES256-SHA384 bits=256 verify=NOT) for <tools-discuss@ietf.org>; Sun, 17 Nov 2019 02:35:23 -0500
Received: from USMA1EX-DAG1MB3.msg.corp.akamai.com ( by usma1ex-dag1mb3.msg.corp.akamai.com ( with Microsoft SMTP Server (TLS) id 15.0.1473.3; Sun, 17 Nov 2019 02:35:23 -0500
Received: from USMA1EX-DAG1MB3.msg.corp.akamai.com ([]) by usma1ex-dag1mb3.msg.corp.akamai.com ([]) with mapi id 15.00.1473.005; Sun, 17 Nov 2019 02:35:21 -0500
From: "Salz, Rich" <rsalz@akamai.com>
To: Tools Team Discussion <tools-discuss@ietf.org>
Thread-Topic: Advice on DT schema changes
Thread-Index: AQHVnRmR/xhGV4DYk0y2uc9ZEHzWyw==
Date: Sun, 17 Nov 2019 07:35:21 +0000
Message-ID: <310B3662-BF5A-4943-9107-198A725EEEA3@akamai.com>
Accept-Language: en-US
Content-Language: en-US
X-MS-Has-Attach: yes
user-agent: Microsoft-MacOutlook/10.1f.0.191110
x-ms-exchange-messagesentrepresentingtype: 1
x-ms-exchange-transport-fromentityheader: Hosted
x-originating-ip: []
Content-Type: multipart/mixed; boundary="_005_310B3662BF5A49439107198A725EEEA3akamaicom_"
MIME-Version: 1.0
X-Proofpoint-Virus-Version: vendor=fsecure engine=2.50.10434:, , definitions=2019-11-17_01:, , signatures=0
X-Proofpoint-Spam-Details: rule=notspam policy=default score=0 suspectscore=0 malwarescore=0 phishscore=0 bulkscore=0 spamscore=0 mlxscore=0 mlxlogscore=999 adultscore=0 classifier=spam adjust=0 reason=mlx scancount=1 engine=8.0.1-1911140001 definitions=main-1911170072
X-Proofpoint-Virus-Version: vendor=fsecure engine=2.50.10434:6.0.95,18.0.572 definitions=2019-11-17_01:2019-11-15,2019-11-16 signatures=0
X-Proofpoint-Spam-Details: rule=notspam policy=default score=0 suspectscore=0 priorityscore=1501 malwarescore=0 mlxlogscore=999 adultscore=0 mlxscore=0 bulkscore=0 lowpriorityscore=0 clxscore=1011 spamscore=0 phishscore=0 impostorscore=0 classifier=spam adjust=0 reason=mlx scancount=1 engine=8.12.0-1910280000 definitions=main-1911170071
Archived-At: <https://mailarchive.ietf.org/arch/msg/tools-discuss/LHaIVjJ25mFRSsEZvmCYPhYd2ic>
Subject: [Tools-discuss] Advice on DT schema changes
X-BeenThere: tools-discuss@ietf.org
X-Mailman-Version: 2.1.29
Precedence: list
List-Id: IETF Tools Discussion <tools-discuss.ietf.org>
List-Unsubscribe: <https://www.ietf.org/mailman/options/tools-discuss>, <mailto:tools-discuss-request@ietf.org?subject=unsubscribe>
List-Archive: <https://mailarchive.ietf.org/arch/browse/tools-discuss/>
List-Post: <mailto:tools-discuss@ietf.org>
List-Help: <mailto:tools-discuss-request@ietf.org?subject=help>
List-Subscribe: <https://www.ietf.org/mailman/listinfo/tools-discuss>, <mailto:tools-discuss-request@ietf.org?subject=subscribe>
X-List-Received-Date: Sun, 17 Nov 2019 07:35:29 -0000

I want to add a uniform and extensible way of attaching “external references” to DT objects: groups, people, documents. For example, I’d like us to be able to say “this is the GitHub repository for this draft,” “my GitLab username is rsalz,” and “the homepage for this WG is https:…..”

I’m attaching two files that I’d like some comments on.   The ext-schema.sql file is a SQL script that shows the tables I am thinking of adding.  The data-changes.py file is a combination of python and pseudo-code that shows how I’d migrate the database. Is this the best place to ask?

Now, I know that this isn’t the way we’d really do things. Instead I’d write Django models, update the view scripts, and a command-line tool to do the migration. But before I dig into that (and learn enough Django so that I can :) I’d like comments – think of them as the high-level design work, for example.

One of my motivations for this (BTW, my first notes on this are on letterhead from the Bangkok hotel :), is so that I can enhance my GitHub scripts, https://github.com/richsalz/ietf-gh-scripts, to automatically pull/push data between GH and DT.

Thanks for any feedback.