Method db_add_name

lib_acl_cpp/app/ndb/ctl_server/db_ctl.cpp:120–156

}

unsigned int db_ctl::db_add_name(const char* name, name_type_t type)
{
	char sql[256];

	// ���������ݿ��¼
	snprintf(sql, sizeof(sql), "insert into tbl_name_type(name, type)"
		" values('%s', %d)", name, (int) type);

	// ���ع������ݿ��¼�Ƿ��Ѿ�����
	(void) ctl_conn_->sql_update(sql);

	// ��ѯ���ݿ�������Ӧ��ID��
	snprintf(sql, sizeof(sql), "select id from tbl_name_type"
		" where name='%s' and type=0", name);
	if (ctl_conn_->sql_select(sql) == false)
	{
		logger_error("create db(%s) error", name);
		return (unsigned int) -1;
	}
	const acl::db_row* first_row = ctl_conn_->get_first_row();
	if (first_row == NULL)
	{
		logger_error("create db(%s) error, sql(%s)", name, sql);
		return (unsigned int) -1;
	}

	unsigned int id = (unsigned int) first_row->field_int("id", -1);
	if (id == (unsigned int) -1)
	{
		ctl_conn_->free_result();
		logger_error("create db(%s) error, id(-1) invalid", name);
		return (unsigned int) -1;
	}

	ctl_conn_->free_result();
	return id;
}

database* db_ctl::db_create(const char* dbname, const char* dbuser /* = NULL */,
	const char* dbpass /* = NULL */)