Databases
StackOverflow2013
Postsdbo
POHow can I store HTML in a Doctrine YML fixture
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow can I store HTML in a Doctrine YML fixture
    primarykey
    data
    text
    <p>I am working with a CMS-type site in Symfony 1.4 (Doctrine 1.2) and one of the things that is frustrating me is not being able to store HTML pages in YML fixtures. Instead I have to create SQL backups of the data if I want to drop and rebuild which is a bit of a pest when Symfony/Doctrine has a fantastic mechanism for doing exactly this.</p> <p>I could write a mechanism that reads in a set of HTML files for each page and fills the data in that way (or even write it as a task). But before I go down that road I am wondering if there is any way for HTML to be stored in a YML fixture so that Doctrine can simply import it into the database.</p> <p><strong>Update:</strong></p> <p>I have tried using <code>symfony doctrine:data-dump</code> and <code>symfony doctrine:data-load</code> however despite the dump correctly creating the fixture with the HTML, the load task appears to 'skip' the value of the column with the HTML and enters everything else into the row. In the database the field doesn't show up as 'NULL' but rather empty so I believe Doctrine is adding the value of the column as ''.</p> <p>Below is a sample of the YML fixture that <code>symfony doctrine:data-dump</code> created. I have tried running <code>symfony doctrine:data-load</code> against various forms of this including removing all the escaped characters (new lines and quotes leaving only angle brackets) but it still doesn't work.</p> <pre><code> Product_69: name: 'My Product' Developer: Developer_30 tagline: 'Text that briefly describes the product' version: '2008' first_published: '' price_code: A79 summary: '' box_image: '' description: "&lt;div id=\"featureSlider\"&gt;\n &lt;ul class=\"slider\"&gt;\n &lt;li class=\"sliderItem\" title=\"Summary\"&gt;\n &lt;div class=\"feature\"&gt;\n Some text goes in here&lt;/div&gt;\n &lt;/li&gt;\n &lt;/ul&gt;\n &lt;/div&gt;\n" is_visible: true </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USj0k
    1. USargibson
    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. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POHow can I store HTML in a Doctrine YML fixture
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POHow can I store HTML in a Doctrine YML fixture
      1. This table or related slice is empty.
      1. VTUpMod
    1. COWHat does your code look like ? Do you get any error ? *I've used HTML in Doctrine fixtures without any trouble nor doing anything special*
      singulars
      1. POHow can I store HTML in a Doctrine YML fixture
      1. USPascal MARTIN
    2. COerr... doesn't `symfony doctrine:data-dump` do the job?
      singulars
      1. POHow can I store HTML in a Doctrine YML fixture
      1. USdevelop7
    3. CODoing `symfony doctrine:data-dump` will create a fixture with all the data just fine however the `symfony doctrine:data-load` task appears to ignore the HTML content and just insert the rest of the item. Interestingly enough it doesn't leave the field null, just blank (so I assume Doctrine tried to insert `''` into the column as a value). I don't get any errors or warnings from the command line when I run `symfony doctrine:data-load`.
      singulars
      1. POHow can I store HTML in a Doctrine YML fixture
      1. USargibson
 

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