<th>English Phrases</th>
<th>Total Phrases</th>
<th>Languages</th>
<th>License</th>
</tr>
''' % date.fromtimestamp(stat(datadir + '/ten.db').st_ctime).strftime('%B %d, %Y')
projs = sorted(projects.values(), key = lambda p: p.total, reverse = True)
for project in projs:
if not project.total:
continue
print '<tr>'
print '\t<td><a href="%s"><img src="%s" alt=""/> %s</a></td>' \
% (project.url, project.icon, project.name)
print '\t<td>%s</td>' % project.branch
print '\t<td align="right">%s</td>' % pretty_int(project.eng)
print '\t<td align="right">%s</td>' % pretty_int(project.total)
print '\t<td align="right">%d</td>' % project.langs
print '\t<td>%s</td>' % project.lic
print '</tr>'
print '''
</table>
<p>
Notice that some of the logos might be copyrighted and their use
might be restricted. Open-Tran hosts them in order to make sure
that they are always available from the same location and in order
to avoid so-called hot-linking.
</p>
</div>
'''
<th>Total Phrases</th>
<th>Languages</th>
<th>License</th>
</tr>
''' % date.fromtimestamp(
stat(datadir + '/ten-en.db').st_ctime).strftime('%B %d, %Y'))
projs = sorted(projects.values(), key=lambda p: p.total, reverse=True)
for project in projs:
if not project.total:
continue
fprojs.write('<tr>\n')
fprojs.write('\t<td><a href="%s"><img src="%s" alt=""/> %s</a></td>\n' \
% (project.url, project.icon, project.name))
fprojs.write('\t<td>%s</td>\n' % project.branch)
fprojs.write('\t<td align="right">%s</td>\n' % pretty_int(project.eng))
fprojs.write('\t<td align="right">%s</td>\n' % pretty_int(project.total))
fprojs.write('\t<td align="right">%d</td>\n' % project.langs)
fprojs.write('\t<td>%s</td>\n' % project.lic)
fprojs.write('</tr>\n')
fprojs.write('''
</table>
<p>
Notice that some of the logos might be copyrighted and their use
might be restricted. Open-Tran hosts them in order to make sure
that they are always available from the same location and in order
to avoid so-called hot-linking.
</p>
</div>
''')
<th>Total Phrases</th>
<th>Languages</th>
<th>License</th>
</tr>
''' % date.fromtimestamp(
stat(datadir + '/ten.db').st_ctime).strftime('%B %d, %Y')
projs = sorted(projects.values(), key=lambda p: p.total, reverse=True)
for project in projs:
if not project.total:
continue
print '<tr>'
print '\t<td><a href="%s"><img src="%s" alt=""/> %s</a></td>' \
% (project.url, project.icon, project.name)
print '\t<td>%s</td>' % project.branch
print '\t<td align="right">%s</td>' % pretty_int(project.eng)
print '\t<td align="right">%s</td>' % pretty_int(project.total)
print '\t<td align="right">%d</td>' % project.langs
print '\t<td>%s</td>' % project.lic
print '</tr>'
print '''
</table>
<p>
Notice that some of the logos might be copyrighted and their use
might be restricted. Open-Tran hosts them in order to make sure
that they are always available from the same location and in order
to avoid so-called hot-linking.
</p>
</div>
'''
conn = sqlite.connect(datadir + '/ten.db')
cur = conn.cursor()
print '''
<div class="ltr">
<h1>Languages</h1>
<table>
<tr><th>Code</th><th>Language</th><th class="right">Count</th></tr>
'''
cur.execute("""
SELECT lang, count(*)
FROM phrases
GROUP BY lang
ORDER BY lang""")
for (lang, cnt) in cur.fetchall():
if not lang in LANGUAGES:
continue
print(
u'<tr><td>%s</td><td><a href="http://%s.open-tran.eu">%s</a></td><td align="right">%s</td></tr>'
% (lang, lang, LANGUAGES[lang], pretty_int(cnt))).encode('utf-8')
cur.close()
conn.close()
print '''
</table>
</div>
'''
conn = sqlite.connect(datadir + '/ten.db')
cur = conn.cursor()
print '''
<div class="ltr">
<h1>Languages</h1>
<table>
<tr><th>Code</th><th>Language</th><th class="right">Count</th></tr>
'''
cur.execute("""
SELECT lang, count(*)
FROM phrases
GROUP BY lang
ORDER BY lang""")
for (lang, cnt) in cur.fetchall():
if not lang in LANGUAGES:
continue
print (u'<tr><td>%s</td><td><a href="http://%s.open-tran.eu">%s</a></td><td align="right">%s</td></tr>' % (lang, lang, LANGUAGES[lang], pretty_int(cnt))).encode('utf-8')
cur.close()
conn.close()
print '''
</table>
</div>
'''
<th>English Phrases</th>
<th>Total Phrases</th>
<th>Languages</th>
<th>License</th>
</tr>
''' % date.fromtimestamp(stat(datadir + '/ten-en.db').st_ctime).strftime('%B %d, %Y'))
projs = sorted(projects.values(), key = lambda p: p.total, reverse = True)
for project in projs:
if not project.total:
continue
fprojs.write('<tr>\n')
fprojs.write('\t<td><a href="%s"><img src="%s" alt=""/> %s</a></td>\n' \
% (project.url, project.icon, project.name))
fprojs.write('\t<td>%s</td>\n' % project.branch)
fprojs.write('\t<td align="right">%s</td>\n' % pretty_int(project.eng))
fprojs.write('\t<td align="right">%s</td>\n' % pretty_int(project.total))
fprojs.write('\t<td align="right">%d</td>\n' % project.langs)
fprojs.write('\t<td>%s</td>\n' % project.lic)
fprojs.write('</tr>\n')
fprojs.write('''
</table>
<p>
Notice that some of the logos might be copyrighted and their use
might be restricted. Open-Tran hosts them in order to make sure
that they are always available from the same location and in order
to avoid so-called hot-linking.
</p>
</div>
''')