Database Setup

before using the linns data pipeline and its associated models, you need to set up the database where the product data will be stored follow these steps to configure and initialize the database 1\ install postgresql if you haven't already, install postgresql on your system you can download and install postgresql from the official website postgresql downloads https //www postgresql org/download/ 2\ create a database open a command prompt or terminal and log in to postgresql using a superuser account (usually "postgres") psql u postgres create a new database for the linns data pipeline (replace 'your database name' with your preferred database name) create database your database name; 3\ configure environment variables the pipeline relies on environment variables to establish a connection to the database ensure you have the following environment variables set username your database username password your database password db the name of the database you created in the previous step host the database host (usually localhost) 4\ initialize the database tables navigate to the directory where your project code is located run the python script to create the necessary tables in the database pythshell models/models py this script will use the sqlalchemy models to create the tables with the defined schema in the postgresql database 5\ verify the database you can use a postgresql client or command line tools like psql to verify that the tables have been created and populated correctly connect to your database using psql or your preferred postgresql client psql u your username d your database name list the tables in the database \dt this should display a list of tables including inventory , locations , stocklevels , and others, confirming that the database setup was successful with the database set up, you can now use the linns data pipeline to manage and analyze product data effectively view the models setup here product item models docid\ n5q1lsjsxc8rpqzvanb5x