aveek22

select * from cs621labexam1;

--1
select * from cs621labexam1 where char_length(observer) > 9;

--2 
select * from cs621labexam1
where 1=1
and date_part('month', ts) = 01
and date_part('year', ts) = 2019

aveek22

import pandas as pd
import sqlalchemy

# Create the engine to connect to a PostgreSQL database
engine = sqlalchemy.create_engine('postgresql://aveek:test1234@localhost:5432/sql-shack-demo')

# Read data from the SQL Table
data = pd.read_csv('superstore.csv')

# Print first few rows of the dataframe

aveek22

from flask import Flask
from flask_restful import Api, Resource, reqparse
import pandas as pd

app = Flask(__name__)
api = Api(app)

class Users(Resource):
    def get(self):
        data = pd.read_csv('users.csv')

aveek22

from flask import Flask
from flask_restful import Api, Resource, reqparse
import pandas as pd

app = Flask(__name__)
api = Api(app)

aveek22

class Users(Resource):
    # Write method to fetch data from the CSV file
    def get(self):
        pass

    def post(self):
    # Write method to write data to the CSV file
        pass

    def delete(self):

aveek22

class Users(Resource):
    def get(self):
        data = pd.read_csv('users.csv')
        data = data.to_dict('records')
        return {'data' : data}, 200


    def post(self):
        parser = reqparse.RequestParser()
        parser.add_argument('name', required=True)

aveek22

if __name__ == '__main__':
    app.run()

aveek22

from flask import Flask
from flask_restful import Api, Resource, reqparse
import pandas as pd

app = Flask(__name__)
api = Api(app)

class Users(Resource):
    def get(self):
        data = pd.read_csv('users.csv')

aveek22

order,product,qty,amount
1,car,2,5000
2,bikes,1,2000
3,cookies,10,80
4,phone,1,5,300

aveek22

# imports the JSON library to work in python
import json

# assign the JSON data to a variable
json_data = """{
                "data": [
                    {
                        "type": "articles",
                        "id": "1",
                        "attributes": {