def create_promos():
create_promos_table = """
CREATE TABLE IF NOT EXISTS promos (
promoID SERIAL PRIMARY KEY,
name TEXT NOT NULL,
discount NUMERIC(12,6)
)
"""
postgres.execute_query(create_promos_table)
def create_taxes():
create_taxes_table = """
CREATE TABLE IF NOT EXISTS taxes (
taxID SERIAL PRIMARY KEY,
name TEXT NOT NULL,
rate NUMERIC(12,6)
)
"""
postgres.execute_query(create_taxes_table)
def create_products():
create_products_table = """
CREATE TABLE IF NOT EXISTS products (
barcode SERIAL PRIMARY KEY,
price NUMERIC(12,2),
name TEXT NOT NULL,
category TEXT,
promoID INTEGER,
taxID INTEGER
)
"""
postgres.execute_query(create_products_table)
def insert_row(table, columns, values):
assert len(columns) == len(values), ('Columns and values don\'t match')
values_str = str(values)[1:-1]
columns_str = str(columns)[1:-1].replace('\"', '').replace('\'', '')
insert_row = ('INSERT INTO ' + table + ' (' + columns_str + ') ' +
' VALUES (' + values_str + ')')
postgres.execute_query(insert_row)
def drop_promos():
drop_products_table = """
DROP TABLE IF EXISTS promos;
"""
postgres.execute_query(drop_products_table)