Changelog

0.3.0

SDK

Refactoring

• The aito.client module is moved from the sdk subpackage to the main aito package.

  You can now import the AitoClient by:

  from aito.client import AitoClient
  # previously: from aito.sdk.aito_client import AitoClient
  

• The data_frame_handler and sql_connection module is moved from the sdk subpackage to the utils subpackage.

  You can now import the DataFrameHandler and SQLConnection by:

  from aito.utils.data_frame_handler import DataFrameHandler
  # previously: from aito.sdk.data_frame_handler import DataFrameHandler
  from aito.utils.sql_connection import SQLConnection
  # previously: from aito.sdk.sql_connection import SQLConnection
  

New features

• Added the aito.schema module which contains the component object of the Aito Schema including:

  • AitoAnalyzerSchema

  • AitoDataTypeSchema

  • AitoColumnTypeSchema

  • AitoTableSchema

  • AitoDatabaseSchema

  Please go to the module page for a full list of the supported components

• Minor changes:

  • Improved Analyzer inference that can now detect Delimiter Analyzer and is exposed at aito.schema.AitoAnalyzerSchema.infer_from_samples()

  • aito.client.AitoClient.get_table_schema() and aito.client.AitoClient.get_database_schema() now return the schema object instead of the JSON response

  • aito.client.AitoClient.create_table(), aito.utils.data_frame_handler.DataFrameHandler.convert_df_using_aito_table_schema() and aito.utils.data_frame_handler.DataFrameHandler.convert_file() now also support input of AitoTableSchema object

  • aito.client.AitoClient.query_entries() now returns a list of table entries instead of the JSON response

  • aito.client.AitoClient.query_entries() and aito.client.AitoClient.query_all_entries() now supports the select keyword to select the fields of an entry

Deprecation

• The SchemaHandler is deprecated and will be removed in an upcoming release. To migrate:

  • SchemaHandler.infer_aito_types_from_pandas_series -> aito.schema.AitoDataTypeSchema.infer_from_samples()

  • SchemaHandler.infer_table_schema_from_pandas_data_frame -> aito.schema.AitoTableSchema.infer_from_pandas_dataframe()

  • SchemaHandler.validate_table_schema -> aito.schema.AitoTableSchema.from_deserialized_object()

CLI

• Removed the database command. All the database operations are now exposed as follows:

  • aito database quick-add-table -> aito quick-add-table

  • aito database create-table -> aito create-table

  • aito database delete-table -> aito delete-table

  • aito database delete-database -> aito delete-database

  • aito database upload-entries -> aito upload-entries

  • aito database upload-file -> aito upload-file

  • aito database upload-data-from-sql -> aito upload-data-from-sql

  • aito database quick-add-table-from-sql -> aito quick-add-table-from-sql

• Added the following commands:

  • configure: configure your Aito instance

  • get-table: return the schema of the specified table

  • show-tables: show the existing tables in the Aito instance

  • copy-table: copy a table

  • rename-table: rename a table

  • get-database: return the schema of the database

• Removed dotenv file support (-e flag).

0.2.2

• Added missing import warnings to Aito client.

• Updated AitoClient API documentation.

0.2.1

• • AitoClient upload_entries() now accepts generators as well as lists.

• • AitoClient upload_entries_by_batches is deprecated and will be removed in an upcoming release, use upload_entries() instead.

0.2.0

CLI

• Added a version flag (--version) and verbosity level flags (--verbose and --quiet) to the CLI.

• The CLI now returns more concise error messages. Use --verbose mode if you want to see the comprehensive error message with stack info.

• The ODBC driver name for SQL functions is now specified by an environment variable (SQL_DRIVER) or a flag (--driver) instead of a required argument as before. For example:

  $ aito infer-table-schema from-sql --driver "PostgreSQL Unicode" "SELECT * FROM tableName"....
  

  instead of:

  $ aito infer-table-schema from-sql PostgreSQL Unicode" "SELECT * FROM tableName"....
  

SDK

• Renamed the utils package to sdk. Please change the import statement accordingly. For example:

  from aito.sdk.aito_client import AitoClient
  

• Changes in AitoClient:

  • The class now requires the instance URL (the instance_url argument) instead of the instance name (the `instance_name` argument).

  • Improve error handling to use Aito response error message.

  • Remove the async_same_requests function.

  • Rename the arguments of the async_request function:

    • request_methods -> methods

    • request_paths -> endpoints

    • request_data -> queries

  • async_request now returns errors if some requests failed.

  • Rename the arguments of the request function:

    • req_method -> method

    • path -> endpoint

    • data -> query

  • Rename the following functions:

    • put_table schema -> create_table

    • put_database_schema -> create_database

    • check_table_existed -> check_table_exists

    • populate_table_entries -> upload_entries

    • populate_table_entries_by_batches -> upload_entries_by_batches

    • populate_table_by_file_upload -> upload_binary_file

    • query_table_entries -> query_entries

  • Add upload_file function to upload a file using the its path instead of its file object

  • Add optimize_table function and add optimize option after data upload

  • Add Job related functions: create_job, get_job_status, get_job_result, and job_request

  • Add Query related functions: get_table_size, query_entries, query_all_entries, and download_table

0.1.2

• Fix a bug when converting or uploading a file in Windows due to tempfile permission

• Fix a bug that requires conversion between String and Text column

• Add compatibility with Python 3.7 and 3.8

0.1.1

• Fix a bug that requires database name for sql_function

• No longer requires both read-only and read-write key for setting up the credentials.

  (Use AITO_API_KEY instead of AITO_RW_KEY and AITO_RO_KEY)

0.1.0

• Integration with SQL. You can now infer table schema, upload data,

  quick add table from the result of a SQL query.

Supported database:

• Postgres

• MySQL

0.0.4

• Change client task to database task

• Requires Aito instance name instead of full URL (use -i flag instead of -u flag)

• Support tab completion with arg complete

0.0.3

• Add quick-add-table, create-table, delete-table, delete-databse, list database operation

• Remove the option to create and use table schema from file-upload

• Convert always use standard out

• Improved documentation