Tag: python-3.x

Compare date of input type datetime with date in SQL using flask

I use this .html page to get input type datetime: And my .py code: my DB: DB Example I want to show only all data of ‘sessioncreate’ when only date of ‘sdate’ equal of today date How can i achieve that? Answer Use the DATE() function. This way you can convert the DATETIME in your datab…

What is the default limit for auto generated primary Column(Integer) in SQLAlchemy with FastAPI and MYSQL?

mysql orm python-3.x sql sqlalchemy

Currently, I’m using Python’s fastAPI with SQLAlchemy and MYSQL. I’ve defined an auto-generated primary column as shown below. What’s the maximum number that this column can hold? Currently, the DB grows by 10k records per day, and I clear 70% of it on the weekends. The number of recor…

SQLAlchemy Column Types As Generic (BIT Type)

python-3.x sql sqlalchemy

I am trying to list out the columns of each table in an MSSQL database. I can get them fine, but I need to turn them into generic types for use elsewhere. (Python types would be more ideal but not sure how to do that?) My code so far works until I come across a BIT type column. I get

python sqlite3 partial search

python python-3.x search sql sqlite

I want to do a partial search with python sqlite3. My initial query is: Then I tried using the LIKE keyword and string formatting to obtain partial search results for the title, like this: As in https://stackoverflow.com/a/20904256/13290801 This seems to do the trick for title, but now when searching on the o…

Incorrect syntax while accessing SQL table using Python

python-3.x sql sql-server

I’m trying to access a SQL Express database using Python, but I keep getting an incorrect syntax error. I’ve tried a few variations based of other examples I’ve seen, but nothing’s working. The error is pyodbc.ProgrammingError: (‘42000’, “[42000] [Microsoft][ODBC SQL …

How to get a first and last value of one column based on another column values

hiveql python-3.x sql

I have a data looks like below. I want to extract the value of the first and last “TS” column based on each “Col” column values (A, B, and C) when it changes. The expected output should be as follows Thanks for your help in advance! Answer This is a type of gaps-and-islands problem. Th…

IBM DB2 CAST AS VARCHAR versus Python Pandas to_datetime Function

db2 pandas parsing python-3.x sql

I have the line in a SQL file hitting an IBM DB2 database. For various reasons, I have to convert to VARCHAR, so leaving out the CAST is not an option. The problem is that this casting is choosing a very poor format. The result comes out like this: 2020-06-09-13.15.00.000000. We have the four-digit year with …