On 11/19/17 8:40 PM, Stefan Ram wrote:
mradul dhakad <mradul.k.dha...@gmail.com> writes:
I am new to python . I am trying to generate Dynamic HTML report using
Pyhton based on number of rows selected from query .Do any one can suggest
some thing for it.
main.py
import sqlite3
conn = sqlite3.connect( ':memory:' )
c = conn.cursor()
c.execute( "CREATE TABLE T ( A TEXT )" )
c.execute( "INSERT INTO T ( A ) VALUES ( '1' ), ( '2' )" )
conn.commit()
c.execute( "SELECT * FROM T WHERE A = '1'" )
number_of_rows_selected_from_query = len( c.fetchall() )
conn.close()
del c
del conn
del sqlite3
I'm curious what superstition compels you to delete these names? There's
no need to.
Also, why set headers that prevent the Python-List mailing list from
archiving your messages?
--Ned.
def HTML( x ):
return f'''<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml"; lang="de" xml:lang="de">
<head><meta charset="UTF-8" />
<title>Number Of Rows Selected From Query</title><style type="text/css">
</style></head><body><h1>Number Of Rows Selected From Query</h1>
<p>The number of rows selected from query is {x}.</p></body></html>'''
print( HTML( number_of_rows_selected_from_query ))
transcript
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml"; lang="de" xml:lang="de">
<head><meta charset="UTF-8" />
<title>Number Of Rows Selected From Query</title><style type="text/css">
</style></head><body><h1>Number Of Rows Selected From Query</h1>
<p>The number of rows selected from query is 1.</p></body></html>
--
https://mail.python.org/mailman/listinfo/python-list
