Comments (9)
historical ones. mssql2:// is rather an experiment.
from pydal.
Given that, I'd set boolean as bit.
from pydal.
No. That would break existing code. MSSQL2Adapter was created for those users who wanted a non-boolean mapping. We do not know that somebody is not relying on it. Why do you want to change it?
On Feb 17, 2015, at 9:45 AM, Paolo Valleri [email protected] wrote:
Given that, I'd set boolean as bit.
—
Reply to this email directly or view it on GitHub.
from pydal.
I use MSSQL2Adapter for a legacy db where boolean types are defined as bit. I fixed it on my local copy. If MSSQL2Adapter is marked experimental, we can still update it?
from pydal.
Mssql2 is a proof of concept of using unicode-capable fields. It's legacy,old and should be reviewed. Of course changing boolean mapping will break compatibility with current models
from pydal.
@mdipierro I've just realized that MSSQL2Adapter is broken anyway.
The following return False.
db = DAL('mssql2://user:passwd@ip/db')
db.define_table('tt', Field('aa', 'boolean', default=True))
db.tt.insert(aa=True)
db().select(db.tt.aa)[0].aa == True
Given that I guess no one is really using this adapter. Despite the backward compatibility, I propose to update it by switching the boolean type from CHAR(1) to BIT
from pydal.
We do not know that nobody is using it. Can we make another one and
deprecate this?
On Mar 25, 2015 12:37 AM, "Paolo Valleri" [email protected] wrote:
@mdipierro https://github.com/mdipierro I've just realized that
MSSQL2Adapter is broken anyway.
The following return False.db = DAL('mssql2://user:passwd@ip/db')
db.define_table('tt', Field('aa', 'boolean', default=True))
db.tt.insert(aa=True)
db().select(db.tt.aa)[0].aa == TrueGiven that I guess no one is really using this adapter. Despite the
backward compatibility, I propose to update it by switching the boolean
type from CHAR(1) to BIT—
Reply to this email directly or view it on GitHub
#62 (comment).
from pydal.
Yes we could. The fact is that, the adapter is broken in a very basic operation. Given that I think we are in the position of fixing and breaking the compatibility, isn't?
from pydal.
Will not be able to look at the code until later. Meanwhile feel free to
make a pr
On Mar 25, 2015 9:28 AM, "Paolo Valleri" [email protected] wrote:
Yes we could. The fact is that, the adapter is broken in a very basic
operation. Given that I think we are in the position of fixing and breaking
the compatibility, isn't?—
Reply to this email directly or view it on GitHub
#62 (comment).
from pydal.
Related Issues (20)
- GHSL-2021-116 HOT 1
- Fix unable to parse csv file in web2py break CSV parsing when dynamic upload is used
- MSSQL adapter, tableX_view.insert (..) + trigger INSTEAD OF INSERT, .lastrowid (), "SELECT SCOPE_IDENTITY ()", return long (../ None / ..)
- NotNullViolation on PostgreSQL migration of populated table with a notnull field
- The user name or password contains @, unable to connect to MySQL HOT 4
- Deprecation imports google.appengine.api.rdbms in _gae and google adapter HOT 1
- Upgrade to python3 datastore adapter. Help
- problem with .contains() when passing list as argument HOT 1
- pool_size and leaking connections on PostgreSQL
- erro calling db.uuid method HOT 1
- count field in restapi HOT 1
- non-database upload field fails to build filename
- web2py_filesystem Updates/Corrections
- REGEXP_LIKE missing parameter "match_parameter" in oracle
- Incorrect sqlite placeholder for InDBMigrator
- Database is locked, attempts not working
- Error in the class FireBird
- import_from_csv_file fails if export_to_csv_file with ref id column with gaps
- PyDAL for Azure MySQL
- PyDAL for Redis
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from pydal.