diff options
author | Asbjørn Sloth Tønnesen <ast@fiberby.net> | 2019-09-07 13:15:52 +0000 |
---|---|---|
committer | Asbjørn Sloth Tønnesen <ast@fiberby.net> | 2019-09-07 13:15:52 +0000 |
commit | c59f1d55b8942e41f96f868e39edff67c47434e2 (patch) | |
tree | 2d15d7f4c8a1e98f8cc2a4a022914f4227cc3988 /README.md | |
parent | eb381cff50bc45d3072cf005aac07c91e79dcfc6 (diff) | |
download | peeringdb-simplesync-c59f1d55b8942e41f96f868e39edff67c47434e2.tar.gz peeringdb-simplesync-c59f1d55b8942e41f96f868e39edff67c47434e2.tar.xz peeringdb-simplesync-c59f1d55b8942e41f96f868e39edff67c47434e2.zip |
handle deleted objects
Signed-off-by: Asbjørn Sloth Tønnesen <ast@fiberby.net>
Diffstat (limited to 'README.md')
-rw-r--r-- | README.md | 9 |
1 files changed, 3 insertions, 6 deletions
@@ -43,17 +43,14 @@ SELECT data->>'irr_as_set', (data->>'info_prefixes4')::int pfx4, (data->>'info_prefixes6')::int pfx6 -FROM peeringdb.net ORDER BY asn; +FROM peeringdb.net +WHERE deleted IS NULL +ORDER BY asn; ``` Note: if you add an `info_prefixes4` column to the schema, then it will automatically be used, just like the `asn` column. -Known issues ------------- - -* Objects are not deleted when they are deleted from PeeringDB. - Disclaimer ---------- |