const arrObjects = [
{name:'Irina', skills: ['js', 'html', 'css']},
{name:'Ruslan', skills: ['nodeJs', 'html', 'css']},
{name:'Kate', skills: ['react', 'js', 'css']},
{name:'Dmitry', skills: ['hh', 'html', 'css']},
{name:'Serg', skills: ['angular', 'mobX', 'js']},
];
const result = arrObjects.filter(person => person.skills.includes('js'));
console.log(result);import sqlite3
db = sqlite3.connect("data.db")
sql = db.cursor()
sql.execute("""CREATE TABLE IF NOT EXISTS "users" (
"username" TEXT,
"password" TEXT)""")
db.commit()
def reg():
username = input("username>> ")
password = input("password>> ")
sql.execute(f"SELECT username, password FROM users WHERE username = '{username}' AND password = '{password}'")
if sql.fetchone() is None:
sql.execute(f"INSERT INTO users VALUES (?,?)", (username, password))
db.commit()
print('You have registered')
login()
else:
print('Такая запись уже существует')
for i in sql.execute('SELECT * FROM users'):
print(i)
def login():
username = input("username>> ")
password = input("password>> ")
a = sql.execute(f"SELECT username, password FROM users WHERE username = '{username}' AND password = '{password}'")
db.commit()
if not sql.fetchone():
print("Нет такой записи")
for i in sql.execute('SELECT * FROM users'):
print(i)
reg()
else:
print('Welcome')
login()