Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p><em>render_partial</em> isn't what you want.</p> <p>First, <a href="https://superuser.com/a/133253/34808">re-encode the executable in base64 format</a>, and specify that the template is base64 encoded (This is assuming hex is not a requirement for your app):</p> <pre><code>@@ template-name (base64) </code></pre> <p>Also, you don't actually need a controller method at all. Mojolicious will handle the process for you - all you have to do is appropriately name the template.</p> <pre><code>use Mojolicious::Lite; app-&gt;start; __DATA__ @@ Test.exe (base64) ... </code></pre> <p><a href="http://127.0.0.1:3000/Test.exe" rel="nofollow noreferrer">http://127.0.0.1:3000/Test.exe</a> will then download the file.</p> <p>-</p> <p>If you still want to use a controller method for app-specific concerns, get the data template specifically:</p> <pre><code>use Mojolicious::Lite; get '/download' =&gt; sub { my $self = shift; # http://mojolicio.us/perldoc/Mojolicious/Renderer.pm#get_data_template my $data = $self-&gt;app-&gt;renderer-&gt;get_data_template({}, 'Test.exe'); # Replace content-disposition instead of adding it, # to prevent duplication from elsewhere in the app $self-&gt;res-&gt;headers-&gt;header( 'Content-Disposition', 'attachment;filename=name.exe'); $self-&gt;render_data($data); }; app-&gt;start; __DATA__ @@ Test.exe (base64) ... </code></pre> <p><a href="http://127.0.0.1:3000/download" rel="nofollow noreferrer">http://127.0.0.1:3000/download</a> will get the template, set the header, and then download it as name.exe.</p>
    singulars
    1. This table or related slice is empty.
    1. POFirst 8 bytes are always wrong when downloading a file from my script
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USCommunity
    1. UStempire
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POFirst 8 bytes are always wrong when downloading a file from my script
      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. VTUpMod
    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. COUmm, base64 is not hexadecimal (although a string of hexadecimal digits is valid base64 if it has the right number of digits, it has a completely different meaning). Unless you reencode Test.exe in base64, you'll be serving a completely different file.
      singulars
      1. PO
      1. UScjm
    2. COIndeed; I assumed that his hex solution was a hack to get render_partial output in an acceptable format.
      singulars
      1. PO
      1. UStempire
    3. COthank you so much for your reply! i will try it tomorrow and let you know
      singulars
      1. PO
      1. USflamey
 

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