Code:
import sqlite3
db = sqlite3.connect("accounts.sqlite")
db.execute("CREATE TABLE IF NOT EXISTS accounts (name TEXT PRIMARY KEY NOT NULL, balance INTEGER NOT NULL)")
db.execute("CREATE TABLE IF NOT EXISTS transactions (time TIMESTAMP NOT NULL,"
" account TEXT NOT NULL, amount INTEGER NOT NULL, PRIMARY KEY (time, account))")
class Account(object):
def __init__(self, name: str, opening_balance: int = 0):
cursor = db.execute("SELECT name, balance FROM accounts WHERE (name = ?)", (name,))
row = cursor.fetchone()
if row:
self.name, self._balance = row
print("Retrieved record for {}. ".format(self.name), end='')
else:
self.name = name
self._balance = opening_balance
cursor.execute("INSERT INTO accounts VALUES(?, ?)", (name, opening_balance))
cursor.connection.commit()
print("Account created for {}. ".format(self.name), end='')
self.show_balance()
def deposit(self, amount: int) -> float:
if amount > 0.0:
self._balance += amount
print("{:.2f} deposited".format(amount / 100))
return self._balance / 100
def withdraw(self, amount: int) -> float:
if 0 < amount <= self._balance:
self._balance -= amount
print("{:.2f} withdrawn".format(amount / 100))
return amount / 100
else:
print("The amount must be greater than zero and no more than your account balance")
return 0.0
def show_balance(self):
print("Balance on account {} is {:.2f}".format(self.name, self._balance / 100))
if __name__ == '__main__':
john = Account("John")
john.deposit(1010)
john.deposit(10)
john.deposit(10)
john.withdraw(30)
john.withdraw(0)
john.show_balance()
terry = Account("Terry")
graham = Account("Graham", 9000)
eric = Account("Eric", 7000)
db.close()Hallo,
ich verstehe leider nicht alles.
print("Retrieved record for {}. ".format(self.name), end='') ---------------------- was bedeutet das end='') .....?
def deposit(self, amount: int) -> float: ----------------- was wird da gemacht?
if __name__ == '__main__': -------------- was bedeutet diese Zeile? Was wird da gemacht?
row = cursor.fetchone() ------ was heisst das?
cursor.connection.commit() ----- was heisst das?
Ich habe erst Java gelernt und bin grade dabei Python zu lernen.
Irgendwie finde ich Java zwar umständlicher aber logischer und einfacher zu verstehen -.-
Wäre gut, wenn sich jemand paar Minuten Zeit nehmen würde.
