I'm trying to retrieve data from a database, and have made these two methods inside of a certain "TodoDB" class: Future<List<SurveyData>> fetchAll() async { final database = await DatabaseService().database; final survey = await database.rawQuery('''SELECT * from $tableName'''); return survey.map((survey) =>…
First, I set John to the user-defined variable @name as shown below: SET @name = 'John'; Then, I set David to @name in a transaction, then rollbacked as shown below: BEGIN; SET @name = 'David'; ROLLBACK; But, @name was not…
I am currently struggling with rendering some images on my React Native application. Currently, my app is connected to a database, which contains the image file names (ex: 'swipe1') that I want to render in my FlatList. However, it is…
I have a SQL database for maintaining D&D games which has tables for things like Characters, Items, and Locations. I want to start modelling the relationships between all these different entity types, such as the relationship a Character has with…
I would create a virtual model modelC (with no real table on the DB) as join between model modelA and model modelB. My need is to access to model modelC like a standard model and access to his attributes (modelA…
I have some values in my table like this, Main Table I want to select only those with the latest/highest date, The result will be like the picture in below: Result Table I already try with union but it didn't…
I have a table with these columns: event_time (date) event_data (json) player_account char() I'm trying to get all three fields from my query and groupBy by "player_account" field. The problem is doing this query: DB::connection('aa')-table('bb') ->where('event_time', ">", $date) ->select('event_time', 'event_data',…
Hello i am 2 days stuck trying to install POSTGRE SQL. Today it is on version 16 but already attempted versions 14, 13, 15.... It looks like the bindata folder, which is the db cluster folder, has some kind of…
I've accidentally named a view : "test..view". When I try to delete it now I get the following error : MongoInvalidArgumentError: Collection names cannot be empty I tried running the following command : db.getCollection("test..view").drop() I also tried to rename it…
I have a .sqlite file in a local folder. I would like to update all URLs in this SQLITE file across all tables, indicies, and rows. What is the best way to do this? In a regular sql file I…