html = '''
<style>
    /* zdvojení složených závorek vypne jejich nahrazovací funkci */
    thead {{ background-color: lightgreen; }}
    tbody > tr:nth-child(2n) {{}}
    tbody > tr:nth-child(2n+1) {{ background-color: lightblue; }}
</style>

<form id="formulář"></form>

<table border>
    <thead>
        <tr>
            <th>F</th>
            <th>A</th>
            <th>M</th>
            <th>Z</th>
            <th>element</th>
            <th>name <input form="formulář" type="text" name="name" value="{value_name}"></th>           <!-- tabulka symboly -->
            <th>origin of name</th> <!-- tabulka symboly -->
            <th>J</th>
            <th>decay mode</th>
            <th>% branch</th>
            <th>excitation energy [MeV]</th>
            <th>Q [MeV]</th>
            <th>T½</th>
            <th>abundance</th>
            <th>atomic mass [MeV]</th>
            <th>uncertain in mass [MeV]</th>
            <th>S</th>
            <th>date</th>
            <th>T½ [s]</th>
        </tr>
    </thead>
    <tbody>
        {data_html}
    </tbody>
</table>
'''

# WSGI-klient
def application(environ, start_response):
    # zpracování (případného) dotazu
    form = parse_qs(environ['QUERY_STRING'])    # vrací dict
    # získání dat z databáze a jejich převod do podoby HTML-tabulky
    if 'name' in form:
        print('name =', form)
        data_name = form['name'][0]
        cursor.execute(f'''
            SELECT * FROM izotopy,symboly
                WHERE izotopy.element = symboly.symbol AND symboly.name LIKE '%{data_name}%';
        ''')
    else:
        data_name = ''
        cursor.execute(f'''
            SELECT * FROM izotopy,symboly
                WHERE izotopy.element = symboly.symbol;
        ''')
    data = ''
    for záznam in cursor:
        F, A, M, Z, element, J, decay_mode, branch_pct, excitation_energy, Q, T12, abundance, atomic_mass, uncertain_in_mass, S, date, T12s, Z2, symbol, name, origin = záznam
        data += f'''
          <tr>
            <td>{F}</td>
            <td>{A}</td>
            <td>{M}</td>
            <td>{Z}</td>
            <td>{element}</td>
            <td>{name}</td>
            <td>{origin}</td>
            <td>{J}</td>
            <td>{decay_mode}</td>
            <td>{branch_pct}</td>
            <td>{excitation_energy}</td>
            <td>{Q}</td>
            <td>{T12}</td>
            <td>{abundance}</td>
            <td>{atomic_mass}</td>
            <td>{uncertain_in_mass}</td>
            <td>{S}</td>
            <td>{date}</td>
            <td>{T12s}</td>
          </tr>
        '''
    # vykreslení vyrobené HTML-tabulky
    body = bytes(html.format(data_html=data, value_name=data_name), encoding='utf-8')
    response_headers = [
        ("Content-type", "text/html; charset=utf-8"),
        ("Content-length", str(len(body)) ),
    ]
    start_response("200 OK", response_headers)
    return (body,)
 
# WSGI-server (spuštěn pro jednu odpověď)
if __name__ == '__main__':
    # spojení na databázi
    import sqlite3
    connection = sqlite3.connect('izotopy.db')
    cursor = connection.cursor()
    # webový server
    from wsgiref.simple_server import make_server
    from urllib.parse import parse_qs
    server = make_server('localhost', 8080, application)
    server.serve_forever()