I have an Order Model which contains an array of objects called item_details. When I create a new order, I want to iterate over item_details and create new instances of OrderDetail which include the Order id. OrderDetail is a join…
what i am trying to do is if the connection to the database fails, instead of getting No connection could be made because the target machine actively refused it, i want to throw a custom view that displays a simple…
this is myTable clientId, itemId, sellId primary is on clientId and there is also btree index no uniqe on sellId now i have part of very slow query LEFT OUTER JOIN myTable wl ON wl.itemId= ld.itemId and wl.clientId= @clientId question…
I am having below tables and want to populate the PAYID from the PAY table by looking in to CATEGORY_ID for below use case if PAYID is mapped with CATEGORY_ID then return the PAYID if PAYID is not mapped to…
I'm trying to insert data to two different table simultaneously. If failed , then roll back the data. And I try to google, and found some solutions: 1.Use data transactions. 2.Create a extra table then join two table. 3.Create a…
I have such models: class Post(models.Model): title = models.CharField(max_length=200) content = models.TextField() tags = models.ManyToManyField(to="tag", related_name="tags", blank=True) def __str__(self): return self.title class Tag(models.Model): value = models.CharField(max_length=50) parent = models.ManyToManyField("Tag", related_name="children", blank=True) image = models.ImageField(upload_to="tags", null=True, blank=True) def __str__(self): return self.value…
I have a series of queries which are now not paralellised, the java code looks something like this: private List<EntityA> cacheA = Lists.newArrayList; private List<EntityB> cacheB = Lists.newArrayList; private List<EntityC> cacheC = Lists.newArrayList; // ... public class Cache { private…
Good day dear developers, I really need your help. I want to make an app in Xamarin. In which I added some text data, and it is saved in this application. I need this information to be in the application,…
i wrote a code that will add records to data base then return the message to a specific div now I need to know how to clear text boxes after I get the result to the div? $(document).ready(function() { $('#message').submit(function(e)…
I have a table named customers, that has many columns: 'id', 'name', 'age', 'weight', 'hight', 'blood', 'sex', 'last name', 'datetime'. I want to add a checking logic before inserting, which is if the datetime already exists, then update/overwrite the whole…