Mercurial > hg > freeDiameter
view doc/app_sip_SL.sql @ 1479:c0aa1e66c12e
csv_to_fd: improve validation
* Validate flags:
- Ensure M and V can't occur more than once.
- Ensure absence of V for vendor 0.
- Ensure presence of V for vendor not 0.
* Ensure AVP name is unique per vendor.
* Add AVP name to most errors.
* Use csv.DictReader.line_num for more accurate line numbers.
TODO: enforce M and V must be present once and only once.
Some AVPs currently fail that rule, including:
- RFC 4005 / RFC 7155 QoS-Filter-Rule
- 3GPP TS 29.212 PDN-Connection-ID
- 3GPP TS 29.212 PS-to-CS-Session-Continuity
author | Luke Mewburn <luke@mewburn.net> |
---|---|
date | Thu, 26 Mar 2020 10:28:16 +1100 |
parents | 533188d2e6cc |
children |
line wrap: on
line source
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -- -- SUBSCRIBER LOCATOR DATABASE -- -- -------------------------------------------------------- -- -- Table structure for table `ds_sip_aor_map` -- CREATE TABLE IF NOT EXISTS `ds_sip_aor_map` ( `id_map` int(11) NOT NULL AUTO_INCREMENT, `sip_aor` varchar(255) NOT NULL, `diameter_uri` varchar(255) NOT NULL, PRIMARY KEY (`id_map`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;