Python Forum

Can you let me know how to list the files using the query output in python.

Output:
Input Files In Unix
Directory : /DDD_Ext/input/

DDD_SL_NE_WAT_FCT_H001_QUAD_BD_20230225.csv
DDD_SL_NE_WAT_FCT_H002_QUAD_BD_20230225.csv
DDD_SL_NE_WAT_FCT_H003_QUAD_BD_20230225.csv
DDD_SL_NE_WAT_FCT_H004_QUAD_BD_20230225.csv

SELECT
	   distinct(filecode),
	   delimiter,
	   a.country,
	   a.catcode,
	   a.client,
		hierarchynum,
		 notify
	FROM 
	   ddd_mail_addresses a 
	              JOIN ddd_data_types b ON a.categorycode = b.categorycode and a.client = b.client and a.country = b.country
				  JOIN ddd_conversion c ON a.categorycode = c.categorycode and a.client = c.client and a.country = c.country
				  JOIN ddd_hierarchy d ON a.categorycode = d.categorycode and a.client = d.client and a.country = d.country
				  where a.client='NE' and a.categorycode='WAT'  and a.country='SL'

Output :

Output:
Filecode   Delimiter    Country		categorycode    Client	hierarchynum	Email
				  
"QUAD"		"|"			"SL"		"WAT"			"NE"	1				"[email protected]"
"QUAD"		"|"			"SL"		"WAT"			"NE"	2				"[email protected]"
"QUAD"		"|"			"SL"		"WAT"			"NE"	3				"[email protected]"
"QUAD"		"|"			"SL"		"WAT"			"NE"	4				"[email protected]"
"WEEK"		"|"			"SL"		"WAT"			"NE"	1				"[email protected]"
"WEEK"		"|"			"SL"		"WAT"			"NE"	2				"[email protected]"
"WEEK"		"|"			"SL"		"WAT"			"NE"	3				"[email protected]"
"WEEK"		"|"			"SL"		"WAT"			"NE"	4				"[email protected]"

Using Query need to list the files.
DDD_$country_$client_$categorycode_FCT_H00$hierarchynum_$filecode_BD_20230225.csv