<commit_before>var sequel = require('../sequel.js')

var data = [
	{
		city: 'New York',
		temp: {temp:5},
		country: 'USA'
	},
	{
		city: 'Los Angeles',
		temp: {temp:5},
		country: 'USA'
	},
	{
		city: 'Paris',
		temp: {temp:5},
		country: 'France'
	},
	{
		city: 'Marseille',
		temp: {temp:5},
		country: 'France'
	},
	{
		city: 'London',
		temp: {temp: 2},
		country: 'UK'
	}
]

sequel.createTableSync('cities', data)

// sequel.query.each('SELECT * FROM cities WHERE 15 != ALL (temp)', function(row){
// 	console.log(row)
// })

sequel.query.each('SELECT * FROM cities', function(row){
	console.log(row)
})


// sequel.query.each('SELECT * FROM cities WHERE 15 = ANY (temp)', function(row){
// 	console.log(row)
// })
<commit_msg>more complex json object support on inserts<commit_after>var sequel = require('../sequel.js')

var data = [
	{
		city: 'New York',
		temp: {temp:[5,2]},
		country: 'USA'
	},
	{
		city: 'Los Angeles',
		temp: {temp:[5,2]},
		country: 'USA'
	},
	{
		city: 'Paris',
		temp: {temp:[5,2]},
		country: 'France'
	},
	{
		city: 'Marseille',
		temp: {temp:[5,2]},
		country: 'France'
	},
	{
		city: 'London',
		temp: {temp:[2,2]},
		country: 'UK'
	}
]

sequel.createTableSync('cities', data)

// sequel.query.each('SELECT * FROM cities WHERE 15 != ALL (temp)', function(row){
// 	console.log(row)
// })

sequel.query.each('SELECT * FROM cities', function(row){
	console.log(row)
})


// sequel.query.each('SELECT * FROM cities WHERE 15 = ANY (temp)', function(row){
// 	console.log(row)
// })

{'fraction_non_alphanumeric': 0.21922317314022383, 'fraction_numerical': 0.015141540487162607, 'mean_word_length': 3.497041420118343, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '872478', 'n_tokens_mistral': 667, 'n_tokens_neox': 607, 'n_words': 131}