FYI: I've got a SQLite module working in build 338
"Mark Hahn" <[email protected]> Tue, 13 Apr 2004 12:12:07 -0700
| Newsgroups | gmane.comp.lang.prothon.user,gmane.comp.lang.prothon.devel |
|---|---|
| Message-ID | <000001c4218b$36e562f0$0b01a8c0@mark> |
This is a multi-part message in MIME format.
--===============1573012817==
Content-Type: multipart/alternative;
boundary="----=_NextPart_000_0001_01C42150.8A88FBF0"
This is a multi-part message in MIME format.
------=_NextPart_000_0001_01C42150.8A88FBF0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
FYI: I've got a SQLite module working in build 338
It's using a subset of the Python DBAPI:
import SQLite
Connection = SQLite.connect.(filename)
Cursor = Connection.cursor()
Connection.close()
Cursor.execute(statement)
Cursor.fetchone()
Cursor.fetchmany()
Cursor.fetchall()
Cursor.rowcount()
The module will be used on a new project that I'm starting. It's a
project to do an auto-documenter application in Prothon. It will be the
first serious application in Prothon and will help solidify the language
by being a usage example as it documents the language at the same time.
(Hopefully we'll have a language settled on enough to use soon :)
Joe Knapka has kindly volunteered to help on coding the HTML generator
at the back-end of the database. I'm starting things off by working on
parsing the C modules and feeding the database. We still need help on
documentation standards at the Prothon code level and a coder for taking
Prothon code as input and feeding the database.
We'll be discussing the project on the prothon-dev list.
------=_NextPart_000_0001_01C42150.8A88FBF0
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<TITLE>Message</TITLE>
<META content=3D"MSHTML 6.00.2800.1400" name=3DGENERATOR></HEAD>
<BODY>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D433385418-13042004>FYI: =
I've got a=20
SQLite module working in build 338</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D433385418-13042004></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D433385418-13042004>It's =
using a subset=20
of the Python DBAPI:</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D433385418-13042004></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D433385418-13042004> import=20
SQLite</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D433385418-13042004></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D433385418-13042004> Connection =3D =
SQLite.connect.(filename)</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D433385418-13042004></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D433385418-13042004><SPAN=20
class=3D433385418-13042004> </SPAN>Cursor =
=3D=20
Connection.cursor()</SPAN></FONT><FONT face=3DArial size=3D2><SPAN=20
class=3D433385418-13042004><BR><SPAN=20
class=3D433385418-13042004> =20
</SPAN>Connection.close()</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D433385418-13042004><BR></SPAN></FONT><FONT face=3DArial =
size=3D2><SPAN=20
class=3D433385418-13042004><SPAN=20
class=3D433385418-13042004> =20
</SPAN>Cursor.execute(statement)<BR><SPAN =
class=3D433385418-13042004><SPAN=20
class=3D433385418-13042004> =20
</SPAN>Cursor.</SPAN>fetchone()<BR><SPAN =
class=3D433385418-13042004><SPAN=20
class=3D433385418-13042004> =20
</SPAN>Cursor.</SPAN>fetchmany()</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D433385418-13042004><SPAN=20
class=3D433385418-13042004><SPAN=20
class=3D433385418-13042004> =20
</SPAN>Cursor.</SPAN>fetchall()<BR><SPAN =
class=3D433385418-13042004><SPAN=20
class=3D433385418-13042004> =20
</SPAN>Cursor.</SPAN>rowcount()</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D433385418-13042004></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D433385418-13042004>The =
module will be=20
used on a new project that I'm starting. It's a project to do =
an=20
auto-documenter application in Prothon. It will be the first =
serious=20
application in Prothon and will help solidify the language by being a =
usage=20
example as it documents the language at the same time. (Hopefully =
we'll=20
have a language settled on enough to use soon :)</SPAN></FONT></DIV>
<DIV><FONT><SPAN class=3D433385418-13042004>
<P><FONT face=3DArial><FONT size=3D2>Joe Knapka<SPAN =
class=3D433385418-13042004> has=20
kindly volunteered to help on coding the HTML generator at =
the back-end of=20
the database. I'm starting things off by working on parsing the C =
modules=20
and feeding the database. We still need help on documentation =
standards at=20
the Prothon code level and a coder for taking Prothon code as input and =
feeding=20
the database.</SPAN></FONT></FONT></P>
<P><FONT face=3DArial><FONT size=3D2><SPAN =
class=3D433385418-13042004>We'll be=20
discussing the project on the prothon-dev=20
list.</SPAN></FONT></FONT></P></SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D433385418-13042004></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN =
class=3D433385418-13042004></SPAN></FONT><FONT=20
face=3DArial size=3D2><SPAN class=3D433385418-13042004> </DIV>
<DIV><BR></DIV></SPAN></FONT></BODY></HTML>
------=_NextPart_000_0001_01C42150.8A88FBF0--
--===============1573012817==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline