Commit7127ccb

authored

Merge pull request#18 from postgresml/circleci-project-setup

Add .circleci/config.yml

2 parentsb0afb0c +b61881a commit7127ccbCopy full SHA for 7127ccb

File tree

+31

-3

lines changed

+31

-3

lines changed

Lines changed: 26 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,26 @@`
	`1`	`+# Use the latest 2.1 version of CircleCI pipeline process engine.`
	`2`	`+# See: https://circleci.com/docs/2.0/configuration-reference`
	`3`	`+version:2.1`
	`4`	`+`
	`5`	`+# Define a job to be invoked later in a workflow.`
	`6`	`+# See: https://circleci.com/docs/2.0/configuration-reference/#jobs`
	`7`	`+jobs:`
	`8`	`+red-wine-quality:`
	`9`	`+# Specify the execution environment. You can specify an image from Dockerhub or use one of our Convenience Images from CircleCI's Developer Hub.`
	`10`	`+# See: https://circleci.com/docs/2.0/configuration-reference/#docker-machine-macos-windows-executor`
	`11`	`+docker:`
	`12`	`+ -image:levkk/postgresml:latest`
	`13`	`+# Add steps to the job`
	`14`	`+# See: https://circleci.com/docs/2.0/configuration-reference/#steps`
	`15`	`+steps:`
	`16`	`+ -checkout`
	`17`	`+ -run:`
	`18`	`+name:"Train and predict"`
	`19`	`+command:"bash docker/entrypoint.sh psql -U root -p 5432 -h 127.0.0.1 -f sql/test.sql"`
	`20`	`+`
	`21`	`+# Invoke jobs via workflows`
	`22`	`+# See: https://circleci.com/docs/2.0/configuration-reference/#workflows`
	`23`	`+workflows:`
	`24`	`+end-to-end-tests:`
	`25`	`+jobs:`
	`26`	`+ -red-wine-quality`

Lines changed: 2 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -2,6 +2,8 @@`
`2`	`2`
`3`	`3`	`![PostgresML](./logo-small.png)`
`4`	`4`
	`5`	`+[![PostgresML](https://circleci.com/gh/postgresml/postgresml/tree/master.svg?style=svg)](https://circleci.com/gh/postgresml/postgresml/tree/master)`
	`6`	`+`
`5`	`7`	`PostgresML is an end-to-end machine learning system. Using only SQL, it allows to train models and run online predictions, alongside normal queries, directly using the data in your databases.`
`6`	`8`
`7`	`9`	`##Why`

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -6,7 +6,7 @@ CREATE EXTENSION IF NOT EXISTS plpython3u;`
`6`	`6`	`---`
`7`	`7`	`--- Create schema for models.`
`8`	`8`	`---`
`9`		`-DROPSCHEMA pgml CASCADE;`
	`9`	`+DROPSCHEMAIF EXISTSpgml CASCADE;`
`10`	`10`	`CREATESCHEMAIF NOT EXISTS pgml;`
`11`	`11`
`12`	`12`	`CREATE OR REPLACEFUNCTIONpgml.auto_updated_at(tbl regclass)`

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -8,12 +8,12 @@ SELECT pgml.version();`
`8`	`8`
`9`	`9`	`\timing`
`10`	`10`
`11`		`-SELECTpgml.train('Red Wine Scores','regression','wine_quality_red','quality');`
	`11`	`+SELECT*FROMpgml.train('Red Wine Scores','regression','wine_quality_red','quality');`
`12`	`12`	`SELECTpgml.predict('Red Wine Scores','{7.4, 0.7, 0, 1.9, 0.076, 11, 34, 0.99, 2, 0.5, 9.4}');`
`13`	`13`	`SELECTpgml.predict('Red Wine Scores','{6.4, 0.7, 0, 1.9, 0.076, 11, 34, 0.99, 2, 0.5, 9.4}');`
`14`	`14`	`SELECTpgml.predict('Red Wine Scores','{5.4, 0.7, 0, 1.9, 0.076, 11, 34, 0.99, 2, 0.5, 9.4}');`
`15`	`15`	`SELECTpgml.predict('Red Wine Scores','{3.4, 0.7, 0, 1.9, 0.076, 11, 34, 0.99, 2, 0.5, 9.4}');`
`16`	`16`
`17`		`-SELECTpgml.train('Red Wine Categories','classification','wine_quality_red','quality','svm');`
	`17`	`+SELECT*FROMpgml.train('Red Wine Categories','classification','wine_quality_red','quality','svm');`
`18`	`18`	`SELECTpgml.predict('Red Wine Categories','{7.4, 0.7, 0, 1.9, 0.076, 11, 34, 0.99, 2, 0.5, 9.4}');`
`19`	`19`

Comments

(0)