r1269 and mysql

[Sharique]

I have checked out latest dblinq r1269. I'm testing it for mysql. I
found northwind mysql script is missing in tests folder.

Second thing : I run dbmetal against drupal 7 dev version database. I
got following error

DbMetal failed:System.ArgumentException: Don't know how to convert the
SQL type 'mediumtext' into a managed type.
Parameter name: dataType
at DbLinq.Vendor.Implementation.SchemaLoader.MapDbType(String
columnName, IDataType dataType) in h:\soft\dot net\dblinq\src\DbLinq
\Vendor\Implementation\SchemaLoader.TypeMapping.cs:line 217
at DbLinq.Vendor.Implementation.SchemaLoader.LoadColumns(Database
schema, SchemaName schemaName, IDbConnection conn, INameAliases
nameAliases, NameFormat nameFormat, Names names) in h:\soft\dot net
\dblinq\src\DbLinq\Vendor\Implementation\SchemaLoader.cs:line 430
at DbLinq.Vendor.Implementation.SchemaLoader.Load(String
databaseName, INameAliases nameAliases, NameFormat nameFormat, Boolean
loadStoredProcedures, String contextNamespace, String entityNamespace)
in h:\soft\dot net\dblinq\src\DbLinq\Vendor\Implementation
\SchemaLoader.cs:line 122
at DbMetal.Generator.Implementation.Processor.ReadSchema(Parameters
parameters, ISchemaLoader& schemaLoader) in h:\soft\dot net\dblinq\src
\DbMetal\Generator\Implementation\Processor.cs:line 218
at DbMetal.Generator.Implementation.Processor.ProcessSchema
(Parameters parameters) in h:\soft\dot net\dblinq\src\DbMetal\Generator
\Implementation\Processor.cs:line 112
--
Sharique

[Jonathan Pryor]

On Wed, 2009-11-11 at 04:13 -0800, Sharique wrote:
> I have checked out latest dblinq r1269. I'm testing it for mysql. I
> found northwind mysql script is missing in tests folder.

No one has "stepped up" to be the MySQL maintainer, so
instnwind.SqlServer.sql hasn't been ported yet.

Interested in helping? :-)

> Second thing : I run dbmetal against drupal 7 dev version database. I
> got following error
>
> DbMetal failed:System.ArgumentException: Don't know how to convert the
> SQL type 'mediumtext' into a managed type.

Please update to r1270.

Thanks,
- Jon

[Sharique uddin Ahmed Farooqui]

I have posted initial port of mysql northwind in issue list.

I checked r1270 and it is working.

> --~--~---------~--~----~------------~-------~--~----~
> You received this message because you are subscribed to the Google Groups
> "DbLinq" group.
> To post to this group, send email to dbl...@googlegroups.com
> To unsubscribe from this group, send email to
> dblinq+un...@googlegroups.com
> For more options, visit this group at
> http://groups.google.com/group/dblinq?hl=en
> -~----------~----~----~----~------~----~------~--~---
>
>


--
Sharique uddin Ahmed Farooqui
(C++/C# Developer, IT Consultant)
http://safknw.blogspot.com/
"Peace" is the Ultimate thing we want.

[Jonathan Pryor]

On Thu, 2009-11-12 at 20:25 +0530, Sharique uddin Ahmed Farooqui wrote:
> I have posted initial port of mysql northwind in issue list.

I noticed, and thank you!

I do wonder what the "errors in insert statements" are, though. Does it
actually work, or not? (Rephrased: is it in a state suitable for adding
to svn w/o getting lots of messages to the list complaining that it
doesn't work? :-)

Thanks!
- Jon

[Sharique uddin Ahmed Farooqui]

Create statements works, insert statements have errors, which i'll fix
in few days.

> --

>
> You received this message because you are subscribed to the Google Groups
> "DbLinq" group.

> To post to this group, send email to dbl...@googlegroups.com.

> For more options, visit this group at

> http://groups.google.com/group/dblinq?hl=.
>
>
>

--
Sent from my mobile device

[Sharique uddin Ahmed Farooqui]

Hi,

Here is the working sql script.

--

[Jonathan Pryor]

On Sun, 2009-11-15 at 01:03 +0530, Sharique uddin Ahmed Farooqui wrote:
> Here is the working sql script.

This has been added to svn, r1273.

Thanks!
- Jon

[Sharique uddin Ahmed Farooqui]

Thanks.
This script does not contains stored procedures. Which I hope to port
in next few days.
I posted file here because code google does not have option to attach
file in comment. I hope they will add this feature soon.

> --
>
> You received this message because you are subscribed to the Google Groups
> "DbLinq" group.
> To post to this group, send email to dbl...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/dblinq?hl=.
>
>
>


--