view scripts/delete-tables.py @ 1138:50a7e1b47a3c Tertuis-Ou-draogo/movingpy-issue-22-from-etienne-beauchamp-1584900380975

Close branch Tertuis-Ou-draogo/movingpy-issue-22-from-etienne-beauchamp-1584900380975.
author Nicolas Saunier <nicolas.saunier@polymtl.ca>
date Sun, 22 Mar 2020 19:10:57 +0000
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)