Database Module

Database operations for GS1 GPC.

This module provides functions for setting up and interacting with the database, including creating tables and inserting data.

class gs1_gpc.db.DatabaseConnection(connection_string, db_type='sqlite')

Bases: object

Database connection abstraction for SQLite and PostgreSQL.

__init__(connection_string, db_type='sqlite')

Initialize a database connection.

Parameters:

• connection_string (str) – Connection string or path to database file

• db_type (str) – Database type (‘sqlite’ or ‘postgresql’)

connect()

Connect to the database.

Returns:

(connection, cursor) or (None, None) on failure

Return type:

tuple

close()

Close the database connection.

commit()

Commit changes to the database.

rollback()

Rollback changes to the database.

gs1_gpc.db.setup_database(db_connection)

Create GPC tables if they don’t exist.

Parameters:

db_connection (DatabaseConnection) – Database connection object

Returns:

True if successful, False otherwise

Return type:

bool

gs1_gpc.db.insert_segment(cursor, segment_code, description)

Insert a segment record.

Parameters:

• cursor – Database cursor

• segment_code (str) – Segment code

• description (str) – Segment description

Returns:

True if successful, False otherwise

Return type:

bool

gs1_gpc.db.insert_family(cursor, family_code, description, segment_code)

Insert a family record.

Parameters:

• cursor – Database cursor

• family_code (str) – Family code

• description (str) – Family description

• segment_code (str) – Segment code

Returns:

True if successful, False otherwise

Return type:

bool

gs1_gpc.db.insert_class(cursor, class_code, description, family_code)

Insert a class record.

Parameters:

• cursor – Database cursor

• class_code (str) – Class code

• description (str) – Class description

• family_code (str) – Family code

Returns:

True if successful, False otherwise

Return type:

bool

gs1_gpc.db.insert_brick(cursor, brick_code, description, class_code)

Insert a brick record.

Parameters:

• cursor – Database cursor

• brick_code (str) – Brick code

• description (str) – Brick description

• class_code (str) – Class code

Returns:

True if successful, False otherwise

Return type:

bool

gs1_gpc.db.insert_attribute_type(cursor, att_type_code, att_type_text, brick_code)

Insert an attribute type record.

Parameters:

• cursor – Database cursor

• att_type_code (str) – Attribute type code

• att_type_text (str) – Attribute type description

• brick_code (str) – Brick code

Returns:

True if successful, False otherwise

Return type:

bool

gs1_gpc.db.insert_attribute_value(cursor, att_value_code, att_value_text, att_type_code)

Insert an attribute value record.

Parameters:

• cursor – Database cursor

• att_value_code (str) – Attribute value code

• att_value_text (str) – Attribute value description

• att_type_code (str) – Attribute type code

Returns:

True if successful, False otherwise

Return type:

bool