Lines Matching refs:table
8 def delete_duplicates(manager, table, first_id, second_id):
12 (first_id, second_id, table, first_id, second_id))
16 (table, first_id, second_id),
19 print 'Deleted %s duplicate rows from %s' % (len(rows), table)
25 'DELETE %(table)s.* FROM %(table)s '
27 'ON %(table)s.%(field)s = %(destination_table)s.id '
29 dict(table=pivot_table, field=foreign_key_field,
37 def unique_index_name(table):
38 return table + '_both_ids'
41 def basic_index_name(table, field):
44 return table + '_' + field
68 def foreign_key_name(table, field):
69 return '_'.join([table, field, 'fk'])
72 def create_foreign_key_constraint(manager, table, field, destination_table):
73 key_name = foreign_key_name(table, field)
74 manager.execute('ALTER TABLE %s ADD CONSTRAINT %s FOREIGN KEY (%s) '
76 (table, key_name, field, destination_table))
79 def drop_foreign_key_constraint(manager, table, field):
80 key_name = foreign_key_name(table, field)
81 manager.execute('ALTER TABLE %s DROP FOREIGN KEY %s' % (table, key_name))
125 for (table, first_field, first_table, second_field, second_table,
127 cleanup_m2m_pivot(manager, table, first_field, first_table,
132 for (table, first_field, first_table, second_field, second_table,
134 reverse_cleanup_m2m_pivot(manager, table, first_field, second_field,
