the mySql blob class has the following function :

&gt; blob.getBytes

use it like this:


    //(assuming you have a ResultSet named RS)
    Blob blob = rs.getBlob(&quot;SomeDatabaseField&quot;);

    int blobLength = (int) blob.length();  
    byte[] blobAsBytes = blob.getBytes(1, blobLength);

    //release the blob and free up memory. (since JDBC 4.0)
    blob.free();

The **easiest** way is this.

    byte[] bytes = resultSet.getBytes(&quot;my_field&quot;);

I&#39;m attempting to clean up a database that, over the years, had acquired many duplicate records, with slightly different names.  For example, in the companies table, there are names like &quot;Some Company Limited&quot; and &quot;SOME COMPANY LTD!&quot;.

My plan was to export the offending tables into R, convert names to lower case, replace common synonyms (like &quot;limited&quot; -&gt; &quot;ltd&quot;), strip out non-alphabetic characters and then use `agrep` to see what looks similar.

My first problem is that `agrep` only accepts a single pattern to match, and looping over every company name to match against the others is slow.  (Some tables to be cleaned will have tens, possibly hundreds of thousands of names to check.)

I&#39;ve very briefly looked at the `tm` package ([JSS article][1]), and it seems very powerful but geared towards analysing big chunks of text, rather than just names.

I have a few related questions:

 1. Is the `tm` package appropriate for this sort of task?  
    
 2. Is there a faster alternative to `agrep`?  (Said function uses the
    Levenshtein edit distance which is anecdotally slow.)
    
 3. Are there other suitable tools in R, apart from `agrep` and `tm`?
    
 4. Should I even be doing this in R, or should this sort of thing be
    done directly in the database?  (It&#39;s an Access database, so I&#39;d
    rather avoid touching it if possible.)

  [1]: http://www.jstatsoft.org/v25/i05/

Techniques for finding near duplicate records

**Short version of my questions:**

 1. Can anyone point me toward some good, detailed sources from which I
    can learn how to implement testing in my MVC 3 application, using
    NUnit, Ninject 2, and Moq?
 2. Can anyone here help clarify for me how Controller-Repository
    decoupling, mocking, and dependency injection work together?

----------


**Longer version of my questions:**

**What I&#39;m trying to do ...**

I am currently beginning to create an MVC 3 application, which will use Entity Framework 4, with a database first approach. I want to do this right, so I am trying to design the classes, layers, etc., to be highly testable. But, I have little to no experience with unit testing or integration testing, other than an academic understanding of them.

After lots of research, I&#39;ve settle on using 

 - **NUnit** as my testing framework
 - **Ninject 2** as my dependency injection framework
 - **Moq** as my mocking framework.

I know the topic of which framework is best, etc., could enter into this, but at this point I really don&#39;t know enough about any of it to form a solid opinion. So, I just decided to go with these free solutions which seem to be well liked and well maintained. 

**What I&#39;ve learned so far ...**

I&#39;ve spent some time working through some of this stuff, reading resources such as:

 - [**Implementing the Repository and Unit of Work Patterns in an
   ASP.NET MVC Application**][1]
 - [**Building Testable ASP.NET MVC Applications**][2]
 - [**NerdDinner Step 12: Unit Testing**][3]
 - [**Using Repository and Unit of Work patterns with Entity Framework
   4.0**][4]

From these resources, I&#39;ve managed to workout the need for a Repository pattern, complete with repository interfaces, in order to decouple my controllers and my data access logic. I have written some of that into my application already, but I admit I am not clear as to the mechanics of the whole thing, and whether I am doing this decoupling in support of mocking, or dependency injection, or both. As such, I certainly wouldn&#39;t mind hearing from you guys about this too. Any clarity I can gain on this stuff will help me at this point.

**Where things got muddy for me ...**

I thought I was grasping this stuff pretty well until I started trying to wrap my head around Ninject, as described in [Building Testable ASP.NET MVC Applications][5], cited above. Specifically, I got completely lost around the point in which the author begins describing the implementation of a Service layer, about half way into the document.

Anyway, I am now looking for more resources to study, in order to try to get various perspectives around this stuff until it begins to make sense to me. 

Summarizing all of this, boiling it down to specific questions, I am wondering the following:

 1. Can anyone point me toward some good, detailed sources from which I
    can learn how to implement testing in my MVC 3 application, using
    NUnit, Ninject 2, and Moq?
 2. Can anyone here help clarify for me how Controller-Repository
    decoupling, mocking, and dependency injection work together?

**EDIT:** 

I just discovered the [Ninject official wiki][6] on Github, so I&#39;m going to start working through that to see if it starts clarifying things for me. But, I&#39;m still very interested in the SO community thoughts on all of this :)


  [1]: http://www.asp.net/entity-framework/tutorials/implementing-the-repository-and-unit-of-work-patterns-in-an-asp-net-mvc-application
  [2]: http://msdn.microsoft.com/en-us/magazine/dd942838.aspx
  [3]: http://nerddinnerbook.s3.amazonaws.com/Part12.htm
  [4]: http://blogs.msdn.com/b/adonet/archive/2009/06/16/using-repository-and-unit-of-work-patterns-with-entity-framework-4-0.aspx
  [5]: http://msdn.microsoft.com/en-us/magazine/dd942838.aspx
  [6]: https://github.com/ninject/ninject/wiki

MVC 3: How to learn how to test with NUnit, Ninject, and Moq?

what is the easiest way to convert a Blob into a byte array?I am using MYSQL and i want to convert a Blob datatype into a byte array.

Iam using java programming language:)


Easiest way to convert a Blob into a byte array

<p>what is the easiest way to convert a Blob into a byte array?I am using MYSQL and i want to convert a Blob datatype into a byte array.</p>
<p>Iam using java programming language:)</p>


I&#39;ve got a conditional to check if a certain file exists before proceeding (`./logs/error.log`). If it isn&#39;t found I want to create it. However, will

    File tmp = new File(&quot;logs/error.log&quot;);
    tmp.createNewFile();

also create `logs/` if it doesn&#39;t exist?


Java&#39;s createNewFile() - will it also create directories?

What is the best way to use the values stored in an Enum as String literals?
For example:

    public enum Modes {
        some-really-long-string,
        mode1,
        mode2,
        mode3
    }

Then later I could use `Mode.mode1` to return its string representation as `mode1`. Without having to keep calling `Mode.mode1.toString()`.

Using Enum values as String literals

&gt; **Possible Duplicate:**  
&gt; [Unable to locate tools.jar](https://stackoverflow.com/questions/5730815/unable-to-locate-tools-jar)  

&lt;!-- End of automatically inserted text --&gt;

I&#39;m trying to use ant to compile using this command :

     ant compile

I don&#39;t know if the problem comes from my windows 64bit, or by something else. Because I have java Installed in the 64 &amp; 32 prog files. 

![Java 64 &amp; 32][1]

I downloaded `apache-ant-1.8.2-bin` and putted it in C:\Program Files\apache-ant-1.8.2

I tried to put ant everywhere, I switched also the ENV PATH between java 64 and 32 but everytime I get this error message :

&gt; Unable to locate tools.jar. Expected to find it in C:\Program
&gt; Files\Java\jre6\lib\tools.jar

I searched for tools.jar in the ant lib folder, in the java 64 and 32, but no trace of it in the system.

What do you think ? 

  [1]: http://i.stack.imgur.com/Rezya.png

Unable to locate tools.jar

I have enums like:

    public static enum Command
    {
    login,
    register,
    logout,
    newMessage
    }

When formatting the file, the output becomes:

    public static enum Command 
    {
    login, register, logout, newMessage
    }



How to stop Eclipse formatter from placing all enums on one line

I&#39;ve noticed that in the Android reference for Fragments (notably [DialogFragment](http://developer.android.com/reference/android/app/DialogFragment.html#AlertDialog)) that they do a couple of things different from what I&#39;d expect:

1). Use &lt;code&gt;public static foo newInstance()&lt;/code&gt; method rather than a constructor.&lt;br&gt;
2). Pass values to onCreateDialog using setArguments rather than member variables.

I&#39;ve read that newInstance appears to be preferrable when using reflection. However I really don&#39;t understand why they&#39;re passing parameters via a bundle. I&#39;d have though using member variables would be safer (not using a string to fetch from a map) and would have less of an overhead.

Any thoughts?

Member variables vs setArguments in Fragments

By default, `mysqldump` takes the backup of an entire database. I need to backup a single table in MySQL. Is it possible? How do I restore it?

How to take backup of a single table in a MySQL database?

I&#39;m designing my database schema using MySQL Workbench, which is pretty cool because you can do diagrams and it converts them :P

Anyways, I&#39;ve decided to use InnoDB because of it&#39;s Foreign Key support. One thing I noticed though is that it allows you to set On Update and on Delete options for foreign keys. Can someone explain where &quot;Restrict&quot;, &quot;Cascade&quot; and set null could be used in a simple example?

For example, say I have a `user` table which includes a `userID`. And say I have a message table `message` which is a many-to-many which has 2 foreign keys (which reference the same primary key, `userID` in the `user` table). Is setting the On Update and On Delete options any useful in this case? If so, which one do I choose? If this isn&#39;t a good example, could you please come up with a good example to illustrate how these could be useful?

Thanks

Foreign key constraints: When to use ON UPDATE and ON DELETE

how can i use **union** and **order by** in mysql ?

    select * from _member_facebook 
    inner join _member_pts 
    ON _member_facebook._fb_owner=_member_pts._username 
    where _member_facebook._promote_point = 9 
    ORDER BY RAND() limit 2 
    UNION ALL
    select * from _member_facebook 
    inner join _member_pts 
    ON _member_facebook._fb_owner=_member_pts._username 
    where _member_facebook._promote_point = 8 limit 3

give me error 

    #1221 - Incorrect usage of UNION and ORDER BY

any one can help ?

Incorrect usage of UNION and ORDER BY?

I&#39;m just trying to add test cases for services accessing a MySQL DB, and I would like to recreate the whole schema (and for some scenarios also just use a MySQL dump file with the data needed for each test case). I was looking around and found some guys using SQLite / H2 and others to do this, but I&#39;m just wandering if there is any way to run MySQL in-memory so I don&#39;t need to worry about anything specific to the the MySQL dialect I might be using on our services.

Is there a way to run MySQL in-memory for JUnit test cases?

I am trying to create a function in MySQL:

Here is the SQL code:

    CREATE FUNCTION F_Dist3D (x1 decimal, y1 decimal) 
    RETURNS decimal
    DETERMINISTIC
    BEGIN 
     DECLARE dist decimal;
     SET dist = SQRT(x1 - y1);
     RETURN dist;
    END;

I am getting the following error:

    #1064 - You have an error in your SQL syntax; 
    check the manual that corresponds to your MySQL 
    server version for the right syntax to use near &#39;&#39; at line 10

I am running this create statement in phpMyAdmin. What is wrong with this function?

MySQL CREATE FUNCTION Syntax

I can find tons of examples but they seem to either rely mostly on Java libraries or just read characters/lines/etc.

I just want to read in some file and get a byte array with scala libraries - can someone help me with that?

How to read a file as a byte array in Scala

I&#39;m trying to implement RC4 and DH key exchange in python. Problem is that I have no idea about how to convert the python long/int from the key exchange to the byte array I need for the RC4 implementation. Is there a simple way to convert a long to the required length byte array?

**Update**: forgot to mention that the numbers I&#39;m dealing with are 768 bit unsigned integers.

Convert python long/int to fixed size byte array

There are a lot of questions with this topic, the same solution, but this doesn&#39;t work for me. I have a simple test with an encryption. The encryption/decryption itself works (as long as I handle this test with the byte array itself and not as Strings). The problem is that don&#39;t want to handle it as byte array but as String, but when I encode the byte array to string and back, the resulting byte array differs from the original byte array, so the decryption doesn&#39;t work anymore. I tried the following parameters in the corresponding string methods: UTF-8, UTF8, UTF-16, UTF8. None of them work. The resulting byte array differs from the original. Any ideas why this is so?

Encrypter:

    public class NewEncrypter
    {
        private String algorithm = &quot;DESede&quot;;
        private Key key = null;
        private Cipher cipher = null;
        
        public NewEncrypter() throws NoSuchAlgorithmException, NoSuchPaddingException
        {
        	 key = KeyGenerator.getInstance(algorithm).generateKey();
             cipher = Cipher.getInstance(algorithm);
        }
        
    	public byte[] encrypt(String input) throws Exception
    	{
    		cipher.init(Cipher.ENCRYPT_MODE, key);
    		byte[] inputBytes = input.getBytes(&quot;UTF-16&quot;);
    		
    		return cipher.doFinal(inputBytes);
    	}
    
    	public String decrypt(byte[] encryptionBytes) throws Exception
    	{
    		cipher.init(Cipher.DECRYPT_MODE, key);
    		byte[] recoveredBytes = cipher.doFinal(encryptionBytes);
    		String recovered = new String(recoveredBytes, &quot;UTF-16&quot;);
    		
    		return recovered;
    	}
    }

This is the test where I try it:

    public class NewEncrypterTest
    {
    	@Test
    	public void canEncryptAndDecrypt() throws Exception
    	{
    		String toEncrypt = &quot;FOOBAR&quot;;
    		
    		NewEncrypter encrypter = new NewEncrypter();
    		
    		byte[] encryptedByteArray = encrypter.encrypt(toEncrypt);
    		System.out.println(&quot;encryptedByteArray:&quot; + encryptedByteArray);
    	
    		String decoded = new String(encryptedByteArray, &quot;UTF-16&quot;);
    		System.out.println(&quot;decoded:&quot; + decoded);
    		
    		byte[] encoded = decoded.getBytes(&quot;UTF-16&quot;);
    		System.out.println(&quot;encoded:&quot; + encoded);
    		
    		String decryptedText = encrypter.decrypt(encoded); //Exception here
    		System.out.println(&quot;decryptedText:&quot; + decryptedText);
    		
    		assertEquals(toEncrypt, decryptedText);
    	}
    }

Problems converting byte array to string and back to byte array

All the solutions I found were for lists.

Thanks.

How to create a bytes or bytearray of given length filled with zeros in Python?

I have a byte array filled with hex numbers and printing it the easy way is pretty pointless because there are many unprintable elements. What I need is the exact hexcode in the form of: `3a5f771c`

How to convert a byte array to a hex string in Java?

I want to store an image(from url) into a sqlite database.

For that I use: 

    db = new DataBase(getApplicationContext());
    URL url = new URL(&quot;http://sree.cc/wp-content/uploads/schogini_team.png&quot;);
    URLConnection ucon = url.openConnection();
    InputStream is = ucon.getInputStream();
    BufferedInputStream bis = new BufferedInputStream(is,128);
    ByteArrayBuffer barb= new ByteArrayBuffer(128);
    
    int current = 0;
    while ((current = bis.read()) != -1) {
    	barb.append((byte) current);
    }
    
    ContentValues filedata= new ContentValues();
    
    filedata.put(DataBase.IMG_SRC,barb.toByteArray());
    
    db.insert(DataBase.Table_Img, null, filedata);

In the `Insert()`:

    public void insert(String tableImg, Object object,
    		ContentValues dataToInsert) {
    	// TODO Auto-generated method stub
    	String sql = &quot;INSERT INTO &quot;+tableImg+&quot; (&quot;+ID+&quot;,&quot;+IMG_SRC+&quot;) &quot; +
    			&quot;VALUES (&#39;&quot;+1+&quot;&#39;,&#39;&quot;+dataToInsert+&quot;&#39;)&quot;;
    	db.execSQL(sql);
    }


For the retrieval of image:

    Cursor cursor = db.selectDataToShow(DataBase.Table_Img, DataBase.IMG_SRC);
    
    byte[] imageByteArray=cursor.getBlob(cursor.getColumnIndex(DataBase.IMG_SRC));    	
    cursor.close();
    
    ByteArrayInputStream imageStream = new ByteArrayInputStream(imageByteArray);
    Bitmap theImage = BitmapFactory.decodeStream(imageStream);
    
    System.out.println(&quot;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt; &quot;+theImage);

So here I got `null`.

And in my database the value of image stored as: `Image=[B@43e5ac48]`

how to store Image as blob in Sqlite &amp; how to retrieve it?

I am retrieving a Blob image from a database, and I&#39;d like to be able to view that image using JavaScript. The following code produces a broken image icon on the page:

    var image = document.createElement(&#39;image&#39;);
        image.src = &#39;data:image/bmp;base64,&#39;+Base64.encode(blob);
        document.body.appendChild(image);

[Here is a jsFiddle][1] containing all the code required, including the blob. The completed code should properly display an image.

 [1]:http://jsfiddle.net/PDhCy/1/

Using JavaScript to display a Blob

Is ok storing files like HTML pages, images, PDF, etc in a table in PostgreSQL or it is slow? I read some articles saying that this is not recommended, but I don&#39;t know if is true.

The column types I have in mind are `BLOB` (as far as I know it stores in a file) or `bytea` type, but others are applicable also.

Are there performance issues storing files in PostgreSQL?

I am planning to store a `json_encoded` string on my database. I can&#39;t precisely tell the length its going to be, but I&#39;m pretty sure it will be long. My concern is which field type I am going to use for this, is it `blob` or `text`?

I prefer the one where I can save space as much as possible over fast searching, in any case I have other column where I should just index.

Should I use blob or text for JSON in MySQL?

What is `blob` and what is `text`? What are the differences?

When do I need to use `blob` and when do I need `text` as data type?

Because for `blob` and `text`, there are `mediumblob` == `mediumtext`, `smallblob` == `small text`. Do they even have the same meaning?

And look at this `MEDIUMBLOB`, `MEDIUMTEXT L` + 3 bytes, where `L &lt; 224`.

What is `L`?

Content Type	Original Author	Original Content on Stackoverflow
Question	androidGuy	View Question on Stackoverflow
Solution 1 - Java	Timothy Groote	View Answer on Stackoverflow
Solution 2 - Java	Lukas Eder	View Answer on Stackoverflow

Easiest way to convert a Blob into a byte array

Java Problem Overview

Java Solutions

Solution 1 - Java

Solution 2 - Java

MVC 3: How to learn how to test with NUnit, Ninject, and Moq?

Techniques for finding near duplicate records

Attributions