am quite new to flutter and my code is pretty much a mess but can anyone explain why db. update doesn't work, whenever I try to update it throws this error "error when trying to update"(https://i.stack.imgur.com/4cCdt.png) "code"(https://i.stack.imgur.com/yDoIl.png) "UI" (https://i.stack.imgur.com/HkahR.png) all…
I'm trying to add the numbers from the MongoDB database. meal_data = Data.objects.filter(year= se_year, month= se_month, category = 'Meal') meal_amt = 0 for i in meal_data: id = i.id m_amount_data = Data.objects.get(id = id) meal_amt += m_amount_data.amount TypeError: unsupported operand…
Schema for Event const eventSchema = new mongoose.Schema( { title: { type: String, required: true }, schedule: { type: Date, required: true }, organizer: { type: mongoose.Schema.Types.ObjectId, ref: "user", required: true }, }, { timestamps: true } ); Schema for…
I want to copy a Postgres table in CSV format from a network database to my computer. For example, here is its address psql postgresql://login:[email protected]:5432/test_table The problem is that I don't have superuser rights and I can't copy the table…
I’m using MySQL to make a table: CREATE TABLE school.student( Std_id INT NOT NULL AUTO_INCREMENT, Std_name CHAR(40) NOT NULL, Std_Birth DATE, Std_Group CHAR(2) check(Std_Group in ('G1', 'G2','G3','G4')) ); And I’m trying to make the auto increment start from 1000 and…
I am trying to create new documents from existing ones in one of my database's collections. I'm flattening one of the fields from the original document. The process worked perfectly when using mongosh, but now I have to run this…
$files = ['a','b','c','d','e','f']; $other = ['a','b','c','d','e','f']; foreach($files as $k => $file){ foreach($other as $key => $value){ $data = [ 'column1' => $file, 'column2' => $value, ]; if($file == $value){ return false }else{ DB::table('abed')->insert($data); } } } How to make combination…
I want to delete a column from a table in WordPress. I tried many ways but either they don't work or they delete the whole row. But I just want to remove the status column. I have a lot of…
I am trying to switch my Django database from SQLite3 to PostgreSQl, so I follow many tutorials to install and setup Postgres with Django project. I did the following: pip install psycopg2, pip install psycopg2-binary and I modified the settings.py…
Im new to the Golang language and im coming from Nodejs, where it was quite simple to access database and manipulate db within a http request handler.Now i want to do the same in Golang and i cant access the…