Code Duplication - antokish/Maintenance-Tracker - Measure and Improve Code Quality continuously with Scrutinizer

Code Duplication Length = 66-66 lines in 2 locations

migrate.py 1 location


from models import connect


def create_tables():
    """create tables in postgresql database"""
    commands = (
        """
        DROP TABLE IF EXISTS tb_users;
        CREATE TABLE tb_users(
            user_id SERIAL PRIMARY KEY,
            username VARCHAR(100) UNIQUE NOT NULL,
            firstname VARCHAR(50) NOT NULL,
            lastname VARCHAR(50) NOT NULL,
            password VARCHAR(255) NOT NULL,
            created_on TIMESTAMP NOT NULL,
            last_login TIMESTAMP
        )
        """
        ,
        """
        DROP TABLE IF EXISTS tb_request;
        CREATE TABLE tb_request(
            request_id SERIAL PRIMARY KEY,
            requestor VARCHAR(255) NOT NULL,
            email VARCHAR(100) NOT NULL,
            type VARCHAR(50) NOT NULL,
            status VARCHAR(50) NOT NULL,
            description TEXT,
            created_on TIMESTAMP NOT NULL
        )
        """
        ,
        """
        DROP TABLE IF EXISTS tb_admin;
        CREATE TABLE tb_admin(
            admin_id SERIAL PRIMARY KEY,
            username VARCHAR(100) UNIQUE NOT NULL,
            fullname VARCHAR(100) NOT NULL,
            password VARCHAR(255) NOT NULL,
            created_on TIMESTAMP NOT NULL,
            last_login TIMESTAMP
        )
        """
    )

    conn = None
    try:
        
        conn = psycopg2.connect(dbname='mtracker_db',user="antonio", password="pass.123")

        #create cursor
        cur = conn.cursor()
        
        #execute statement
        for command in commands:
            cur.execute(command)

        cur.close()

        #commit the changes
        conn.commit()

    except (Exception, psycopg2.DatabaseError) as error:
        print(error)
    finally:
        if conn is not None:
            conn.close()
    
    return "Tables user, request and admin created succesfully"
        

if __name__ == '__main__':

tests/models.py 1 location


from models import connect


def create_tables():
    """create tables in postgresql database"""
    commands = (
        """
        DROP TABLE IF EXISTS tb_users;
        CREATE TABLE tb_users(
            user_id SERIAL PRIMARY KEY,
            username VARCHAR(100) UNIQUE NOT NULL,
            firstname VARCHAR(50) NOT NULL,
            lastname VARCHAR(50) NOT NULL,
            password VARCHAR(255) NOT NULL,
            created_on TIMESTAMP NOT NULL,
            last_login TIMESTAMP
        )
        """
        ,
        """
        DROP TABLE IF EXISTS tb_request;
        CREATE TABLE tb_request(
            request_id SERIAL PRIMARY KEY,
            requestor VARCHAR(255) NOT NULL,
            email VARCHAR(100) NOT NULL,
            type VARCHAR(50) NOT NULL,
            status VARCHAR(50) NOT NULL,
            description TEXT,
            created_on TIMESTAMP NOT NULL
        )
        """
        ,
        """
        DROP TABLE IF EXISTS tb_admin;
        CREATE TABLE tb_admin(
            admin_id SERIAL PRIMARY KEY,
            username VARCHAR(100) UNIQUE NOT NULL,
            fullname VARCHAR(100) NOT NULL,
            password VARCHAR(255) NOT NULL,
            created_on TIMESTAMP NOT NULL,
            last_login TIMESTAMP
        )
        """
    )

    conn = None
    try:
        
        conn = psycopg2.connect(dbname='test_db',user="antonio", password="pass.123")

        #create cursor
        cur = conn.cursor()
        
        #execute statement
        for command in commands:
            cur.execute(command)

        cur.close()

        #commit the changes
        conn.commit()

    except (Exception, psycopg2.DatabaseError) as error:
        print(error)
    finally:
        if conn is not None:
            conn.close()
    
    return "Tables user, request and admin created succesfully"
        

if __name__ == '__main__':

		@@ 6-71 (lines=66) @@
3		from models import connect
4
5
6		def create_tables():
7		"""create tables in postgresql database"""
8		commands = (
9		"""
10		DROP TABLE IF EXISTS tb_users;
11		CREATE TABLE tb_users(
12		user_id SERIAL PRIMARY KEY,
13		username VARCHAR(100) UNIQUE NOT NULL,
14		firstname VARCHAR(50) NOT NULL,
15		lastname VARCHAR(50) NOT NULL,
16		password VARCHAR(255) NOT NULL,
17		created_on TIMESTAMP NOT NULL,
18		last_login TIMESTAMP
19		)
20		"""
21		,
22		"""
23		DROP TABLE IF EXISTS tb_request;
24		CREATE TABLE tb_request(
25		request_id SERIAL PRIMARY KEY,
26		requestor VARCHAR(255) NOT NULL,
27		email VARCHAR(100) NOT NULL,
28		type VARCHAR(50) NOT NULL,
29		status VARCHAR(50) NOT NULL,
30		description TEXT,
31		created_on TIMESTAMP NOT NULL
32		)
33		"""
34		,
35		"""
36		DROP TABLE IF EXISTS tb_admin;
37		CREATE TABLE tb_admin(
38		admin_id SERIAL PRIMARY KEY,
39		username VARCHAR(100) UNIQUE NOT NULL,
40		fullname VARCHAR(100) NOT NULL,
41		password VARCHAR(255) NOT NULL,
42		created_on TIMESTAMP NOT NULL,
43		last_login TIMESTAMP
44		)
45		"""
46		)
47
48		conn = None
49		try:
50
51		conn = psycopg2.connect(dbname='mtracker_db',user="antonio", password="pass.123")
52
53		#create cursor
54		cur = conn.cursor()
55
56		#execute statement
57		for command in commands:
58		cur.execute(command)
59
60		cur.close()
61
62		#commit the changes
63		conn.commit()
64
65		except (Exception, psycopg2.DatabaseError) as error:
66		print(error)
67		finally:
68		if conn is not None:
69		conn.close()
70
71		return "Tables user, request and admin created succesfully"
72
73
74		if __name__ == '__main__':

antokish / Maintenance-Tracker

Code Duplication Length = 66-66 lines in 2 locations

migrate.py 1 location

tests/models.py 1 location