#file user
from hashlib import sha224

class user:
    login = 'login'
    email = 'email'
    password = 'password'
    custom = 'custom one'

    def __init__(self, login, email, password):
        self.login = login
        self.email = email
        self.__password = password

    def get_login(self, prefix):
        return prefix + self.login

    def get_password(self):
        return self.password

user = user('login', 'email', 'password')
user.get_password()


#file register class
import sqlite3

class register:
    var1 = 1
    conn = 0

    def __init__(self, login, email, password):
        self.login = login
        self.email = email
        self.password = password
        self.conn = sqlite3.connect('users.db')
        self.cursor = self.conn.cursor()

    def register(self):
        self.conn.execute("INSERT INTO users VALUES ('%s', '%s', '%s')" %(self.login, self.email, self.password))
        self.conn.commit()

    def viev_user(self):
        self.cursor.execute("SELECT * FROM users")
        return self.cursor.fetchone()

    def search_user(self):
        self.cursor.execute("SELECT * FROM users WHERE login LIKEsk '%dd%'")
        return self.cursor.fetchone()



register = register('john', 'doe', 'passdsword1')
print register.search_user()
print register.viev_user()