MyNotesApplication/Database.py at master · Dra9ana/MyNotesApplication · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
# CREATE A DATABASE

import sqlite3

global id_total

# Create database
conn = sqlite3.connect('Notes.db')
# Create cursor
c = conn.cursor()

# Create table - Job
c.execute('''CREATE TABLE Job
             ([generated_id] INTEGER PRIMARY KEY, [Name] text, [Date] date, [Time] time, [Duration] time, [Description] text)''')

# Create table - School
c.execute('''CREATE TABLE School
             ([generated_id] INTEGER PRIMARY KEY, [Name] text, [Subject] text, [activity] text, [Date] date, [Time] time, [Duration] time, [Description] text )''')

# Create table - FaF
c.execute('''CREATE TABLE FaF
             ([generated_id] INTEGER PRIMARY KEY, [Name] text, [Activity] text, [Date] date, [Time] time, [Duration] time, [Description] text)''')

# Create table - House
c.execute('''CREATE TABLE House
             ([generated_id] INTEGER PRIMARY KEY, [Name] text, [Activity] text, [Date] date, [Time] time, [Description] text)''')

# Create table - Travel
c.execute('''CREATE TABLE Travel
             ([generated_id] INTEGER PRIMARY KEY, [Name] text, [Destination] text, [Date] date, [Time] time, [Duration] time, [Description] text)''')

# Create table - Extracurricular
c.execute('''CREATE TABLE Extracurricular
             ([generated_id] INTEGER PRIMARY KEY, [Name] text, [Destination] text, [Date] date, [Time] time, [Duration] time, [Description] text)''')

# Create table - Passwords
c.execute('''CREATE TABLE Passwords
             ([generated_id] INTEGER PRIMARY KEY, [Name] text, [Website] text, [Additional_info] text, [Username] text, [Mail] text, [Password] text)''')

# Create table - Allowance
c.execute('''CREATE TABLE Allowance
             ([generated_id] INTEGER PRIMARY KEY, [Food] float, [Clothes] float, [Bills] float, [Direct_debts] float, [Other] float, [Total] float)''')

# Create table - Expenes
c.execute('''CREATE TABLE Expences
             ([generated_id] INTEGER PRIMARY KEY, [Date] date, [Incomes] float, [Food] float, [Clothes] float, [Bills] float, [Direct_debts] float, [Other] float, [Total] float)''')

cursor=conn.cursor()
cursor.execute("INSERT INTO Expences (Date, Incomes, Food, Clothes, Bills, Direct_debts, Other, Total) VALUES(?, ?, ?, ?, ?, ?, ?, ?)",
                                                  (0/0/0, 0, 0, 0, 0, 0, 0, 0))
# Get id of last row inserted into database
id_total=cursor.lastrowid

# Commit changes
conn.commit()
# Close Database
conn.close()