Comments (9)
I will look at it, but I need some more context. How the update operation was constructed? This DELETE with Any, it looks like it is made from Linq and then scheduled for execution on SaveChanges? Pls provide some pseudo code or general sequence what was going on
from vita.
VITA_UPDATE Script.pptx
The presentation will show you very briefly what Pathway, Place, Transition, and Edge represent.
In the second slide, you can see that one place and one transition, along with two edges (not visible), are removed.
The Pseudo code looks like this:
Find what changed (removed place, transition, and two edges)
This code is executed for each entity
public void Delete(IList<int> identifiers)
{
if (identifiers == null || !identifiers.Any())
return;
foreach (var pk in identifiers.Select(identifier => Session.CreatePrimaryKey<TEntity>(identifier)))
{
Delete(pk);
}
}
public TEntity Delete(object id)
{
Entity = this.GetEntity(id);
if (Entity == null) return null;
Session.DeleteEntity(Entity);
return Entity;
}
....
....
and then this line is called at the end
Session.SaveChanges();
Place, transition contains one identifier and edges two, the script is generated correctly from my point of view but only the semicolon is missing.
Pathway is updated due to modify date.
from vita.
I ran the 'TestMics_DeleteMany' test and the command text is without ;
You can see the delete script:
DELETE FROM misc."Driver"
WHERE "Id" = ANY(@P0)
In this case, missing semicolon doesn't matter.
from vita.
wow, fancy chemistry! ok, got it, will look at it over weekend and push the fix
from vita.
pushed fix, v 3.5.1, should be working now
from vita.
The problem persists even after updating VITA to 3.5.1. version:
UPDATE pathway."Pathway"
SET "ModifyDate" = '2023-02-06T19:09:20.07359', "Timestamp" = '2023-02-06T20:09:15.20968'
WHERE "Id" = 1;
DELETE FROM pathway."Edge"
WHERE "Id" = ANY(@P0)
DELETE FROM pathway."Place"
WHERE "Id" = 3;
DELETE FROM pathway."Transition"
WHERE "Id" = 2;
from vita.
sorry, looking at it...
from vita.
fixed, pushed 3.5.2, try it
from vita.
It works. Thank you very much for the fix.
from vita.
Related Issues (20)
- GUID with Auto HOT 1
- DB Function Error HOT 2
- Left outer join view on multiple columns HOT 7
- Allow reference entity without creating foreign key constraint in table HOT 5
- Session schedule insert or update HOT 4
- DBFunction error HOT 3
- ExecuteDelete missing parenthesis HOT 4
- View does not group by datetime date HOT 3
- Functions like createdOn.Date are ignored in GroupBy HOT 6
- 3.6 not working correctly HOT 6
- System.NullReferenceException: Object reference not set to an instance of an object. HOT 3
- Operation Triggers HOT 34
- Execute Stored Procedures using Vita,
- There is already an open DataReader associated with this Connection which must be closed first. HOT 4
- Version 3.7 is pushed HOT 3
- Plan to restructure the source solution, trim some fat, remove Web projects and old modules HOT 4
- Check property is modified HOT 2
- Anybody using QueryFilter ? HOT 2
- Date Types PostGres SQL HOT 34
- Version 4.0.0 published
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from vita.