Re: [Dev] Introduce new table to the embedded database
Hi Damith, When you are implementing the feature, you can add the create table statement in the database scripts in following location (Assuming you are doing this for IS). For each type of databse there is a separate .sql file and you can add the new command to each file. *IS_HOME/dbscripts/identity/* Then you can start the server with -Dsetup so it will automatically create the new table in your setup. This way you can test your feature. Once you complete the feature, you can send a pull request to [1] adding the new table. [1] https://github.com/wso2/carbon-identity/tree/master/components/identity-core/org.wso2.carbon.identity.core/src/main/resources/dbscripts Regards, TharinduE On Mon, Jun 15, 2015 at 11:50 AM, Damith Senanayake dami...@wso2.com wrote: Hi, I am trying to implement a new feature and I need to introduce a new table to the embedded database. (namely, IDN_UID_USER). What is the normal way to properly do this rather than logging into the H2 Console through the web interface? Thanks in advance -- *-Damith Senanayake-* +94712205272 ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev -- Tharindu Edirisinghe Software Engineer | WSO2 Inc Identity Server Team Blog : tharindue.blogspot.com mobile : +94 775 181586 ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
[Dev] Introduce new table to the embedded database
Hi, I am trying to implement a new feature and I need to introduce a new table to the embedded database. (namely, IDN_UID_USER). What is the normal way to properly do this rather than logging into the H2 Console through the web interface? Thanks in advance -- *-Damith Senanayake-* +94712205272 ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
Re: [Dev] Introduce new table to the embedded database
got it... However, how can I incorporate into the product? On Mon, Jun 15, 2015 at 12:10 PM, Tharindu Edirisinghe tharin...@wso2.com wrote: Hi Damith, When you are implementing the feature, you can add the create table statement in the database scripts in following location (Assuming you are doing this for IS). For each type of databse there is a separate .sql file and you can add the new command to each file. *IS_HOME/dbscripts/identity/* Then you can start the server with -Dsetup so it will automatically create the new table in your setup. This way you can test your feature. Once you complete the feature, you can send a pull request to [1] adding the new table. [1] https://github.com/wso2/carbon-identity/tree/master/components/identity-core/org.wso2.carbon.identity.core/src/main/resources/dbscripts Regards, TharinduE On Mon, Jun 15, 2015 at 11:50 AM, Damith Senanayake dami...@wso2.com wrote: Hi, I am trying to implement a new feature and I need to introduce a new table to the embedded database. (namely, IDN_UID_USER). What is the normal way to properly do this rather than logging into the H2 Console through the web interface? Thanks in advance -- *-Damith Senanayake-* +94712205272 ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev -- Tharindu Edirisinghe Software Engineer | WSO2 Inc Identity Server Team Blog : tharindue.blogspot.com mobile : +94 775 181586 -- *-Damith Senanayake-* +94712205272 ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
Re: [Dev] Introduce new table to the embedded database
got it... However, how can I incorporate into the product? On Mon, Jun 15, 2015 at 12:10 PM, Tharindu Edirisinghe tharin...@wso2.com wrote: Hi Damith, When you are implementing the feature, you can add the create table statement in the database scripts in following location (Assuming you are doing this for IS). For each type of databse there is a separate .sql file and you can add the new command to each file. *IS_HOME/dbscripts/identity/* Then you can start the server with -Dsetup so it will automatically create the new table in your setup. This way you can test your feature. Once you complete the feature, you can send a pull request to [1] adding the new table. [1] https://github.com/wso2/carbon-identity/tree/master/components/identity-core/org.wso2.carbon.identity.core/src/main/resources/dbscripts Regards, TharinduE On Mon, Jun 15, 2015 at 11:50 AM, Damith Senanayake dami...@wso2.com wrote: Hi, I am trying to implement a new feature and I need to introduce a new table to the embedded database. (namely, IDN_UID_USER). What is the normal way to properly do this rather than logging into the H2 Console through the web interface? Thanks in advance -- *-Damith Senanayake-* +94712205272 ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev -- Tharindu Edirisinghe Software Engineer | WSO2 Inc Identity Server Team Blog : tharindue.blogspot.com mobile : +94 775 181586 -- *-Damith Senanayake-* +94712205272 ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
Re: [Dev] Introduce new table to the embedded database
Hi Damith, All the required tables are created through the scripts located at 'wso2is-5.0.0/dbscripts/'. Usually these IDN_* tables reside in identity data-source, created with the scripts at 'wso2is-5.0.0/dbscripts/identity/'. When introducing a new table to a data source, you should - include the create table query in all the relevant script types (It's not enough just to add this in H2. Should include in all the scripts for the database types we support (MySQL, MSSQL etc..)) - should wait for identity.core to be active, in your feature, as that is the component which initialize the database for identity data source. Hope this helps. Thanks, Pushpalanka. -- Pushpalanka Jayawardhana, B.Sc.Eng.(Hons). Software Engineer, WSO2 Lanka (pvt) Ltd; wso2.com/ Mobile: +94779716248 Blog: pushpalankajaya.blogspot.com/ | LinkedIn: lk.linkedin.com/in/pushpalanka/ | Twitter: @pushpalanka On Mon, Jun 15, 2015 at 11:50 AM, Damith Senanayake dami...@wso2.com wrote: Hi, I am trying to implement a new feature and I need to introduce a new table to the embedded database. (namely, IDN_UID_USER). What is the normal way to properly do this rather than logging into the H2 Console through the web interface? Thanks in advance -- *-Damith Senanayake-* +94712205272 ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev