Open pamflores-clip opened 4 days ago
Hello @pamflores-clip! I'm here to assist you with any bugs, questions, or contributions you may have. Let's work together to resolve your issue.
To delete all data in a project without deleting the actual project, you can use the "Collect Data in Full Refresh Mode." This mode will delete all existing data within the designated time range and re-collect it. Here are the steps:
This should remove the outdated or incorrect data and re-collect it from the original tools [1].
If you have already tried this and the data is still not updated, there might be an issue with the specific version you are using (v1.0.1-beta7@3f84bae). Unfortunately, I couldn't find any known issues or bugs related to the 'Collect Data in Full Refresh Mode' for this version [2].
As a workaround, you can manually delete specific records from the database using the Delete
method provided by the Dal interface. Here are the steps:
Delete
method from the Dal interface to delete the record.// Assuming you have a User model and you want to delete a user with a specific email
user := &models.User{
Email: "hello@example.com", // assuming this is the Primary key
}
err := db.Delete(user)
if err != nil {
// handle error
}
By following these steps and precautions, you can safely and effectively delete specific records from the database without using the UI.
To continue talking to Dosu, mention @dosu.
@pamflores-clip , thanks for reporting. We'll look at it.
Hi @pamflores-clip , In the database, the update_date field represents when the data itself was last updated, while the update_at field indicates when it was updated in the database. Could you check if the update_at field shows the time you were expecting? Thank you
Search before asking
What happened
I have a record in the DB that is not correctly updated. In github, this ticket has an updated date of september:
and in the DB the updated date is in march:
What do you expect to happen
I was searching for a way to delete all of the data that is in a project without deleting the actual project
How to reproduce
I have already tried the Collect Data in Full Refresh Mode but still is not updated in DB
Anything else
We updated our devlake version in August
Version
v1.0.1-beta7@3f84bae
Are you willing to submit PR?
Code of Conduct