modules.logging.delete_old() - Code Metrics - Inspection of "logger" - MadiNyan/rikka-telegram-bot - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — master ( 9dd95f...75b147 )

by Anas

created 2018-07-31 14:10 UTC

modules.logging.delete_old() A

↳ Parent: modules.logging

Complexity

Conditions

Size

Total Lines	12
Code Lines	12

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
cc	3
eloc	12
nop	2
dl	0
loc	12
rs	9.8
c	0
b	0
f	0

#!/usr/bin/python
# -*- coding: utf-8 -*-
from datetime import datetime, timedelta

import threading
import sqlite3


def module_init(gd):
    global c, conn, db_lock
    db_lock = threading.Lock()
    path = gd.config["path"]
    conn  = sqlite3.connect(path+"rikka.db", check_same_thread=False) 
    c = conn.cursor()


def data_entry(table, entry_columns, values):
    values_count = ("?, "*len(values))[:-2]
    db_lock.acquire()

    c.execute("INSERT INTO "+table+" ("+entry_columns+") VALUES ("+values_count+")", (values))

    conn.commit()

    db_lock.release()


def check_entry(chat_id, table):
    c.execute("SELECT chat_id FROM "+table+" WHERE chat_id = %s" %(chat_id))

    if c.fetchone() is not None:
        return True
    else:
        return False


def get_chat_info(bot, update):
    if update.callback_query is not None:
        user_name = update.callback_query.message.chat.username
        chat_id = update.callback_query.message.chat_id
        user_id = update.callback_query.from_user.id
    else:
        user_name = update.effective_message.from_user.name[1:]
        chat_id = update.effective_message.chat_id
        user_id = update.effective_message.from_user.id
    chat = bot.getChat(chat_id)
    return chat_id, chat.title, user_id, user_name


def log_command(bot, update, date, command):
    table_name = "commands"
    entry_columns = "date, user_id, user, command, chat_id, chat_title" 
    chat_id, chat_title, user_id, user = get_chat_info(bot, update)
    values = [date, user_id, user, command, chat_id, chat_title]
    data_entry(table_name, entry_columns, values)


def vk(bot, update):
    current_time = datetime.strftime(datetime.now(), "%d.%m.%Y %H:%M:%S")
    table_name = "vk"
    entry_columns = "date, unixtime, post_id"
    values = [0, 0, 0]
    c.execute("SELECT unixtime FROM vk ORDER BY rowid DESC LIMIT 1")

    fetch = c.fetchone()
    if fetch is not None:
        old_date = int(fetch[0])
        return current_time, old_date
    else:
        data_entry(table_name, entry_columns, values)
        return current_time, 0


def vk_add(bot, update, date, unixtime, post_id):
    table_name = "vk"
    entry_columns = "date, unixtime, post_id"
    values = [date, unixtime, post_id]
    data_entry(table_name, entry_columns, values)


1			#!/usr/bin/python
2			# -- coding: utf-8 --
3			from datetime import datetime, timedelta
			0 ignored issues – show Unused Code introduced 2018-07-31 14:12 UTC by Report Bug Copy Issue Report Unused timedelta imported from datetime Loading history...
4			import threading
5			import sqlite3
6
7
8			def module_init(gd):
9			global c, conn, db_lock
10			db_lock = threading.Lock()
11			path = gd.config["path"]
12			conn = sqlite3.connect(path+"rikka.db", check_same_thread=False)
13			c = conn.cursor()
14
15
16			def data_entry(table, entry_columns, values):
17			values_count = ("?, "*len(values))[:-2]
18			db_lock.acquire()
			0 ignored issues – show Comprehensibility Best Practice introduced 2018-07-12 13:29 UTC by Report Bug Copy Issue Report The variable `db_lock` does not seem to be defined. Loading history...
19			c.execute("INSERT INTO "+table+" ("+entry_columns+") VALUES ("+values_count+")", (values))
			0 ignored issues – show Comprehensibility Best Practice introduced 2018-07-12 13:29 UTC by Report Bug Copy Issue Report The variable `c` does not seem to be defined. Loading history...
20			conn.commit()
			0 ignored issues – show Comprehensibility Best Practice introduced 2018-07-12 13:29 UTC by Report Bug Copy Issue Report The variable `conn` does not seem to be defined. Loading history...
21			db_lock.release()
22
23
24			def check_entry(chat_id, table):
25			c.execute("SELECT chat_id FROM "+table+" WHERE chat_id = %s" %(chat_id))
			0 ignored issues – show Comprehensibility Best Practice introduced 2018-07-12 13:29 UTC by Report Bug Copy Issue Report The variable `c` does not seem to be defined. Loading history...
26			if c.fetchone() is not None:
27			return True
28			else:
29			return False
30
31
32			def get_chat_info(bot, update):
33			if update.callback_query is not None:
34			user_name = update.callback_query.message.chat.username
35			chat_id = update.callback_query.message.chat_id
36			user_id = update.callback_query.from_user.id
37			else:
38			user_name = update.effective_message.from_user.name[1:]
39			chat_id = update.effective_message.chat_id
40			user_id = update.effective_message.from_user.id
41			chat = bot.getChat(chat_id)
42			return chat_id, chat.title, user_id, user_name
43
44
45			def log_command(bot, update, date, command):
46			table_name = "commands"
47			entry_columns = "date, user_id, user, command, chat_id, chat_title"
48			chat_id, chat_title, user_id, user = get_chat_info(bot, update)
49			values = [date, user_id, user, command, chat_id, chat_title]
50			data_entry(table_name, entry_columns, values)
51
52
53			def vk(bot, update):
54			current_time = datetime.strftime(datetime.now(), "%d.%m.%Y %H:%M:%S")
55			table_name = "vk"
56			entry_columns = "date, unixtime, post_id"
57			values = [0, 0, 0]
58			c.execute("SELECT unixtime FROM vk ORDER BY rowid DESC LIMIT 1")
			0 ignored issues – show Comprehensibility Best Practice introduced 2018-07-12 13:29 UTC by Report Bug Copy Issue Report The variable `c` does not seem to be defined. Loading history...
59			fetch = c.fetchone()
60			if fetch is not None:
61			old_date = int(fetch[0])
62			return current_time, old_date
63			else:
64			data_entry(table_name, entry_columns, values)
65			return current_time, 0
66
67
68			def vk_add(bot, update, date, unixtime, post_id):
69			table_name = "vk"
70			entry_columns = "date, unixtime, post_id"
71			values = [date, unixtime, post_id]
72			data_entry(table_name, entry_columns, values)
73

MadiNyan / rikka-telegram-bot

Push — master ( 9dd95f...75b147 )

modules.logging.delete_old() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like