Request to support create/drop a database. about go_ibm_db HOT 13 CLOSED

Hi @tredoe

I don't know how oracle handles 'create database' query but in our db2 you have to call a new api to create the database, not the exec api.

You can check this documentation where we support create and drop database API's.
https://github.com/ibmdb/node-ibm_db/blob/master/APIDocumentation.md#createDbSyncApi

we have taken your request to support create and drop database api but it will be supported in the same way how node js supports.

Thanks,
Akhil

from go_ibm_db.

Hi @tredoe
Our driver is based on the go standard package database/sql.
As of now, database package does not support create a database (admin operation) so we cannot support it.

If go add's support for creating a database. we will also support that.

Thanks,
Akhil.

from go_ibm_db.

I can create databases using the package database/sql at other DBMSs like Mysql, PostgreSQL, MariaDB, and Microsoft SQL Server (it's that I've tested until now).

By now, only fails with IBM DB2. The next ones to testing are Oracle and Firebird. So it is not an issue related to the support at database/sql.

To create a database, there is to connect to the master database and then to send a statement like 'CREATE DATABASE [name]'.

from go_ibm_db.

I can create databases using the package database/sql at other DBMSs like Mysql, PostgreSQL, MariaDB, and Microsoft SQL Server (it's that I've tested until now)

Can you send me the GitHub links of these drivers?

from go_ibm_db.

MySQL/MariaDB: "github.com/go-sql-driver/mysql"
PostgreSQL: "github.com/lib/pq"
SQL Server: "github.com/denisenkom/go-mssqldb"

In fact, I could add the code where it shows how I create a database. MySQL or PostgreSQL?

from go_ibm_db.

Hi @tredoe
In IBM db2 to create a database, you have to disconnect from the database.

And in the go-driver, we can add that support if you are not connecting to the database.

Thanks,
Akhil

from go_ibm_db.

could you to add support to create and drop a database with db.Exec() API?

@tredoe we cannot add a create database with db.Exec() but we can try to add this support with a new api.
Sample:-

import 'github.com/ibmdb/go_ibm_db'
func main(){
//connection string without database name.
go_ibm_db.CreateDB('databasename', 'host=localhost;uid=uname;pass=password,port=40000')
}

from go_ibm_db.

It is not necessary to add a new API.

If the connection string has the key 'Database', then it connect to such DB, else it connects to the instance where we could send a statement like "CREATE DATABASE".

from go_ibm_db.

If the connection string has the key 'Database', then it connect to such DB, else it connects to the instance where we could send a statement like "CREATE DATABASE".

@tredoe
Are you talking about IBM DB?
Did you pass the connection string(like datbase, host, uid, port, pass) or dsn=name?

from go_ibm_db.

I'm talking about IBM DB2, and I used the string "Hostname=127.0.0.1;Protocol=tcpip;Port=50000;Database=%s;Uid=%s;Pwd=%s".

It was only an idea to not have to add a different API.

from go_ibm_db.

I'm talking about IBM DB2, and I used the string "Hostname=127.0.0.1;Protocol=tcpip;Port=50000;Database=%s;Uid=%s;Pwd=%s".

It was only an idea to not have to add a different API.

Our clidriver does not work in that way...It uses different api to create a database.

Create database is admin operation.

from go_ibm_db.

With Oracle there is also to use a command to create a database (sqlplus; db2 for IBM2), so there is no need to change the API on this driver. Those DBMSs work of that way and there is no need to change the API to be enable to create/drop a database.

Thanks anyway!

from go_ibm_db.

Hi @tredoe

Database creation support has been added. Please pull the latest code and use it.

Thanks,
Akhil

from go_ibm_db.