2026-06-25 11:00:09 [scrapy.utils.log] INFO: Scrapy 2.12.0 started (bot: SwiggyOutletOnOff) 2026-06-25 11:00:09 [scrapy.utils.log] INFO: Versions: lxml 6.0.2.0, libxml2 2.14.6, cssselect 1.3.0, parsel 1.10.0, w3lib 2.3.1, Twisted 25.5.0, Python 3.12.3 (main, Mar 23 2026, 19:04:32) [GCC 13.3.0], pyOpenSSL 25.1.0 (OpenSSL 3.5.2 5 Aug 2025), cryptography 45.0.6, Platform Linux-6.17.0-1013-aws-x86_64-with-glibc2.39 2026-06-25 11:00:09 [scrapy.addons] INFO: Enabled addons: [] 2026-06-25 11:00:09 [asyncio] DEBUG: Using selector: EpollSelector 2026-06-25 11:00:09 [scrapy.utils.log] DEBUG: Using reactor: twisted.internet.asyncioreactor.AsyncioSelectorReactor 2026-06-25 11:00:09 [scrapy.utils.log] DEBUG: Using asyncio event loop: asyncio.unix_events._UnixSelectorEventLoop 2026-06-25 11:00:09 [scrapy.utils.log] DEBUG: Using reactor: twisted.internet.asyncioreactor.AsyncioSelectorReactor 2026-06-25 11:00:09 [scrapy.utils.log] DEBUG: Using asyncio event loop: asyncio.unix_events._UnixSelectorEventLoop 2026-06-25 11:00:09 [scrapy.extensions.telnet] INFO: Telnet Password: 80be2b49cd1298c4 2026-06-25 11:00:09 [scrapy.middleware] INFO: Enabled extensions: ['scrapy.extensions.corestats.CoreStats', 'scrapy.extensions.telnet.TelnetConsole', 'scrapy.extensions.memusage.MemoryUsage', 'scrapy.extensions.logstats.LogStats'] 2026-06-25 11:00:09 [scrapy.crawler] INFO: Overridden settings: {'BOT_NAME': 'SwiggyOutletOnOff', 'FEED_EXPORT_ENCODING': 'utf-8', 'LOG_FILE': '/home/ubuntu/logs/SwiggyOutletOnOff/swiggy_outlet_on_off/06cd9bcd708511f1be230aab37b1cebd.log', 'NEWSPIDER_MODULE': 'SwiggyOutletOnOff.spiders', 'SPIDER_MODULES': ['SwiggyOutletOnOff.spiders'], 'TWISTED_REACTOR': 'twisted.internet.asyncioreactor.AsyncioSelectorReactor'} 2026-06-25 11:00:09 [scrapy.middleware] INFO: Enabled downloader middlewares: ['scrapy.downloadermiddlewares.offsite.OffsiteMiddleware', 'scrapy.downloadermiddlewares.httpauth.HttpAuthMiddleware', 'scrapy.downloadermiddlewares.downloadtimeout.DownloadTimeoutMiddleware', 'scrapy.downloadermiddlewares.defaultheaders.DefaultHeadersMiddleware', 'scrapy.downloadermiddlewares.useragent.UserAgentMiddleware', 'scrapy.downloadermiddlewares.retry.RetryMiddleware', 'scrapy.downloadermiddlewares.redirect.MetaRefreshMiddleware', 'scrapy.downloadermiddlewares.httpcompression.HttpCompressionMiddleware', 'scrapy.downloadermiddlewares.redirect.RedirectMiddleware', 'scrapy.downloadermiddlewares.cookies.CookiesMiddleware', 'scrapy.downloadermiddlewares.httpproxy.HttpProxyMiddleware', 'scrapy.downloadermiddlewares.stats.DownloaderStats'] 2026-06-25 11:00:09 [scrapy.middleware] INFO: Enabled spider middlewares: ['scrapy.spidermiddlewares.httperror.HttpErrorMiddleware', 'scrapy.spidermiddlewares.referer.RefererMiddleware', 'scrapy.spidermiddlewares.urllength.UrlLengthMiddleware', 'scrapy.spidermiddlewares.depth.DepthMiddleware'] 2026-06-25 11:00:09 [scrapy.middleware] INFO: Enabled item pipelines: ['SwiggyOutletOnOff.pipelines.SwiggyoutletonoffPipeline'] 2026-06-25 11:00:09 [scrapy.core.engine] INFO: Spider opened 2026-06-25 11:00:09 [scrapy.extensions.logstats] INFO: Crawled 0 pages (at 0 pages/min), scraped 0 items (at 0 items/min) 2026-06-25 11:00:09 [scrapy.extensions.telnet] INFO: Telnet console listening on 127.0.0.1:6025 2026-06-25 11:00:09 [scrapy.core.engine] DEBUG: Crawled (200) (referer: https://partner-self-client.swiggy.com/) 2026-06-25 11:00:09 [py.warnings] WARNING: /home/ubuntu/eggs/SwiggyOutletOnOff/1782378550.egg/SwiggyOutletOnOff/spiders/swiggy_outlet_on_off.py:128: UserWarning: pandas only supports SQLAlchemy connectable (engine/connection) or database string URI or sqlite3 DBAPI2 connection. Other DBAPI2 objects are not tested. Please consider using SQLAlchemy. comp_response = pd.read_sql_query(comp_query, self.conn) 2026-06-25 11:00:10 [scrapy.core.engine] DEBUG: Crawled (200) (referer: https://vhc-composer.swiggy.com/) 2026-06-25 11:00:10 [scrapy.core.scraper] DEBUG: Scraped from <200 https://rms.swiggy.com/restaurant/availability/v2> None 2026-06-25 11:00:10 [scrapy.core.scraper] DEBUG: Scraped from <200 https://rms.swiggy.com/restaurant/availability/v2> None 2026-06-25 11:00:10 [scrapy.core.scraper] DEBUG: Scraped from <200 https://rms.swiggy.com/restaurant/availability/v2> None 2026-06-25 11:00:10 [scrapy.core.scraper] DEBUG: Scraped from <200 https://rms.swiggy.com/restaurant/availability/v2> None 2026-06-25 11:00:10 [scrapy.core.scraper] DEBUG: Scraped from <200 https://rms.swiggy.com/restaurant/availability/v2> None 2026-06-25 11:00:10 [scrapy.core.scraper] DEBUG: Scraped from <200 https://rms.swiggy.com/restaurant/availability/v2> None 2026-06-25 11:00:10 [scrapy.core.scraper] DEBUG: Scraped from <200 https://rms.swiggy.com/restaurant/availability/v2> None 2026-06-25 11:00:10 [scrapy.core.scraper] DEBUG: Scraped from <200 https://rms.swiggy.com/restaurant/availability/v2> None 2026-06-25 11:00:10 [scrapy.core.scraper] DEBUG: Scraped from <200 https://rms.swiggy.com/restaurant/availability/v2> None 2026-06-25 11:00:10 [scrapy.core.engine] INFO: Closing spider (finished) 2026-06-25 11:00:10 [scrapy.statscollectors] INFO: Dumping Scrapy stats: {'downloader/request_bytes': 2507, 'downloader/request_count': 2, 'downloader/request_method_count/POST': 2, 'downloader/response_bytes': 35544, 'downloader/response_count': 2, 'downloader/response_status_count/200': 2, 'elapsed_time_seconds': 0.820603, 'finish_reason': 'finished', 'finish_time': datetime.datetime(2026, 6, 25, 11, 0, 10, 344037, tzinfo=datetime.timezone.utc), 'httpcompression/response_bytes': 150649, 'httpcompression/response_count': 2, 'item_scraped_count': 9, 'items_per_minute': None, 'log_count/DEBUG': 16, 'log_count/INFO': 10, 'log_count/WARNING': 1, 'memusage/max': 130412544, 'memusage/startup': 130412544, 'request_depth_max': 1, 'response_received_count': 2, 'responses_per_minute': None, 'scheduler/dequeued': 2, 'scheduler/dequeued/memory': 2, 'scheduler/enqueued': 2, 'scheduler/enqueued/memory': 2, 'start_time': datetime.datetime(2026, 6, 25, 11, 0, 9, 523434, tzinfo=datetime.timezone.utc)} 2026-06-25 11:00:10 [scrapy.core.engine] INFO: Spider closed (finished)