how to add names to arguments when executing script Python

Asked Dec 07 '20 at 15:14

Active Dec 07 '20 at 15:14

Viewed 30 times

I have a script which and I want to enter arguments for an sql request in my function (parameters) as following:

def doQuery( conn ) :
    cur = conn.cursor()
    day_start = sys.argv[1]
    day_end = sys.argv[3]
    dep_air = sys.argv[4]
    arr_air = sys.argv[5]
    aircraft = sys.argv[6]
    balname = sys.argv[7]

cur.execute( "SELECT id, day, ftfm_pp->>'name' AS Name, ftfm_pp->>'lat' AS LAT, ftfm_pp->>'lon' AS LON FROM public.pln where day between %s and %s and dep_airport = %s and arr_airport like %s and type_acft = %s and ftfm_pp->'name'?%s" , (day_start, day_end, dep_air, arr_air,aircraft,balname))

sql_data = pd.DataFrame(cur.fetchall(), columns=['ID', 'DAY', 'NAME', 'LAT', 'LON'])
.....
.....
.....

I want to know how to add names for my arguments like :

python -dayStart arg1 -dayEnd arg2 -depAir arg3 -arrAir arg4 -aircraft -arg5 -balname -arg6

Merci pour votre aide par avance

asked Dec 07 '20 at 15:14

Flora8832

Argparse, perhaps? https://docs.python.org/3/library/argparse.html – NNN Dec 07 '20 at 15:16
Does this answer your question? [How to read/process command line arguments?](https://stackoverflow.com/questions/1009860/how-to-read-process-command-line-arguments) – Tomerikoo Dec 07 '20 at 15:17
thank's for your help – Flora8832 Dec 08 '20 at 09:57

how to add names to arguments when executing script Python

0 Answers0