Improve the way to output/generate the csv file

[dadiorchen]

Now we just simply write csv with join, we need to improve the output in a professional way like using csv lib to do it.

treetracker-airflow-dags/lib/capture_export.py

Lines 12 to 28 in c3e9fa7

	sql = f"SELECT {','.join(columns)} FROM trees LIMIT 20"
	print("SQL:", sql)
	# execute query
	cur.execute(sql)
	# fetch all rows
	rows = cur.fetchall()
	lines = [','.join(columns)]
	# print rows
	print ("rows:", rows)
	for row in rows:
	print ("row:", row)
	# join row elements with comma
	line = ",".join(str(v) for v in row)
	# add line to lines
	lines.append(line)
	print ("lines:", lines)
	print ("lines length:", len(lines))

[dark-teal-coder]

Do I have to understand your entire script? After I ran it, there's no output on my screen.

[vishanthan8055]

dframe = pd.read_csv(‘file_name.csv’,nrows=number)

This is the best way to print the csv with with n number of rows and we can export through many modules and functions