import pandas as pd
import sqlite3


conn = sqlite3.connect("amazon.db")

def read_sql():
    df = pd.read_sql_query("select * from amazon_product;", conn)
    print(df)
    return df

def write_sql(id,link,product_title,product_price,category):
    c = conn.cursor()
    c.execute("INSERT INTO amazon_product VALUES "
              "(CURRENT_TIMESTAMP,id, link,product_title,product_price,category)")




00d05b3d4684069318426cb12edb8cc8f577b659
<mask token>


def read_sql():
    df = pd.read_sql_query('select * from amazon_product;', conn)
    print(df)
    return df


<mask token>

<mask token>


def read_sql():
    df = pd.read_sql_query('select * from amazon_product;', conn)
    print(df)
    return df


def write_sql(id, link, product_title, product_price, category):
    c = conn.cursor()
    c.execute(
        'INSERT INTO amazon_product VALUES (CURRENT_TIMESTAMP,id, link,product_title,product_price,category)'
        )

<mask token>
conn = sqlite3.connect('amazon.db')


def read_sql():
    df = pd.read_sql_query('select * from amazon_product;', conn)
    print(df)
    return df


def write_sql(id, link, product_title, product_price, category):
    c = conn.cursor()
    c.execute(
        'INSERT INTO amazon_product VALUES (CURRENT_TIMESTAMP,id, link,product_title,product_price,category)'
        )

import pandas as pd
import sqlite3
conn = sqlite3.connect('amazon.db')


def read_sql():
    df = pd.read_sql_query('select * from amazon_product;', conn)
    print(df)
    return df


def write_sql(id, link, product_title, product_price, category):
    c = conn.cursor()
    c.execute(
        'INSERT INTO amazon_product VALUES (CURRENT_TIMESTAMP,id, link,product_title,product_price,category)'
        )

import pandas as pd
import sqlite3


conn = sqlite3.connect("amazon.db")

def read_sql():
    df = pd.read_sql_query("select * from amazon_product;", conn)
    print(df)
    return df

def write_sql(id,link,product_title,product_price,category):
    c = conn.cursor()
    c.execute("INSERT INTO amazon_product VALUES "
              "(CURRENT_TIMESTAMP,id, link,product_title,product_price,category)")



