Int.Elligence
Published © GPL3+

Smart Door Lock

It's a simulated door lock using cloud services and IoT.

IntermediateFull instructions provided3 days2,370
Smart Door Lock

Things used in this project

Hardware components

Raspberry Pi 3 Model B
Raspberry Pi 3 Model B
×1
RFID reader (generic)
×1
Buzzer
Buzzer
×1
PIR Motion Sensor (generic)
PIR Motion Sensor (generic)
×1
Camera Module
Raspberry Pi Camera Module
×1
LED (generic)
LED (generic)
×1
DHT11 Temperature & Humidity Sensor (4 pins)
DHT11 Temperature & Humidity Sensor (4 pins)
×1
Standard LCD - 16x2 White on Blue
Adafruit Standard LCD - 16x2 White on Blue
×1
Resistor 10k ohm
Resistor 10k ohm
×1
Jumper wires (generic)
Jumper wires (generic)
×1

Software apps and online services

MQTT
MQTT
AWS RDS
Amazon Web Services AWS RDS
Flask
AWS S3
Amazon Web Services AWS S3
AWS IoT
Amazon Web Services AWS IoT

Story

Read more

Schematics

Full Fritzing Diagram

The full Fritzing diagram for the project

Full tutorial

It's the full tutorial, packed with information.

Code

SQL File

SQL
This is the sql file required to help create your table
-- phpMyAdmin SQL Dump
-- version 4.2.12deb2+deb8u2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Aug 19, 2018 at 12:04 PM
-- Server version: 5.5.54-0+deb8u1
-- PHP Version: 5.6.29-0+deb8u1

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `CA1db`
--

-- --------------------------------------------------------

--
-- Table structure for table `cards`
--

CREATE TABLE IF NOT EXISTS `cards` (
`id` int(11) unsigned NOT NULL,
  `userId` varchar(50) DEFAULT NULL,
  `tagId` bigint(18) unsigned NOT NULL,
  `permission` int(10) NOT NULL,
  `added` varchar(50) NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `cards`
--

INSERT INTO `cards` (`id`, `userId`, `tagId`, `permission`, `added`) VALUES
(5, 'Alvin', 136486164126, 1, '23-06-2018 04:33:51'),
(7, 'Mandfred', 1364341751, 2, '26-06-2018 13:22:53');

-- --------------------------------------------------------

--
-- Table structure for table `readings`
--

CREATE TABLE IF NOT EXISTS `readings` (
`id` bigint(11) unsigned NOT NULL,
  `tagId` bigint(18) unsigned NOT NULL,
  `time` varchar(50) DEFAULT NULL,
  `action` int(2) unsigned NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=83 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `readings`
--

INSERT INTO `readings` (`id`, `tagId`, `time`, `action`) VALUES
(61, 136486164126, '23-06-2018 04:33:58', 1),
(62, 136486164126, '23-06-2018 04:35:20', 2),
(63, 136486164126, '24-06-2018 00:43:33', 1),
(64, 136486164126, '24-06-2018 00:49:29', 1),
(65, 136486164126, '24-06-2018 00:55:20', 1),
(66, 136486164126, '24-06-2018 03:04:01', 2),
(67, 136486164126, '24-06-2018 03:38:33', 1),
(68, 136486164126, '24-06-2018 04:09:13', 2),
(69, 136486164126, '24-06-2018 15:04:56', 1),
(70, 136486164126, '24-06-2018 15:08:23', 2),
(71, 136486164126, '24-06-2018 15:12:04', 1),
(72, 136486164126, '24-06-2018 15:12:51', 2),
(73, 136486164126, '24-06-2018 15:14:51', 1),
(74, 136486164126, '24-06-2018 23:07:56', 1),
(75, 136486164126, '25-06-2018 00:32:30', 1),
(76, 136486164126, '26-06-2018 13:06:33', 1),
(77, 136486164126, '26-06-2018 13:07:02', 2),
(78, 136486164126, '26-06-2018 13:07:30', 1),
(79, 136486164126, '26-06-2018 13:08:15', 2),
(80, 136486164126, '26-06-2018 13:12:02', 1),
(81, 136486164126, '26-06-2018 13:13:03', 2),
(82, 136486164126, '26-06-2018 13:15:36', 1);

-- --------------------------------------------------------

--
-- Table structure for table `tempdata`
--

CREATE TABLE IF NOT EXISTS `tempdata` (
`id` int(11) NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `temperature` int(11) NOT NULL,
  `humidity` int(11) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=530 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tempdata`
--

INSERT INTO `tempdata` (`id`, `date`, `temperature`, `humidity`) VALUES
(9, '2018-06-24 08:41:15', 26, 65),
(10, '2018-06-24 08:42:12', 26, 65),
(11, '2018-06-24 08:43:37', 26, 65),
(12, '2018-06-24 08:45:43', 26, 65),
(13, '2018-06-24 08:58:43', 26, 67),
(14, '2018-06-24 08:58:48', 26, 65),
(15, '2018-06-24 08:58:49', 26, 67),
(16, '2018-06-24 08:58:57', 26, 66),
(17, '2018-06-24 08:58:57', 26, 66),
(18, '2018-06-24 08:58:58', 26, 65),
(19, '2018-06-24 08:58:59', 26, 65),
(20, '2018-06-24 08:59:10', 26, 66),
(21, '2018-06-24 08:59:20', 26, 66),
(22, '2018-06-24 08:59:23', 26, 65),
(23, '2018-06-24 09:19:13', 26, 68),
(24, '2018-06-24 09:19:14', 27, 66),
(25, '2018-06-24 09:20:48', 26, 68),
(26, '2018-06-24 09:22:45', 26, 68),
(27, '2018-06-24 09:22:51', 26, 68),
(28, '2018-06-24 09:22:56', 26, 68),
(29, '2018-06-24 09:23:02', 27, 67),
(30, '2018-06-24 09:23:07', 26, 68),
(31, '2018-06-24 09:23:15', 26, 68),
(32, '2018-06-24 09:23:23', 26, 68),
(33, '2018-06-24 09:23:31', 27, 66),
(34, '2018-06-24 09:23:40', 26, 66),
(35, '2018-06-24 09:23:45', 26, 68),
(36, '2018-06-24 09:23:54', 26, 68),
(37, '2018-06-24 09:24:02', 26, 68),
(38, '2018-06-24 09:24:07', 26, 68),
(39, '2018-06-24 09:24:13', 26, 68),
(40, '2018-06-24 09:24:26', 26, 68),
(41, '2018-06-24 09:24:31', 26, 68),
(42, '2018-06-24 09:24:37', 26, 69),
(43, '2018-06-24 09:24:42', 26, 69),
(44, '2018-06-24 09:24:48', 26, 69),
(45, '2018-06-24 09:24:54', 26, 68),
(46, '2018-06-24 09:25:02', 26, 69),
(47, '2018-06-24 09:25:07', 26, 69),
(48, '2018-06-24 09:25:13', 26, 69),
(49, '2018-06-24 09:25:21', 26, 69),
(50, '2018-06-24 09:25:26', 26, 69),
(51, '2018-06-24 09:25:35', 26, 69),
(52, '2018-06-24 09:25:43', 26, 68),
(53, '2018-06-24 09:25:48', 26, 69),
(54, '2018-06-24 09:25:54', 26, 69),
(55, '2018-06-24 09:26:02', 26, 69),
(56, '2018-06-24 09:26:07', 27, 68),
(57, '2018-06-24 09:26:15', 26, 69),
(58, '2018-06-24 09:26:21', 27, 68),
(59, '2018-06-24 09:26:34', 27, 68),
(60, '2018-06-24 09:26:40', 26, 69),
(61, '2018-06-24 09:26:50', 26, 69),
(62, '2018-06-24 09:26:56', 26, 69),
(63, '2018-06-24 09:27:01', 26, 69),
(64, '2018-06-24 09:27:07', 26, 69),
(65, '2018-06-24 09:27:13', 27, 68),
(66, '2018-06-24 09:27:18', 26, 69),
(67, '2018-06-24 09:27:26', 26, 69),
(68, '2018-06-24 09:27:42', 26, 69),
(69, '2018-06-24 09:27:50', 26, 69),
(70, '2018-06-24 09:27:58', 26, 69),
(71, '2018-06-24 09:28:09', 26, 69),
(72, '2018-06-24 09:28:14', 27, 67),
(73, '2018-06-24 09:28:25', 26, 69),
(74, '2018-06-24 09:28:35', 26, 69),
(75, '2018-06-24 09:28:41', 26, 69),
(76, '2018-06-24 09:28:47', 27, 69),
(77, '2018-06-24 09:32:10', 26, 71),
(78, '2018-06-24 09:32:15', 26, 70),
(79, '2018-06-24 09:32:21', 26, 71),
(80, '2018-06-24 10:34:48', 26, 70),
(81, '2018-06-24 10:34:54', 26, 70),
(82, '2018-06-24 10:34:59', 26, 70),
(83, '2018-06-24 10:35:10', 26, 70),
(84, '2018-06-24 10:35:18', 26, 70),
(85, '2018-06-24 10:35:50', 26, 70),
(86, '2018-06-24 10:35:56', 26, 70),
(87, '2018-06-24 10:36:02', 26, 70),
(88, '2018-06-24 10:36:07', 26, 70),
(89, '2018-06-24 10:36:13', 26, 70),
(90, '2018-06-24 10:36:18', 26, 70),
(91, '2018-06-24 10:36:24', 26, 69),
(92, '2018-06-24 10:36:29', 26, 68),
(93, '2018-06-24 10:36:40', 26, 69),
(94, '2018-06-24 10:36:58', 26, 69),
(95, '2018-06-24 10:37:45', 26, 68),
(96, '2018-06-24 10:37:51', 26, 68),
(97, '2018-06-24 10:39:25', 26, 67),
(98, '2018-06-24 10:39:35', 26, 66),
(99, '2018-06-24 10:39:41', 26, 66),
(100, '2018-06-24 10:39:46', 26, 66),
(101, '2018-06-24 10:39:52', 26, 66),
(102, '2018-06-24 10:40:00', 26, 66),
(103, '2018-06-24 10:40:05', 26, 66),
(104, '2018-06-24 10:40:11', 26, 67),
(105, '2018-06-24 10:40:17', 26, 67),
(106, '2018-06-24 10:40:22', 26, 67),
(107, '2018-06-24 10:42:26', 26, 66),
(108, '2018-06-24 10:42:32', 26, 67),
(109, '2018-06-24 10:42:37', 26, 67),
(110, '2018-06-24 10:42:43', 26, 67),
(111, '2018-06-24 10:42:48', 26, 67),
(112, '2018-06-24 10:42:59', 26, 67),
(113, '2018-06-24 10:43:07', 26, 67),
(114, '2018-06-24 10:43:12', 26, 67),
(115, '2018-06-24 10:43:21', 26, 68),
(116, '2018-06-24 10:43:26', 26, 67),
(117, '2018-06-24 10:43:32', 26, 67),
(118, '2018-06-24 10:43:40', 26, 67),
(119, '2018-06-24 10:43:45', 18, 67),
(120, '2018-06-24 10:43:51', 26, 68),
(121, '2018-06-24 10:43:56', 26, 68),
(122, '2018-06-24 10:44:02', 26, 68),
(123, '2018-06-24 10:44:07', 26, 68),
(124, '2018-06-24 10:44:13', 26, 68),
(125, '2018-06-24 10:44:24', 26, 66),
(126, '2018-06-24 10:44:29', 26, 67),
(127, '2018-06-24 10:44:35', 26, 68),
(128, '2018-06-24 10:44:43', 26, 68),
(129, '2018-06-24 10:44:51', 26, 68),
(130, '2018-06-24 10:44:59', 26, 68),
(131, '2018-06-24 10:45:14', 26, 68),
(132, '2018-06-24 10:45:22', 26, 68),
(133, '2018-06-24 10:45:29', 26, 67),
(134, '2018-06-24 10:46:08', 26, 68),
(135, '2018-06-24 10:46:14', 26, 69),
(136, '2018-06-24 10:46:22', 26, 69),
(137, '2018-06-24 10:46:33', 26, 68),
(138, '2018-06-24 10:46:41', 26, 68),
(139, '2018-06-24 10:46:49', 26, 69),
(140, '2018-06-24 10:46:57', 26, 69),
(141, '2018-06-24 10:52:09', 26, 69),
(142, '2018-06-24 10:52:19', 26, 77),
(143, '2018-06-24 10:52:27', 26, 74),
(144, '2018-06-24 10:52:33', 26, 73),
(145, '2018-06-24 10:52:38', 26, 71),
(146, '2018-06-24 10:52:59', 26, 70),
(147, '2018-06-24 10:53:04', 26, 69),
(148, '2018-06-24 10:58:46', 26, 69),
(149, '2018-06-24 10:58:59', 26, 69),
(150, '2018-06-24 10:59:05', 26, 69),
(151, '2018-06-24 10:59:13', 26, 69),
(152, '2018-06-24 10:59:19', 26, 69),
(153, '2018-06-24 10:59:32', 26, 69),
(154, '2018-06-24 10:59:37', 26, 69),
(155, '2018-06-24 11:01:26', 26, 68),
(156, '2018-06-24 11:01:32', 26, 69),
(157, '2018-06-24 11:15:33', 27, 69),
(158, '2018-06-24 11:15:39', 26, 70),
(159, '2018-06-24 11:15:47', 26, 70),
(160, '2018-06-24 11:15:52', 26, 69),
(161, '2018-06-24 11:16:15', 26, 69),
(162, '2018-06-24 11:18:22', 26, 70),
(163, '2018-06-24 11:18:30', 26, 69),
(164, '2018-06-24 11:51:30', 26, 69),
(165, '2018-06-24 11:51:35', 26, 69),
(166, '2018-06-24 11:51:41', 26, 69),
(167, '2018-06-24 12:19:54', 26, 70),
(168, '2018-06-24 12:20:02', 26, 70),
(169, '2018-06-24 12:20:07', 26, 70),
(170, '2018-06-24 13:55:26', 27, 72),
(171, '2018-06-24 13:55:32', 26, 73),
(172, '2018-06-24 13:55:37', 26, 73),
(173, '2018-06-24 13:55:45', 26, 73),
(174, '2018-06-24 13:55:56', 26, 73),
(175, '2018-06-24 13:56:01', 26, 73),
(176, '2018-06-24 13:59:26', 26, 73),
(177, '2018-06-24 13:59:32', 26, 73),
(178, '2018-06-24 13:59:38', 26, 73),
(179, '2018-06-24 13:59:43', 26, 73),
(180, '2018-06-24 13:59:49', 26, 71),
(181, '2018-06-24 13:59:54', 26, 73),
(182, '2018-06-24 14:00:00', 26, 73),
(183, '2018-06-24 14:00:05', 26, 73),
(184, '2018-06-24 14:00:13', 26, 73),
(185, '2018-06-24 14:00:21', 26, 73),
(186, '2018-06-24 14:00:27', 26, 73),
(187, '2018-06-24 14:00:38', 26, 73),
(188, '2018-06-24 14:00:43', 26, 73),
(189, '2018-06-24 14:00:51', 26, 73),
(190, '2018-06-24 14:00:57', 26, 73),
(191, '2018-06-24 14:01:05', 26, 74),
(192, '2018-06-24 14:01:10', 26, 73),
(193, '2018-06-24 14:01:16', 26, 71),
(194, '2018-06-24 14:01:21', 26, 74),
(195, '2018-06-24 14:01:27', 26, 74),
(196, '2018-06-24 14:01:37', 26, 72),
(197, '2018-06-24 14:01:46', 26, 73),
(198, '2018-06-24 14:01:54', 26, 74),
(199, '2018-06-24 14:01:59', 26, 74),
(200, '2018-06-24 14:02:12', 26, 73),
(201, '2018-06-24 14:02:20', 26, 74),
(202, '2018-06-24 14:02:26', 26, 74),
(203, '2018-06-24 14:02:34', 26, 74),
(204, '2018-06-24 14:02:39', 26, 73),
(205, '2018-06-24 14:02:45', 26, 74),
(206, '2018-06-24 14:02:51', 26, 74),
(207, '2018-06-24 14:02:56', 26, 74),
(208, '2018-06-24 14:03:02', 26, 74),
(209, '2018-06-24 15:05:52', 26, 74),
(210, '2018-06-24 15:05:57', 26, 74),
(211, '2018-06-24 15:06:06', 26, 74),
(212, '2018-06-24 15:06:31', 26, 74),
(213, '2018-06-24 15:06:37', 26, 74),
(214, '2018-06-24 15:06:42', 26, 74),
(215, '2018-06-24 15:06:48', 26, 74),
(216, '2018-06-24 15:07:11', 26, 74),
(217, '2018-06-24 15:07:32', 26, 74),
(218, '2018-06-24 15:07:37', 26, 74),
(219, '2018-06-24 15:07:43', 26, 74),
(220, '2018-06-24 15:07:51', 26, 74),
(221, '2018-06-24 15:07:57', 26, 75),
(222, '2018-06-24 15:08:02', 26, 74),
(223, '2018-06-24 15:08:08', 26, 74),
(224, '2018-06-24 15:08:13', 26, 74),
(225, '2018-06-24 15:08:26', 26, 74),
(226, '2018-06-24 15:08:32', 26, 74),
(227, '2018-06-24 15:08:37', 26, 74),
(228, '2018-06-24 15:08:43', 26, 74),
(229, '2018-06-24 15:08:51', 26, 74),
(230, '2018-06-24 15:08:56', 26, 75),
(231, '2018-06-24 15:09:02', 26, 75),
(232, '2018-06-24 15:09:08', 26, 75),
(233, '2018-06-24 15:09:16', 26, 75),
(234, '2018-06-24 15:09:26', 26, 74),
(235, '2018-06-24 17:25:51', 0, 0),
(236, '2018-06-24 17:26:34', 0, 0),
(237, '2018-06-26 05:06:15', 22, 48),
(238, '2018-06-26 05:06:28', 22, 48),
(239, '2018-06-26 05:06:33', 22, 48),
(240, '2018-06-26 05:06:39', 22, 48),
(241, '2018-06-26 05:06:47', 22, 49),
(242, '2018-06-26 05:06:53', 22, 48),
(243, '2018-06-26 05:06:58', 22, 48),
(244, '2018-06-26 05:07:04', 22, 48),
(245, '2018-06-26 05:07:09', 22, 48),
(246, '2018-06-26 05:07:17', 22, 49),
(247, '2018-06-26 05:07:23', 22, 48),
(248, '2018-06-26 05:07:28', 22, 49),
(249, '2018-06-26 05:07:34', 22, 49),
(250, '2018-06-26 05:07:39', 22, 49),
(251, '2018-06-26 05:07:47', 22, 49),
(252, '2018-06-26 05:07:56', 23, 48),
(253, '2018-06-26 05:08:04', 23, 52),
(254, '2018-06-26 05:08:12', 23, 49),
(255, '2018-06-26 05:08:22', 23, 48),
(256, '2018-06-26 05:08:33', 23, 47),
(257, '2018-06-26 05:08:38', 23, 47),
(258, '2018-06-26 05:08:44', 23, 46),
(259, '2018-06-26 05:13:29', 23, 47),
(260, '2018-06-26 05:13:34', 23, 45),
(261, '2018-06-26 05:13:40', 23, 46),
(262, '2018-06-26 05:13:48', 23, 47),
(263, '2018-06-26 05:13:53', 23, 46),
(264, '2018-06-26 05:14:02', 23, 47),
(265, '2018-06-26 05:14:10', 23, 47),
(266, '2018-06-26 05:14:18', 23, 47),
(267, '2018-06-26 05:14:23', 23, 47),
(268, '2018-06-26 05:14:34', 23, 47),
(269, '2018-06-26 05:14:39', 23, 47),
(270, '2018-06-26 05:14:47', 23, 47),
(271, '2018-06-26 05:14:53', 23, 47),
(272, '2018-06-26 05:14:58', 23, 46),
(273, '2018-06-26 05:15:04', 23, 46),
(274, '2018-06-26 05:15:10', 23, 47),
(275, '2018-06-26 05:15:23', 23, 46),
(276, '2018-06-26 05:15:28', 23, 46),
(277, '2018-06-26 05:15:34', 23, 47),
(278, '2018-06-26 05:15:39', 23, 47),
(279, '2018-06-26 05:15:47', 23, 48),
(280, '2018-06-26 05:15:53', 23, 46),
(281, '2018-06-26 05:15:58', 23, 48),
(282, '2018-06-26 05:16:17', 23, 47),
(283, '2018-06-26 05:16:22', 23, 46),
(284, '2018-06-26 05:16:28', 23, 47),
(285, '2018-06-26 05:16:33', 23, 47),
(286, '2018-06-26 05:16:46', 23, 47),
(287, '2018-06-26 05:16:54', 23, 47),
(288, '2018-06-26 05:17:00', 23, 46),
(289, '2018-06-26 05:17:05', 23, 47),
(290, '2018-06-26 05:17:16', 23, 46),
(291, '2018-06-26 05:17:24', 23, 46),
(292, '2018-06-26 05:17:30', 23, 47),
(293, '2018-06-26 05:17:35', 23, 46),
(294, '2018-06-26 05:17:48', 23, 46),
(295, '2018-06-26 05:17:54', 23, 46),
(296, '2018-06-26 05:18:02', 23, 47),
(297, '2018-06-26 05:18:07', 23, 46),
(298, '2018-06-26 05:18:13', 23, 47),
(299, '2018-06-26 05:18:19', 23, 47),
(300, '2018-06-26 05:18:24', 23, 47),
(301, '2018-06-26 05:18:35', 23, 46),
(302, '2018-06-26 05:18:48', 23, 46),
(303, '2018-06-26 05:18:58', 23, 46),
(304, '2018-06-26 05:19:09', 23, 46),
(305, '2018-06-26 05:19:14', 23, 46),
(306, '2018-06-26 05:19:33', 23, 47),
(307, '2018-06-26 05:19:38', 23, 46),
(308, '2018-06-26 05:19:44', 23, 47),
(309, '2018-06-26 05:19:54', 23, 46),
(310, '2018-06-26 05:20:00', 23, 46),
(311, '2018-06-26 05:20:09', 23, 47),
(312, '2018-06-26 05:20:14', 23, 47),
(313, '2018-06-26 05:20:20', 23, 47),
(314, '2018-06-26 05:20:25', 23, 47),
(315, '2018-06-26 05:20:31', 23, 47),
(316, '2018-06-26 05:20:44', 23, 46),
(317, '2018-06-26 05:20:50', 23, 45),
(318, '2018-06-26 05:20:58', 23, 46),
(319, '2018-06-26 05:21:03', 23, 45),
(320, '2018-06-26 05:21:09', 23, 46),
(321, '2018-06-26 05:21:14', 23, 47),
(322, '2018-06-26 05:21:20', 23, 47),
(323, '2018-06-26 05:21:30', 23, 45),
(324, '2018-06-26 05:21:36', 23, 45),
(325, '2018-06-26 05:21:41', 23, 46),
(326, '2018-06-26 05:21:47', 23, 45),
(327, '2018-06-26 05:21:55', 23, 45),
(328, '2018-06-26 05:22:03', 23, 45),
(329, '2018-06-26 05:22:11', 23, 45),
(330, '2018-06-26 05:22:17', 23, 45),
(331, '2018-06-26 05:22:27', 23, 46),
(332, '2018-06-26 05:22:38', 23, 45),
(333, '2018-06-26 05:22:43', 23, 46),
(334, '2018-06-26 05:22:49', 23, 45),
(335, '2018-06-26 05:22:55', 23, 46),
(336, '2018-06-26 05:23:03', 23, 47),
(337, '2018-06-26 05:23:11', 23, 47),
(338, '2018-06-26 05:23:19', 23, 47),
(339, '2018-06-26 05:23:24', 23, 46),
(340, '2018-06-26 05:23:30', 23, 48),
(341, '2018-06-26 05:23:35', 23, 47),
(342, '2018-06-26 05:23:41', 23, 47),
(343, '2018-06-26 05:23:46', 23, 47),
(344, '2018-06-26 05:23:57', 23, 48),
(345, '2018-06-26 05:24:03', 23, 47),
(346, '2018-06-26 05:24:08', 23, 44),
(347, '2018-06-26 05:24:14', 23, 48),
(348, '2018-06-26 05:24:19', 23, 48),
(349, '2018-06-26 05:24:25', 23, 48),
(350, '2018-06-26 05:24:33', 23, 48),
(351, '2018-06-26 05:24:38', 23, 47),
(352, '2018-06-26 05:24:44', 23, 48),
(353, '2018-06-26 05:24:49', 23, 48),
(354, '2018-06-26 05:24:55', 23, 48),
(355, '2018-08-18 12:41:00', 0, 0),
(356, '2018-08-18 12:41:43', 0, 0),
(357, '2018-08-18 12:42:26', 0, 0),
(358, '2018-08-18 12:43:09', 0, 0),
(359, '2018-08-18 12:43:51', 0, 0),
(360, '2018-08-18 12:44:34', 0, 0),
(361, '2018-08-18 12:45:17', 0, 0),
(362, '2018-08-18 12:46:00', 0, 0),
(363, '2018-08-18 12:46:43', 0, 0),
(364, '2018-08-18 12:47:26', 0, 0),
(365, '2018-08-18 12:48:09', 0, 0),
(366, '2018-08-18 12:48:52', 0, 0),
(367, '2018-08-18 12:49:35', 0, 0),
(368, '2018-08-18 12:50:18', 0, 0),
(369, '2018-08-18 12:51:01', 0, 0),
(370, '2018-08-18 12:51:43', 0, 0),
(371, '2018-08-18 12:52:26', 0, 0),
(372, '2018-08-18 12:53:09', 0, 0),
(373, '2018-08-18 12:53:52', 0, 0),
(374, '2018-08-18 12:54:35', 0, 0),
(375, '2018-08-18 12:55:18', 0, 0),
(376, '2018-08-18 12:56:01', 0, 0),
(377, '2018-08-18 12:56:44', 0, 0),
(378, '2018-08-18 12:57:27', 0, 0),
(379, '2018-08-18 12:58:10', 0, 0),
(380, '2018-08-18 12:58:53', 0, 0),
(381, '2018-08-18 12:59:36', 0, 0),
(382, '2018-08-18 13:00:18', 0, 0),
(383, '2018-08-18 13:01:01', 0, 0),
(384, '2018-08-18 13:01:44', 0, 0),
(385, '2018-08-18 13:02:27', 0, 0),
(386, '2018-08-18 13:03:10', 0, 0),
(387, '2018-08-18 13:03:53', 0, 0),
(388, '2018-08-18 13:04:36', 0, 0),
(389, '2018-08-18 13:05:19', 0, 0),
(390, '2018-08-18 13:06:02', 0, 0),
(391, '2018-08-18 13:06:45', 0, 0),
(392, '2018-08-18 13:07:28', 0, 0),
(393, '2018-08-18 13:08:11', 0, 0),
(394, '2018-08-18 13:08:53', 0, 0),
(395, '2018-08-18 13:09:36', 0, 0),
(396, '2018-08-18 13:10:19', 0, 0),
(397, '2018-08-18 13:11:02', 0, 0),
(398, '2018-08-18 13:11:45', 0, 0),
(399, '2018-08-18 13:12:28', 0, 0),
(400, '2018-08-18 13:13:11', 0, 0),
(401, '2018-08-18 13:13:54', 0, 0),
(402, '2018-08-18 13:14:37', 0, 0),
(403, '2018-08-18 13:15:20', 0, 0),
(404, '2018-08-18 13:16:03', 0, 0),
(405, '2018-08-18 13:16:45', 0, 0),
(406, '2018-08-18 13:17:28', 0, 0),
(407, '2018-08-18 13:18:11', 0, 0),
(408, '2018-08-18 13:18:54', 0, 0),
(409, '2018-08-18 13:19:37', 0, 0),
(410, '2018-08-18 13:20:20', 0, 0),
(411, '2018-08-18 13:21:03', 0, 0),
(412, '2018-08-18 13:21:46', 0, 0),
(413, '2018-08-18 13:22:29', 0, 0),
(414, '2018-08-18 13:23:12', 0, 0),
(415, '2018-08-18 13:23:55', 0, 0),
(416, '2018-08-18 13:24:38', 0, 0),
(417, '2018-08-18 13:25:20', 0, 0),
(418, '2018-08-18 13:26:03', 0, 0),
(419, '2018-08-18 13:26:46', 0, 0),
(420, '2018-08-18 13:27:29', 0, 0),
(421, '2018-08-18 13:28:12', 0, 0),
(422, '2018-08-18 13:28:55', 0, 0),
(423, '2018-08-18 13:29:38', 0, 0),
(424, '2018-08-18 13:30:21', 0, 0),
(425, '2018-08-18 13:31:04', 0, 0),
(426, '2018-08-18 13:31:47', 0, 0),
(427, '2018-08-18 13:32:30', 0, 0),
(428, '2018-08-18 13:33:13', 0, 0),
(429, '2018-08-18 13:33:55', 0, 0),
(430, '2018-08-18 13:34:38', 0, 0),
(431, '2018-08-18 13:35:21', 0, 0),
(432, '2018-08-18 13:36:04', 0, 0),
(433, '2018-08-18 13:36:47', 0, 0),
(434, '2018-08-18 13:37:30', 0, 0),
(435, '2018-08-18 13:38:13', 0, 0),
(436, '2018-08-18 13:38:56', 0, 0),
(437, '2018-08-18 13:39:39', 0, 0),
(438, '2018-08-18 13:40:22', 0, 0),
(439, '2018-08-18 13:41:05', 0, 0),
(440, '2018-08-18 13:41:48', 0, 0),
(441, '2018-08-18 13:42:30', 0, 0),
(442, '2018-08-18 13:43:13', 0, 0),
(443, '2018-08-18 13:43:56', 0, 0),
(444, '2018-08-18 13:44:39', 0, 0),
(445, '2018-08-18 13:45:22', 0, 0),
(446, '2018-08-18 13:46:05', 0, 0),
(447, '2018-08-18 13:46:48', 0, 0),
(448, '2018-08-18 13:47:31', 0, 0),
(449, '2018-08-18 13:48:14', 0, 0),
(450, '2018-08-18 13:48:57', 0, 0),
(451, '2018-08-18 13:49:40', 0, 0),
(452, '2018-08-18 13:50:23', 0, 0),
(453, '2018-08-18 13:51:05', 0, 0),
(454, '2018-08-18 13:51:48', 0, 0),
(455, '2018-08-18 13:52:31', 0, 0),
(456, '2018-08-18 13:53:14', 0, 0),
(457, '2018-08-18 13:53:57', 0, 0),
(458, '2018-08-18 13:54:40', 0, 0),
(459, '2018-08-18 13:55:23', 0, 0),
(460, '2018-08-18 13:56:06', 0, 0),
(461, '2018-08-18 13:56:49', 0, 0),
(462, '2018-08-18 13:57:32', 0, 0),
(463, '2018-08-18 13:58:15', 0, 0),
(464, '2018-08-18 13:58:57', 0, 0),
(465, '2018-08-18 13:59:40', 0, 0),
(466, '2018-08-18 14:00:23', 0, 0),
(467, '2018-08-18 14:01:06', 0, 0),
(468, '2018-08-18 14:01:49', 0, 0),
(469, '2018-08-18 14:02:32', 0, 0),
(470, '2018-08-18 14:03:15', 0, 0),
(471, '2018-08-18 14:03:58', 0, 0),
(472, '2018-08-18 14:04:41', 0, 0),
(473, '2018-08-18 14:05:24', 0, 0),
(474, '2018-08-18 14:06:07', 0, 0),
(475, '2018-08-18 14:06:50', 0, 0),
(476, '2018-08-18 14:07:32', 0, 0),
(477, '2018-08-18 14:08:15', 0, 0),
(478, '2018-08-18 14:08:58', 0, 0),
(479, '2018-08-18 14:09:41', 0, 0),
(480, '2018-08-18 14:10:24', 0, 0),
(481, '2018-08-18 14:11:07', 0, 0),
(482, '2018-08-18 14:11:50', 0, 0),
(483, '2018-08-18 14:12:33', 0, 0),
(484, '2018-08-18 14:13:16', 0, 0),
(485, '2018-08-18 14:13:59', 0, 0),
(486, '2018-08-18 14:14:42', 0, 0),
(487, '2018-08-18 14:15:25', 0, 0),
(488, '2018-08-18 14:16:07', 0, 0),
(489, '2018-08-18 14:16:50', 0, 0),
(490, '2018-08-18 14:17:33', 0, 0),
(491, '2018-08-18 14:18:16', 0, 0),
(492, '2018-08-18 14:18:59', 0, 0),
(493, '2018-08-18 14:19:42', 0, 0),
(494, '2018-08-18 14:20:25', 0, 0),
(495, '2018-08-18 14:21:08', 0, 0),
(496, '2018-08-18 14:21:51', 0, 0),
(497, '2018-08-18 14:22:34', 0, 0),
(498, '2018-08-18 14:23:17', 0, 0),
(499, '2018-08-18 14:24:00', 0, 0),
(500, '2018-08-18 14:24:42', 0, 0),
(501, '2018-08-18 14:25:25', 0, 0),
(502, '2018-08-18 14:26:08', 0, 0),
(503, '2018-08-18 14:26:51', 0, 0),
(504, '2018-08-18 14:27:34', 0, 0),
(505, '2018-08-18 14:28:17', 0, 0),
(506, '2018-08-18 14:29:00', 0, 0),
(507, '2018-08-18 14:29:43', 0, 0),
(508, '2018-08-18 14:30:26', 0, 0),
(509, '2018-08-18 14:31:09', 0, 0),
(510, '2018-08-18 14:31:52', 0, 0),
(511, '2018-08-18 14:32:35', 0, 0),
(512, '2018-08-18 14:33:17', 0, 0),
(513, '2018-08-18 14:34:00', 0, 0),
(514, '2018-08-18 14:34:43', 0, 0),
(515, '2018-08-18 14:35:26', 0, 0),
(516, '2018-08-18 17:48:44', 0, 0),
(517, '2018-08-18 17:49:27', 0, 0),
(518, '2018-08-18 17:50:18', 0, 0),
(519, '2018-08-18 17:51:01', 0, 0),
(520, '2018-08-18 17:51:44', 0, 0),
(521, '2018-08-18 17:53:45', 0, 0),
(522, '2018-08-18 17:54:28', 0, 0),
(523, '2018-08-18 18:06:57', 0, 0),
(524, '2018-08-18 18:08:54', 0, 0),
(525, '2018-08-18 18:12:36', 0, 0),
(526, '2018-08-18 18:13:19', 0, 0),
(527, '2018-08-18 18:16:25', 0, 0),
(528, '2018-08-18 18:17:07', 0, 0),
(529, '2018-08-18 18:17:50', 0, 0);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `cards`
--
ALTER TABLE `cards`
 ADD PRIMARY KEY (`id`), ADD KEY `ix_cardId` (`id`);

--
-- Indexes for table `readings`
--
ALTER TABLE `readings`
 ADD PRIMARY KEY (`id`), ADD KEY `ix_id` (`id`);

--
-- Indexes for table `tempdata`
--
ALTER TABLE `tempdata`
 ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `cards`
--
ALTER TABLE `cards`
MODIFY `id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT for table `readings`
--
ALTER TABLE `readings`
MODIFY `id` bigint(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=83;
--
-- AUTO_INCREMENT for table `tempdata`
--
ALTER TABLE `tempdata`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=530;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

Full Source Code

Python
Just Extract and place in a folder
No preview (download only).

Credits

Int.Elligence

Int.Elligence

1 project • 0 followers

Comments

Add projectSign up / Login