Databases
StackOverflow2013
Postsdbo
PODjango: Can I run syncdb on user demand? (to keep model in sync with file system)
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PODjango: Can I run syncdb on user demand? (to keep model in sync with file system)
    primarykey
    data
    text
    <p>I have a Django model that represents data files on a server, with some metadata about each file. These files are generated by an instrument and can appear at any time throughout the day. I would like the Django table to reflect the files that are actually available for the user to select. </p> <p>Here is what I have so far:</p> <ul> <li>I have a python script that scans the directory, produces an intial_data.json file and puts it in the app/fixtures directory. (The script pulls out important metadata from each file to make it easy for the user to make selections.)</li> <li>I have <a href="https://code.djangoproject.com/wiki/Fixtures" rel="nofollow">fixtures</a> working so that when I run syncdb, it loads the data into the model.</li> </ul> <p>My question is, how do I do this repeatedly (hourly? on-demand? -- for example, triggered by clicking a button on the page?) </p> <p>My impression is that syncdb is only meant to be run occasionally, like, for a data migration. Am I wrong - can I run it "at the click of a button"?</p> <p>Is there a better way of keeping my table in sync with the file system? I have considered using <a href="https://docs.djangoproject.com/en/1.6/ref/models/fields/#filefield" rel="nofollow">FileField</a> or <a href="https://docs.djangoproject.com/en/1.6/ref/models/fields/#filepathfield" rel="nofollow">FilePathField</a> but these seem not workable, because I want to pre-load the table with the file metadata.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. UStar
    1. USOwen
    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
    1. VO
      singulars
      1. PODjango: Can I run syncdb on user demand? (to keep model in sync with file system)
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    1. COI don't see anything horrible about the idea you've described, but why not turn the Python script that scans the directory into one that writes directly to the DB? If you don't want to do that, you could simplify down to using the `loaddata` command instead of `syncdb`: https://docs.djangoproject.com/en/dev/ref/django-admin/#loaddata-fixture-fixture
      singulars
      1. PODjango: Can I run syncdb on user demand? (to keep model in sync with file system)
      1. USPeter DeGlopper
    2. COsyncdb is definitely intended to be something only run in setup, and not to be something you run as part of your app's normal operation. If it's only fixtures you need, though, then fortunately you have a lot of options on how to load those aside from syncdb.
      singulars
      1. PODjango: Can I run syncdb on user demand? (to keep model in sync with file system)
      1. USAndrew Gorcester
    3. COThank you both for the helpful comments. I'm accepting the below answer for the sake of closing the question.
      singulars
      1. PODjango: Can I run syncdb on user demand? (to keep model in sync with file system)
      1. USOwen
 

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