LP9Vjkmm

1import sqlite3 as sql
2
3creating = '''
4CREATE TABLE if NOT EXISTS users (
5id INTEGER PRIMARY KEY AUTOINCREMENT,
6name text not null,
7age integer not null,
8email text not null
9);
10'''
11
12
13def create_db():
14    connect = sql.connect('users.db')
15    cur = connect.cursor()
16    cur.execute(creating)
17
18
19def connect_db():
20    conn = sql.connect('users.db')
21    conn.row_factory = sql.Row
22    return conn
23
24
25email_list_check = ['@mail.ru', '@gmail.com', '@yandex.ru']
26
27
28class User:
29    def __init__(self):
30        self.name = None
31        self.age = None
32        self.email = None
33
34    def setName(self, name):
35        self.name = name
36
37    def setAge(self, age):
38        self.age = age
39
40    def setEmail(self, email):
41        for mail in email_list_check:
42            if mail in email:
43                self.email = email
44                break
45            else:
46                self.email = ''
47
48    def getName(self):
49        return self.name
50
51    def getAge(self):
52        return self.age
53
54    def getEmail(self):
55        return self.email
56
57
58ob = input(str('object: '))
59ob = User()
60
61handlerName = input(str('name: '))
62ob.setName(handlerName)
63
64handlerAge = input(str('age: '))
65ob.setAge(handlerAge)
66
67handlerEmail = input(str('email: '))
68ob.setEmail(handlerEmail)
69
70db = connect_db()
71db.cursor().execute('insert into users values (null, ?, ?, ?)', (ob.getName(), ob.getAge(), ob.getEmail()))
72db.commit()