Menu
Search

Forums

Forum Index

Thread overview
Write binary data as a file
Aug 02, 2022
Alexander Zhirov
Aug 02, 2022
H. S. Teoh
Aug 02, 2022
Adam D Ruppe
Aug 03, 2022
Alexander Zhirov
August 02, 2022
Gravatar of Alexander ZhirovPosted by Alexander ZhirovReply
Alexander Zhirov
Gravatar of Alexander Zhirov


Reply

I'm trying to write a mechanism for writing and reading from Postgres.
Using the Adama D. Ruppe library. I write data to Postgres in the form of this code:

ubyte[] bytes = cast(ubyte[])read("myFile");
PostgresResult resultQuery = cast(PostgresResult) db.query("insert into amts.t_client_xrdp_settings (pid_client, settings_file) values (?, ?)", id, bytes);
assert(resultQuery !is null);

Data appears in the database. Now I'm trying to do the reverse process. Get data from Postgres and create a file:

auto result = db.query("select tcxs.settings_file as dbfile from amts.t_client_xrdp_settings tcxs where tcxs.pid_client = ?", id);
ubyte[] bytes = cast(ubyte[])result.front()["dbfile"];
write("newFile", bytes);

As a result, I get only a set of text data.
I am sure that my mechanism lacks refinement. It remains only to find out which one.

August 02, 2022
Gravatar of H. S. TeohPosted by H. S. Teoh
in reply to Alexander Zhirov		Reply
H. S. Teoh
Gravatar of H. S. Teoh
Posted in reply to Alexander Zhirov


Reply
On Tue, Aug 02, 2022 at 11:10:27AM +0000, Alexander Zhirov via Digitalmars-d-learn wrote: [...]
> ```d
> auto result = db.query("select tcxs.settings_file as dbfile from
> amts.t_client_xrdp_settings tcxs where tcxs.pid_client = ?", id);
> ubyte[] bytes = cast(ubyte[])result.front()["dbfile"];
> write("newFile", bytes);
> ```

Don't use `write` for binary data. Use instead File.rawWrite:

	ubyte[] data = ...;
	File f = File("dbfile", "w");
	f.rawWrite(data[]);


T

-- 
This is a tpyo.
August 02, 2022
Gravatar of Adam D RuppePosted by Adam D Ruppe
in reply to Alexander Zhirov		Reply
Adam D Ruppe
Gravatar of Adam D Ruppe
Posted in reply to Alexander Zhirov


Reply
On Tuesday, 2 August 2022 at 11:10:27 UTC, Alexander Zhirov wrote:
> As a result, I get only a set of text data.

my database layer is doing to!string(that_ubyte) which is wrong. gonna see about pushing a fix
August 03, 2022
Gravatar of Alexander ZhirovPosted by Alexander Zhirov
in reply to Adam D Ruppe		Reply
Alexander Zhirov
Gravatar of Alexander Zhirov
Posted in reply to Adam D Ruppe


Reply
On Tuesday, 2 August 2022 at 15:30:13 UTC, Adam D Ruppe wrote:
> On Tuesday, 2 August 2022 at 11:10:27 UTC, Alexander Zhirov wrote:
>> As a result, I get only a set of text data.
>
> my database layer is doing to!string(that_ubyte) which is wrong. gonna see about pushing a fix

It's decided! After the fix, everything works! Thank you very much!