Re: [openstack-dev] [TaskFlow]Create Tables for SQLAlchemy backend issue

2015-05-07 Thread jeffty 
Thanks Josh. I run that and it works. Tables were created successfully.
Also if I create table, foreign keys and index that also work. Except for
table alembic_version. Seems taskflow works well without this table.

It's wired that my gmail didn't receive ur response and I have to go to the
mailing list archive page to find my post and reply.

Thanks again for your kindly help.

[openstack-dev] [TaskFlow]Create Tables for SQLAlchemy backend issue*Joshua
Harlow* harlowja at outlook.com
openstack-dev%40lists.openstack.org?Subject=Re%3A%20%5Bopenstack-dev%5D%20%5BTaskFlow%5DCreate%20Tables%20for%20SQLAlchemy%20backend%0A%20issueIn-Reply-To=%3CBLU436-SMTP277D1317D7BA26D2DD960DD8D00%40phx.gbl%3E
*Wed May 6 05:37:06 UTC 2015*


   - Previous message: [openstack-dev] [TaskFlow]Create Tables for
   SQLAlchemy backend issue
   http://lists.openstack.org/pipermail/openstack-dev/2015-May/063375.html
   - Next message: [openstack-dev] [Fuel] Swagger documentation
   http://lists.openstack.org/pipermail/openstack-dev/2015-May/063378.html
   - *Messages sorted by:* [ date ]
   http://lists.openstack.org/pipermail/openstack-dev/2015-May/date.html#63377
[ thread ]
   
http://lists.openstack.org/pipermail/openstack-dev/2015-May/thread.html#63377
[ subject ]
   
http://lists.openstack.org/pipermail/openstack-dev/2015-May/subject.html#63377
[ author ]
   
http://lists.openstack.org/pipermail/openstack-dev/2015-May/author.html#63377

--

Good question!

U have to call into the following:
http://docs.openstack.org/developer/taskflow/persistence.html#taskflow.persistence.base.Connection.upgrade

This is getting renamed (hopefully to a more obvious name) in the
following review: https://review.openstack.org/#/c/180351/ (others got
confused by this one also).
https://blueprints.launchpad.net/taskflow/+spec/storage-initialize-instead-of-upgrade

Hope that helps,

-Josh

jeffty wrote:
* Hi there,
** I’m trying to use mysql to store lobbooks and atom etc.
** Here is the code:
** backend = backends.fetch({
** 'connection': 'mysql://test:test@192.168.1.10/test
mysql://test:test@192.168.1.10/test',
** 'user': test,
** 'password': test,
** })
** book, flow_detail = pu.temporary_flow_detail(backend=backend)
** And I got below errors:
** taskflow.exceptions.StorageFailure: Failed saving logbook
** 'e34f21c0-72cf-48be-ad96-766befa55ab3'
** ProgrammingError: (ProgrammingError) (1146, Table 'flow.logbooks'
** doesn't exist) 'SELECT logbooks.created_at, logbooks.updated_at,
** logbooks.meta, logbooks.name http://logbooks.name, logbooks.uuid
\nFROM logbooks \nWHERE
** logbooks.uuid = %s' ('e34f21c0-72cf-48be-ad96-766befa55ab3',)
** After checked
** http://docs.openstack.org/developer/taskflow/persistence.html
http://docs.openstack.org/developer/taskflow/persistence.html ,
there
** are 3 tables to be created.
** So we need to create these tables manually right? Or is there any API
** for the tables initiation?
** Thanks.
** __
** OpenStack Development Mailing List (not for usage questions)
** Unsubscribe: OpenStack-dev-request at lists.openstack.org
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev?subject:unsubscribe
** http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev*


2015-05-06 13:14 GMT+08:00 jeffty wantwater...@gmail.com:

 Hi there,



 I’m trying to use mysql to store lobbooks and atom etc.



 Here is the code:



 backend = backends.fetch({

 'connection': 'mysql://test:test@192.168.1.10/test',

 'user': test,

 'password': test,

 })



 book, flow_detail = pu.temporary_flow_detail(backend=backend)



 And I got below errors:



 taskflow.exceptions.StorageFailure: Failed saving logbook
 'e34f21c0-72cf-48be-ad96-766befa55ab3'

   ProgrammingError: (ProgrammingError) (1146, Table 'flow.logbooks'
 doesn't exist) 'SELECT logbooks.created_at, logbooks.updated_at,
 logbooks.meta, logbooks.name, logbooks.uuid \nFROM logbooks \nWHERE
 logbooks.uuid = %s' ('e34f21c0-72cf-48be-ad96-766befa55ab3',)



 After checked
 http://docs.openstack.org/developer/taskflow/persistence.html , there are
 3 tables to be created.



 So we need to create these tables manually right? Or is there any API for
 the tables initiation?



 Thanks.

__
OpenStack Development Mailing List (not for usage questions)
Unsubscribe: openstack-dev-requ...@lists.openstack.org?subject:unsubscribe
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev

Re: [openstack-dev] [TaskFlow]Create Tables for SQLAlchemy backend issue

2015-05-07 Thread Joshua Harlow 

No problem,

Probably more DKIM/SPF... issues (oh well, I give up on resolving that 
stuff anymore...) causing emails to go in weird places (aka your spam 
folder)...


Feel free to jump on IRC to:

irc://chat.freenode.net/openstack-state-management

-Josh

jeffty wrote:


  Thanks Josh. I run that and it works. Tables were created
  successfully. Also if I create table, foreign keys and index that also
  work. Except for table alembic_version. Seems taskflow works well
  without this table.


It's wired that my gmail didn't receive ur response and I have to go to
the mailing list archive page to find my post and reply.

Thanks again for your kindly help.


  [openstack-dev] [TaskFlow]Create Tables for SQLAlchemy backend issue

*Joshua Harlow*harlowja at outlook.com
mailto:openstack-dev%40lists.openstack.org?Subject=Re%3A%20%5Bopenstack-dev%5D%20%5BTaskFlow%5DCreate%20Tables%20for%20SQLAlchemy%20backend%0A%20issueIn-Reply-To=%3CBLU436-SMTP277D1317D7BA26D2DD960DD8D00%40phx.gbl%3E
/Wed May 6 05:37:06 UTC 2015/

  * Previous message: [openstack-dev] [TaskFlow]Create Tables for
SQLAlchemy backend issue
http://lists.openstack.org/pipermail/openstack-dev/2015-May/063375.html
  * Next message: [openstack-dev] [Fuel] Swagger documentation
http://lists.openstack.org/pipermail/openstack-dev/2015-May/063378.html
  * *Messages sorted by:* [ date ]

http://lists.openstack.org/pipermail/openstack-dev/2015-May/date.html#63377
[ thread ]

http://lists.openstack.org/pipermail/openstack-dev/2015-May/thread.html#63377
[ subject ]

http://lists.openstack.org/pipermail/openstack-dev/2015-May/subject.html#63377
[ author ]

http://lists.openstack.org/pipermail/openstack-dev/2015-May/author.html#63377



Good question!

U have to call into the following:

http://docs.openstack.org/developer/taskflow/persistence.html#taskflow.persistence.base.Connection.upgrade

This is getting renamed (hopefully to a more obvious name) in the
following review:https://review.openstack.org/#/c/180351/  (others got
confused by this one also).

https://blueprints.launchpad.net/taskflow/+spec/storage-initialize-instead-of-upgrade

Hope that helps,

-Josh

jeffty wrote:

/  Hi there,

//
//  I’m trying to use mysql to store lobbooks and atom etc.
//
//  Here is the code:
//
//  backend = backends.fetch({
//
//  'connection':'mysql://test:test@192.168.1.10/test',
//
//  'user': test,
//
//  'password': test,
//
//  })
//
//  book, flow_detail = pu.temporary_flow_detail(backend=backend)
//
//  And I got below errors:
//
//  taskflow.exceptions.StorageFailure: Failed saving logbook
//  'e34f21c0-72cf-48be-ad96-766befa55ab3'
//
//  ProgrammingError: (ProgrammingError) (1146,Table'flow.logbooks'
//  doesn't exist)'SELECT logbooks.created_at, logbooks.updated_at,
//  logbooks.meta,logbooks.name  http://logbooks.name, logbooks.uuid \nFROM 
logbooks \nWHERE
//  logbooks.uuid = %s'  ('e34f21c0-72cf-48be-ad96-766befa55ab3',)
//
//  After checked
//  http://docs.openstack.org/developer/taskflow/persistence.html  , there
//  are 3 tables to be created.
//
//  So we need to create these tables manually right? Or is there any API
//  for the tables initiation?
//
//  Thanks.
//
//  __
//  OpenStack Development Mailing List (not for usage questions)
//  Unsubscribe:OpenStack-dev-request at lists.openstack.org  
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev?subject:unsubscribe
//  http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev/


2015-05-06 13:14 GMT+08:00 jeffty wantwater...@gmail.com
mailto:wantwater...@gmail.com:

Hi there,

__ __

I’m trying to use mysql to store lobbooks and atom etc.

__ __

Here is the code:

__ __

backend = backends.fetch({

'connection': 'mysql://test:test@192.168.1.10/test
http://test:test@192.168.1.10/test',

'user': test,

'password': test,

})

__ __

book, flow_detail = pu.temporary_flow_detail(backend=backend)

__ __

And I got below errors:

__ __

taskflow.exceptions.StorageFailure: Failed saving logbook
'e34f21c0-72cf-48be-ad96-766befa55ab3'

   ProgrammingError: (ProgrammingError) (1146, Table
'flow.logbooks' doesn't exist) 'SELECT logbooks.created_at,
logbooks.updated_at, logbooks.meta, logbooks.name
http://logbooks.name, logbooks.uuid \nFROM logbooks \nWHERE
logbooks.uuid = %s' ('e34f21c0-72cf-48be-ad96-766befa55ab3',)

__ __

After checked
http://docs.openstack.org/developer/taskflow/persistence.html ,
there are 3 tables to be created.

__ __

So we need to create these tables manually right? Or is there any
API for the tables initiation?

__ __

Thanks

[openstack-dev] [TaskFlow]Create Tables for SQLAlchemy backend issue

2015-05-05 Thread jeffty 
Hi there,

 

I'm trying to use mysql to store lobbooks and atom etc.

 

Here is the code:

 

backend = backends.fetch({

'connection': 'mysql://test:test@192.168.1.10/test',

'user': test,

'password': test,

})

 

book, flow_detail = pu.temporary_flow_detail(backend=backend)

 

And I got below errors:

 

taskflow.exceptions.StorageFailure: Failed saving logbook
'e34f21c0-72cf-48be-ad96-766befa55ab3'

  ProgrammingError: (ProgrammingError) (1146, Table 'flow.logbooks' doesn't
exist) 'SELECT logbooks.created_at, logbooks.updated_at, logbooks.meta,
logbooks.name, logbooks.uuid \nFROM logbooks \nWHERE logbooks.uuid = %s'
('e34f21c0-72cf-48be-ad96-766befa55ab3',)

 

After checked http://docs.openstack.org/developer/taskflow/persistence.html
, there are 3 tables to be created.

 

So we need to create these tables manually right? Or is there any API for
the tables initiation?

 

Thanks.

__
OpenStack Development Mailing List (not for usage questions)
Unsubscribe: openstack-dev-requ...@lists.openstack.org?subject:unsubscribe
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev

Re: [openstack-dev] [TaskFlow]Create Tables for SQLAlchemy backend issue

2015-05-05 Thread Joshua Harlow 

Good question!

U have to call into the following:

http://docs.openstack.org/developer/taskflow/persistence.html#taskflow.persistence.base.Connection.upgrade

This is getting renamed (hopefully to a more obvious name) in the 
following review: https://review.openstack.org/#/c/180351/ (others got 
confused by this one also).


https://blueprints.launchpad.net/taskflow/+spec/storage-initialize-instead-of-upgrade

Hope that helps,

-Josh

jeffty wrote:

Hi there,

I’m trying to use mysql to store lobbooks and atom etc.

Here is the code:

backend = backends.fetch({

'connection': 'mysql://test:test@192.168.1.10/test',

'user': test,

'password': test,

})

book, flow_detail = pu.temporary_flow_detail(backend=backend)

And I got below errors:

taskflow.exceptions.StorageFailure: Failed saving logbook
'e34f21c0-72cf-48be-ad96-766befa55ab3'

ProgrammingError: (ProgrammingError) (1146, Table 'flow.logbooks'
doesn't exist) 'SELECT logbooks.created_at, logbooks.updated_at,
logbooks.meta, logbooks.name, logbooks.uuid \nFROM logbooks \nWHERE
logbooks.uuid = %s' ('e34f21c0-72cf-48be-ad96-766befa55ab3',)

After checked
http://docs.openstack.org/developer/taskflow/persistence.html , there
are 3 tables to be created.

So we need to create these tables manually right? Or is there any API
for the tables initiation?

Thanks.

__
OpenStack Development Mailing List (not for usage questions)
Unsubscribe: openstack-dev-requ...@lists.openstack.org?subject:unsubscribe
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev


__
OpenStack Development Mailing List (not for usage questions)
Unsubscribe: openstack-dev-requ...@lists.openstack.org?subject:unsubscribe
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev