Skip to content

Lesson11 #6

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Open
AlexN-github wants to merge 2 commits into
base: master
Choose a base branch
from
Open

Lesson11 #6

Show file tree
Hide file tree
Changes from 1 commit
Commits
Show all changes
2 commits
Select commit Hold shift + click to select a range
361315d
Выполнил 1.1
AlexN-github Nov 24, 2019
4ccf42e
Сделал все
AlexN-github Nov 25, 2019
File filter

Filter by extension

Filter by extension
Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
Prev Previous commit
Сделал все
  • Loading branch information
@AlexN-github
AlexN-github committed Nov 25, 2019
commit 4ccf42e5f398a40e915f857bb9eb52325088c6ea
28 changes: 26 additions & 2 deletions lesson11/task1.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -3,12 +3,12 @@
use shop;
DROP TABLE IF exists logs;
CREATE TABLE logs (
id SERIAL PRIMARY KEY,
#id SERIAL PRIMARY KEY,
id_PK INT UNSIGNED,
table_name VARCHAR(25),
field_name VARCHAR(25),
created_at DATETIME DEFAULT NOW()
);
)engine=archive;

drop trigger if exists tr_logs_write_users;
drop trigger if exists tr_logs_write_catalogs;
Expand Down Expand Up @@ -54,3 +54,27 @@ INSERT INTO catalogs VALUES
(NULL, 'Блоки питания');




#Задание2

use shop;

drop procedure if exists dorepeat;
delimiter //

CREATE PROCEDURE dorepeat()
BEGIN
SET @x = 0;
set @p1 = 1000000;
REPEAT
SET @x = @x + 1;
INSERT INTO users (name, birthday_at) VALUES
('Геннадий', '1990-10-05');
UNTIL @x > @p1 END REPEAT;
END
//

DELIMITER ;

CALL dorepeat();
79 changes: 79 additions & 0 deletions lesson11/task2.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
@@ -0,0 +1,79 @@
################################
#Задание1
sadd 192.168.0.1 user1
sadd 192.168.0.1 user2
sadd 192.168.0.2 user3
sadd 192.168.0.3 user4
sass 192.168.0.1 user4
sadd 192.168.0.1 user4
sadd 192.168.0.2 user2
smembers 192.168.0.1


################################
#Задание2
select 2
set user1 user1@mail.ru
set user2 user2@mail.ru
set user3 user3@mail.ru
set user4 user4@mail.ru
set user5 user5@mail.ru

#Получаем email пользователя
get user4

#Получаем hash таблицу
hset users:1 name "name1"
hset users:1 name "n1@n.ru"
hset users:2 name "name2"
hset users:2 name "n2@n.ru"
hset users:3 name "name3"
hset users:3 name "n3@n.ru"

hvals users:1
hkeys users:1


################################
#Задание3
db.shop.insert(
{
"id":1,
"name":"Intel Core i3-8100",
"description":"Процессор для настольных персональных компьютеров, основанных на платформе Intel.",
"price":7890,
"catalog_id":1,
"creates_at":"2019-11-24 10:00:00",
"update_at":"2019-11-24 10:00:00"
})
db.shop.insert(
{
"id":2,
"name":"Intel Core i5-7400",
"description":"Процессор для настольных персональных компьютеров, основанных на платформе Intel.",
"price":12700,
"catalog_id":1,
"creates_at":"2019-11-24 10:00:00",
"update_at":"2019-11-24 10:00:00"
})
db.shop.insert(
{
"id":3,
"name":"Gigabyte H310M S2H",
"description":"Материнская плата Gigabyte H310M S2H, H310, Socket 1151-V2, DDR4, mATX",
"price":4790,
"catalog_id":2,
"creates_at":"2019-11-24 10:00:00",
"update_at":"2019-11-24 10:00:00"
})

db.shop.insert(
{
"id":1,
"name":"Процессоры"
})
db.shop.insert(
{
"id":2,
"name":"Материнские платы"
})