Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>When your debugging something and you just CANT wrap your mind around whats going wrong... break it down into something easy to debug, throw out your hard test cases and try something very simple then move up to harder ones and find where it breaks, heres how i found it.</p> <p>I commented out all your code where you input the file and made your input to a fixed string:</p> <pre><code>String[] lineArray = ("3;2;" + "1 2 3 " + "6 5 4 ").split(";"); // see how the output should be 123456...very easy to see and debug </code></pre> <p>Putting a breakpoint at <code>while (maxX &gt; minX || maxY &gt; minY)</code>, I looked at the matrix array and saw that the matrix was of size 2x3 not 3x2, and my numbers were not stored how I would think they should be. And voila problem found.</p> <pre><code>/*if (maxY &gt;= maxX){*/ // This for loop is what you want for (int j = 0; j &lt;= maxY; j++){ for (int i = 0; i &lt;= maxX; i++){ matrix[i][j] = (valueArray[count]); count++; } } /*}/*delete this junk/ else if (maxX &gt; maxY){ for (int i = 0; i &lt;= maxX; i++){ for (int j = 0; j &lt;= maxY; j++){ matrix[i][j] = (valueArray[count]); count++; } } }*/ </code></pre> <p>This is a fun one for recursion. I assume you already submitted your code for your project so I took a stab at it. Heres what I ended up with: (I left in the printlns so you could see the program flow)</p> <pre><code>// called by System.out.println(getSpiral(matrix,0,0,0,0)); public static String getSpiral(String[][] array, int x, int y, double direction, int turnCount) { int [] velocity = getDirection(direction); if(x+velocity[0] &gt;= array.length || y+velocity[1] &gt;= array[x].length || x+velocity[0] &lt; 0 || y+velocity[1] &lt; 0 || array[x+velocity[0]][y+velocity[1]].equals("done")) { System.out.println("turn"); if(turnCount&gt;=3) return array[x][y]; return getSpiral(array, x, y, direction+Math.PI/2,turnCount+1); } String value = array[x][y].toLowerCase(); array[x][y]="done"; System.out.println(value); return value + " " + getSpiral(array, x+velocity[0], y+velocity[1], direction,0); } public static int[] getDirection(double angle) { return new int[] {(int)Math.round(Math.cos(angle)), (int)Math.round(Math.sin(angle))}; } </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POJava 2D Array Spiral/Clockwise Traversal
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USug_
    1. USug_
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThank you for taking a look. It appears as though I was over thinking the initialization. I've edited my post to reflect the current issue. I'll of course spend some more time debugging when I can and update if I figure it out, but I'm still hoping someone might see what must be a big issue. It still fails to print the last number '5' on the 3 by 4 array, and when I submit to the codeeval auto grader, it gets a 10% :-(.
      singulars
      1. PO
      1. USspacecadet
    2. CO@spacecadet If you had a 3x3 square and did the entire border. Your minX would start at 0, maxX at 2. Fast forward 1 border loop around, your miX=1,maxX=1,x=1... would your while loop run again? no it would not, this is only the case for squares and only when it reaches the very center because it has narrowed it down to a 1x1 square. Fix? hack that code together and put that center number at the end if its a square matrix :) good luck, god speed.
      singulars
      1. PO
      1. USug_
    3. COThat definitely helped a bit! There was an issue there, stemming from when max equaled min. Basically it triggered when the array was balanced, but seemingly had an odd number of elements. My fix was to keep a counter of the elements appended, and if it were less than the total at the end, append on the median X+1 median Y+1. This solved my test cases perfectly..though it has only done slightly better in the auto grader, going from a 10% to a 30%. Sigh @_@
      singulars
      1. PO
      1. USspacecadet
 

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