<commit_before>package test.test1_basic_crud;

import static com.github.drinkjava2.jsqlbox.SQLHelper.e;
import static com.github.drinkjava2.jsqlbox.SQLHelper.q;

import com.github.drinkjava2.BeanBox;
import com.github.drinkjava2.jsqlbox.Dao;

import test.test1_basic_crud.po.User;

public class Tester {

	public void tx_insertDemo() {
		Dao.dao.execute("delete from user");
		Dao.dao.execute("insert user (username,age) values(" + q("user1") + "," + q(10) + ")");
		Dao.dao.execute("insert user (username,age) values(" + q("user2", 20) + ")");
		Dao.dao.execute("insert user (username,age) values(?,?)" + e("user3") + e(30));
		Dao.dao.execute("insert user (username,age) values(?,?)" + e("user4", 40));
		Dao.dao.execute(
				"insert " + User.Table + " (" + User.UserName + "," + User.Age + ") values(" + q("user5", 50) + ")");
		Dao.dao.execute("update user set username=?,address=? " + e("Sam", "BeiJing") + " where age=" + q(10));
		Dao.dao.execute("update user set username=?,address=? ", e("John", "Shanghai"), " where age=", q(20));
		Dao.dao.execute("update user set", //
				" username=?", e("Peter"), //
				",address=? ", e("Nanjing"), //
				" where age=?", e(30));
		Dao.dao.execute("update user set", //
				" username=", q("Jeffery"), //
				",address=", q("Tianjing"), //
				" where age=", q(40));
		User user = new User();
		user.setUsername("user3");
		user.setAge(70);
		user.dao().save();// TODO not finished
		System.out.println("tx_insertDemo Done");
	}

	public void tx_batchInsertDemo() {
		for (int i = 6; i < 10000; i++)
			Dao.dao.cacheSQL("insert user (username,age) values(?,?)" + e("user" + i, 60));
		Dao.dao.executeCachedSQLs();
		System.out.println("tx_batchInsertDemo Done");
	}

	public void tx_main() {
		tx_insertDemo();
		tx_batchInsertDemo();
		// tx_insertDefaultProxyUser();
		// tx_insertCtxProxyUser();
	}

	public static void main(String[] args) {
		Tester tester = BeanBox.getBean(Tester.class);
		tester.tx_main();
	}

}<commit_msg>16th update, Tester tiny change<commit_after>package test.test1_basic_crud;

import static com.github.drinkjava2.jsqlbox.SQLHelper.e;
import static com.github.drinkjava2.jsqlbox.SQLHelper.q;

import com.github.drinkjava2.BeanBox;
import com.github.drinkjava2.jsqlbox.Dao;

import test.test1_basic_crud.po.User;

public class Tester {

	public void tx_insertDemo() {
		Dao.dao.execute("delete from user");
		Dao.dao.execute("insert user (username,age) values(" + q("user1") + "," + q(10) + ")");
		Dao.dao.execute("insert user (username,age) values(" + q("user2", 20) + ")");
		Dao.dao.execute("insert user (username,age) values(?,?)" + e("user3") + e(30));
		Dao.dao.execute("insert user (username,age) values(?,?)" + e("user4", 40));
		Dao.dao.execute(
				"insert " + User.Table + " (" + User.UserName + "," + User.Age + ") values(" + q("user5", 50) + ")");
		Dao.dao.execute("insert user ", //
				" (username", e("Andy"), //
				", address", e("Guanzhou"), //
				", age)", e("60"), //
				" values(?,?,?)");
		Dao.dao.execute("update user set username=?,address=? " + e("Sam", "BeiJing") + " where age=" + q(10));
		Dao.dao.execute("update user set username=?,address=? ", e("John", "Shanghai"), " where age=", q(20));
		Dao.dao.execute("update user set", //
				" username=?", e("Peter"), //
				",address=? ", e("Nanjing"), //
				" where age=?", e(30));
		Dao.dao.execute("update user set", //
				" username=", q("Jeffery"), //
				",address=", q("Tianjing"), //
				" where age=", q(40));

		User user = new User();
		user.setUsername("user3");
		user.setAge(70);
		user.dao().save();// TODO not finished
		System.out.println("tx_insertDemo Done");
	}

	public void tx_batchInsertDemo() {
		for (int i = 7; i < 100000; i++)
			Dao.dao.cacheSQL("insert user (username,age) values(?,?)" + e("user" + i, 70));
		Dao.dao.executeCachedSQLs();
		System.out.println("tx_batchInsertDemo Done");
	}

	public void tx_main() {
		tx_insertDemo();
		tx_batchInsertDemo();
		// tx_insertDefaultProxyUser();
		// tx_insertCtxProxyUser();
	}

	public static void main(String[] args) {
		Tester tester = BeanBox.getBean(Tester.class);
		tester.tx_main();
	}

}
{'fraction_non_alphanumeric': 0.2153399467699008, 'fraction_numerical': 0.02056617469150738, 'mean_word_length': 4.1546134663341645, 'pattern_counts': {'":': 0, '<': 5, '<?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': '5827709', 'n_tokens_mistral': 1684, 'n_tokens_neox': 1545, 'n_words': 295}