Database restart where left off
-
Is there a way to make database read from a group and if bot restarted to start where it left off before?
I was thinking delete from db then insert back into database and that may put it at the bottom of the list in the group?
-
@hellomembersha said in Database restart where left off:
Is there a way to make database read from a group and if bot restarted to start where it left off before?
I was thinking delete from db then insert back into database and that may put it at the bottom of the list in the group?
Create a separate column and record the usage time of this data in it. When searching for data, use the "from old to new" date filter. But when using a database in resources, this method will not work, perhaps your method with deleting and adding data will work.
-
@Fox If I want to filter database for any lines NOT matching a specific date in one of the columns how would I do that? It would be a reverse filter basically.
-
@hellomembersha said in Database restart where left off:
@Fox If I want to filter database for any lines NOT matching a specific date in one of the columns how would I do that? It would be a reverse filter basically.
In the standard database module, the "not equal" condition exists only for the "int" data type, which means you can write a date in milliseconds to a column with this data type and then use a filter with the "not equal" condition