Projects¶

class mindsdb_sdk.projects.Project(api, name, agents: mindsdb_sdk.agents.Agents = None, skills: mindsdb_sdk.skills.Skills = None, knowledge_bases: mindsdb_sdk.knowledge_bases.KnowledgeBases = None, databases: mindsdb_sdk.databases.Databases = None)¶

Bases: object

Allows to work with project: to manage models and views inside of it or call raw queries inside of project

Server instance allows to manipulate project and databases (integration) on mindsdb server

Attributes for accessing to different objects:

models, see Models()
views, see Views()
jobs, see Jobs()

It is possible to cal queries from project context:

Making prediciton using sql:

>>> query = project.query('select * from database.table join model1')
>>> df = query.fetch()

Making time series prediction:

>>> df = project.query('''
...      SELECT m.saledate as date, m.ma as forecast
...     FROM mindsdb.house_sales_model as m
...     JOIN example_db.demo_data.house_sales as t
...     WHERE t.saledate > LATEST AND t.type = 'house'
...     AND t.bedrooms=2
...     LIMIT 4;
...    ''').fetch()

drop_model_version(name: str, version: int)¶

Drop version of the model

Parameters

name – name of the model
version – version to drop

query(sql: str) → mindsdb_sdk.query.Query¶

Execute raw query inside of project

Parameters: sql – sql query
Returns: Query object

class mindsdb_sdk.projects.Projects(api)¶

Bases: mindsdb_sdk.utils.objects_collection.CollectionBase

list of projects

>>> projects.list()

create

>>> project = projects.create('proj')

drop

>>> projects.drop('proj')

get existing

>>> projects.get('proj')

by attribute >>> projects.proj

create(name: str) → mindsdb_sdk.projects.Project¶

Create new project and return it

Parameters: name – name of the project
Returns: Project object

drop(name: str)¶

Drop project from server

Parameters: name – name of the project

get(name: str = 'mindsdb') → mindsdb_sdk.projects.Project¶

Get Project by name

Parameters: name – name of project
Returns: Project object

list() → List[mindsdb_sdk.projects.Project]¶

Show list of project on server

Returns: list of Project objects