view scripts/delete-tables.py @ 1231:6487ef10c0e0

work in progress
author Nicolas Saunier <nicolas.saunier@polymtl.ca>
date Thu, 24 Aug 2023 17:06:16 -0400
parents cc5cb04b04b0
children
line wrap: on
line source

#! /usr/bin/env python3

import sys, argparse

from trafficintelligence import utils, storage

parser = argparse.ArgumentParser(description='The program deletes (drops) the tables in the database before saving new results (for objects, tables object_features and objects are dropped; for interactions, the tables interactions and indicators are dropped')
#parser.add_argument('configFilename', help = 'name of the configuration file')
parser.add_argument('-d', dest = 'databaseFilename', help = 'name of the Sqlite database', required = True)
parser.add_argument('-t', dest = 'dataType', help = 'type of the data to remove', required = True, choices = ['object','interaction', 'bb', 'pois', 'prototype'])
args = parser.parse_args()

storage.deleteFromSqlite(args.databaseFilename, args.dataType)