how to add new data table to DB

[Kuang-Ching Wang]

Hi,

I need to create a new table to store data in the cloudstack DB.  I followed 
existing examples to:
- add a new VO class, with @Entity and @Table(name = “new_table_name")
- add a new Dao interface
- add a new DaoImpl class for the interface
- update spring context (of my network plugin) with a new bean id for the new 
DaoImpl class

I was expecting with the change and a reinstall of my cloudstack-management 
service (even doing cloudstack-setup-databases again), a new table would be 
created.  However, this is not happening.

Is there some step I missed?

Thanks,
KC

Re: how to add new data table to DB

[Abhinandan Prateek]

You still need to write Sql for creating new db table in MySQL db.

-abhi

> On 29-Sep-2014, at 6:41 am, Kuang-Ching Wang  
> wrote:
> 
> Hi,
> 
> I need to create a new table to store data in the cloudstack DB.  I followed 
> existing examples to:
> - add a new VO class, with @Entity and @Table(name = “new_table_name")
> - add a new Dao interface
> - add a new DaoImpl class for the interface
> - update spring context (of my network plugin) with a new bean id for the new 
> DaoImpl class
> 
> I was expecting with the change and a reinstall of my cloudstack-management 
> service (even doing cloudstack-setup-databases again), a new table would be 
> created.  However, this is not happening.
> 
> Is there some step I missed?
> 
> Thanks,
> KC

Re: how to add new data table to DB

[Mike Tutkowski]

Assuming you are doing this for version 4.5, please take a look at adding
your table to this file:

schema-441to450.sql

By the way, do we really need to add a new table for this plug-in or is
there some "*_details" table (ex. storage_pool_details) where you can store
information specific to your needs?

Thanks

On Sun, Sep 28, 2014 at 7:11 PM, Kuang-Ching Wang  wrote:

> Hi,
>
> I need to create a new table to store data in the cloudstack DB.  I
> followed existing examples to:
> - add a new VO class, with @Entity and @Table(name = “new_table_name")
> - add a new Dao interface
> - add a new DaoImpl class for the interface
> - update spring context (of my network plugin) with a new bean id for the
> new DaoImpl class
>
> I was expecting with the change and a reinstall of my
> cloudstack-management service (even doing cloudstack-setup-databases
> again), a new table would be created.  However, this is not happening.
>
> Is there some step I missed?
>
> Thanks,
> KC




-- 
*Mike Tutkowski*
*Senior CloudStack Developer, SolidFire Inc.*
e: mike.tutkow...@solidfire.com
o: 303.746.7302
Advancing the way the world uses the cloud
*™*

Re: how to add new data table to DB

[Jayapal Reddy Uradi]

You need to add you create table entries in schema-440to441.sql.

If you do not want to redeploy (without using cloudstack-setup-databases) you 
can go to mysql prompt, use cloud db and create table.
After creating table restart the MS will work.

Thanks,
Jayapal

On 29-Sep-2014, at 9:37 AM, Abhinandan Prateek  wrote:

> You still need to write Sql for creating new db table in MySQL db.
> 
> -abhi
> 
>> On 29-Sep-2014, at 6:41 am, Kuang-Ching Wang  
>> wrote:
>> 
>> Hi,
>> 
>> I need to create a new table to store data in the cloudstack DB.  I followed 
>> existing examples to:
>> - add a new VO class, with @Entity and @Table(name = “new_table_name")
>> - add a new Dao interface
>> - add a new DaoImpl class for the interface
>> - update spring context (of my network plugin) with a new bean id for the 
>> new DaoImpl class
>> 
>> I was expecting with the change and a reinstall of my cloudstack-management 
>> service (even doing cloudstack-setup-databases again), a new table would be 
>> created.  However, this is not happening.
>> 
>> Is there some step I missed?
>> 
>> Thanks,
>> KC

Re: how to add new data table to DB

[Kuangching Wang]

By convention, which file should I add to? create-database.sql?

KC

On Sep 28, 2014, at 9:07 PM, Abhinandan Prateek  wrote:

> You still need to write Sql for creating new db table in MySQL db.
> 
> -abhi
> 
>> On 29-Sep-2014, at 6:41 am, Kuang-Ching Wang  
>> wrote:
>> 
>> Hi,
>> 
>> I need to create a new table to store data in the cloudstack DB.  I followed 
>> existing examples to:
>> - add a new VO class, with @Entity and @Table(name = “new_table_name")
>> - add a new Dao interface
>> - add a new DaoImpl class for the interface
>> - update spring context (of my network plugin) with a new bean id for the 
>> new DaoImpl class
>> 
>> I was expecting with the change and a reinstall of my cloudstack-management 
>> service (even doing cloudstack-setup-databases again), a new table would be 
>> created.  However, this is not happening.
>> 
>> Is there some step I missed?
>> 
>> Thanks,
>> KC

--
Dr. Wang, Kuang-Ching, Associate Professor
308 Fluor Daniel Building
ECE Department, Clemson University
Clemson, SC 29634
864-656-0846 (Office)
864-656-7220 (Fax)
kw...@clemson.edu

Re: how to add new data table to DB

[Kuangching Wang]

Why 440to441? What’s the convention to choose which .sql file to add to?  I am 
working against master, which is 4.5.0.

KC
  
On Sep 28, 2014, at 9:25 PM, Jayapal Reddy Uradi 
 wrote:

> You need to add you create table entries in schema-440to441.sql.
> 
> If you do not want to redeploy (without using cloudstack-setup-databases) you 
> can go to mysql prompt, use cloud db and create table.
> After creating table restart the MS will work.
> 
> Thanks,
> Jayapal
> 
> On 29-Sep-2014, at 9:37 AM, Abhinandan Prateek  wrote:
> 
>> You still need to write Sql for creating new db table in MySQL db.
>> 
>> -abhi
>> 
>>> On 29-Sep-2014, at 6:41 am, Kuang-Ching Wang  
>>> wrote:
>>> 
>>> Hi,
>>> 
>>> I need to create a new table to store data in the cloudstack DB.  I 
>>> followed existing examples to:
>>> - add a new VO class, with @Entity and @Table(name = “new_table_name")
>>> - add a new Dao interface
>>> - add a new DaoImpl class for the interface
>>> - update spring context (of my network plugin) with a new bean id for the 
>>> new DaoImpl class
>>> 
>>> I was expecting with the change and a reinstall of my cloudstack-management 
>>> service (even doing cloudstack-setup-databases again), a new table would be 
>>> created.  However, this is not happening.
>>> 
>>> Is there some step I missed?
>>> 
>>> Thanks,
>>> KC
> 

--
Dr. Wang, Kuang-Ching, Associate Professor
308 Fluor Daniel Building
ECE Department, Clemson University
Clemson, SC 29634
864-656-0846 (Office)
864-656-7220 (Fax)
kw...@clemson.edu

Re: how to add new data table to DB

[Kuang-Ching Wang]

Thanks Mike, I added the table successfully.

And also thanks for the suggestion.  I spent some time looking into what we 
need - we need to store some topology/tenant mapping info specific to our 
plugin for syncing purpose.  Logically it really needs to be maintained in a 
separate table.  Similar practice has been adopted by some other 
network-element plugins as well.

Thanks,
KC


On Sep 28, 2014, at 9:23 PM, Mike Tutkowski  
wrote:

> Assuming you are doing this for version 4.5, please take a look at adding 
> your table to this file:
> 
> schema-441to450.sql
> 
> By the way, do we really need to add a new table for this plug-in or is there 
> some "*_details" table (ex. storage_pool_details) where you can store 
> information specific to your needs?
> 
> Thanks
> 
> On Sun, Sep 28, 2014 at 7:11 PM, Kuang-Ching Wang  
> wrote:
> Hi,
> 
> I need to create a new table to store data in the cloudstack DB.  I followed 
> existing examples to:
> - add a new VO class, with @Entity and @Table(name = “new_table_name")
> - add a new Dao interface
> - add a new DaoImpl class for the interface
> - update spring context (of my network plugin) with a new bean id for the new 
> DaoImpl class
> 
> I was expecting with the change and a reinstall of my cloudstack-management 
> service (even doing cloudstack-setup-databases again), a new table would be 
> created.  However, this is not happening.
> 
> Is there some step I missed?
> 
> Thanks,
> KC
> 
> 
> 
> -- 
> Mike Tutkowski
> Senior CloudStack Developer, SolidFire Inc.
> e: mike.tutkow...@solidfire.com
> o: 303.746.7302
> Advancing the way the world uses the cloud™

Re: how to add new data table to DB

[Nitin Mehta]

I kind of agree with Mike. We shouldn¹t really be adding tables with
plugins. If there is a need to do so then its a limitation with our plugin
framework and should be enhanced accordingly.
It would good if you could specify your use case and why it can't be
fitted with existing schema.

Thanks,
-Nitin

On 08/10/14 11:07 AM, "Kuang-Ching Wang"  wrote:

>Thanks Mike, I added the table successfully.
>
>And also thanks for the suggestion.  I spent some time looking into what
>we need - we need to store some topology/tenant mapping info specific to
>our plugin for syncing purpose.  Logically it really needs to be
>maintained in a separate table.  Similar practice has been adopted by
>some other network-element plugins as well.
>
>Thanks,
>KC
>
>
>On Sep 28, 2014, at 9:23 PM, Mike Tutkowski
> wrote:
>
>> Assuming you are doing this for version 4.5, please take a look at
>>adding your table to this file:
>> 
>> schema-441to450.sql
>> 
>> By the way, do we really need to add a new table for this plug-in or is
>>there some "*_details" table (ex. storage_pool_details) where you can
>>store information specific to your needs?
>> 
>> Thanks
>> 
>> On Sun, Sep 28, 2014 at 7:11 PM, Kuang-Ching Wang
>> wrote:
>> Hi,
>> 
>> I need to create a new table to store data in the cloudstack DB.  I
>>followed existing examples to:
>> - add a new VO class, with @Entity and @Table(name = ³new_table_name")
>> - add a new Dao interface
>> - add a new DaoImpl class for the interface
>> - update spring context (of my network plugin) with a new bean id for
>>the new DaoImpl class
>> 
>> I was expecting with the change and a reinstall of my
>>cloudstack-management service (even doing cloudstack-setup-databases
>>again), a new table would be created.  However, this is not happening.
>> 
>> Is there some step I missed?
>> 
>> Thanks,
>> KC
>> 
>> 
>> 
>> -- 
>> Mike Tutkowski
>> Senior CloudStack Developer, SolidFire Inc.
>> e: mike.tutkow...@solidfire.com
>> o: 303.746.7302
>> Advancing the way the world uses the cloud
>