Databases
StackOverflow2013
Postsdbo
POHow do I properly format a StringIO object(python and django) to be inserted into an database?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow do I properly format a StringIO object(python and django) to be inserted into an database?
    primarykey
    data
    text
    <p>I have a requeriment to store images in the database using django, and for that I created a custom field :</p> <pre><code>from django.db import models class BlobField(models.Field): __metaclass__ = models.SubfieldBase def db_type(self, connection): #TODO handle other db engines backend = connection.settings_dict['ENGINE'] if backend == 'django.db.backends.postgresql': return 'bytea' elif backend == 'django.db.backends.sqlite3': return 'blob' else: raise Exception('unsuported db') def to_python(self, value): #TODO return value def get_db_prep_value(self, value, connection, prepared=False): #TODO return value </code></pre> <p>I have already implemented a custom <a href="http://docs.djangoproject.com/en/1.2/howto/custom-file-storage/" rel="nofollow">storage system</a> to handle the storage/retrieval of images using a custom Model(that contains the above BlobField). The 'value' parameter in the 'get_db_prep_value' method is a 'StringIO' object that contains the image binary data. The catch is that I don't know what to return in the 'get_db_prep_value' method since the 'StringIO' object will surely contain non-printable characters. </p> <p>I have some questions about the problem:</p> <ul> <li>What should I return in the 'get_db_prep_value' method? </li> <li>If the expected value is an ASCII string, can I represent the blob(hexadecimal escapes) in a database independent way?</li> <li>If not, are there built in libraries that handle this kind of conversion for me?</li> <li>What can I expect to receive as input for the 'to_python' method, and how can I convert it to a StringIO object?</li> </ul>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USThiago de Arruda
    plurals
    1. This table or related slice is empty.
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POHow do I properly format a StringIO object(python and django) to be inserted into an database?
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POHow do I properly format a StringIO object(python and django) to be inserted into an database?
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POHow do I properly format a StringIO object(python and django) to be inserted into an database?
      1. This table or related slice is empty.
      1. VTUpMod
    1. This table or related slice is empty.
 

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