Skip to content

appcelerator-archive/appc.mssql

Repository files navigation

MSSQL Connector

This is an Arrow connector to Microsoft SQL Server (MSSQL).

Installation

$ appc install connector/appc.mssql

Usage

Reference the connector in your model.

var Account = Arrow.Model.extend('Account', {
	fields: {
		Name: { type: String, required: true, validator: /[a-zA-Z]{3,}/ }
	},
	connector: 'appc.mssql'
});

If you want to map a specific model to a specific table, use metadata. For example, to map the account model to the table accounts, set it such as:

var Account = Arrow.Model.extend('account', {
	fields: {
		Name: { type: String, required: false, validator: /[a-zA-Z]{3,}/ }
	},
	connector: 'appc.mssql',
	metadata: {
		'appc.mssql': {
			table: 'accounts'
		}
	}
});

The types in the database are converted to javascript types as follows:

  • char, varchar, text, nchar, nvarchar, ntext -> to String

  • decimal, money, numeric, smallmoney, real, tinyint, smallint, mediumint, bigint, int, integer, float, bit, double, binary -> to Number

  • datetimeoffset, smalldatetime, datetime2, date, datetime, time, year -> to Date

All other types are converted to String.

Development

This section is for individuals developing the MSSQL Connector and not intended for end-users.

npm install
node app.js

Running Unit Tests

The tests will automatically create their own table named "TEST_Post".

npm test

Contributing

This project is open source and licensed under the Apache Public License (version 2). Please consider forking this project to improve, enhance or fix issues. If you feel like the community will benefit from your fork, please open a pull request.

To protect the interests of the contributors, Appcelerator, customers and end users we require contributors to sign a Contributors License Agreement (CLA) before we pull the changes into the main repository. Our CLA is simple and straightforward - it requires that the contributions you make to any Appcelerator open source project are properly licensed and that you have the legal authority to make those changes. This helps us significantly reduce future legal risk for everyone involved. It is easy, helps everyone, takes only a few minutes, and only needs to be completed once.

You can digitally sign the CLA online. Please indicate your email address in your first pull request so that we can make sure that will locate your CLA. Once you've submitted it, you no longer need to send one for subsequent submissions.

Legal Stuff

Appcelerator is a registered trademark of Appcelerator, Inc. Arrow and associated marks are trademarks of Appcelerator. All other marks are intellectual property of their respective owners. Please see the LEGAL information about using our trademarks, privacy policy, terms of usage and other legal information at http://www.appcelerator.com/legal.