Menu
▾
▴
haskelldb-users — For questions, suggestions, bug reports and patches
You can subscribe to this list here.
| 2004 |
Jan
|
Feb
(6) |
Mar
(11) |
Apr
(5) |
May
(23) |
Jun
|
Jul
(5) |
Aug
|
Sep
(13) |
Oct
|
Nov
(10) |
Dec
(1) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2005 |
Jan
(1) |
Feb
(18) |
Mar
|
Apr
(5) |
May
(6) |
Jun
(2) |
Jul
(2) |
Aug
(2) |
Sep
(10) |
Oct
|
Nov
(1) |
Dec
(5) |
| 2006 |
Jan
(2) |
Feb
|
Mar
(11) |
Apr
|
May
|
Jun
|
Jul
(34) |
Aug
(5) |
Sep
|
Oct
(1) |
Nov
|
Dec
|
| 2007 |
Jan
(4) |
Feb
|
Mar
(2) |
Apr
(1) |
May
|
Jun
|
Jul
|
Aug
(3) |
Sep
(5) |
Oct
(3) |
Nov
(14) |
Dec
(15) |
| 2008 |
Jan
(13) |
Feb
(3) |
Mar
(12) |
Apr
(16) |
May
(4) |
Jun
(2) |
Jul
(26) |
Aug
|
Sep
|
Oct
|
Nov
|
Dec
(3) |
| 2009 |
Jan
|
Feb
(4) |
Mar
(13) |
Apr
(22) |
May
(25) |
Jun
(2) |
Jul
(10) |
Aug
(2) |
Sep
(41) |
Oct
(5) |
Nov
(9) |
Dec
|
| 2010 |
Jan
(3) |
Feb
(4) |
Mar
|
Apr
(5) |
May
|
Jun
|
Jul
|
Aug
(5) |
Sep
(1) |
Oct
(4) |
Nov
(8) |
Dec
|
| 2011 |
Jan
(2) |
Feb
|
Mar
(3) |
Apr
|
May
(1) |
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
(2) |
Dec
|
| 2012 |
Jan
|
Feb
|
Mar
|
Apr
(3) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(5) |
Nov
|
Dec
(1) |
| 2013 |
Jan
|
Feb
|
Mar
(4) |
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
(4) |
| 2014 |
Jan
(3) |
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2016 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
(1) |
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2017 |
Jan
|
Feb
(1) |
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: Henning T. <le...@he...> - 2017-02-02 18:34:03
|
I have just tried to install haskelldb-hdbc-mysql-0.1.1 with HDBC-2.4.0.1 using: $ cabal install --allow-newer=HDBC haskelldb-hdbc-mysql and it seems to work. Would you mind to relax the upper version bound on HDBC in haskelldb-hdbc-mysql? Please also add a Source-Repository field to haskelldb-hdbc-mysql.cabal. |
|
From: Tom E. <tom...@ja...> - 2014-01-07 18:12:16
|
On Mon, Jan 06, 2014 at 05:34:41PM +0000, Tom Ellis wrote: > On Mon, Jan 06, 2014 at 09:29:44AM -0800, Justin Bailey wrote: > > Thanks for your PR. I posted a comment and will look for your reply there! > > Thank you. Just replied. > > https://github.com/m4dc4p/haskelldb/pull/19 Thanks for merging! |
|
From: Tom E. <tom...@ja...> - 2014-01-06 17:34:37
|
On Mon, Jan 06, 2014 at 09:29:44AM -0800, Justin Bailey wrote: > Thanks for your PR. I posted a comment and will look for your reply there! Thank you. Just replied. https://github.com/m4dc4p/haskelldb/pull/19 |
|
From: Justin B. <jgb...@gm...> - 2014-01-06 17:30:12
|
Tom, Thanks for your PR. I posted a comment and will look for your reply there! On Mon, Dec 30, 2013 at 10:48 AM, Tom Ellis <tom...@ja...> wrote: > On Mon, Dec 30, 2013 at 10:06:14AM +0000, Tom Ellis wrote: >> On Wed, Dec 18, 2013 at 09:24:36AM -0800, Justin Bailey wrote: >> > Sorry I missed those issues - I didn't realize they had been entered. >> > >> > Please send Pull Requests and I'll be glad to review! >> > >> > Just in case, send a note to the mailing list if you submit a PR (or >> > file another issue). >> >> I've just sent a Pull Request. It adds support for UNION ALL to the backend >> (which I need for my application) and it fixes this issue >> >> https://github.com/m4dc4p/haskelldb/issues/14 > > The Pull Request also now fixes > > https://github.com/m4dc4p/haskelldb/issues/16 > > Tom > > ------------------------------------------------------------------------------ > Rapidly troubleshoot problems before they affect your business. Most IT > organizations don't have a clear picture of how application performance > affects their revenue. With AppDynamics, you get 100% visibility into your > Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro! > http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk > _______________________________________________ > Haskelldb-users mailing list > Has...@li... > https://lists.sourceforge.net/lists/listinfo/haskelldb-users |
|
From: Tom E. <tom...@ja...> - 2013-12-30 18:43:33
|
On Mon, Dec 30, 2013 at 10:06:14AM +0000, Tom Ellis wrote: > On Wed, Dec 18, 2013 at 09:24:36AM -0800, Justin Bailey wrote: > > Sorry I missed those issues - I didn't realize they had been entered. > > > > Please send Pull Requests and I'll be glad to review! > > > > Just in case, send a note to the mailing list if you submit a PR (or > > file another issue). > > I've just sent a Pull Request. It adds support for UNION ALL to the backend > (which I need for my application) and it fixes this issue > > https://github.com/m4dc4p/haskelldb/issues/14 The Pull Request also now fixes https://github.com/m4dc4p/haskelldb/issues/16 Tom |
|
From: Tom E. <tom...@ja...> - 2013-12-30 10:01:36
|
On Wed, Dec 18, 2013 at 09:24:36AM -0800, Justin Bailey wrote:
> Sorry I missed those issues - I didn't realize they had been entered.
>
> Please send Pull Requests and I'll be glad to review!
>
> Just in case, send a note to the mailing list if you submit a PR (or
> file another issue).
I've just sent a Pull Request. It adds support for UNION ALL to the backend
(which I need for my application) and it fixes this issue
https://github.com/m4dc4p/haskelldb/issues/14
Thanks,
Tom
|
|
From: Justin B. <jgb...@gm...> - 2013-12-18 17:25:03
|
Sorry I missed those issues - I didn't realize they had been entered. Please send Pull Requests and I'll be glad to review! Just in case, send a note to the mailing list if you submit a PR (or file another issue). On Wed, Dec 18, 2013 at 2:15 AM, Tom Ellis <tom...@ja...> wrote: > I would like to make a number of contributions to HaskellDB, including > patching some of the issues I have raised here > > https://github.com/m4dc4p/haskelldb/issues/created_by/tomjaguarpaw?state=open > > What is the best way to go about "joining" the project? Thanks, > > Tom > > ------------------------------------------------------------------------------ > Rapidly troubleshoot problems before they affect your business. Most IT > organizations don't have a clear picture of how application performance > affects their revenue. With AppDynamics, you get 100% visibility into your > Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro! > http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk > _______________________________________________ > Haskelldb-users mailing list > Has...@li... > https://lists.sourceforge.net/lists/listinfo/haskelldb-users |
|
From: Tom E. <tom...@ja...> - 2013-12-18 10:50:15
|
I would like to make a number of contributions to HaskellDB, including
patching some of the issues I have raised here
https://github.com/m4dc4p/haskelldb/issues/created_by/tomjaguarpaw?state=open
What is the best way to go about "joining" the project? Thanks,
Tom
|
|
From: Günther S. <gue...@we...> - 2013-03-15 18:42:30
|
Hello Guys, I managed to create my db layout and to generate the queries I want to sent of to my database. So far I have not figured out how to actually connect to my MySQL database (via HDBC). I have seen a single code example using PostgreSQL but it didn't help me much, it could not translate this for use MySQL. Which packages do I need to import? Could someone please post an example on how to connect to a MySQL database, fire off an arbitrary query and iterate over the result? I googled extensively but the net nowadays seems void of any coherent haskelldb examples. Thanks upfront Günther |
|
From: Günther S. <gue...@we...> - 2013-03-13 00:32:33
|
Thanks guys! Am 12.03.13 19:45, schrieb MightyByte: > I use something like the following command to generate code from my > database schema. > > DBDirect-hdbc-postgresql Acme.DB <password> "host=<host> dbname=<db-name>" > > The DBDirect-hdbc-postgresql executable is generated by the > haskelldb-hdbc-postgresql package. > > > On Mon, Mar 11, 2013 at 10:45 PM, Justin Bailey <jgb...@gm... > <mailto:jgb...@gm...>> wrote: > > Can anyone help Gunther? > > > I'd like to save myself some typing with the database layout but > would like to refrain from > > Template Haskell. Could you point me to an example on how to use > DBDirect for it? > > ---------- Forwarded message ---------- > From: *Günther Schmidt* <gue...@we... > <mailto:gue...@we...>> > Date: Mon, Mar 11, 2013 at 2:21 PM > Subject: Haskelldb DBDirect > To: Justin Bailey <jgb...@gm... <mailto:jgb...@gm...>> > > > Hello Justin, > > you might remember even though I haven't written you in quite a > while, a couple of years actually but I'm beginning to use Haskell > again for writing apps. Since Haskell now has support for writing > web-based applications it's becoming quite an option. > > Naturally I'd like to use HaskellDB for my persistence layer and > I'm glad to see that you have not abandoned it. > > I'd like to save myself some typing with the database layout but > would like to refrain from Template Haskell. Could you point me to > an example on how to use DBDirect for it? > > > Best regards > > Günther > > > > ------------------------------------------------------------------------------ > Symantec Endpoint Protection 12 positioned as A LEADER in The > Forrester > Wave(TM): Endpoint Security, Q1 2013 and "remains a good choice" > in the > endpoint security space. For insight on selecting the right partner to > tackle endpoint security challenges, access the full report. > http://p.sf.net/sfu/symantec-dev2dev > _______________________________________________ > Haskelldb-users mailing list > Has...@li... > <mailto:Has...@li...> > https://lists.sourceforge.net/lists/listinfo/haskelldb-users > > > > > ------------------------------------------------------------------------------ > Everyone hates slow websites. So do we. > Make your web apps faster with AppDynamics > Download AppDynamics Lite for free today: > http://p.sf.net/sfu/appdyn_d2d_mar > > > _______________________________________________ > Haskelldb-users mailing list > Has...@li... > https://lists.sourceforge.net/lists/listinfo/haskelldb-users |
|
From: MightyByte <mig...@gm...> - 2013-03-12 18:45:20
|
I use something like the following command to generate code from my database schema. DBDirect-hdbc-postgresql Acme.DB <password> "host=<host> dbname=<db-name>" The DBDirect-hdbc-postgresql executable is generated by the haskelldb-hdbc-postgresql package. On Mon, Mar 11, 2013 at 10:45 PM, Justin Bailey <jgb...@gm...> wrote: > Can anyone help Gunther? > > > I'd like to save myself some typing with the database layout but would > like to refrain from > > Template Haskell. Could you point me to an example on how to use > DBDirect for it? > > ---------- Forwarded message ---------- > From: Günther Schmidt <gue...@we...> > Date: Mon, Mar 11, 2013 at 2:21 PM > Subject: Haskelldb DBDirect > To: Justin Bailey <jgb...@gm...> > > > Hello Justin, > > you might remember even though I haven't written you in quite a while, a > couple of years actually but I'm beginning to use Haskell again for writing > apps. Since Haskell now has support for writing web-based applications it's > becoming quite an option. > > Naturally I'd like to use HaskellDB for my persistence layer and I'm glad > to see that you have not abandoned it. > > I'd like to save myself some typing with the database layout but would > like to refrain from Template Haskell. Could you point me to an example on > how to use DBDirect for it? > > > Best regards > > Günther > > > > > ------------------------------------------------------------------------------ > Symantec Endpoint Protection 12 positioned as A LEADER in The Forrester > Wave(TM): Endpoint Security, Q1 2013 and "remains a good choice" in the > endpoint security space. For insight on selecting the right partner to > tackle endpoint security challenges, access the full report. > http://p.sf.net/sfu/symantec-dev2dev > _______________________________________________ > Haskelldb-users mailing list > Has...@li... > https://lists.sourceforge.net/lists/listinfo/haskelldb-users > > |
|
From: Justin B. <jgb...@gm...> - 2013-03-12 02:45:59
|
Can anyone help Gunther? > I'd like to save myself some typing with the database layout but would like to refrain from > Template Haskell. Could you point me to an example on how to use DBDirect for it? ---------- Forwarded message ---------- From: Günther Schmidt <gue...@we...> Date: Mon, Mar 11, 2013 at 2:21 PM Subject: Haskelldb DBDirect To: Justin Bailey <jgb...@gm...> Hello Justin, you might remember even though I haven't written you in quite a while, a couple of years actually but I'm beginning to use Haskell again for writing apps. Since Haskell now has support for writing web-based applications it's becoming quite an option. Naturally I'd like to use HaskellDB for my persistence layer and I'm glad to see that you have not abandoned it. I'd like to save myself some typing with the database layout but would like to refrain from Template Haskell. Could you point me to an example on how to use DBDirect for it? Best regards Günther |
|
From: Kei H. <ex8...@gm...> - 2012-12-12 02:52:17
|
Hi, I have an idea to extend Relation types and Record types into tuple-ed ones. I wrote experimentally implementation to achieve this. https://github.com/khibino/haskelldb/tree/tuple_join Query of single table case is like below. type RelX = RecCons X0 (Expr p0) (RecCons X1 ... ) tableX :: Table RelX ... type RecordX = RecCons X0 p0 (RecCons X1 ... ) single :: Query (Rel RelX) single = do tx <- table tableX ... project $ copyAll tx querySingle :: Database -> IO [Record RecordX] querySingle = (`query` single) As usual, joined query case, we have been required to re-compose joined type other than defined Relation and Record types. type RelY = RecCons Y0 (Expr q0) (RecCons Y1 ... ) tableY :: Table RelY ... type RelJoined = RecCons X0 (Expr p0) ( ... (RecCons Y0 (Expr q0) ... ) ... ) type RecordJoined = RecCons X0 p0 ( ... (RecCons Y0 q0 ... ) ... ) joined' :: Query (Rel Joined) joined' = do tx <- table tableX ty <- table tableY ... project $ copy x0 tx # copy x1 tx ... # copy y0 ty # copy y0 ty ... queryJoined' :: Database -> IO [Record RecordJoined] queryJoined' = (`query` joined') On my implementation, we can simply use tuple type in joined query case. Not required to re-compose joined Reltion and Record types. type RecordY = RecCons Y0 q0 (RecCons Y1 ... ) joined :: Query (Rel (RelX, RelY)) joined = do tx <- table tableX ty <- table tableY ... project $ (,) <$> copyAll tx <*> copyAll ty queryJoined :: Database -> IO [Record (RecordX, RecordY)] queryJoined = (`query` joined) -- -- Kei Hibino -- ex8...@gm... -- |
|
From: Andras G. <lga...@gm...> - 2012-10-26 19:44:04
|
Hi, i made this patch to support FOR UPDATE https://github.com/agyomrey/haskelldb/commit/101ec4ce846e691199ed90a06e528e5e68d8a0c7. What do you think? Andras |
|
From: Justin B. <jgb...@gm...> - 2012-10-12 17:58:23
|
I started the process of moving HaskellDB to GitHub a few weeks ago, and today I've nearly completed the process. You can now find the HaskellDB sources at https://github.com/m4dc4p/haskelldb. I migrated all the existing wiki articles from http://trac.haskell.org/haskelldb to a GitHub wiki at https://github.com/m4dc4p/haskelldb/wiki. Eventually, I plan on migrating issues from Trac that are still relevant. I will also update some of the archival pages to point to the new source location. Finally, I uploaded new versions of all packages to give the new homepage and repository. Thanks to everyone for recent patches to HaskellDB! Justin |
|
From: Kei H. <ex8...@gm...> - 2012-10-12 14:21:39
|
In the message "Re: HDBC >= 2.2.7.0 breaks haskelldb-hdbc "
<CAB...@ma...>
Justin Bailey wrote:
> I'm in the process of moving HaskellDB to GitHub. Please submit your
> patch there:
> https://github.com/m4dc4p/haskelldb
I forked this repository and made pull request .
https://github.com/m4dc4p/haskelldb/pull/4
> On Wed, Oct 10, 2012 at 9:10 PM, Kei HIBINO <ex8...@gm...> wrote:
> >
> > Hi,
> >
> > I updated a bugfix patch previously sent one.
> > ([Subject: HDBC >= 2.2.7.0 breaks haskelldb-hdbc]
> > http://sourceforge.net/mailarchive/message.php?msg_id=29139981)
> >
> > Updated patch is attached in this message as 'normalize-field.diff'
> >
> > I want to use fixed codes from Debian systems.
> > Please tell me if there is anything I can do.
> >
> >
> > I have checked repository (http://code.haskell.org/haskelldb) changes of
> > haskelldb-hdbc from haskelldb-hdbc-2.1.0(newest version of haskelldb-hdbc on hackage).
> > A little diff is found like below.
> >
> >
> > Regards.
> >
> >
> > diff -ubr haskelldb-hdbc-2.1.0/Database/HaskellDB/HDBC.hs haskelldb/driver-hdbc/Database/HaskellDB/HDBC.hs
> > --- haskelldb-hdbc-2.1.0/Database/HaskellDB/HDBC.hs 2012-10-10 11:32:34.788662463 +0900
> > +++ haskelldb/driver-hdbc/Database/HaskellDB/HDBC.hs 2012-10-09 17:33:44.000000000 +0900
> > @@ -55,6 +55,7 @@
> > dbTables = hdbcTables connection,
> > dbDescribe = hdbcDescribe connection,
> > dbTransaction = hdbcTransaction connection,
> > + dbCommit = HDBC.commit connection,
> > dbCreateDB = hdbcCreateDB gen connection,
> > dbCreateTable = hdbcCreateTable gen connection,
> > dbDropDB = hdbcDropDB gen connection,
> >
> > --
> > -- Kei Hibino
> > -- ex8...@gm...
> > --
> >
|
|
From: Justin B. <jgb...@gm...> - 2012-10-11 16:19:00
|
I'm in the process of moving HaskellDB to GitHub. Please submit your patch there: https://github.com/m4dc4p/haskelldb On Wed, Oct 10, 2012 at 9:10 PM, Kei HIBINO <ex8...@gm...> wrote: > > Hi, > > I updated a bugfix patch previously sent one. > ([Subject: HDBC >= 2.2.7.0 breaks haskelldb-hdbc] > http://sourceforge.net/mailarchive/message.php?msg_id=29139981) > > Updated patch is attached in this message as 'normalize-field.diff' > > I want to use fixed codes from Debian systems. > Please tell me if there is anything I can do. > > > I have checked repository (http://code.haskell.org/haskelldb) changes of > haskelldb-hdbc from haskelldb-hdbc-2.1.0(newest version of haskelldb-hdbc on hackage). > A little diff is found like below. > > > Regards. > > > diff -ubr haskelldb-hdbc-2.1.0/Database/HaskellDB/HDBC.hs haskelldb/driver-hdbc/Database/HaskellDB/HDBC.hs > --- haskelldb-hdbc-2.1.0/Database/HaskellDB/HDBC.hs 2012-10-10 11:32:34.788662463 +0900 > +++ haskelldb/driver-hdbc/Database/HaskellDB/HDBC.hs 2012-10-09 17:33:44.000000000 +0900 > @@ -55,6 +55,7 @@ > dbTables = hdbcTables connection, > dbDescribe = hdbcDescribe connection, > dbTransaction = hdbcTransaction connection, > + dbCommit = HDBC.commit connection, > dbCreateDB = hdbcCreateDB gen connection, > dbCreateTable = hdbcCreateTable gen connection, > dbDropDB = hdbcDropDB gen connection, > > -- > -- Kei Hibino > -- ex8...@gm... > -- > |
|
From: Kei H. <ex8...@gm...> - 2012-10-11 04:31:35
|
Hi, I updated a bugfix patch previously sent one. ([Subject: HDBC >= 2.2.7.0 breaks haskelldb-hdbc] http://sourceforge.net/mailarchive/message.php?msg_id=29139981) Updated patch is attached in this message as 'normalize-field.diff' I want to use fixed codes from Debian systems. Please tell me if there is anything I can do. I have checked repository (http://code.haskell.org/haskelldb) changes of haskelldb-hdbc from haskelldb-hdbc-2.1.0(newest version of haskelldb-hdbc on hackage). A little diff is found like below. Regards. diff -ubr haskelldb-hdbc-2.1.0/Database/HaskellDB/HDBC.hs haskelldb/driver-hdbc/Database/HaskellDB/HDBC.hs --- haskelldb-hdbc-2.1.0/Database/HaskellDB/HDBC.hs 2012-10-10 11:32:34.788662463 +0900 +++ haskelldb/driver-hdbc/Database/HaskellDB/HDBC.hs 2012-10-09 17:33:44.000000000 +0900 @@ -55,6 +55,7 @@ dbTables = hdbcTables connection, dbDescribe = hdbcDescribe connection, dbTransaction = hdbcTransaction connection, + dbCommit = HDBC.commit connection, dbCreateDB = hdbcCreateDB gen connection, dbCreateTable = hdbcCreateTable gen connection, dbDropDB = hdbcDropDB gen connection, -- -- Kei Hibino -- ex8...@gm... -- |
|
From: Kei H. <ex8...@gm...> - 2012-04-18 06:59:32
|
In the message "Re: HDBC >= 2.2.7.0 breaks haskelldb-hdbc "
<CABPxb2=k=u3G...@ma...>
Justin Bailey wrote:
> Thanks for your bug report and patch. I will apply it as soon as I
> can, but that might be a while.
> If you wish to submit a patch that rolls the version number of
> haskell-hdbc and updates the dependency on HDBC, I'd be glad to apply
> it right away.
I appreciate your consideration.
I think this change is portable for older HDBC versions too.
> Out of curiousity, how are you using HaskellDB? How did you find it?/
I'm using IBM DB2 client driver over unixODBC with haskelldb-hdbc-odbc.
Default behavior of DB2 river returns upper-case field names.
So, my database accessing code raised "No such field" error :)
> On Tue, Apr 17, 2012 at 1:26 AM, Kei HIBINO <ex8...@gm...> wrote:
> >
> > Hi.
> >
> > I want to report a bug.
> >
> > Sorry, not to use trac tickets.
> > I couldn't receive trac's address verification mails.
> >
> > I'm trying haskelldb-hdbc-2.1.0 with HDBC-2.3.1.
> > I noticed HDBC's new versions no longer converts column names to lower case
> >
> > https://github.com/hdbc/hdbc/commit/23f82c23d41ec11decff0c3851fedc1437a7ef28
> >
> > which breaks hdbcGetValue in Database/HaskellDB/HDBC.hs .
> > I made a small naive patch to avoid this problem below this.
> >
> > Regards.
> >
> >
> >
> > --- haskelldb-hdbc-2.1.0.orig/Database/HaskellDB/HDBC.hs
> > +++ haskelldb-hdbc-2.1.0/Database/HaskellDB/HDBC.hs
> > @@ -171,8 +171,14 @@ hdbcPrimQuery conn sql scheme rel =
> > do
> > stmt <- handleSqlError $ HDBC.prepare conn sql
> > handleSqlError $ HDBC.execute stmt []
> > - rows <- HDBC.fetchAllRowsMap stmt
> > - mapM (getRec hdbcGetInstances rel scheme) rows
> > + rows <- fetchLowerAllRowsAL stmt
> > + mapM (getRec hdbcGetInstances rel scheme) $ map Map.fromList rows
> > + where fetchLowerAllRowsAL sth =
> > + do names <- map wordToLower `fmap` getColumnNames sth
> > + rows <- fetchAllRows sth
> > + return $ map (zip names) rows
> > + wordToLower = map toLower
> > +
> >
> > -- | Primitive execute
> > hdbcPrimExecute :: (IConnection conn) => conn -- ^ Database connection.
|
|
From: Justin B. <jgb...@gm...> - 2012-04-17 23:59:57
|
Thanks for your bug report and patch. I will apply it as soon as I can, but that might be a while. If you wish to submit a patch that rolls the version number of haskell-hdbc and updates the dependency on HDBC, I'd be glad to apply it right away. Out of curiousity, how are you using HaskellDB? How did you find it?/ On Tue, Apr 17, 2012 at 1:26 AM, Kei HIBINO <ex8...@gm...> wrote: > > Hi. > > I want to report a bug. > > Sorry, not to use trac tickets. > I couldn't receive trac's address verification mails. > > I'm trying haskelldb-hdbc-2.1.0 with HDBC-2.3.1. > I noticed HDBC's new versions no longer converts column names to lower case > > https://github.com/hdbc/hdbc/commit/23f82c23d41ec11decff0c3851fedc1437a7ef28 > > which breaks hdbcGetValue in Database/HaskellDB/HDBC.hs . > I made a small naive patch to avoid this problem below this. > > Regards. > > > > --- haskelldb-hdbc-2.1.0.orig/Database/HaskellDB/HDBC.hs > +++ haskelldb-hdbc-2.1.0/Database/HaskellDB/HDBC.hs > @@ -171,8 +171,14 @@ hdbcPrimQuery conn sql scheme rel = > do > stmt <- handleSqlError $ HDBC.prepare conn sql > handleSqlError $ HDBC.execute stmt [] > - rows <- HDBC.fetchAllRowsMap stmt > - mapM (getRec hdbcGetInstances rel scheme) rows > + rows <- fetchLowerAllRowsAL stmt > + mapM (getRec hdbcGetInstances rel scheme) $ map Map.fromList rows > + where fetchLowerAllRowsAL sth = > + do names <- map wordToLower `fmap` getColumnNames sth > + rows <- fetchAllRows sth > + return $ map (zip names) rows > + wordToLower = map toLower > + > > -- | Primitive execute > hdbcPrimExecute :: (IConnection conn) => conn -- ^ Database connection. |
|
From: Kei H. <ex8...@gm...> - 2012-04-17 08:44:21
|
Hi. I want to report a bug. Sorry, not to use trac tickets. I couldn't receive trac's address verification mails. I'm trying haskelldb-hdbc-2.1.0 with HDBC-2.3.1. I noticed HDBC's new versions no longer converts column names to lower case https://github.com/hdbc/hdbc/commit/23f82c23d41ec11decff0c3851fedc1437a7ef28 which breaks hdbcGetValue in Database/HaskellDB/HDBC.hs . I made a small naive patch to avoid this problem below this. Regards. --- haskelldb-hdbc-2.1.0.orig/Database/HaskellDB/HDBC.hs +++ haskelldb-hdbc-2.1.0/Database/HaskellDB/HDBC.hs @@ -171,8 +171,14 @@ hdbcPrimQuery conn sql scheme rel = do stmt <- handleSqlError $ HDBC.prepare conn sql handleSqlError $ HDBC.execute stmt [] - rows <- HDBC.fetchAllRowsMap stmt - mapM (getRec hdbcGetInstances rel scheme) rows + rows <- fetchLowerAllRowsAL stmt + mapM (getRec hdbcGetInstances rel scheme) $ map Map.fromList rows + where fetchLowerAllRowsAL sth = + do names <- map wordToLower `fmap` getColumnNames sth + rows <- fetchAllRows sth + return $ map (zip names) rows + wordToLower = map toLower + -- | Primitive execute hdbcPrimExecute :: (IConnection conn) => conn -- ^ Database connection. |
|
From: yrazes <yr...@gm...> - 2011-11-07 23:41:24
|
Sorry, but I got this error while I compile it. * * *[yulys@yulys haskell]$ ghc -o quick quick.hs* *[1 of 1] Compiling Main ( quick.hs, quick.o )* * * *quick.hs:7:11: parse error on input `<-'* *[yulys@yulys haskell]$ * On Mon, Nov 7, 2011 at 4:23 PM, KC <kc...@gm...> wrote: > What is your question? > > > > On Mon, Nov 7, 2011 at 9:45 AM, yrazes <yr...@gm...> wrote: > > module Main (main) where > > quicksort [] = [] > > quicksort (s:xs) = quicksort [x|x <- xs,x < s] ++ [s] ++ quicksort [x|x > <- > > xs,x >= s] > > main = putStr "Ingrese la lista\n" > > [xs] <- getLine > > _______________________________________________ > > Haskell-Cafe mailing list > > Has...@ha... > > http://www.haskell.org/mailman/listinfo/haskell-cafe > > > > > > > > -- > -- > Regards, > KC > |
|
From: yrazes <yr...@gm...> - 2011-11-07 17:45:07
|
module Main (main) where
quicksort [] = []
quicksort (s:xs) = quicksort [x|x <- xs,x < s] ++ [s] ++ quicksort [x|x <-
xs,x >= s]
main = putStr "Ingrese la lista\n"
[xs] <- getLine
|
|
From: Anakreon <ana...@ya...> - 2011-05-18 16:17:24
|
I'm using the following command: DBDirect-hdbc-mysql MyModule db_test localhost It fails to connect. The program attempts to connect to database "test" which does not exist. If I pass the name of the database: DBDirect-hdbc-mysql MyModule db_test localhost db_test the error message is: Unnecessary arguments: ["localhost","db_test"] How should I place the driver options? I want to connect to a database named db_test from localhost with username root and no password |
|
From: Simon M. <si...@jo...> - 2011-03-18 23:10:28
|
On Mar 18, 2011, at 3:43 PM, Justin Bailey wrote: > THose two are related, but I don't have a fix. Anyone can submit a > patch ... :) I didn't manage to get the linked workaround working. Perhaps next time. > I believe so, but I don't have anyone to point you to. My feeling is > that HaskellDB works best for generating SQL which you then execute > with your favorite DB library. Hmm.. do you mean something like, for instance, HDBC:quickQuery conn (render $ ppQuery q) [] ? Thanks, -Simon |
4 messages has been excluded from this view by a project administrator.
