public byte[] getXyz(int storage_id, SqlConnection conn) { object ret = BingoSqlUtils.ExecObjQuery(conn, "SELECT xyz from {0} where storage_id={1}", shadowTable, storage_id); return((byte[])ret); }
private void _getBitChunk(Block block, int bit_index, SqlConnection conn, ref byte[] chunk) { BingoTimer timer = new BingoTimer("fingerprints.read"); if (block.bits != null) { Buffer.BlockCopy(block.bits[bit_index], 0, chunk, 0, chunk.Length); } else { chunk = (byte[])BingoSqlUtils.ExecObjQuery(conn, "SELECT bits_chunk from {0} where part = {1} and bit = {2}", _index_data.fingerprintBitsTable, block.part, bit_index); } timer.end(); }
public static void DropAllIndices(SqlConnection conn, string bingo_schema, bool only_invalid) { List <TableWithId> tables = new List <TableWithId>(); using (SqlCommand cmd = new SqlCommand(String.Format( "SELECT full_table_name, obj_id FROM {0}", _contextTable(bingo_schema)), conn)) { cmd.CommandTimeout = 3600; using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { string full_table_name = Convert.ToString(reader[0]); int table_id = Convert.ToInt32(reader[1]); tables.Add(new TableWithId() { table_name = full_table_name, id = table_id }); } } } foreach (TableWithId table in tables) { if (only_invalid) { object ret = BingoSqlUtils.ExecObjQuery(conn, "SELECT OBJECT_NAME({0})", table.id); if (ret != null) { continue; } } DropIndexData(conn, bingo_schema, table.table_name, false); } }