C#•2y ago

how to move json datas to mysql

I have few datas which stored in user_activity.json I need to move them to the mysql and I need to use them in my controller. In screenshots you can see the type of data and also I created a model like this.

Pobiega•3/27/24, 10:50 AM

is this a one-time thing or on an interval or triggered via an event?

Pobiega•3/27/24, 10:50 AM

Are you using EF Core for MySQL, or just straight ADO.NET?

Pobiega•3/27/24, 10:53 AM

Regardless, most of the code will be similar. Deserialize the JSON, your models seem to be for that already, then map each event to the corresponding datatype for your MySQL table, and insert it

Pobiega•3/27/24, 10:53 AM

the insert step might look a bit different depending on how you talk to the database

only you knowOP•3/27/24, 10:57 AM

one time thing I think I have the data i'll import to the mysql and for example I'll use it for getting custom methods like user1's total activity of 1 month, how many logins logouts username changes.

only you knowOP•3/27/24, 10:57 AM

I'll use ado.net

Pobiega•3/27/24, 10:57 AM

then make a console app, that just does this in 3 steps

Pobiega•3/27/24, 10:58 AM

step 1: deserialize the json
step 2: map from json models to database models, if they differ at all (likely)
step 3: insert to DB

only you knowOP•3/27/24, 10:59 AM

but I need to do it as api

Pobiega•3/27/24, 10:59 AM

it makes no sense as an API, its a one time thing

only you knowOP•3/27/24, 11:00 AM

first I'll move everything to db then created my model and it'll goes like service and controller

only you knowOP•3/27/24, 11:00 AM

isn't like this?

only you knowOP•3/27/24, 11:01 AM

I won't add anything but i need to use these datas with my program

Pobiega•3/27/24, 11:01 AM

the database is a separate thing

Pobiega•3/27/24, 11:02 AM

you know this right?

Pobiega•3/27/24, 11:02 AM

its has a life of its own

Pobiega•3/27/24, 11:02 AM

you can connect to the same database from multiple programs

Pobiega•3/27/24, 11:02 AM

so you can have an API for accessing this data, and the console app for reading the JSON and inserting it

only you knowOP•3/27/24, 11:02 AM

oh you say console for just moving datas to db

Pobiega•3/27/24, 11:02 AM

yes.

only you knowOP•3/27/24, 11:03 AM

so my program doesn't need to contain these kinda codes

only you knowOP•3/27/24, 11:03 AM

got you now

Pobiega•3/27/24, 11:03 AM

yeah, its not part of the API. just uses the same data

PPobiega then make a console app, that just does this in 3 steps

only you knowOP•3/27/24, 11:04 AM

so I'll follow this steps

Pobiega•3/27/24, 11:05 AM

only you knowOP•3/27/24, 11:25 AM

@Pobiega how does it look?

Pobiega•3/27/24, 11:59 AM

looks okay. A bit too OOP for my tastes

Pobiega•3/27/24, 11:59 AM

I'd personally have separates the concerns a bit, so that reading and writing were two distinct steps, but it does the exact same thing

only you knowOP•3/27/24, 12:06 PM

anyway it doesn't work

only you knowOP•3/27/24, 12:06 PM

Pobiega•3/27/24, 12:07 PM

you. uhh..

Pobiega•3/27/24, 12:07 PM

I dont think it handles enums for you

Pobiega•3/27/24, 12:07 PM

so you gotta manually cast that enum to whatever format you want. int/string

only you knowOP•3/27/24, 12:07 PM

I even tried like this

Pobiega•3/27/24, 12:08 PM

cast the enum

Pobiega•3/27/24, 12:08 PM

only you knowOP•3/27/24, 12:09 PM

still same i guess

only you knowOP•3/27/24, 12:09 PM

only you knowOP•3/27/24, 12:10 PM

are there mistakes here?

only you knowOP•3/27/24, 12:13 PM

what do you think about this?

only you knowOP•3/27/24, 12:15 PM

it's working in this way

only you knowOP•3/27/24, 12:16 PM

but I think I made mistake while mapping

only you knowOP•3/27/24, 12:17 PM

cuz I have 10 users and I want to collect their activities but there are so many Id's

only you knowOP•3/27/24, 12:19 PM

should I a column as UserId and keep the activity id still or change the all Id's as user Id

Pobiega•3/27/24, 12:23 PM

ah, seems as if your database is treating enums as strings?

only you knowOP•3/27/24, 12:24 PM

yes

only you knowOP•3/27/24, 12:24 PM

but as you see I couldn't manage to classify activites by users

only you knowOP•3/27/24, 12:30 PM

there are so many usernames but all of them belongs to 10 user so I need to add "Id" as userId right

Pobiega•3/27/24, 12:30 PM

I dont know what data you have or not have mate