清空数据库的表
s="""| ANSWERS | | ANSWER_EVALUATIONS | | BULLETINS | | BULLETIN_RECEIVERS | | CHAT_LOGS | | COLLECTION_QUESTIONS | | COMMON_NEWSES | | COMMON_NEWS_CHANNELS | | COURSES | | CURRENT_STUDY_NODES | | CUSTOMIZE_NEWS_CHANNELS | | EVALUATION_MEMBER | | EVALUATION_MSG | | EVALUATION_TASK | | EXERCISES | | EXERCISE_RECEIVERS | | EXERCISE_STRATEGY | | EXERCISE_STUDENTS | | EXPERIMENT | | EXPERIMENT_COURSES | | FORUMS | | FORUM_CATEGORIES | | FORUM_POSTS | | FORUM_TOPICS | | FORUM_TOPIC_TO_USER | | FORUM_TO_USER | | FRIEND_GROUPS | | FRIEND_LINKS | | GRADES | | GRADE_COURSE | | GROUP_TO_ROLE | | HOMEWORK_RECORD | | KNOWLEDGE_DOCUMENT | | KNOWLEDGE_NODES | | LEARNING_RESOURCE | | LEARNING_RESOURCE_TO_NODE | | LEARNING_RES_TO_RECOMMEND_RES | | LOW_PRACTICE_RECORD | | MASTER | | MESSAGES | | MESSAGE_RECEIVERS | | MESSAGE_STATISTICS | | PAPER | | PAPER_ANSWER_JUDGE | | PAPER_ANSWER_JUDGE_ITEM | | PAPER_ARRANGEMENT | | PAPER_STRATEGY | | PAPER_STRATEGY_ITEM | | PERSONAL_NOTE | | PRACTICES | | PRAXIS_ANSWER_STATISTICS | | PRAXIS_CONTENT | | PRAXIS_PAPER | | PRAXIS_REVIEW | | PRAXIS_STAT | | QUESTIONS | | QUESTION_EVALUATIONS | | QUESTION_LIBRARIES | | RECENT_CONTACTS | | RECOMMEND_RECEIVERS | | RECOMMEND_RESOURCES | | RECOMMEND_RES_TO_RES | | ROLE_TO_RESOURCE | | SCHEDULINGS | | SCHEDULING_RECEIVERS | | SCHOOLS | | SITE_VISIT_STATES | | SUP_QUES_OF_PAPER | | SYSTEM_CONFIGS | | SYSTEM_LOGS | | SYSTEM_RESOURCES | | TASK_ARRANGES | | TASK_PRACTICE_RECORD | | TASK_RECEIVERS | | TC_MA_VERSIONS | | TEACH_RESOURCES | | TEACH_RESOURCES_CACHE | | TEACH_RESOURCES_COMMENTS | | TEACH_RESOURCES_RECOMMEND | | TEACH_RESOURCES_TO_USERS_ACCEPT | | TEACH_RESOURCES_TO_USERS_ACCEPT_GROUP | | TEACH_RESOURCES_TO_USERS_STORE | | TEXTBOOK_ARRANGES | | TINY_QUES_OF_PAPER | | UPLOAD_FILES | | USERS | | USER_GROUPS | | USER_ROLES | | USER_TO_FRIEND_GROUP | | USER_TO_GROUP | | USER_TO_ROLE | | VICE_ADMIN_USER_TO_GROUP | | VOD_RECORDS | | VOTE_OPTIONS | | VOTE_QUESTIONS | | WORK | """sql=""for t in s.split('|'): t = t.strip() if t == '': pass else: if t=='USERS': sql += "DELETE FROM "+t+" WHERE ACCOUNT!='admin';" elif t in ('USER_TO_ROLE','USER_ROLES'): pass else: sql += "DELETE FROM "+t+";"fd=open(r'c:\delete.sql','w')fd.write(sql)fd.close()print sql
页:
[1]