Re: ORM from the command line

Tim Johnson Thu, 09 Apr 2020 10:39:25 -0700

Thank you too Adam.

Great stuff!


On 4/9/20 7:43 AM, Adam Mičuda wrote:

Hi,

you can also write simple python script and run it in Django contextviahttps://django-extensions.readthedocs.io/en/latest/runscript.html from`django-extensions` package.


Best regards.
Adam

čt 9. 4. 2020 v 17:14 odesílatel Tim Johnson <t...@akwebsoft.com<mailto:t...@akwebsoft.com>> napsal:


    Thank you Andréas. I have come across that too, after my OT.

    This is definitely what I was looking for.

    cheers

    On 4/9/20 2:05 AM, Andréas Kühne wrote:

    Hi Tim,

    What you probably should do is use a custom command on the
    manage.py command interface. You till then get access to all of
    djangos goodness - and it can be run from the command line.

    See here:
    https://docs.djangoproject.com/en/3.0/howto/custom-management-commands/

    This is how I would handle it.

    Regards,

    Andréas


    Den tors 9 apr. 2020 kl 00:18 skrev Tim Johnson
    <t...@akwebsoft.com <mailto:t...@akwebsoft.com>>:

        using django.VERSION (2, 1, 5, 'final', 0) with

        python 3.7.2 on ubuntu 16.04

        I have a need for a "Housekeeping" application. It's usage
        would be to

        1) connect to a database, either mysql, mariadb or postgres

        2) truncate two tables and repopulate them based on an
        arbitrary data
        structure such as a compound list or tuple.

        Such an application would not need be and most preferably
        should not be
        part of a deployed website.

        This should not be a very complicated endeavor. The simplest
        method
        might be to manually establish an ORM connection using
        settings.py to
        import the connection credentials. I am wondering if this is
        possible.

        However, I am unable to find documentation that would edify
        me on
        manually coding an ORM connection and clearing a database
        without the
        loading of django resources.

        If such an approach is feasible, I would welcome URLs to
        appropriate
        documentation and/or discussion.

        Using a model-view approach would be the simplest method, I
        would think,
        but there would be no need to have such a view deployed.
        There is
        probably a solution that would necessitate installing a
        custom package
        to be used from manage.py, such as
        https://github.com/KhaledElAnsari/django-truncate and that
        might be
        complicated.

        Comments are welcome

        thanks

--Tim

        tj49.com <http://tj49.com>

--You received this message because you are subscribed to the

        Google Groups "Django users" group.
        To unsubscribe from this group and stop receiving emails from
        it, send an email to
        django-users+unsubscr...@googlegroups.com
        <mailto:django-users%2bunsubscr...@googlegroups.com>.
        To view this discussion on the web visit
        
https://groups.google.com/d/msgid/django-users/4be7c6fc-d99e-7419-24ef-d54cbdf384d4%40akwebsoft.com.

--You received this message because you are subscribed to the

    Google Groups "Django users" group.
    To unsubscribe from this group and stop receiving emails from it,
    send an email to django-users+unsubscr...@googlegroups.com
    <mailto:django-users+unsubscr...@googlegroups.com>.
    To view this discussion on the web visit
    
https://groups.google.com/d/msgid/django-users/CAK4qSCdSf%2BJ9ZufHavQqv-9ftOkOUwNODsFd-w6QQmzzK61j5Q%40mail.gmail.com
    
<https://groups.google.com/d/msgid/django-users/CAK4qSCdSf%2BJ9ZufHavQqv-9ftOkOUwNODsFd-w6QQmzzK61j5Q%40mail.gmail.com?utm_medium=email&utm_source=footer>.

--Tim

    tj49.com  <http://tj49.com>

--You received this message because you are subscribed to the Google

    Groups "Django users" group.
    To unsubscribe from this group and stop receiving emails from it,
    send an email to django-users+unsubscr...@googlegroups.com
    <mailto:django-users+unsubscr...@googlegroups.com>.
    To view this discussion on the web visit
    
https://groups.google.com/d/msgid/django-users/35392bf4-d25a-95d6-fb32-bf09fd01e997%40akwebsoft.com
    
<https://groups.google.com/d/msgid/django-users/35392bf4-d25a-95d6-fb32-bf09fd01e997%40akwebsoft.com?utm_medium=email&utm_source=footer>.

--

You received this message because you are subscribed to the GoogleGroups "Django users" group.To unsubscribe from this group and stop receiving emails from it, sendan email to django-users+unsubscr...@googlegroups.com<mailto:django-users+unsubscr...@googlegroups.com>.To view this discussion on the web visithttps://groups.google.com/d/msgid/django-users/CAB9%3DGXbjT24BoEtw-_mUc7wS8WtX9kSFQnfKTmCmWEfv5nTomQ%40mail.gmail.com<https://groups.google.com/d/msgid/django-users/CAB9%3DGXbjT24BoEtw-_mUc7wS8WtX9kSFQnfKTmCmWEfv5nTomQ%40mail.gmail.com?utm_medium=email&utm_source=footer>.


--
Tim
tj49.com

--
You received this message because you are subscribed to the Google Groups "Django 
users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/e30884da-07ab-543e-927c-e1fa0778e481%40akwebsoft.com.

Re: ORM from the command line

Reply via email to