B4J Question Store image to SQLite (from HTMLeditor and Clipboard)

[ThRuST]

I want to store an image into a SQLite database using B4J and also load it back, let's say the image is in a HTMLeditor1 control. Store an image directly from the clipboard is also an option I would like to cover. Any advice on how it's done?

I zipped up my small source code example for you to play around with post your changes as a zip thanks. You will also get my B4JUtils library as a code module. It makes it very easy to create/access the application folder and subfolders.

btw the loaded byte array should show the image in ImageView2.

Solution in v1.1 Thanks to MarkusR for providing help for the solution. Erel contributed with help as well.

v1.2 contains the new improved code provided by Erel and MarkusR. Check it out

 

[MarkusR]

i am new to B4X but here a example
i copy a image from paint into Clipboard

    Dim stream As OutputStream
    stream.InitializeToBytesArray(0)
  
    Dim Image1 As Image
    Image1 = fx.Clipboard.GetImage()
    Image1.WriteToStream( stream )
  
     Dim Buffer1() As Byte = stream.ToBytesArray

    stream.Close

    Log(Buffer1.Length)

 

[ThRuST]

@MarkusR Works nicely, great As long as Master Erel or some of the other gurus does not come up with a better solution I rest my case Cheers

 

[ThRuST]

oh, I forgot from the HTMLeditor haha just to bug you further @MarkusR. Save an image from HTMLeditor to file, THAT is the hard bonus question

 

[MarkusR]

see also

fx.Clipboard.HasImage

not used this HTMLEditor but it have a HTMLEditor1.Snapshot

 

[ThRuST]

The thing is, when saving from the HTMLeditor control you save as HTMLtext, which wrapps the image in some HTML code. This has been bugging me for a long time how to only store the image, in case there's just an image in the HTMLeditor view. It's possible to take a snapshot, so I guess that might be the solution. The magic wil lthen be to know the size of the image. EDIT : so when the HTMLtext is loaded back, it needs to be put in the HTMLeditor control to view correctly. If pasted into Word for example, there will be HTML surrounding the image name only, which is not what we want

 

[MarkusR]

The magic wil lthen be to know the size of the image.

    Dim Img As Image = HTMLEditor1.Snapshot
    Log(Img.Width & " x "& Img.Height)

 

[ThRuST]

That will include formatting for text font size etc as well? have you tested it? What if there's two images? haha I am pushing my luck here, please don't go upset. Excuse me for my lack of knowledge

 

[MarkusR]

i guess you well extract only the content images from HTMLEditor1 ...
i not played with but if i found a solution i post here.

 

[ThRuST]

Thanks, I could not try it in the source code example because somehow the HTMLeditor webview won't allow focus. Tried to run both in debug and release mode same thing.
I assume your solution will work to put an image from HTMLeditor into ImageView1 in the source, but I cannot test it so I'll leave it at that.

Sub Button1_Click
    
    'InsertBlob
    
    Dim Img As Image = HTMLEditor1.Snapshot
    Log(Img.Width & " x "& Img.Height)
    
    ' Set nbew image in ImageView1
    ImageView1.SetImage(Img)
    
End Sub

I think we'll covered this so it will help others as well. It will be very useful for my own project Athena.
You can find my post about it in B4J forum - Share my creations, to see what it's all about. Cheers

 

[MarkusR]

a normal html page have only a reference to images, i think you can get this with regular expressions from the html source code.
then u need Okhttputils to "download" image from uri one by one.
OT:Athena looks like a code snippet database for me.

 

[ThRuST]

Intersting idea. I should try the snapshot with HTMLeditor again and try to locate the problem ,it might be useful to use snapshot with storing of images. Athena's document manager is to be correct a knowledge framework to store documents that can hold text and images about any category. There's a programmable contextmenu that supports Code, HTML, Folders, Programs, Weblinks and... soon Images so I wanted to cover this properly to be able to add support for storing/retrieving images in the contextmenu. There will be alot more baked in, so it's not only one application because of the concept I have to keep my innovative mind open but code snippets yes, as well as a way for the common user to interact with the computer system. Software development is a huge area, and the idea is that only working solutions will be available in server mode. That means, no questions only answers. In local mode you can store anything, even passwords to recruitment companies, dev sites, general accounts and so on. You should buy a 9-buttoned mouse because it will make it smooth to toggle between the floating menus, as there's four of them, 30 rows * 4 menus. And there's 4 database banks which gives a total of 120 * 4 = 480 slots for code snippets, folders shortcuts, shortcuts to programs, Weblinks.. and soon also images. Ambitious project so I gotta get to work

 

[ThRuST]

The 9 buttoned mouse device I use is this. Highly recommended. The two topleft buttons cycles floating menus white middle mouse counts menus up by one every click. The right button shows the contextmenu. Which can be turned on and off in settings in Athena. Some quite advertising here, it's only for the better I can tell