English 中文(简体)
如何在赫鲁库投下一张单桌给决哥应用
原标题:How to drop a single table in Heroku for Django app

我看到如何在Django的Hemoku(

最佳回答

嘿,这是很直的前进方向。你应该做一个视图函数, 你可以处理原始 SQL 。 我昨天刚做了这个尝试, 试图解决后格唯一的索引同步问题 。

视图. py: 将此映射到某些 URL 上, 然后访问浏览器中的 URL, 函数将执行 。

from django.db import connection, transaction

def dropTable(request):

 cursor = connection.cursor()

 cursor.execute(“DROP TABLE WHATEVER”) //custom raw SQL goes here

 success = simplejson.dumps({‘success’:’success’,}) //I do this as a success message

 return HttpResponse(success, mimetype=’application/json’) //you ll need an import or two for the json stuff to work
问题回答

当我看到这个文章时,我也有同样的问题,我认为有比较容易的办法来解决这个问题。赫鲁库推出了PostgreSQL Studio ,这是一个基于网络的 PSQL 界面, 允许您查看您的 DB 和 PSQL 命令。

一旦您连接到 DB, 只要打开一个 < a href=\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\

TRUNCATE TABLE table_name;




相关问题
How to get two random records with Django

How do I get two distinct random records using Django? I ve seen questions about how to get one but I need to get two random records and they must differ.

Moving (very old) Zope/Plone Site to Django

I am ask to move data from a (now offline) site driven by Plone to a new Django site. These are the version informations I have: Zope Version (unreleased version, python 2.1.3 ) Python Version 2.1....

Can Django models use MySQL functions?

Is there a way to force Django models to pass a field to a MySQL function every time the model data is read or loaded? To clarify what I mean in SQL, I want the Django model to produce something like ...

Flexible pagination in Django

I d like to implement pagination such that I can allow the user to choose the number of records per page such as 10, 25, 50 etc. How should I go about this? Is there an app I can add onto my project ...

is it convenient to urlencode all next parameters? - django

While writing code, it is pretty common to request a page with an appended "next" query string argument. For instance, in the following template code next points back to the page the user is on: &...

Pragmatically adding give-aways/freebies to an online store

Our business currently has an online store and recently we ve been offering free specials to our customers. Right now, we simply display the special and give the buyer a notice stating we will add the ...

热门标签