OpenEuphoria

1. Test an Online Database Utility

• Posted by cklester <cklester at yahoo.com> Aug 11, 2005
• 468 views

I need some people to go to

   http://www.cklester.com/dbtest/

and play around with the site. Make some databases. Make some tables. Make
some records. Delete some or all of the above.

Also, how would one make a page so a user could upload a graphic?

Thanks!

-=ck
"Programming in a state of EUPHORIA."
http://www.cklester.com/euphoria/

3. Re: Test an Online Database Utility

• Posted by cklester <cklester at yahoo.com> Aug 11, 2005
• 482 views
• Last edited Aug 12, 2005

rudy toews wrote:
> cklester wrote:
> > I need some people to go to
> > 
> >    <a
> >    href="http://www.cklester.com/dbtest/">http://www.cklester.com/dbtest/</a>
> > 
> > and play around with the site. Make some databases. Make some tables. Make
> > some records. Delete some or all of the above.
> 
> hi ck
> i succeeded in creating a database and table.
> i entered one record without any leading/trailing braces,brackets or quotes.
> i put commas between items in the record.
> 
> the result was most items were paired up with '%' between the pairs,not the
> first one.
> the input commas were ignored?
> 
> input rules need to be displayed 

Hey, rudy... thanks for testing it for me.

As you can see, for this test the input is pretty limited: one text item for
the key and one string of text for the data. I'll see about delimiting fields
in the next iteration. :)

-=ck
"Programming in a state of EUPHORIA."
http://www.cklester.com/euphoria/

5. Re: Test an Online Database Utility

• Posted by Robert Craig <rds at RapidEuphoria.com> Aug 11, 2005
• 454 views
• Last edited Aug 12, 2005

cklester wrote:
> Also, how would one make a page so a user could upload a graphic?

Uploading a file with CGI came up once before.
Here's what I said then:

http://www.listfilter.com/cgi-bin/esearch.exu?fromMonth=3&fromYear=A&toMonth=8&toYear=A&postedBy=rds&keywords=uploading+cgi

Regards,
   Rob Craig
   Rapid Deployment Software
   http://www.RapidEuphoria.com

7. Re: Test an Online Database Utility

• Posted by cklester <cklester at yahoo.com> Aug 12, 2005
• 453 views

ags wrote:
> cklester wrote:
> >> and play around with the site. Make some databases. Make some tables. Make
> > some records. Delete some or all of the above.
> > 
> > Also, how would one make a page so a user could upload a graphic?
> > 
> Looks good, for what it does.  I mean, I guess the three table limit is just
> arbitrary? 

Yes, I didn't want you guys creating a billion databases/tables/records. :)

One interesting note: somebody created a database called *. When it was
deleted, all the databases got deleted (*.edb)... Clever! Glad I patched
that up quickly, although the slashes weren't getting converted from their
html equivalent (../ became ..%2N (or something)).

> To store a graphic I'd use a file upload field and convert it to a sequence
> verbatim with a header saying what type it is (using a Content-Type would
> save processing retrieving the data, and also allow other data types, eg 
> image/jpeg, application/octet-stream, etc.)

Anybody got code for receiving a file via upload? I'll check all of Rob's
web code. :)

> To be truly useful you might want to define fields in the databases and add
> records based on the fields present.  But then I guess it's up to whatever
> application you have in mind :)

Yeah, I intend to use fields next iteration...

-=ck
"Programming in a state of EUPHORIA."
http://www.cklester.com/euphoria/

9. Re: Test an Online Database Utility

• Posted by cklester <cklester at yahoo.com> Aug 12, 2005
• 447 views

Bernie Ryan wrote:
> 
> CK:
>   You might want your user to be sure that Java Script
>   is turned on in their browser. I don't know if you can
>   detect that from your server so you might have a header
>   saying that the site requires Java script to be turn on.

Bernie, where is it required?

-=ck
"Programming in a state of EUPHORIA."
http://www.cklester.com/euphoria/

11. Re: Test an Online Database Utility

• Posted by Greg Haberek <ghaberek at gmail.com> Aug 12, 2005
• 445 views
• Last edited Aug 13, 2005

> Anybody got code for receiving a file via upload? I'll check all of Rob's
> web code. :)

http://www.rapideuphoria.com/uploads/cgi-libs.zip

I just uploaded two CGI libraries to the archive (in one zip file)
that I've been using for years. I didn't realize they weren't in the
Archive any more. LibCGI has excellent support for multi-part forms
(which include file uploads).

~Greg

13. Re: Test an Online Database Utility

• Posted by Matt Lewis <matthewwalkerlewis at gmail.com> Aug 13, 2005
• 454 views

cklester wrote:
> 
> I'm also going to check out Matt's OOEU interpreter, since it's faster than
> any other interpreter out there (except the original) and I've been intrigued
> by Ruby's syntax... but I can get object-orientation with Euphoria syntax?!
> That kicks ax.
> 

And actually, as long as you don't use any of the 'RDS Incompatible' features,
(var_id, eval, goto) you can pre-process the code so that it will run with 
the standard RDS interpreter.

I'm in the process right now of adding constructors.  It's pretty simple.
You just create a member function with the same name as the class.  In fact,
as long as the parameters are different, you can create multiple constructors.
Here's a simple example from one of the demos (just a part of the full demo):

euclass ECircle( EShape c )
	-- This is a shape defined by its center and a radius.
	-- Note that the Center is an EPoint.
	EPoint Center
	atom Radius
	
	-- The constructor isn't very interesting, but it
	-- does initialize the sequence.
	function ECircle( EPoint center, atom radius )
		ECircle this
		this = repeat( 0, ECircle.Radius )
		this.Name = "Circle"
		this.Center = center
		this.Radius = radius
		return this
	end function
	
	-- This is an alternate form of creation, in case you'd rather
	-- supply two atoms rather than a sequence.
	function ECircle( atom x, atom y, atom radius )
		return ECircle( {x,y}, radius )
	end function
end euclass

ECircle c
c = ECircle( 0, 1, 1 )

I think it makes creating euclass type objects more intuitive, and the
modifications are fairly simple.

Matt Lewis

15. Re: Test an Online Database Utility

• Posted by Brian Broker <brian_broker at yahoo.com> Aug 13, 2005
• 438 views

I wrote:

Is the site still available for testing?
> 
> This gives me an empty page:
> <a href="http://www.cklester.com/dbtest/?txt_new_table_name=*&db= at
> .edb">http://www.cklester.com/dbtest/?txt_new_table_name=*&db=@.edb</a>
> 
> -- Brian

In fact, I could bug this site all night...
http://www.cklester.com/dbtest/?db=@.edb doesn't even work.  You need to check
invalid characters and character limits all of the way down the line.

After you do that, I'll try to break it again. ;)
-- Brian