Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Insert NULL using BULK #4001

Closed
ostropik opened this issue Apr 6, 2023 · 4 comments
Closed

Insert NULL using BULK #4001

ostropik opened this issue Apr 6, 2023 · 4 comments
Assignees

Comments

@ostropik
Copy link

ostropik commented Apr 6, 2023

std::vector< Poco::Nullable<Poco::Data::BLOB>> data;
data.push_back(Poco::Data::BLOB()); // zero size bianry data
m_stmt << "INSERT INTO VALUEXXX VALUES(?)", use(data, bulk), now;

Can't find any solution for INSERT NULL (using BULK-feature)

@ostropik
Copy link
Author

ostropik commented Apr 6, 2023

Maybe missed something like

template <class T>
class TypeHandler<std::vector<Nullable<T>>> : public AbstractTypeHandler
	/// Specialization of type handler for std::vector with Nullable objects.

for

	Poco::SharedPtr<AbstractBinding> ptrBinder
		(new BulkBinding<std::vector< Poco::Nullable<Poco::Data::BLOB>>>(vec_of_null_blob_vec, static_cast<Poco::UInt32>(vec_of_null_blob_vec.size()), std::string()));

Copy link

github-actions bot commented Apr 6, 2024

This issue is stale because it has been open for 365 days with no activity.

@github-actions github-actions bot added the stale label Apr 6, 2024
Copy link

github-actions bot commented Jun 5, 2024

This issue was closed because it has been inactive for 60 days since being marked as stale.

@github-actions github-actions bot closed this as completed Jun 5, 2024
@aleks-f aleks-f reopened this Jun 6, 2024
@aleks-f aleks-f added this to the Release 1.14.0 milestone Jun 6, 2024
Copy link

github-actions bot commented Aug 6, 2024

This issue was closed because it has been inactive for 60 days since being marked as stale.

@github-actions github-actions bot closed this as completed Aug 6, 2024
@aleks-f aleks-f reopened this Aug 17, 2024
@aleks-f aleks-f added feature and removed stale labels Aug 17, 2024
@aleks-f aleks-f self-assigned this Aug 17, 2024
@aleks-f aleks-f added this to 1.14 Oct 31, 2024
@aleks-f aleks-f moved this to In Progress in 1.14 Nov 1, 2024
@aleks-f aleks-f changed the title Question. INSERT NULL (using BULK-feature) INSERT NULL (using BULK-feature) Nov 1, 2024
@aleks-f aleks-f changed the title INSERT NULL (using BULK-feature) Insert NULL using BULK Nov 1, 2024
aleks-f added a commit that referenced this issue Nov 1, 2024
resolve bound types and sizes at compile time
aleks-f added a commit that referenced this issue Nov 8, 2024
aleks-f added a commit that referenced this issue Nov 11, 2024
@aleks-f aleks-f added the fixed label Nov 11, 2024
@aleks-f aleks-f moved this from In Progress to Done in 1.14 Nov 11, 2024
aleks-f added a commit that referenced this issue Nov 11, 2024
* fix(ODBC): Insert NULL using BULK #4001
resolve bound types and sizes at compile time

* fix: remove string suffix for static_assert

* Insert NULL using BULK #4001

* fix: typo

* fix(SQLite): missing functions; consolidate extract calls

* chore(SQLite): remove unnecessary typedef

* fix(SQLite): remove duplicate functions

* fix(SQLite): compile errors and warnings

* fix(SQLite): extract implementation signatures

* fix(SQLite): long64 platforms compile errors

* fix(SQLite): long64 platforms compile errors, part ii

* fix(ODBC): windows build

* fix(ODBC): MSSQL big string on windows

* fix(Data): psql and mysql compile errors

* fix(PostgreSQL): add missing functions

* fix(ODBC): revert column size discovery (breaks Oracle)

* fix(PostgreSQL): Nullable extraction #4001

* fix(MySQL): Nullable extraction #4001

* chore(Data): code tidy up

* fix(ODBC): add missing changes
@matejk matejk closed this as completed Nov 28, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
Status: Done
Development

No branches or pull requests

3 participants