Database Documentation

This document specifies python-duplicate’s database package.

FromPSQL

class pyduplicate.database.from_psql.FromPSQL(info_dict: dict, table: str, column: str)

Handle search of duplicate or unique item inside a PostgreSQL table

Parameters

  • info_dict (dict) – Param to connect to PostgreSQL

  • table (str) – Param to select the right table

  • column (str) – Param to search duplicate or unique on

connect() → object

Connect to PostgreSQL (with information given to the class)

Returns

psycopg2 connection object

disconnect() → None

Disconnect of PostgreSQL

get_pk_name() → str
Returns

Primary key name

select_duplicate(rows_list: bool = False) → list
Parameters

rows_list – Boolean to return list of pk or rows

Returns

Duplicate entries

select_unique(rows_list: bool = False) → list
Parameters

rows_list – Boolean to return list of pk or rows

Returns

Unique entries

FromMySQL

class pyduplicate.database.from_mysql.FromMySQL(info_dict: dict, table: str, column: str)

Handle search of duplicate or unique item inside a MySQL table

Parameters

  • info_dict (dict) – Param to connect to MySQL

  • table (str) – Param to select the right table

  • column (str) – Param to search duplicate or unique on

connect() → object

Connect to MySQL (with information given to the class)

Returns

PyMySQL connection object

disconnect() → None

Disconnect of MySQL

get_pk_name() → str
Returns

Primary key name

select_duplicate(rows_list: bool = False) → list
Parameters

rows_list – Boolean to return list of pk or rows

Returns

Duplicate entries

select_unique(rows_list: bool = False) → list
Parameters

rows_list – Boolean to return list of pk or rows

Returns

Unique entries

Utils

Postgres

class pyduplicate.database.utils.Postgres(table: str, column: str)

Provides functions to query PostgreSQL

Parameters

  • table (str) – Param to select the right table

  • column (str) – Param to search duplicate or unique on

MySQL

class pyduplicate.database.utils.MySQL(table: str, column: str)

Provides functions to query MySQL

Parameters

  • table (str) – Param to select the right table

  • column (str) – Param to search duplicate or unique on