cleandb.sh:

#!/bin/bash
mysql neutron < /scripts/cleanupneutrondb.sql
mysql octavia < /scripts/cleanupoctaviadb.sql

cleanupneutrondb.sql:

delete from lbaas_l7rules;
delete from lbaas_l7policies;
delete from lbaas_members;
delete from lbaas_sessionpersistences;
delete from lbaas_listeners;
delete from lbaas_pools;
delete from lbaas_healthmonitors;
delete from lbaas_loadbalancer_statistics;
delete from lbaas_loadbalancers;

cleanupoctaviadb.sql:

delete from l7rule;
delete from l7policy;
delete from amphora_health;
delete from health_monitor;
delete from member;
delete from session_persistence;
delete from listener_statistics;
delete from listener;
delete from pool;
delete from vip;
delete from vrrp_group;
delete from amphora;
delete from load_balancer;