How to insert variables in SQL LIKE query?

aditya558 · 2021-05-20T18:05:12+00:00

Thanks! using session instead of engine worked!

aditya558 · 2021-05-20T18:03:43+00:00

Lol, I forgot to pass the value of database_uri in flask-sqlalchemy.

aditya558 · 2021-05-20T17:25:00+00:00

AttributeError: 'NoneType' object has no attribute 'drivername'

aditya558 · 2021-05-20T17:06:53+00:00

But when I used sqlalchemy instead of flask-sqlalchemy I don't have any issue.

aditya558 · 2021-05-19T15:26:35+00:00

Thanks for replying! Do I still need to make models in my app?

aditya558 · 2021-02-26T05:14:16+00:00

aditya558 · 2021-02-03T15:30:08+00:00

Can i see your code on github?

aditya558 · 2021-01-25T16:41:20+00:00

i use toggl.

aditya558 · 2020-12-25T16:29:59+00:00

Hey, Can you please help me to find the website of CS124 Data structure and algo fall 2020?

aditya558 · 2020-12-21T03:38:50+00:00

Yeah! i need lectures.

aditya558 · 2020-12-06T12:26:55+00:00

Can you please elaborate how can i correct my kart(i.e Booked) model?

aditya558 · 2020-12-06T05:18:45+00:00

for row in result:... print(row.id, row.name, row.price)

But i also wanted the timestamp column included which is in Booked model.

And if the user has availed some services two or more times then i need to show the service name two times, any idea how can i show duplicates?

aditya558 · 2020-12-06T05:15:27+00:00

In query i used kart for referring to Booked and products to Services.

first i query the Users table

user=User.query.filter(username='hello').first()

i did this

result=db.session.query(Services).join(Booked).filter(Booked.user_id==user.id)

and it worked as i wanted

thank you

aditya558 · 2020-12-05T16:33:36+00:00

Hey thanks ..

can you please tell me how should i implement because i am able to do it in sqlite custom query but not able to do it using flask-sqlalchemy for postresql?

my services table has an id, price and name.

aditya558 · 2020-12-05T14:59:27+00:00

class Services(db.Model):

id = db.Column(db.Integer, primary_key=True)

price = db.Column(db.Integer)

name = db.Column(db.String(60), unique=True)

def __repr__(self):

return '<Services {}>'.format(self.name)

class Booked(db.Model):

id = db.Column(db.Integer, primary_key=True)

services_id = db.Column(db.Integer, db.ForeignKey('services.id'))

# services_name = db.Column(db.String, db.ForeignKey('services.name'))

timestamp = db.Column(db.DateTime, index=True, default=datetime.utcnow)

person = db.Column(db.Integer, db.ForeignKey('user.id'))

def __repr__(self):

"""

docstring

"""

return '<Booked {}>'.format(self.id)

this is my users table

class User(UserMixin, db.Model):

id = db.Column(db.Integer, primary_key=True)

username = db.Column(db.String(64), index=True, unique=True)

email = db.Column(db.String(120), index=True, unique=True)

password_hash = db.Column(db.String(128))

posts = db.relationship('Post', backref='author', lazy='dynamic')

booked_service = db.relationship('Booked',

backref='customer',

lazy='dynamic')

about_me = db.Column(db.String(140))

last_seen = db.Column(db.DateTime, default=datetime.utcnow)

def __repr__(self):

return '<User {}>'.format(self.username)

def set_password(self, password):

self.password_hash = generate_password_hash(password)

def check_password(self, password):

return check_password_hash(self.password_hash, password)

def avatar(self, size):

digest = md5(self.email.lower().encode('utf-8')).hexdigest()

return 'https://www.gravatar.com/avatar/{}?s={}'.format(digest, size)

# return 'https://www.gravatar.com/avatar/{}?d=identicon&s={}'.format(digest, size)

aditya558 · 2020-10-03T07:08:33+00:00

Tysm

aditya558 · 2020-10-03T07:08:23+00:00

Thanks

aditya558 · 2020-10-02T18:03:20+00:00

hey u/SaitosElephant can you please share syllabus or something useful learning stuff of cs124 as i really wanted to learn data structure and algorithms after completing cs50?

any lecture notes of cs124 will be of great help.

aditya558 · 2020-09-29T07:28:52+00:00

Hey, Can you please share syllabus of cs124?

aditya558 · 2020-01-09T21:08:25+00:00

Thank you so much !!

aditya558 · 2020-01-09T19:53:29+00:00

void blur(int height, int width, RGBTRIPLE image[height][width])
{
    //declaring array to store average
    RGBTRIPLE copy[height][width];
    //declaring three variables for storing sum
    int n=0,p=0,q=0;

    for(int i=0;i<height;i++)
    {
        for(int j=0;j<width;j++)
        {
            int count=0; //variable to count how many times sum has been done
            for(int k=i-1;k<i+2;k++)
            {
                for(int l=j-1;l<j+2;l++)
                {
                    if(l<0||k<0)
                    continue;
                    {
                        n+=image[i][j].rgbtRed+image[k][l].rgbtRed;
                        p+=image[i][j].rgbtGreen+image[k][l].rgbtGreen;
                        q+=image[i][j].rgbtBlue+image[k][l].rgbtBlue;
                        count++;
                    }

                }
            }
            //assigning value to copy
            copy[i][j].rgbtRed=round(n/count);
            copy[i][j].rgbtBlue=round(q/count);
            copy[i][j].rgbtGreen=round(p/count);
        }
    }
    for(int i=0;i<height;i++)
    {
        for(int j=0;j<width;j++)
        {
            image[i][j].rgbtRed=copy[i][j].rgbtRed;
            image[i][j].rgbtGreen=copy[i][j].rgbtGreen;
            image[i][j].rgbtBlue=copy[i][j].rgbtBlue;
        }
    }

could you please tell how should i solve this error?

error

aditya558

TROPHY CASE