Das deutsche Python-Forum

Code: Alles auswählen

def computeWeightDifference(self):

		# connect to DATABASE
		connection = sqlite.connect("E:\Schule\Programmieren\WeightWatcher\WeightWatcher.db", isolation_level = None)

		# read last entered weight
		cursor = connection.cursor()
		lastentry = cursor.execute("SELECT weight FROM WeightWatcher ORDER BY id DESC LIMIT 1")
		print lastentry

Code: Alles auswählen

In [16]: a = u'42'

In [17]: type(a)
Out[17]: <type 'unicode'>

In [18]: int(a)
Out[18]: 42

Code: Alles auswählen

self.difference = int(lastentry.fetchone()[0])/100 * int(lastentry.fetchone())[0]-int(self.weight)

Code: Alles auswählen

# WeightWatcher.py

import time
try:
    from pysqlite2 import dbapi2 as sqlite
except:
    from sqlite3 import dbapi2 as sqlite

class WeightWatcher(object):

	def __init__(self, weight):

		self.weight = weight

		self.difference = None
		self.date = None

	def writeIntoDatabase(self):

		# date
		self.date = str(time.localtime()[2]) + "." + str(time.localtime()[1]) + "." + str(time.localtime()[0])

		try:
			# connect to DATABASE
			connection = sqlite.connect("E:\Schule\Programmieren\WeightWatcher\WeightWatcher.db", isolation_level = None)

			# write into DATABASE
			cursor = connection.cursor()
			cursorparam = """INSERT INTO WeightWatcher VALUES(NULL, "%s", "%s", "%s")""" % (self.date, self.weight, self.difference)
			cursor.execute(cursorparam)
		except:
			print "Error"


	def computeWeightDifference(self):

		try:
			# connect to DATABASE
			connection = sqlite.connect("E:\Schule\Programmieren\WeightWatcher\WeightWatcher.db", isolation_level = None)

			# read last entered weight
			cursor = connection.cursor()
			lastentry = cursor.execute("SELECT weight FROM WeightWatcher ORDER BY id DESC LIMIT 1")

			try:
				ff = int(lastentry.fetchone()[0])
				self.difference = (float(ff/100)) * (ff-int(self.weight))
			except TypeError:
				ff = 0
			print self.difference
		except:
			print "Error!"

	def createDatabase(self):

		try:
			# create DATABASE
			connection = sqlite.connect("E:\Schule\Programmieren\WeightWatcher\WeightWatcher.db", isolation_level = None)

			# create TABLE
			cursor = connection.cursor()
			cursor.execute("""CREATE TABLE WeightWatcher(id integer primary key,date char(8),weight varchar(10),difference char(4))""")
		except:
			print "Error!"


weight = raw_input("Enter your today's weight")

weightwatcher = WeightWatcher(weight)
#weightwatcher.createDatabase()
weightwatcher.computeWeightDifference()
weightwatcher.writeIntoDatabase()

Code: Alles auswählen

In [24]: 50 / 100
Out[24]: 0

Code: Alles auswählen

In [25]: time.strftime('%d.%m.%Y')
Out[25]: '29.04.2007'

Code: Alles auswählen

#!/usr/bin/env python
# -*- coding: iso-8859-15 -*-

try:
    import sqlite3
except ImportError:
    from pysqlite2 import dbapi2 as sqlite3
import datetime

# Connection so erstellen, dass DATE- und TIMESTAMP-Felder erkannt werden.
conn = sqlite3.connect(
    ":memory:",
    detect_types = sqlite3.PARSE_DECLTYPES | sqlite3.PARSE_COLNAMES
)

# weights-Tabelle erstellen
sql = """
CREATE TABLE weights (
    id INTEGER PRIMARY KEY,
    timestamp TIMESTAMP,
    weight REAL
)
"""
conn.execute(sql)
conn.commit()

# Index mit dem Feld timestamp erstellen
sql = """
CREATE INDEX ix_weights_timestamp 
ON weights (timestamp)
"""
conn.execute(sql)
conn.commit()

# Einen Datensatz in die Tabelle weights schreiben
sql = """
INSERT INTO weights (timestamp, weight) VALUES (?, ?)
"""
conn.execute(
    sql, (datetime.datetime.now(), 100)
)
conn.commit()

# Zwei Datensätze in die Tabelle weights schreiben
conn.executemany(
    sql, (
        (datetime.datetime.now(), 90),
        (datetime.datetime.now(), 80),
    )
)

# Alle Datensätze der Tabelle weights auslesen
sql = """
SELECT * FROM weights
"""
cur = conn.cursor()
cur.execute(sql)

for row in cur:
    print row # --> (1, datetime.datetime(2007, 4, 29, 20, 33, 47, 781000), 100.0)

Code: Alles auswählen

(1, datetime.datetime(2007, 4, 29, 22, 57, 24, 781000), 100.0)
(2, datetime.datetime(2007, 4, 29, 22, 57, 24, 781000), 90.0)
(3, datetime.datetime(2007, 4, 29, 22, 57, 24, 781000), 80.0)

Code: Alles auswählen

# Letzten Datensatz der Tabelle weights auslesen
sql = """
SELECT id, timestamp, weight FROM weights ORDER BY id DESC LIMIT 1
"""
cur = conn.cursor()
cur.execute(sql)

id, timestamp, weight = cur.fetchone()

print "id:", id
print "timestamp:", timestamp
print "irgendeine Rechnung mit weight:", weight / 100

Code: Alles auswählen

id: 3
timestamp: 2007-04-29 22:56:19.765000
irgendeine Rechnung mit weight: 0.8