Method create_table

class/databaseModel/sqliteModel.py:311–339

@name 创建表

(self,args)

    def create_table(self,args):
        """
        @name 创建表
        """
        path = args.path
        if not os.path.exists(path):
            return public.returnMsg(False,'数据库不存在.')

        data = self.get_database_list()
        if not path in data:
            return public.returnMsg(False,'数据库不存在.')

        table = args.table
        sql_shell = args.sql_shell
        db = self.get_db_info(path)
        if not db:
            return public.returnMsg(False,'数据库文件错误.')

        sql = db['sql']
        tables = sql.query('select `name` from sqlite_master where type="table"')
        if table in tables:
            return public.returnMsg(False,'数据表已存在.')

        result = sql.execute(sql_shell)
        tables = sql.query('select `name` from sqlite_master where type="table"')
        if table in tables:
            return public.returnMsg(True,'创建成功.')
        else:
            return public.returnMsg(False,'创建失败,error:{}'.format(result))

    def execute_sql(self,args):
        """