Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I haven't had much time to look at this or refactor my code so this is more of a brain dump but might be a good place to start and refactor into something a little neater!</p> <pre><code>public class StrongFileType { private string _friendlyName = string.Empty; public StrongFileType(string friendlyName) { _friendlyName = friendlyName; } public IEnumerable&lt;StrongFileType&gt; CompatibleTypes { get; set; } public override string ToString() { return _friendlyName; } } private void SampleTest() { // The possible types var typeA = new StrongFileType("A"); var typeB = new StrongFileType("B"); var typeC = new StrongFileType("C"); var typeD = new StrongFileType("D"); var typeE = new StrongFileType("E"); // Setup possible compatible types typeA.CompatibleTypes = new List&lt;StrongFileType&gt; { typeA, typeB, typeC, typeD }; typeB.CompatibleTypes = new List&lt;StrongFileType&gt; { typeA, typeB, typeC }; typeC.CompatibleTypes = new List&lt;StrongFileType&gt; { typeA, typeB, typeC, typeD }; typeD.CompatibleTypes = new List&lt;StrongFileType&gt; { typeA, typeC, typeD, typeE }; typeE.CompatibleTypes = new List&lt;StrongFileType&gt; { typeD, typeE }; // Now do a check... var userSubmittedFilesValid = new List&lt;StrongFileType&gt; { typeA, typeB, typeC }; CheckCompatible(userSubmittedFilesValid); var userSubmittedFilesInvalid = new List&lt;StrongFileType&gt; { typeA, typeB, typeC, typeD }; CheckCompatible(userSubmittedFilesInvalid); } private bool CheckCompatible(IEnumerable&lt;StrongFileType&gt; requestedFiles) { // Useful for debugging var validList = new List&lt;string&gt;(); var invalidList = new List&lt;string&gt;(); foreach (StrongFileType fileType in requestedFiles) { string invalid = string.Empty; string validCombination = string.Empty; foreach (StrongFileType fileTypeToCheck in requestedFiles) { if (!fileType.CompatibleTypes.Contains(fileTypeToCheck)) { // Show as not compatible and remove any previously valid combinations that match invalid += string.Format("{0} not compatible with {1}", fileType, fileTypeToCheck); validList.RemoveAll(x =&gt; x.Contains(fileType.ToString()) &amp;&amp; x.Contains(fileTypeToCheck.ToString())); } else { validCombination += string.Format("{0}", fileTypeToCheck); } } // Add to respective lists if (!string.IsNullOrEmpty(validCombination) &amp;&amp; !validList.Contains(validCombination)) { validList.Add(validCombination); } if (!string.IsNullOrEmpty(invalid)) { invalidList.Add(invalid); } } // Was valid? return invalidList.Count == 0; } </code></pre> <p>This should result with the first one showing VALID list of ABC and INVALID list is empty. Second one should show ABC and ACD as VALID and BD and DB as INVALID.</p> <p>Sorry I didn't have more time to tidy it up!</p>
    singulars
    1. This table or related slice is empty.
    1. POHow do I make a new list of strings from another list based on certain criteria?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USBelogix
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POHow do I make a new list of strings from another list based on certain criteria?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COI should add that the lists contain strings but this could just as easily be list of StrongFileType etc. Just added them for debugging so you could see a simple output of what you were getting. You can also remove a lot of the string.format etc and generally tidy up! Did it in my lunch break so didn't have time to clean it up! Also, you may want to return the list of valid lists rather than boolean. Hope it helps!
      singulars
      1. PO
      1. USBelogix
    2. COI think you had a very productive lunch @Belogix ! I've compiled it and tested - seems good!! I've got a bit more playing but looks very good at this stage!
      singulars
      1. PO
      1. USSisyphus
    3. COI tested it again, expanded the types to go to "F" and added multiples of the same type - all was good. Many,many thanks.
      singulars
      1. PO
      1. USSisyphus
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload