i have a database which has two thing in my database, name of a fruit and how long is it in the freezer. when i use rows will actually show the name of the fruit, time in freezer and the amount of fruit in batch How do i separate this, so that Or at least tell me how do i
Tag: python
How to access attached database’s tables using python’s sqlite3?
I am attempting to attach a second database to an sqlite3 connection to a database. However when I attempt to retrieve the tables from the connected database sqlite crashes as there is no such table. Even though the PRAGMA database_list sqlite command displays the connected database file, implying that the at…
Google Bigquery SQL with clause `where 1=0` is not returning correct schema
I recently added a new column in my BigQuery Table. The following code snippet is used in legacy code to determine the table schema But the problem is that it is not returning the newly added column in the df. Although when I use some other condition like 1=3 in where clause or limit 0 then it returns the cor…
Case in Sqlalchemy hybrid_property / expression error
I want to use expressions is ORM queries like this. Profile.query.filter(Profile.complete).all() Where complete is a calculated field Sqlalchemy docs shows the below So i’ve attempted to copy it with the following. But the output sql query is as below – the case isn’t compared agaisnt anythi…
PyOrient client.command(“SELECT X FROM Protein”) seems to always return the internal ID of the record (Studio returns the property)
I am trying to develop python programs to set up a multi-omics graph database in OrientDB, starting with the gene-transcript-protein relations from Ensembl. A completely unexpected problem I have run into is that the python interface (pyorient/pyorientdb),for queries like client.command(“SELECT uID FROM…
python function parameter control
I have a function called “getBooks”, and this function is actually a combination of 2 functions. one function must work without taking the ‘name’ parameter, the other must work by taking the ‘name’ parameter because i have to change the sql template according to the ‘…
Python – Printing output into a SQL Table
I have a python script that can extract the metadata from pictures in a directory. As of right now they go into a text file in table format and the current output looks like this: Here is the current script I have: The script opens the directory and for each photo it takes the filename, size, type, height, wi…
Pyspark, iteratively get values from column containing json string
I wonder how you would iteratively get the values from a json string in pyspark. I have the following format of my data and would like to create the “value” column: id_1 id_2 json_string value 1 1001 {“1001”:106, “2200”:101} 106 1 2200 {“1001”:106, “2200&#…
python how to write an update sql query?
I am trying to write an update query but I could not manage the string. My connections is ok. My query is like this: This is giving me error: undefined column name ‘hello’. I want to update message column as hello but it is getting it as a column name. In sql, when I write it as UPDATE users SET
ValueError when reading dates from hfsql database using ODBC
With some struggles I connected to a hfsql server using ODBC. I’ve tried both pypyodbc and pyodbc. My goal is to get some insights in the data (and visualize some aspects). For some planning visualization I need to read out some of the data, which works fine for most tables and columns. However, when I …