10 examples of 'drop table if exists mysql' in Python

78
def drop(table_name, cursor):
79
    '''
80
    |  drop *table_name*
81
    '''
82
    sql = "DROP TABLE IF EXISTS " + str(table_name)
83
    read(sql, cursor)

20
def drop_tables():
21
    """Drop all tables except for media and rawposts"""
22
    session = sql_functions.connect_to_db()
23
    Base.metadata.drop_all()

47
def drop_table(self):
48
    self.pr('drop table')
49
    self.session.drop(self.tablename, None)

302
def drop_all(self):
303
    """Drops all databases and users created.
304
    """
305
    self.drop_db(self.server1, "util_test")
306
    self.drop_db(self.server1, "util_test1")
307
    self.drop_db(self.server2, "util_test")
308
    self.drop_db(self.server1, 'db.`:db')
309
    self.drop_db(self.server2, 'db.`:db')
310
    self.drop_db(self.server1, 'db_diff_test')
311
    self.drop_db(self.server2, 'db_diff_test')
312
313
    drop_user = ["DROP USER 'joe'@'user'", "DROP USER 'joe_wildcard'@'%'"]
314
    for drop in drop_user:
315
        try:
316
            self.server1.exec_query(drop)
317
            self.server2.exec_query(drop)
318
        except UtilError:
319
            pass
320
    return True

111
def drop(self):
112
    #mssql
113
    sql = "if object_id('%s') is not null drop table %s" % (self.tname, self.tname)
114
    try:
115
        self.execute(sql)
116
    except Exception as e:
117
        self.conn.rollback()
118
        if 'syntax error' not in str(e):
119
            raise
120
        #sqlite
121
        sql = 'drop table if exists %s' % self.tname
122
        self.execute(sql)

203
def dropTables(self):
204
    self.runQueryNoError("drop table nodeaccess")
205
    self.runQueryNoError("drop table user")
206
    self.runQueryNoError("drop table node")
207
    self.runQueryNoError("drop table nodefile")
208
    self.runQueryNoError("drop table nodeattribute")
209
    self.runQueryNoError("drop table nodemapping")
210
    # self.commit()
211
    log.info("tables deleted")

459
def dropDatabase(self):
460
    self._createOrDropDatabase(op="DROP")

91
def drop_tables():
92
    meta = MetaData(bind=engine, reflect=True)
93
    meta.drop_all()

40
def downgrade():
41
    # Load existing tables
42
    metadata.reflect()
43
    try:
44
        APIKeys_table.drop()
45
    except Exception, e:
46
        log.debug( "Dropping api_keys table failed: %s" % str( e ) )

45
def downgrade():
46
    metadata.reflect()
47
    # Drop repository_metadata table.
48
    try:
49
        RepositoryMetadata_table.drop()
50
    except Exception, e:
51
        print str(e)
52
        log.debug( "Dropping repository_metadata table failed: %s" % str( e ) )