alexlegg/backup.py

## backup.py
#!/bin/python
import sqlite3
from datetime import datetime

conn = sqlite3.connect('backup')
c = conn.cursor()

print """
<html>
<head>
    <title>Message Backup</title>
    <style text="text/css">
        div#container {
            margin: auto;
            width: 600px;
            font-family: arial;
        }
        .date {
            font-weight: bold;
            color: grey;
            font-size: 8pt;
        }
        div#container div {
            //width: 400px;
        }
        .from {
            float: left;
        }
        .to {
            float: right;
            text-align: right;
        }
        div.message {
            position: relative;
            -moz-border-radius: 10px;
            -webkit-border-radius: 10px;
            border-radius: 10px;
            border: 1px solid grey;
            padding: 5px;
            max-width: 70%;
        }
        div.from {
            background: #EBEBEB;
        }
        div.to {
            //background: #D0ECCC;
            background: #92D885;
        }
    </style>
</head>
<body>
    <div id="container">"""
c.execute("SELECT date, text, flags FROM message WHERE Address='+61405298675'")
for (date, message, flags) in c:
    if message:
        if flags == 3:
            mclass = 'from'
        else:
            mclass = 'to'
        print '<span class="', mclass, 'date">', datetime.fromtimestamp(date), '</span>'
        print '<br />'
        print '<div class="', mclass, 'message">', message.encode('ascii', 'ignore'), '</div>'
        print '<div style="clear:both;"></br /></div>'

print '</div></body></html>'
	#!/bin/python
	import sqlite3
	from datetime import datetime

	conn = sqlite3.connect('backup')
	c = conn.cursor()

	print """
	<html>
	<head>
	<title>Message Backup</title>
	<style text="text/css">
	div#container {
	margin: auto;
	width: 600px;
	font-family: arial;
	}
	.date {
	font-weight: bold;
	color: grey;
	font-size: 8pt;
	}
	div#container div {
	//width: 400px;
	}
	.from {
	float: left;
	}
	.to {
	float: right;
	text-align: right;
	}
	div.message {
	position: relative;
	-moz-border-radius: 10px;
	-webkit-border-radius: 10px;
	border-radius: 10px;
	border: 1px solid grey;
	padding: 5px;
	max-width: 70%;
	}
	div.from {
	background: #EBEBEB;
	}
	div.to {
	//background: #D0ECCC;
	background: #92D885;
	}
	</style>
	</head>
	<body>
	<div id="container">"""
	c.execute("SELECT date, text, flags FROM message WHERE Address='+61405298675'")
	for (date, message, flags) in c:
	if message:
	if flags == 3:
	mclass = 'from'
	else:
	mclass = 'to'
	print '<span class="', mclass, 'date">', datetime.fromtimestamp(date), '</span>'
	print '<br />'
	print '<div class="', mclass, 'message">', message.encode('ascii', 'ignore'), '</div>'
	print '<div style="clear:both;"></br /></div>'

	print '</div></body></html>'